Skip to Content
Last modified by Helena on 2025/09/10 11:19
From version 4.6
edited by Helena
on 2025/05/16 11:22
Change comment: There is no comment for this version
To version 4.2
edited by Helena
on 2025/05/16 11:11
Change comment: There is no comment for this version

Summary

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 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" %)^^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,31 +282,38 @@
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 +
288 288  This is the [REPORTING_YEAR_START_DATE]
289 289  
290 -**a) If the [PERIOD_INDICATOR] is W:**
291 +1.
292 +11. **If the [PERIOD_INDICATOR] is W:**
293 +111. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:**
291 291  
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].
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].
294 294  
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].
297 +1.
298 +11.
299 +111. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
297 297  
298 -**b) Else:**
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 +
299 299  The [REPORTING_YEAR_START_DATE] is the [REPORTING_YEAR_BASE].
300 300  
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]:**
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]:**
310 310  
311 311  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].
312 312  
... ... @@ -319,34 +319,53 @@
319 319  **Examples:**
320 320  
321 321  **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
328 328  
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
330 +1. [REPORTING_YEAR_START_DATE] = 2010-07-01
333 333  
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 +
334 334  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
335 335  
336 336  **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
349 349  
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 +
350 350  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
351 351  
352 352  === {{id name="_Toc291513"/}}4.2.7 Distinct Range ===