Changes for page 4 General Notes for Implementers
Last modified by Helena on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -260,7 +260,7 @@ 260 260 261 261 Representation: common:ReportingWeekType (YYYY-Www, e.g. 2000-W53) 262 262 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 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 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. 264 264 265 265 **Reporting Day**: 266 266 ... ... @@ -282,38 +282,31 @@ 282 282 283 283 Since the duration and the reporting year start day are known for any reporting period, it is possible to relate any reporting period to a distinct calendar period. The actual Gregorian calendar period covered by the reporting period can be computed as follows (based on the standard format of [REPROTING_YEAR]-[PERIOD_INDICATOR][PERIOD_VALUE] and the reporting year start day as [REPORTING_YEAR_START_DAY]): 284 284 285 -1. **Determine [REPORTING_YEAR_BASE]:**285 +**~1. Determine [REPORTING_YEAR_BASE]:** 286 286 287 287 Combine [REPORTING_YEAR] of the reporting period value (YYYY) with [REPORTING_YEAR_START_DAY] (MM-DD) to get a date (YYYY-MM-DD). 288 - 289 289 This is the [REPORTING_YEAR_START_DATE] 290 290 291 -1. 292 -11. **If the [PERIOD_INDICATOR] is W:** 293 -111. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:** 290 +**a) If the [PERIOD_INDICATOR] is W:** 294 294 295 -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]. 292 + ~1. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday**: 293 + 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]. 296 296 297 -1. 298 -11. 299 -111. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:** 295 +**~ 2. If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:** 296 + Add^^4^^ (P0D, -P1D, -P2D, or -P3D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE]. 300 300 301 -Add^^4^^ (P0D, -P1D, -P2D, or -P3D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE]. 302 - 303 -1. 304 -11. **Else:** 305 - 298 +**b) Else:** 306 306 The [REPORTING_YEAR_START_DATE] is the [REPORTING_YEAR_BASE]. 307 307 308 - 1.**Determine [PERIOD_DURATION]:**309 - 11.If the [PERIOD_INDICATOR] is A, the [PERIOD_DURATION] is P1Y.310 - 11.If the [PERIOD_INDICATOR] is S, the [PERIOD_DURATION] is P6M.311 - 11.If the [PERIOD_INDICATOR] is T, the [PERIOD_DURATION] is P4M.312 - 11.If the [PERIOD_INDICATOR] is Q, the [PERIOD_DURATION] is P3M.313 - 11.If the [PERIOD_INDICATOR] is M, the [PERIOD_DURATION] is P1M.314 - 11.If the [PERIOD_INDICATOR] is W, the [PERIOD_DURATION] is P7D.315 - 11.If the [PERIOD_INDICATOR] is D, the [PERIOD_DURATION] is P1D.316 - 1.**Determine [PERIOD_START]:**301 +**2. Determine [PERIOD_DURATION]:** 302 +a) If the [PERIOD_INDICATOR] is A, the [PERIOD_DURATION] is P1Y. 303 +b) If the [PERIOD_INDICATOR] is S, the [PERIOD_DURATION] is P6M. 304 +c) If the [PERIOD_INDICATOR] is T, the [PERIOD_DURATION] is P4M. 305 +d) If the [PERIOD_INDICATOR] is Q, the [PERIOD_DURATION] is P3M. 306 +e) If the [PERIOD_INDICATOR] is M, the [PERIOD_DURATION] is P1M. 307 +f) If the [PERIOD_INDICATOR] is W, the [PERIOD_DURATION] is P7D. 308 +g) If the [PERIOD_INDICATOR] is D, the [PERIOD_DURATION] is P1D. 309 +**3. Determine [PERIOD_START]:** 317 317 318 318 Subtract one from the [PERIOD_VALUE] and multiply this by the [PERIOD_DURATION]. Add^^4^^ this to the [REPORTING_YEAR_BASE]. The result is the [PERIOD_START]. 319 319 ... ... @@ -326,53 +326,34 @@ 326 326 **Examples:** 327 327 328 328 **2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)** 322 +~1. [REPORTING_YEAR_START_DATE] = 2010-07-01 323 + b) [REPORTING_YEAR_BASE] = 2010-07-01 324 +2. [PERIOD_DURATION] = P3M 325 +3. (2-1) * P3M = P3M 326 + 2010-07-01 + P3M = 2010-10-01 327 + [PERIOD_START] = 2010-10-01 329 329 330 -1. [REPORTING_YEAR_START_DATE] = 2010-07-01 329 +4. 2 * P3M = P6M 330 + 2010-07-01 + P6M = 2010-13-01 = 2011-01-01 331 + 2011-01-01 + -P1D = 2010-12-31 332 + [PERIOD_END] = 2010-12-31 331 331 332 -b) [REPORTING_YEAR_BASE] = 2010-07-01 333 - 334 -1. [PERIOD_DURATION] = P3M 335 -1. (2-1) * P3M = P3M 336 - 337 -2010-07-01 + P3M = 2010-10-01 338 - 339 -[PERIOD_START] = 2010-10-01 340 - 341 -1. 2 * P3M = P6M 342 - 343 -2010-07-01 + P6M = 2010-13-01 = 2011-01-01 344 - 345 -2011-01-01 + -P1D = 2010-12-31 346 - 347 -[PERIOD_END] = 2010-12-31 348 - 349 349 The actual calendar range covered by 2010-Q2 (assuming the reporting year begins July 1) is 2010-10-01T00:00:00/2010-12-31T23:59:59 350 350 351 351 **2011-W36, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)** 337 +~1. [REPORTING_YEAR_START_DATE] = 2010-07-01 338 + a) 2011-07-01 = Friday 339 + 2011-07-01 + P3D = 2011-07-04 340 + [REPORTING_YEAR_BASE] = 2011-07-04 341 +2. [PERIOD_DURATION] = P7D 342 +3. (36-1) * P7D = P245D 343 + 2011-07-04 + P245D = 2012-03-05 344 + [PERIOD_START] = 2012-03-05 345 +4. 36 * P7D = P252D 346 + 2011-07-04 + P252D =2012-03-12 347 + 2012-03-12 + -P1D = 2012-03-11 348 + [PERIOD_END] = 2012-03-11 352 352 353 -1. [REPORTING_YEAR_START_DATE] = 2010-07-01 354 - 355 -a) 2011-07-01 = Friday 356 - 357 -2011-07-01 + P3D = 2011-07-04 358 - 359 -[REPORTING_YEAR_BASE] = 2011-07-04 360 - 361 -1. [PERIOD_DURATION] = P7D 362 -1. (36-1) * P7D = P245D 363 - 364 -2011-07-04 + P245D = 2012-03-05 365 - 366 -[PERIOD_START] = 2012-03-05 367 - 368 -1. 36 * P7D = P252D 369 - 370 -2011-07-04 + P252D =2012-03-12 371 - 372 -2012-03-12 + -P1D = 2012-03-11 373 - 374 -[PERIOD_END] = 2012-03-11 375 - 376 376 The actual calendar range covered by 2011-W36 (assuming the reporting year begins July 1) is 2012-03-05T00:00:00/2012-03-11T23:59:59 377 377 378 378 === {{id name="_Toc291513"/}}4.2.7 Distinct Range ===