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
-
... ... @@ -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