Changes for page SDMX 2.1 Standards. Section 6. Technical Notes
Last modified by Artur on 2025/08/19 10:43
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -381,39 +381,37 @@ 381 381 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 ====384 +=== 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 ====388 +=== 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 ====392 +=== 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 - 396 +**Gregorian Year:** 398 398 Representation: xs:gYear (YYYY) 398 +Period: the start of January 1 to the end of December 31 399 399 400 -Period: the start of January 1 to the end of December 31 **Gregorian Year Month**: 401 - 400 +**Gregorian Year Month**: 402 402 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 -Period: the start of the first day of the month to end of the last day of the month **Gregorian Day**: 405 - 404 +**Gregorian Day**: 406 406 Representation: xs:date (YYYY-MM-DD) 407 - 408 408 Period: the start of the day (00:00:00) to the end of the day (23:59:59) 409 409 410 -=== =4.2.5 Date Time ====408 +=== 4.2.5 Date Time === 411 411 412 412 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. 413 413 414 414 Representation: xs:dateTime (YYYY-MM-DDThh:mm:ss)[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^~[1~]^^>>path:#_ftn1]] 415 415 416 -=== =4.2.6 Standard Reporting Period ====414 +=== 4.2.6 Standard Reporting Period === 417 417 418 418 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: 419 419 ... ... @@ -420,75 +420,52 @@ 420 420 [REPORTING_YEAR]-[PERIOD_INDICATOR][PERIOD_VALUE] 421 421 422 422 Where: 423 - 424 424 REPORTING_YEAR represents the reporting year as four digits (YYYY) PERIOD_INDICATOR identifies the type of period which determines the duration of the period 425 - 426 426 PERIOD_VALUE indicates the actual period within the year 427 427 428 428 The following section details each of the standard reporting periods defined in SDMX: 429 429 430 -**Reporting Year**: 431 - 432 - Period Indicator: A 433 - 426 +**Reporting Year**: 427 +Period Indicator: A 434 434 Period Duration: P1Y (one year) 435 - 436 436 Limit per year: 1 430 +Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1) 437 437 438 -Representation: common:ReportingYearType (YYYY-A1, e.g. 2000-A1) **Reporting Semester:** 439 - 440 - Period Indicator: S 441 - 432 +**Reporting Semester:** 433 +Period Indicator: S 442 442 Period Duration: P6M (six months) 443 - 444 444 Limit per year: 2 436 +Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2) 445 445 446 -Representation: common:ReportingSemesterType (YYYY-Ss, e.g. 2000-S2) **Reporting Trimester:** 447 - 448 - Period Indicator: T 449 - 438 +**Reporting Trimester:** 439 +Period Indicator: T 450 450 Period Duration: P4M (four months) 451 - 452 452 Limit per year: 3 442 +Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3) 453 453 454 -Representation: common:ReportingTrimesterType (YYYY-Tt, e.g. 2000-T3) **Reporting Quarter:** 455 - 456 - Period Indicator: Q 457 - 444 +**Reporting Quarter:** 445 +Period Indicator: Q 458 458 Period Duration: P3M (three months) 459 - 460 460 Limit per year: 4 448 +Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4) 461 461 462 -Representation: common:ReportingQuarterType (YYYY-Qq, e.g. 2000-Q4) **Reporting Month**: 463 - 450 +**Reporting Month**: 464 464 Period Indicator: M 465 - 466 466 Period Duration: P1M (one month) 467 - 468 468 Limit per year: 1 469 - 470 470 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. 471 471 472 472 **Reporting Week**: 473 - 474 474 Period Indicator: W 475 - 476 476 Period Duration: P7D (seven days) 477 - 478 478 Limit per year: 53 479 - 480 480 Representation: common:ReportingWeekType (YYYY-Www, e.g. 2000-W53) 481 - 482 482 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. 483 483 484 484 **Reporting Day**: 485 - 486 486 Period Indicator: D 487 - 488 488 Period Duration: P1D (one day) 489 - 490 490 Limit per year: 366 491 - 492 492 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). 493 493 494 494 This allows the values to be sorted chronologically using textual sorting methods. ... ... @@ -499,55 +499,39 @@ 499 499 500 500 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]): 501 501 502 -1. **Determine [REPORTING_YEAR_BASE]:** 503 - 477 +**~1. Determine [REPORTING_YEAR_BASE]:** 504 504 Combine [REPORTING_YEAR] of the reporting period value (YYYY) with [REPORTING_YEAR_START_DAY] (MM-DD) to get a date (YYYY-MM-DD). 505 - 506 506 This is the [REPORTING_YEAR_START_DATE] 507 - 508 -**a) If the [PERIOD_INDICATOR] is W:** 509 - 510 -1. 511 -11. 512 -111. 513 -1111. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:** 514 - 480 +**a) If the [PERIOD_INDICATOR] is W: 481 +~1. If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday:** 515 515 Add^^3^^ (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE]. 516 516 517 -1. 518 -11. 519 -111. 520 -1111. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:** 521 - 484 +2. **If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:** 522 522 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] 523 523 524 - b)**Else:**489 +**2. Determine [PERIOD_DURATION]:** 525 525 526 -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. 527 527 528 -1. **Determine [PERIOD_DURATION]:** 529 -11. 530 -111. If the [PERIOD_INDICATOR] is A, the [PERIOD_DURATION] is P1Y. 531 -111. If the [PERIOD_INDICATOR] is S, the [PERIOD_DURATION] is P6M. 532 -111. If the [PERIOD_INDICATOR] is T, the [PERIOD_DURATION] is P4M. 533 -111. If the [PERIOD_INDICATOR] is Q, the [PERIOD_DURATION] is P3M. 534 -111. If the [PERIOD_INDICATOR] is M, the [PERIOD_DURATION] is P1M. 535 -111. If the [PERIOD_INDICATOR] is W, the [PERIOD_DURATION] is P7D. 536 -111. If the [PERIOD_INDICATOR] is D, the [PERIOD_DURATION] is P1D. 537 -1. **Determine [PERIOD_START]:** 538 - 499 +**3. Determine [PERIOD_START]:** 539 539 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]. 540 540 541 -1. **Determine the [PERIOD_END]:** 542 - 502 +**4. Determine the [PERIOD_END]:** 543 543 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]. 544 544 545 545 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). 546 546 547 -**Examples: ** 507 +**Examples: 508 +2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)** 548 548 549 -**2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)** 550 - 551 551 ~1. [REPORTING_YEAR_START_DATE] = 2010-07-01 552 552 553 553 b) [REPORTING_YEAR_BASE] = 2010-07-01