Last modified by Helena on 2025/09/10 11:19

From version 3.6
edited by Helena
on 2025/05/15 23:54
Change comment: There is no comment for this version
To version 3.12
edited by Helena
on 2025/05/16 00:01
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -102,29 +102,27 @@
102 102  
103 103  Further to the above, the mapping between the non-native data types is presented in the table below:
104 104  
105 -(% style="width:1026.29px" %)
106 -|(% style="width:159px" %)**SDMX Facet**|(% style="width:179px" %)**XML Schema**|(% style="width:683px" %)**JSON schema **"**pattern**"{{footnote}}Regular expressions, as specified in W3C XML Schema Definition Language (XSD) 1.1 Part 2: Datatypes.{{/footnote}} **for "string" type**
107 -|(% style="width:159px" %)GregorianYear|(% style="width:179px" %)xsd:gYear|(% style="width:683px" %)(((
105 +(% style="width:1146.29px" %)
106 +|(% style="width:159px" %)**SDMX Facet**|(% style="width:179px" %)**XML Schema**|(% style="width:800px" %)**JSON schema **"**pattern**"{{footnote}}Regular expressions, as specified in W3C XML Schema Definition Language (XSD) 1.1 Part 2: Datatypes.{{/footnote}} **for "string" type**
107 +|(% style="width:159px" %)GregorianYear|(% style="width:179px" %)xsd:gYear|(% style="width:800px" %)(((
108 108  "^-?( [1-9] [0-9] {3,}|0[0-9]{3}) (Z| (\ + | -) ((0 [0 - 9]| 1[0 - 3]):[0 - 5] [0 - 9] | 14:00))?$"
109 109  )))
110 -|(% style="width:159px" %)GregorianMonth|(% style="width:179px" %)xsd:gYearMonth|(% style="width:683px" %)(((
110 +|(% style="width:159px" %)GregorianMonth|(% style="width:179px" %)xsd:gYearMonth|(% style="width:800px" %)(((
111 111  "^-?([1-9] [0-9] {3,}|0 [0-9] {3}) - (0 [1-9]|1[ 0- 2])(Z|(\+|-)((0[0-9]|1[0-3]):[0-5] [0 - 9]|14:00))?$"
112 112  )))
113 -
114 -(% style="width:1030.29px" %)
115 -|(% style="width:163px" %)GregorianDay|(% style="width:179px" %)xsd:date|(% style="width:684px" %)(((
113 +|(% style="width:163px" %)GregorianDay|(% style="width:179px" %)xsd:date|(% style="width:800px" %)(((
116 116  "^-?([1-9][0-9]{3,}|0[0-9]{3})-(0[1-9]|1[0-2])- (0[1-9]|[12][0-9]|3[01])(Z|(\+|-)((0[0-9]|1[0- 3]):[0-5][0-9]|14:00))?$"
117 117  )))
118 -|(% style="width:163px" %)Day|(% style="width:179px" %)xsd:gDay|(% style="width:684px" %)(((
116 +|(% style="width:163px" %)Day|(% style="width:179px" %)xsd:gDay|(% style="width:800px" %)(((
119 119  "^~-~--(0[1-9]|[12][0-9]|3[01])(Z|(\+|- )((0[0-9]|1[0-3]):[0-5][0-9]|14:00))?$"
120 120  )))
121 -|(% style="width:163px" %)MonthDay|(% style="width:179px" %)xsd:gMonthDay|(% style="width:684px" %)(((
119 +|(% style="width:163px" %)MonthDay|(% style="width:179px" %)xsd:gMonthDay|(% style="width:800px" %)(((
122 122  "^~-~-(0[1-9]|1[0-2])-(0[1-9]|[12][0- 9]|3[01])(Z|(\+|-)((0[0-9]|1[0-3]):[0-5][0- 9]|14:00))?$"
123 123  )))
124 -|(% style="width:163px" %)Month|(% style="width:179px" %)xsd:Month|(% style="width:684px" %)(((
122 +|(% style="width:163px" %)Month|(% style="width:179px" %)xsd:Month|(% style="width:800px" %)(((
125 125  "^~-~-(0[1-9]|1[0-2])(Z|(\+|-)((0[0-9]|1[0- 3]):[0-5][0-9]|14:00))?$"
126 126  )))
127 -|(% style="width:163px" %)Duration|(% style="width:179px" %)xsd:duration|(% style="width:684px" %)(((
125 +|(% style="width:163px" %)Duration|(% style="width:179px" %)xsd:duration|(% style="width:800px" %)(((
128 128  "^-?P[0-9]+Y?([0-9]+M)?([0-9]+D)?(T([0- 9]+H)?([0-9]+M)?([0-9]+(\.[0-9]+)?S)?)?$"
129 129  )))
130 130  
... ... @@ -140,17 +140,14 @@
140 140  
141 141  The hierarchy of time formats is as follows (**bold** indicates a category which is made up of multiple formats, //italic// indicates a distinct format):
142 142  
143 -* **Observational Time Period **o **Standard Time Period**
141 +* **Observational Time Period**
142 +** **Standard Time Period**
143 +*** **Basic Time Period**
144 +**** **Gregorian Time Period**
145 +**** //Date Time//
146 +*** **Reporting Time Period**
147 +** **//Time Range//**
144 144  
145 -▪ **Basic Time Period**
146 -
147 -* **Gregorian Time Period**
148 -* //Date Time//
149 -
150 -▪ **Reporting Time Period**
151 -
152 -o //Time Range//
153 -
154 154  The details of these time period categories and of the distinct formats which make them up are detailed in the sections to follow.
155 155  
156 156  === {{id name="_Toc291508"/}}4.2.2 Observational Time Period ===
... ... @@ -169,12 +169,16 @@
169 169  
170 170  Representation: xs:gYear (YYYY)
171 171  
172 -Period: the start of January 1 to the end of December 31 **Gregorian Year Month**:
167 +Period: the start of January 1 to the end of December 31
173 173  
169 +**Gregorian Year Month**:
170 +
174 174  Representation: xs:gYearMonth (YYYY-MM)
175 175  
176 -Period: the start of the first day of the month to end of the last day of the month **Gregorian Day**:
173 +Period: the start of the first day of the month to end of the last day of the month
177 177  
175 +**Gregorian Day**:
176 +
178 178  Representation: xs:date (YYYY-MM-DD)
179 179  
180 180  Period: the start of the day (00:00:00) to the end of the day (23:59:59)
... ... @@ -183,7 +183,7 @@
183 183  
184 184  This is used to unambiguously state that a date-time represents an observation at a single point in time. Therefore, if one wants to use SDMX for data which is measured at a distinct point in time rather than being reported over a period, the date-time representation can be used.
185 185  
186 -Representation: xs:dateTime (YYYY-MM-DDThh:mm:ss)^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^2^^>>path:#sdfootnote2sym||name="sdfootnote2anc"]](%%)^^
185 +Representation: xs:dateTime (YYYY-MM-DDThh:mm:ss){{footnote}}The seconds can be reported fractionally{{/footnote}}
187 187  
188 188  === {{id name="_Toc291512"/}}4.2.6 Standard Reporting Period ===
189 189  
... ... @@ -207,8 +207,10 @@
207 207  
208 208  Limit per year: 1
209 209  
210 -Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1) **Reporting Semester:**
209 +Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1)
211 211  
211 +**Reporting Semester:**
212 +
212 212  Period Indicator: S
213 213  
214 214  Period Duration: P6M (six months)
... ... @@ -217,8 +217,6 @@
217 217  
218 218  Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2)
219 219  
220 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape2" height="1" width="192"]]
221 -
222 222  **Reporting Trimester:**
223 223  
224 224  Period Indicator: T
... ... @@ -227,8 +227,10 @@
227 227  
228 228  Limit per year: 3
229 229  
230 -Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3) **Reporting Quarter:**
229 +Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3)
231 231  
231 +**Reporting Quarter:**
232 +
232 232  Period Indicator: Q
233 233  
234 234  Period Duration: P3M (three months)
... ... @@ -235,8 +235,10 @@
235 235  
236 236  Limit per year: 4
237 237  
238 -Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4) **Reporting Month**:
239 +Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4)
239 239  
241 +**Reporting Month**:
242 +
240 240  Period Indicator: M
241 241  
242 242  Period Duration: P1M (one month)
... ... @@ -257,7 +257,7 @@
257 257  
258 258  Representation: common:ReportingWeekType (YYYY-Www, e.g. 2000-W53)
259 259  
260 -Notes: There are either 52 or 53 weeks in a reporting year. This is based on the ISO 8601 definition of a week (Monday - Saturday), where the first week of a reporting year is defined as the week with the first Thursday on or after the reporting year start day.^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^3^^>>path:#sdfootnote3sym||name="sdfootnote3anc"]](%%)^^ The reporting week is always represented as two digits, therefore 1-9 are 0 padded (e.g. 01). This allows the values to be sorted chronologically using textual sorting methods.
263 +Notes: There are either 52 or 53 weeks in a reporting year. This is based on the ISO 8601 definition of a week (Monday - Saturday), where the first week of a reporting year is defined as the week with the first Thursday on or after the reporting year start day.^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^3^^>>path:#sdfootnote3sym||name="sdfootnote3anc"]](%%)^^ The reporting week is always represented as two digits, therefore 1-9 are 0 padded (e.g. 01). This allows the values to be sorted chronologically using textual sorting methods.
261 261  
262 262  **Reporting Day**:
263 263  
... ... @@ -295,7 +295,7 @@
295 295  11. **If the [PERIOD_INDICATOR] is W:**
296 296  111. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:**
297 297  
298 -Add^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^4^^>>path:#sdfootnote4sym||name="sdfootnote4anc"]](%%)^^ (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
301 +Add{{footnote}}The rules for adding durations to a date time are described in the W3C XML Schema specification. See http://www.w3.org/TR/xmlschema-2/#adding-durations-to-dateTimes for further details.{{/footnote}} (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
299 299  
300 300  1.
301 301  11.