Skip to Content
Last modified by Artur on 2025/08/19 10:43
From version 5.6
edited by Helena
on 2025/05/21 21:52
Change comment: There is no comment for this version
To version 5.2
edited by Helena
on 2025/05/21 21:41
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -371,47 +371,50 @@
371 371  
372 372  The hierarchy of time formats is as follows (**bold** indicates a category which is made up of multiple formats, //italic// indicates a distinct format):
373 373  
374 -* **Observational Time Period**
375 -** **Standard Time Period**
376 -*** **Basic Time Period**
377 -**** **Gregorian Time Period**
378 -**** //Date Time//
379 -*** **Reporting Time Period**
380 -** //Time Range//
374 +* **Observational Time Period **o **Standard Time Period**
381 381  
376 + § **Basic Time Period**
377 +
378 +* **Gregorian Time Period**
379 +* //Date Time//
380 +
381 +§ **Reporting Time Period **o //Time Range//
382 +
382 382  The details of these time period categories and of the distinct formats which make them up are detailed in the sections to follow.
383 383  
384 -=== 4.2.2 Observational Time Period ===
385 +==== 4.2.2 Observational Time Period ====
385 385  
386 386  This is the superset of all time representations in SDMX. This allows for time to be expressed as any of the allowable formats.
387 387  
388 -=== 4.2.3 Standard Time Period ===
389 +==== 4.2.3 Standard Time Period ====
389 389  
390 390  This is the superset of any predefined time period or a distinct point in time. A time period consists of a distinct start and end point. If the start and end of a period are expressed as date instead of a complete date time, then it is implied that the start of the period is the beginning of the start day (i.e. 00:00:00) and the end of the period is the end of the end day (i.e. 23:59:59).
391 391  
392 -=== 4.2.4 Gregorian Time Period ===
393 +==== 4.2.4 Gregorian Time Period ====
393 393  
394 394  A Gregorian time period is always represented by a Gregorian year, year-month, or day. These are all based on ISO 8601 dates. The representation in SDMX-ML messages and the period covered by each of the Gregorian time periods are as follows:
395 395  
396 -**Gregorian Year:**
397 +**Gregorian Year:**
398 +
397 397  Representation: xs:gYear (YYYY)
398 -Period: the start of January 1 to the end of December 31
399 399  
400 -**Gregorian Year Month**:
401 +Period: the start of January 1 to the end of December 31 **Gregorian Year Month**:
402 +
401 401  Representation: xs:gYearMonth (YYYY-MM)
402 -Period: the start of the first day of the month to end of the last day of the month
403 403  
404 -**Gregorian Day**:
405 +Period: the start of the first day of the month to end of the last day of the month **Gregorian Day**:
406 +
405 405  Representation: xs:date (YYYY-MM-DD)
408 +
406 406  Period: the start of the day (00:00:00) to the end of the day (23:59:59)
407 407  
408 -=== 4.2.5 Date Time ===
411 +==== 4.2.5 Date Time ====
409 409  
410 410  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.
411 411  
412 412  Representation: xs:dateTime (YYYY-MM-DDThh:mm:ss)[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^~[1~]^^>>path:#_ftn1]]
413 413  
414 -=== 4.2.6 Standard Reporting Period ===
417 +==== 4.2.6 Standard Reporting Period ====
415 415  
416 416  Standard reporting periods are periods of time in relation to a reporting year. Each of these standard reporting periods has a duration (based on the ISO 8601 definition) associated with it. The general format of a reporting period is as follows:
417 417  
... ... @@ -418,52 +418,75 @@
418 418  [REPORTING_YEAR]-[PERIOD_INDICATOR][PERIOD_VALUE]
419 419  
420 420  Where:
424 +
421 421  REPORTING_YEAR represents the reporting year as four digits (YYYY) PERIOD_INDICATOR identifies the type of period which determines the duration of the period
426 +
422 422  PERIOD_VALUE indicates the actual period within the year
423 423  
424 424  The following section details each of the standard reporting periods defined in SDMX:
425 425  
426 -**Reporting Year**:
427 -Period Indicator: A
431 +**Reporting Year**:
432 +
433 + Period Indicator: A
434 +
428 428  Period Duration: P1Y (one year)
436 +
429 429  Limit per year: 1
430 -Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1)
431 431  
432 -**Reporting Semester:**
433 -Period Indicator: S
439 +Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1) **Reporting Semester:**
440 +
441 + Period Indicator: S
442 +
434 434  Period Duration: P6M (six months)
444 +
435 435  Limit per year: 2
436 -Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2)
437 437  
438 -**Reporting Trimester:**
439 -Period Indicator: T
447 +Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2) **Reporting Trimester:**
448 +
449 + Period Indicator: T
450 +
440 440  Period Duration: P4M (four months)
452 +
441 441  Limit per year: 3
442 -Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3)
443 443  
444 -**Reporting Quarter:**
445 -Period Indicator: Q
455 +Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3) **Reporting Quarter:**
456 +
457 + Period Indicator: Q
458 +
446 446  Period Duration: P3M (three months)
460 +
447 447  Limit per year: 4
448 -Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4)
449 449  
450 -**Reporting Month**:
463 +Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4) **Reporting Month**:
464 +
451 451  Period Indicator: M
466 +
452 452  Period Duration: P1M (one month)
468 +
453 453  Limit per year: 1
470 +
454 454  Representation: common:ReportingMonthType (YYYY-Mmm, e.g. 2000-M12) Notes: The reporting month 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.
455 455  
456 456  **Reporting Week**:
474 +
457 457  Period Indicator: W
476 +
458 458  Period Duration: P7D (seven days)
478 +
459 459  Limit per year: 53
480 +
460 460  Representation: common:ReportingWeekType (YYYY-Www, e.g. 2000-W53)
482 +
461 461  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" %)^^~[2~]^^>>path:#_ftn2]](%%) 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.
462 462  
463 463  **Reporting Day**:
486 +
464 464  Period Indicator: D
488 +
465 465  Period Duration: P1D (one day)
490 +
466 466  Limit per year: 366
492 +
467 467  Representation: common:ReportingDayType (YYYY-Dddd, e.g. 2000-D366) Notes: There are either 365 or 366 days in a reporting year, depending on whether the reporting year includes leap day (February 29). The reporting day is always represented as three digits, therefore 1-99 are 0 padded (e.g. 001).
468 468  
469 469  This allows the values to be sorted chronologically using textual sorting methods.
... ... @@ -474,48 +474,72 @@
474 474  
475 475  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]):
476 476  
477 -**~1. Determine [REPORTING_YEAR_BASE]:**
503 +1. **Determine [REPORTING_YEAR_BASE]:**
504 +
478 478  Combine [REPORTING_YEAR] of the reporting period value (YYYY) with [REPORTING_YEAR_START_DAY] (MM-DD) to get a date (YYYY-MM-DD).
506 +
479 479  This is the [REPORTING_YEAR_START_DATE]
480 -**a) If the [PERIOD_INDICATOR] is W:
481 -~1. If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:**
508 +
509 +**a) If the [PERIOD_INDICATOR] is W:**
510 +
511 +1.
512 +11.
513 +111.
514 +1111. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:**
515 +
482 482  Add^^3^^ (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
483 483  
484 -​​​​​​​2. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
518 +1.
519 +11.
520 +111.
521 +1111. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
522 +
485 485  Add^^3^^ (P0D, -P1D, -P2D, or -P3D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
486 -b) **Else:** 
487 -The [REPORTING_YEAR_START_DATE] is the [REPORTING_YEAR_BASE]
488 488  
489 -**2. Determine [PERIOD_DURATION]:**
525 +b) **Else:**
490 490  
491 -a) If the [PERIOD_INDICATOR] is A, the [PERIOD_DURATION] is P1Y.
492 -b) If the [PERIOD_INDICATOR] is S, the [PERIOD_DURATION] is P6M.
493 -c) If the [PERIOD_INDICATOR] is T, the [PERIOD_DURATION] is P4M.
494 -d) If the [PERIOD_INDICATOR] is Q, the [PERIOD_DURATION] is P3M.
495 -e) If the [PERIOD_INDICATOR] is M, the [PERIOD_DURATION] is P1M.
496 -f) If the [PERIOD_INDICATOR] is W, the [PERIOD_DURATION] is P7D.
497 -g) If the [PERIOD_INDICATOR] is D, the [PERIOD_DURATION] is P1D.
527 +The [REPORTING_YEAR_START_DATE] is the [REPORTING_YEAR_BASE].
498 498  
499 -**3. Determine [PERIOD_START]:**
529 +1. **Determine [PERIOD_DURATION]:**
530 +11.
531 +111. If the [PERIOD_INDICATOR] is A, the [PERIOD_DURATION] is P1Y.
532 +111. If the [PERIOD_INDICATOR] is S, the [PERIOD_DURATION] is P6M.
533 +111. If the [PERIOD_INDICATOR] is T, the [PERIOD_DURATION] is P4M.
534 +111. If the [PERIOD_INDICATOR] is Q, the [PERIOD_DURATION] is P3M.
535 +111. If the [PERIOD_INDICATOR] is M, the [PERIOD_DURATION] is P1M.
536 +111. If the [PERIOD_INDICATOR] is W, the [PERIOD_DURATION] is P7D.
537 +111. If the [PERIOD_INDICATOR] is D, the [PERIOD_DURATION] is P1D.
538 +1. **Determine [PERIOD_START]:**
539 +
500 500  Subtract one from the [PERIOD_VALUE] and multiply this by the [PERIOD_DURATION]. Add[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^~[3~]^^>>path:#_ftn3]](%%) this to the [REPORTING_YEAR_BASE]. The result is the [PERIOD_START].
501 501  
502 -**4. Determine the [PERIOD_END]:**
542 +1. **Determine the [PERIOD_END]:**
543 +
503 503  Multiply the [PERIOD_VALUE] by the [PERIOD_DURATION]. Add^^3^^ this to the [REPORTING_YEAR_BASE] add^^3^^ -P1D. The result is the [PERIOD_END].
504 504  
505 505  For all of these ranges, the bounds include the beginning of the [PERIOD_START] (i.e. 00:00:00) and the end of the [PERIOD_END] (i.e. 23:59:59).
506 506  
507 -**Examples:**
548 +**Examples: **
508 508  
509 509  **2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)**
551 +
510 510  ~1. [REPORTING_YEAR_START_DATE] = 2010-07-01
553 +
511 511  b) [REPORTING_YEAR_BASE] = 2010-07-01
512 -[PERIOD_DURATION] = P3M
513 -(2-1) * P3M = P3M
555 +
556 +1. [PERIOD_DURATION] = P3M
557 +1. (2-1) * P3M = P3M
558 +
514 514  2010-07-01 + P3M = 2010-10-01
560 +
515 515  [PERIOD_START] = 2010-10-01
562 +
516 516  4. 2 * P3M = P6M
564 +
517 517  2010-07-01 + P6M = 2010-13-01 = 2011-01-01
566 +
518 518  2011-01-01 + -P1D = 2010-12-31
568 +
519 519  [PERIOD_END] = 2011-12-31
520 520  
521 521  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