Changes for page Guidelines on Non-Calendar Year Reporting of Data
Last modified by Artur K. on 2026/05/29 14:28
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -xwiki:XWiki.he lena1 +xwiki:XWiki.arturkryazhev - Content
-
... ... @@ -66,26 +66,24 @@ 66 66 67 67 The code list for “reference period detail” previously used in the National Accounts DSDs is as follows: 68 68 69 -|**Code**|**Description** 70 -|C|Calendar year 71 -|F_O|Fiscal year (other definition) 72 -|F02|Fiscal year starting in February 73 -|F03|Fiscal year starting in March 74 -|F04|Fiscal year starting in April 75 -|F05|Fiscal year starting in May 76 -|F06|Fiscal year starting in June 77 -|F07|Fiscal year starting in July 78 -|F08|Fiscal year starting in August 79 -|F09|Fiscal year starting in September 80 -|F10|Fiscal year starting in October 81 -|F11|Fiscal year starting in November 82 -|F12|Fiscal year starting in December 69 +|(% style="width:168px" %)**Code**|(% style="width:2050px" %)**Description** 70 +|(% style="width:168px" %)C|(% style="width:2050px" %)Calendar year 71 +|(% style="width:168px" %)F_O|(% style="width:2050px" %)Fiscal year (other definition) 72 +|(% style="width:168px" %)F02|(% style="width:2050px" %)Fiscal year starting in February 73 +|(% style="width:168px" %)F03|(% style="width:2050px" %)Fiscal year starting in March 74 +|(% style="width:168px" %)F04|(% style="width:2050px" %)Fiscal year starting in April 75 +|(% style="width:168px" %)F05|(% style="width:2050px" %)Fiscal year starting in May 76 +|(% style="width:168px" %)F06|(% style="width:2050px" %)Fiscal year starting in June 77 +|(% style="width:168px" %)F07|(% style="width:2050px" %)Fiscal year starting in July 78 +|(% style="width:168px" %)F08|(% style="width:2050px" %)Fiscal year starting in August 79 +|(% style="width:168px" %)F09|(% style="width:2050px" %)Fiscal year starting in September 80 +|(% style="width:168px" %)F10|(% style="width:2050px" %)Fiscal year starting in October 81 +|(% style="width:168px" %)F11|(% style="width:2050px" %)Fiscal year starting in November 82 +|(% style="width:168px" %)F12|(% style="width:2050px" %)Fiscal year starting in December 83 83 84 - 85 - 86 86 Following this code list, the cases lined out in the problem statement could be coded as such: 87 87 88 -1 .Reporting year is equal to the calendar year86 +1) Reporting year is equal to the calendar year 89 89 90 90 <na_:Series **REF_PERIOD_DETAIL="C" **STO="B1G" REF_AREA="LU" FREQ="Q"> 91 91 <na_:Obs OBS_VALUE="44" TIME_PERIOD="**1995**-Q1"/> ... ... @@ -94,7 +94,7 @@ 94 94 95 95 REF_PERIOD_DETAIL="C" à reporting year 1995 starts 1^^st^^ January 1995 96 96 97 - 1.Reporting year starts on the first day of a month different to January95 +2) Reporting year starts on the first day of a month different to January 98 98 Example: fiscal year starting on the 1^^st^^ of July 99 99 100 100 <na_:Series **REF_PERIOD_DETAIL="F07" **STO="B1G" REF_AREA="LU" FREQ="Q"> ... ... @@ -104,7 +104,7 @@ 104 104 105 105 REF_PERIOD_DETAIL="F07" à reporting year 1995 starts 1^^st^^ July 1995 and Q1 projected on the calendar year goes from: 07-09/1995 106 106 107 - 1.Reporting year starts on a given day in the year105 +3) Reporting year starts on a given day in the year 108 108 Example: tax year starting on the 5^^th^^ of April 109 109 110 110 <na_:Series **REF_PERIOD_DETAIL="F04" **STO="B1G" REF_AREA="LU" FREQ="Q"> ... ... @@ -121,7 +121,7 @@ 121 121 122 122 REF_PERIOD_DETAIL="F_O" à reporting year 1995 has another definition. The case is only partly solved because we do not know the exact date. Additional metadata are needed and the reporting period cannot directly be parsed by a system. 123 123 124 - 1.Reporting year **ends** on a given day in the year122 +4) Reporting year **ends** on a given day in the year 125 125 Example: fiscal year ending on the 30^^th^^ of June, equivalent to fiscal year starting on the 1^^st^^ of July Y-1 126 126 127 127 <na_:Series **REF_PERIOD_DETAIL="??" **STO="B1G" REF_AREA="LU" FREQ="Q"> ... ... @@ -135,7 +135,7 @@ 135 135 136 136 Using the attributes as suggested above, all cases outlined in the National Account examples can be fully covered: 137 137 138 -1 .Reporting year is equal to the calendar year136 +1) Reporting year is equal to the calendar year 139 139 140 140 <na_:Series **REF_PERIOD_DETAIL="C" REPYEARSTART="~-~-01-01"// //**STO="B1G" REF_AREA="LU" FREQ="Q"> 141 141 <na_:Obs OBS_VALUE="44" TIME_PERIOD="**1995**-Q1"/> ... ... @@ -143,7 +143,7 @@ 143 143 144 144 1995-Q1 is the same as the calendar definition: from 1^^st^^ January 1995 until 31^^st^^ March 1995. In this case, the attribute REPYEARSTART may be omitted, since it expressed the default value of 1^^st^^ January. 145 145 146 -Reporting year starts on the first day of a month different to January 144 +2) Reporting year starts on the first day of a month different to January 147 147 Example: fiscal year starting on the 1^^st^^ of July 148 148 149 149 <na_:Series **REF_PERIOD_DETAIL="F07" REPYEARSTART="~-~-07-01" **STO="B1G" REF_AREA="LU" FREQ="Q"> ... ... @@ -152,7 +152,7 @@ 152 152 153 153 Reporting period 1995-Q1 lasts in that case from 1^^st^^ July 1995 until 30^^th^^ September 1995. 154 154 155 - 1.Reporting year starts on a given day in the year153 +3) Reporting year starts on a given day in the year 156 156 Example: tax year starting on the 5^^th^^ of April 157 157 158 158 <na_:Series **REF_PERIOD_DETAIL="F04" REPYEARSTART="~-~-04-05" **STO="B1G" REF_AREA="LU" FREQ="Q"> ... ... @@ -161,7 +161,7 @@ 161 161 162 162 Reporting period 1995-Q1 lasts in that case from 5^^th^^ April 1995 until 4^^th^^ July 1995. 163 163 164 - 1.Reporting year **ends** on a given day in the year162 +4) Reporting year **ends** on a given day in the year 165 165 Example: fiscal year ending on the 30^^th^^ of June, equivalent to fiscal year starting on the 1^^st^^ of July Y-1 166 166 167 167 <na_:Series **REF_PERIOD_DETAIL="??" REPYEAREND="~-~-06-30" **STO="B1G" REF_AREA="LU" FREQ="Q"> ... ... @@ -170,7 +170,7 @@ 170 170 171 171 Reporting period 1995-Q1 lasts in that case from 1^^st^^ July 1994 until 30^^th^^ September 1994 172 172 173 - 1. Example 2: Based on Agriculture data exchange171 += 4. Example 2: Based on Agriculture data exchange = 174 174 175 175 == //Problem statement// == 176 176 ... ... @@ -244,15 +244,16 @@ 244 244 245 245 **Sample Data for China** 246 246 247 -|**Crop year**|**Season**|**Calendar period**|**Units** 248 -|**2011**|Winter|Sep-Oct 2010|100 planted 249 -| | |May-Jun 2011|100 harvested 250 -| |Summer|Mar-Apr 2011|200 planted 251 -| | |Jul-Aug 2011|200 harvested 252 -|**2012**|Winter|Sep-Oct 2011|120 planted 253 -| | |May-Jun 2011|120 harvested 254 -| |Summer|Mar-Apr 2012|220 planted 255 -| | |Jul-Aug 2012|220 harvested 245 +(% style="width:918.446px" %) 246 +|(% style="width:121px" %)**Crop year**|(% style="width:165px" %)**Season**|(% style="width:191px" %)**Calendar period**|(% style="width:438px" %)**Units** 247 +|(% style="width:121px" %)**2011**|(% style="width:165px" %)Winter|(% style="width:191px" %)Sep-Oct 2010|(% style="width:438px" %)100 planted 248 +|(% style="width:121px" %) |(% style="width:165px" %) |(% style="width:191px" %)May-Jun 2011|(% style="width:438px" %)100 harvested 249 +|(% style="width:121px" %) |(% style="width:165px" %)Summer|(% style="width:191px" %)Mar-Apr 2011|(% style="width:438px" %)200 planted 250 +|(% style="width:121px" %) |(% style="width:165px" %) |(% style="width:191px" %)Jul-Aug 2011|(% style="width:438px" %)200 harvested 251 +|(% style="width:121px" %)**2012**|(% style="width:165px" %)Winter|(% style="width:191px" %)Sep-Oct 2011|(% style="width:438px" %)120 planted 252 +|(% style="width:121px" %) |(% style="width:165px" %) |(% style="width:191px" %)May-Jun 2011|(% style="width:438px" %)120 harvested 253 +|(% style="width:121px" %) |(% style="width:165px" %)Summer|(% style="width:191px" %)Mar-Apr 2012|(% style="width:438px" %)220 planted 254 +|(% style="width:121px" %) |(% style="width:165px" %) |(% style="width:191px" %)Jul-Aug 2012|(% style="width:438px" %)220 harvested 256 256 257 257 == //Recommendations based on the Use Cases from Agriculture// == 258 258