Last modified by Artur on 2025/08/19 10:43

From version 5.2
edited by Helena
on 2025/05/21 21:41
Change comment: There is no comment for this version
To version 5.5
edited by Helena
on 2025/05/21 21:51
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -371,50 +371,47 @@
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 **o **Standard Time Period**
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//
375 375  
376 - § **Basic Time Period**
377 -
378 -* **Gregorian Time Period**
379 -* //Date Time//
380 -
381 -§ **Reporting Time Period **o //Time Range//
382 -
383 383  The details of these time period categories and of the distinct formats which make them up are detailed in the sections to follow.
384 384  
385 -==== 4.2.2 Observational Time Period ====
384 +=== 4.2.2 Observational Time Period ===
386 386  
387 387  This is the superset of all time representations in SDMX. This allows for time to be expressed as any of the allowable formats.
388 388  
389 -==== 4.2.3 Standard Time Period ====
388 +=== 4.2.3 Standard Time Period ===
390 390  
391 391  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).
392 392  
393 -==== 4.2.4 Gregorian Time Period ====
392 +=== 4.2.4 Gregorian Time Period ===
394 394  
395 395  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:
396 396  
397 -**Gregorian Year:**
398 -
396 +**Gregorian Year:**
399 399  Representation: xs:gYear (YYYY)
398 +Period: the start of January 1 to the end of December 31
400 400  
401 -Period: the start of January 1 to the end of December 31 **Gregorian Year Month**:
402 -
400 +**Gregorian Year Month**:
403 403  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
404 404  
405 -Period: the start of the first day of the month to end of the last day of the month **Gregorian Day**:
406 -
404 +**Gregorian Day**:
407 407  Representation: xs:date (YYYY-MM-DD)
408 -
409 409  Period: the start of the day (00:00:00) to the end of the day (23:59:59)
410 410  
411 -==== 4.2.5 Date Time ====
408 +=== 4.2.5 Date Time ===
412 412  
413 413  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.
414 414  
415 415  Representation: xs:dateTime (YYYY-MM-DDThh:mm:ss)[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^~[1~]^^>>path:#_ftn1]]
416 416  
417 -==== 4.2.6 Standard Reporting Period ====
414 +=== 4.2.6 Standard Reporting Period ===
418 418  
419 419  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:
420 420  
... ... @@ -421,75 +421,52 @@
421 421  [REPORTING_YEAR]-[PERIOD_INDICATOR][PERIOD_VALUE]
422 422  
423 423  Where:
424 -
425 425  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 -
427 427  PERIOD_VALUE indicates the actual period within the year
428 428  
429 429  The following section details each of the standard reporting periods defined in SDMX:
430 430  
431 -**Reporting Year**:
432 -
433 - Period Indicator: A
434 -
426 +**Reporting Year**:
427 +Period Indicator: A
435 435  Period Duration: P1Y (one year)
436 -
437 437  Limit per year: 1
430 +Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1)
438 438  
439 -Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1) **Reporting Semester:**
440 -
441 - Period Indicator: S
442 -
432 +**Reporting Semester:**
433 +Period Indicator: S
443 443  Period Duration: P6M (six months)
444 -
445 445  Limit per year: 2
436 +Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2)
446 446  
447 -Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2) **Reporting Trimester:**
448 -
449 - Period Indicator: T
450 -
438 +**Reporting Trimester:**
439 +Period Indicator: T
451 451  Period Duration: P4M (four months)
452 -
453 453  Limit per year: 3
442 +Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3)
454 454  
455 -Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3) **Reporting Quarter:**
456 -
457 - Period Indicator: Q
458 -
444 +**Reporting Quarter:**
445 +Period Indicator: Q
459 459  Period Duration: P3M (three months)
460 -
461 461  Limit per year: 4
448 +Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4)
462 462  
463 -Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4) **Reporting Month**:
464 -
450 +**Reporting Month**:
465 465  Period Indicator: M
466 -
467 467  Period Duration: P1M (one month)
468 -
469 469  Limit per year: 1
470 -
471 471  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.
472 472  
473 473  **Reporting Week**:
474 -
475 475  Period Indicator: W
476 -
477 477  Period Duration: P7D (seven days)
478 -
479 479  Limit per year: 53
480 -
481 481  Representation: common:ReportingWeekType (YYYY-Www, e.g. 2000-W53)
482 -
483 483  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.
484 484  
485 485  **Reporting Day**:
486 -
487 487  Period Indicator: D
488 -
489 489  Period Duration: P1D (one day)
490 -
491 491  Limit per year: 366
492 -
493 493  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).
494 494  
495 495  This allows the values to be sorted chronologically using textual sorting methods.
... ... @@ -500,55 +500,39 @@
500 500  
501 501  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]):
502 502  
503 -1. **Determine [REPORTING_YEAR_BASE]:**
504 -
477 +**~1. Determine [REPORTING_YEAR_BASE]:**
505 505  Combine [REPORTING_YEAR] of the reporting period value (YYYY) with [REPORTING_YEAR_START_DAY] (MM-DD) to get a date (YYYY-MM-DD).
506 -
507 507  This is the [REPORTING_YEAR_START_DATE]
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 -
480 +**a) If the [PERIOD_INDICATOR] is W:
481 +~1. If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:**
516 516  Add^^3^^ (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
517 517  
518 -1.
519 -11.
520 -111.
521 -1111. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
522 -
484 +​​​​​​​2. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
523 523  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]
524 524  
525 -b) **Else:**
489 +**2. Determine [PERIOD_DURATION]:**
526 526  
527 -The [REPORTING_YEAR_START_DATE] is the [REPORTING_YEAR_BASE].
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.
528 528  
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 -
499 +**3. Determine [PERIOD_START]:**
540 540  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].
541 541  
542 -1. **Determine the [PERIOD_END]:**
543 -
502 +**4. Determine the [PERIOD_END]:**
544 544  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].
545 545  
546 546  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).
547 547  
548 -**Examples: **
507 +**Examples:
508 +2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)**
549 549  
550 -**2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)**
551 -
552 552  ~1. [REPORTING_YEAR_START_DATE] = 2010-07-01
553 553  
554 554  b) [REPORTING_YEAR_BASE] = 2010-07-01