Changes for page 13 Structure Mapping
Last modified by Helena on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -311,30 +311,29 @@ 311 311 The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved): 312 312 313 313 (% style="width:896.294px" %) 314 -|**Letter**|(% style="width:340px" %)**Date or Time Component**|(% style="width:153px" %)**Presentation**|(% style="width:172px" %)Examples 315 -|G|(% style="width:340px" %)Era designator|(% style="width:153px" %)Text|(% style="width:172px" %)AD 316 -|yy|(% style="width:340px" %)Year short (upper case is Year of Week{{footnote}}yyyy represents the calendar year while YYYY represents the year of the week, which is only relevant for 53 week years{{/footnote}})|(% style="width:153px" %)Year|(% style="width:172px" %)96 317 -|yyyy|(% style="width:340px" %)Year Full (upper case is Year of Week)|(% style="width:153px" %)Year|(% style="width:172px" %)1996 318 -|MM|(% style="width:340px" %)Month number in year starting with 1|(% style="width:153px" %)Month|(% style="width:172px" %)07 319 -|MMM|(% style="width:340px" %)Month name short|(% style="width:153px" %)Month|(% style="width:172px" %)Jul 320 -|MMMM|(% style="width:340px" %)Month name full|(% style="width:153px" %)Month|(% style="width:172px" %)July 321 -|ww|(% style="width:340px" %)Week in year|(% style="width:153px" %)Number|(% style="width:172px" %)27 322 -|W|(% style="width:340px" %)Week in month|(% style="width:153px" %)Number|(% style="width:172px" %)2 323 -|DD|(% style="width:340px" %)Day in year|(% style="width:153px" %)Number|(% style="width:172px" %)189 324 -|dd|(% style="width:340px" %)Day in month|(% style="width:153px" %)Number|(% style="width:172px" %)10 325 -|F|(% style="width:340px" %)Day of week in month|(% style="width:153px" %)Number|(% style="width:172px" %)2 326 -|E|(% style="width:340px" %)Day name in week|(% style="width:153px" %)Text|(% style="width:172px" %)Tuesday; Tue 314 +|(% style="width:133px" %)**Letter**|(% style="width:414px" %)**Date or Time Component**|(% style="width:157px" %)**Presentation**|(% style="width:172px" %)**Examples** 315 +|(% style="width:133px" %)G|(% style="width:414px" %)Era designator|(% style="width:157px" %)Text|(% style="width:172px" %)AD 316 +|(% style="width:133px" %)yy|(% style="width:414px" %)Year short (upper case is Year of Week{{footnote}}yyyy represents the calendar year while YYYY represents the year of the week, which is only relevant for 53 week years{{/footnote}})|(% style="width:157px" %)Year|(% style="width:172px" %)96 317 +|(% style="width:133px" %)yyyy|(% style="width:414px" %)Year Full (upper case is Year of Week)|(% style="width:157px" %)Year|(% style="width:172px" %)1996 318 +|(% style="width:133px" %)MM|(% style="width:414px" %)Month number in year starting with 1|(% style="width:157px" %)Month|(% style="width:172px" %)07 319 +|(% style="width:133px" %)MMM|(% style="width:414px" %)Month name short|(% style="width:157px" %)Month|(% style="width:172px" %)Jul 320 +|(% style="width:133px" %)MMMM|(% style="width:414px" %)Month name full|(% style="width:157px" %)Month|(% style="width:172px" %)July 321 +|(% style="width:133px" %)ww|(% style="width:414px" %)Week in year|(% style="width:157px" %)Number|(% style="width:172px" %)27 322 +|(% style="width:133px" %)W|(% style="width:414px" %)Week in month|(% style="width:157px" %)Number|(% style="width:172px" %)2 323 +|(% style="width:133px" %)DD|(% style="width:414px" %)Day in year|(% style="width:157px" %)Number|(% style="width:172px" %)189 324 +|(% style="width:133px" %)dd|(% style="width:414px" %)Day in month|(% style="width:157px" %)Number|(% style="width:172px" %)10 325 +|(% style="width:133px" %)F|(% style="width:414px" %)Day of week in month|(% style="width:157px" %)Number|(% style="width:172px" %)2 326 +|(% style="width:133px" %)E|(% style="width:414px" %)Day name in week|(% style="width:157px" %)Text|(% style="width:172px" %)Tuesday; Tue 327 +|(% style="width:132px" %)U|(% style="width:414px" %)Day number of week (1 = Monday, ..., 7 = Sunday)|(% style="width:157px" %)Number|(% style="width:217px" %)1 328 +|(% style="width:132px" %)HH|(% style="width:414px" %)Hour in day (0-23)|(% style="width:157px" %)Number|(% style="width:217px" %)0 329 +|(% style="width:132px" %)kk|(% style="width:414px" %)Hour in day (1-24)|(% style="width:157px" %)Number|(% style="width:217px" %)24 330 +|(% style="width:132px" %)KK|(% style="width:414px" %)Hour in am/pm (0-11)|(% style="width:157px" %)Number|(% style="width:217px" %)0 331 +|(% style="width:132px" %)hh|(% style="width:414px" %)Hour in am/pm (1-12)|(% style="width:157px" %)Number|(% style="width:217px" %)12 332 +|(% style="width:132px" %)mm|(% style="width:414px" %)Minute in hour|(% style="width:157px" %)Number|(% style="width:217px" %)30 333 +|(% style="width:132px" %)ss|(% style="width:414px" %)Second in minute|(% style="width:157px" %)Number|(% style="width:217px" %)55 334 +|(% style="width:132px" %)S|(% style="width:414px" %)Millisecond|(% style="width:157px" %)Number|(% style="width:217px" %)978 335 +|(% style="width:132px" %)n|(% style="width:414px" %)Number of periods, used after a SDMX Frequency Identifier such as M, Q, D (month, quarter, day)|(% style="width:157px" %)Number|(% style="width:217px" %)12 327 327 328 -|U|Day number of week (1 = Monday, ..., 7 = Sunday)|Number|1 329 -|HH|Hour in day (0-23)|Number|0 330 -|kk|Hour in day (1-24)|Number|24 331 -|KK|Hour in am/pm (0-11)|Number|0 332 -|hh|Hour in am/pm (1-12)|Number|12 333 -|mm|Minute in hour|Number|30 334 -|ss|Second in minute|Number|55 335 -|S|Millisecond|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|978 336 -|n|Number of periods, used after a SDMX Frequency Identifier such as M, Q, D (month, quarter, day)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|12 337 - 338 338 The model is illustrated below: 339 339 340 340 [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg||height="265" width="477"]] ... ... @@ -355,17 +355,16 @@ 355 355 * microsecond 356 356 * nanosecond 357 357 358 -|Numerical datetime systems|Base|Period 359 -|((( 357 +(% style="width:573.294px" %) 358 +|(% style="width:276px" %)**Numerical datetime systems**|(% style="width:117px" %)**Base**|(% style="width:177px" %)**Period** 359 +|(% style="width:276px" %)((( 360 360 Epoch Time (UNIX) 361 - 362 362 Milliseconds since 01 Jan 1970 363 -)))|1970|millisecond 364 -|((( 362 +)))|(% style="width:117px" %)1970|(% style="width:177px" %)millisecond 363 +|(% style="width:276px" %)((( 365 365 Windows System Time 366 - 367 367 Milliseconds since 01 Jan 1601 368 -)))|1601|millisecond 366 +)))|(% style="width:117px" %)1601|(% style="width:177px" %)millisecond 369 369 370 370 The example above illustrates numerical based datetime mapping rules for two commonly used time standards. 371 371 ... ... @@ -387,41 +387,34 @@ 387 387 388 388 The main use case is setting the value of Observation Attributes in the target dataset. 389 389 390 -|Rule|Source|Target 391 -|1|((( 388 +(% style="width:786.294px" %) 389 +|(% style="width:92px" %)**Rule**|(% style="width:377px" %)**Source**|(% style="width:315px" %)**Target** 390 +|(% style="width:92px" %)1|(% style="width:377px" %)((( 392 392 If 393 - 394 394 INDICATOR=XULADS; and TIME_PERIOD=2007. 395 -)))|((( 393 +)))|(% style="width:315px" %)((( 396 396 Set 397 - 398 398 OBS_CONF=F 399 399 ))) 400 -|2|((( 397 +|(% style="width:92px" %)2|(% style="width:377px" %)((( 401 401 If 402 - 403 403 INDICATOR=XULADS; and TIME_PERIOD=2008. 404 -)))|((( 400 +)))|(% style="width:315px" %)((( 405 405 Set 406 - 407 407 OBS_CONF=F 408 408 ))) 409 -|3|((( 404 +|(% style="width:92px" %)3|(% style="width:377px" %)((( 410 410 If 411 - 412 412 INDICATOR=XULADS; and TIME_PERIOD=2009. 413 -)))|((( 407 +)))|(% style="width:315px" %)((( 414 414 Set 415 - 416 416 OBS_CONF=F 417 417 ))) 418 -|4|((( 411 +|(% style="width:92px" %)4|(% style="width:377px" %)((( 419 419 If 420 - 421 421 INDICATOR=XULADS; and TIME_PERIOD=2010. 422 -)))|((( 414 +)))|(% style="width:315px" %)((( 423 423 Set 424 - 425 425 OBS_CONF=**C** 426 426 ))) 427 427