Skip to Content

Changes for page 13 Structure Mapping

Last modified by Helena on 2025/09/10 11:19
From version 10.16
edited by Helena
on 2025/05/16 09:31
Change comment: There is no comment for this version
To version 10.13
edited by Helena
on 2025/05/16 09:28
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -354,16 +354,17 @@
354 354  * microsecond
355 355  * nanosecond
356 356  
357 -(% style="width:573.294px" %)
358 -|(% style="width:276px" %)**Numerical datetime systems**|(% style="width:117px" %)**Base**|(% style="width:177px" %)**Period**
359 -|(% style="width:276px" %)(((
357 +|Numerical datetime systems|Base|Period
358 +|(((
360 360  Epoch Time (UNIX)
360 +
361 361  Milliseconds since 01 Jan 1970
362 -)))|(% style="width:117px" %)1970|(% style="width:177px" %)millisecond
363 -|(% style="width:276px" %)(((
362 +)))|1970|millisecond
363 +|(((
364 364  Windows System Time
365 +
365 365  Milliseconds since 01 Jan 1601
366 -)))|(% style="width:117px" %)1601|(% style="width:177px" %)millisecond
367 +)))|1601|millisecond
367 367  
368 368  The example above illustrates numerical based datetime mapping rules for two commonly used time standards.
369 369  
... ... @@ -385,34 +385,41 @@
385 385  
386 386  The main use case is setting the value of Observation Attributes in the target dataset.
387 387  
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" %)(((
389 +|Rule|Source|Target
390 +|1|(((
391 391  If
392 +
392 392  INDICATOR=XULADS; and TIME_PERIOD=2007.
393 -)))|(% style="width:315px" %)(((
394 +)))|(((
394 394  Set
396 +
395 395  OBS_CONF=F
396 396  )))
397 -|(% style="width:92px" %)2|(% style="width:377px" %)(((
399 +|2|(((
398 398  If
401 +
399 399  INDICATOR=XULADS; and TIME_PERIOD=2008.
400 -)))|(% style="width:315px" %)(((
403 +)))|(((
401 401  Set
405 +
402 402  OBS_CONF=F
403 403  )))
404 -|(% style="width:92px" %)3|(% style="width:377px" %)(((
408 +|3|(((
405 405  If
410 +
406 406  INDICATOR=XULADS; and TIME_PERIOD=2009.
407 -)))|(% style="width:315px" %)(((
412 +)))|(((
408 408  Set
414 +
409 409  OBS_CONF=F
410 410  )))
411 -|(% style="width:92px" %)4|(% style="width:377px" %)(((
417 +|4|(((
412 412  If
419 +
413 413  INDICATOR=XULADS; and TIME_PERIOD=2010.
414 -)))|(% style="width:315px" %)(((
421 +)))|(((
415 415  Set
423 +
416 416  OBS_CONF=**C**
417 417  )))
418 418  
... ... @@ -426,22 +426,27 @@
426 426  
427 427  By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows:
428 428  
429 -(% style="width:808.294px" %)
430 -|(% style="width:93px" %)**Rule**|(% style="width:385px" %)**Source**|(% style="width:328px" %)**Target**
431 -|(% style="width:93px" %)1|(% style="width:385px" %)(((
437 +|Rule|Source|Target
438 +|1|(((
432 432  If
440 +
433 433  INDICATOR=XULADS.
442 +
434 434  Validity Period start period=2007 end period=2009
435 -)))|(% style="width:328px" %)(((
444 +)))|(((
436 436  Set
446 +
437 437  OBS_CONF=F
438 438  )))
439 -|(% style="width:93px" %)2|(% style="width:385px" %)(((
449 +|2|(((
440 440  If
451 +
441 441  INDICATOR=XULADS.
453 +
442 442  Validity Period start period=2010
443 -)))|(% style="width:328px" %)(((
455 +)))|(((
444 444  Set
457 +
445 445  OBS_CONF=F** **
446 446  )))
447 447  
... ... @@ -453,20 +453,28 @@
453 453  
454 454  === 13.10.1 Many to one mapping (N-1) ===
455 455  
456 -(% style="width:762.294px" %)
457 -|(% style="width:474px" %)**Source**|(% style="width:284px" %)**Map To**
458 -|(% style="width:474px" %)(((
469 +|Source|Map To
470 +|(((
459 459  **FREQ**="A"
472 +
460 460  ADJUSTMENT="N"
474 +
461 461  **REF_AREA**="PL"
476 +
462 462  **COUNTERPART_AREA**="W0"
478 +
463 463  REF_SECTOR="S1"
480 +
464 464  COUNTERPART_SECTOR="S1" ACCOUNTING_ENTRY="B"
482 +
465 465  STO="B5G"
466 -)))|(% style="width:284px" %)(((
484 +)))|(((
467 467  FREQ="A"
486 +
468 468  REF_AREA="PL"
488 +
469 469  COUNTERPART_AREA="W0"
490 +
470 470  INDICATOR="IND_ABC"
471 471  )))
472 472  
... ... @@ -494,24 +494,28 @@
494 494  
495 495  The following representation mapping can be used to explicitly map each age to an output code.
496 496  
518 +:
519 +
497 497  (((
498 -(% style="width:669.294px" %)
499 -|(% style="width:218px" %)**Source Input Free Text**|(% style="width:448px" %)**Desired Output Code Id**
500 -|(% style="width:218px" %)0|(% style="width:448px" %)A
501 -|(% style="width:218px" %)1|(% style="width:448px" %)A
502 -|(% style="width:218px" %)2|(% style="width:448px" %)A
503 -|(% style="width:218px" %)3|(% style="width:448px" %)B
504 -|(% style="width:218px" %)4|(% style="width:448px" %)B
521 +|Source Input Free Text|Desired Output Code Id
522 +|0|A
523 +|1|A
524 +|2|A
525 +|3|B
526 +|4|B
505 505  )))
506 506  
507 507  If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules:
508 508  
531 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]]
532 +
509 509  __Regular Expression __Desired Output
510 510  
535 +:
536 +
511 511  (((
512 -(% style="width:675.294px" %)
513 -|(% style="width:219px" %)[0-2]|(% style="width:453px" %)A
514 -|(% style="width:219px" %)[3-4]|(% style="width:453px" %)B
538 +|[0-2]|A
539 +|[3-4]|B
515 515  )))
516 516  
517 517  === 13.10.3 Observation Attributes for Time Period ===
... ... @@ -518,18 +518,21 @@
518 518  
519 519  This use case is where a specific observation for a specific time period has an attribute 3468 value.
520 520  
546 +:
547 +
521 521  (((
522 -(% style="width:689.294px" %)
523 -|(% style="width:220px" %)**Input INDICATOR**|(% style="width:223px" %)**Input TIME_PERIOD**|(% style="width:243px" %)**Output OBS_CONF**
524 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2008|(% style="width:243px" %)C
525 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2009|(% style="width:243px" %)C
526 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2010|(% style="width:243px" %)C
549 +|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF
550 +|XULADS|2008|C
551 +|XULADS|2009|C
552 +|XULADS|2010|C
527 527  )))
528 528  
529 529  __Or using a validity period on the Representation Mapping__:
530 530  
531 -Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C
557 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6dbf7f.gif||alt="Shape11" height="36" width="555"]] Input INDICATOR Valid From/ Valid To Output OBS_CONF
532 532  
559 +XULADS 2008/2010 C
560 +
533 533  === 13.10.4 Time mapping ===
534 534  
535 535  This use case is to create a time period from an input that does not respect SDMXTime Formats.