Skip to Content
Last modified by Helena on 2025/09/10 11:19
From version 6.1
edited by Helena
on 2025/05/16 09:09
Change comment: There is no comment for this version
To version 5.25
edited by Helena
on 2025/05/16 09:01
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -636,159 +636,204 @@
636 636  
637 637  The following table describes the default mapping for converting from the SDMX data types to the VTL basic scalar types.
638 638  
639 -(% style="width:823.294px" %)
640 -|(% style="width:509px" %)**SDMX data type (BasicComponentDataType)**|(% style="width:312px" %)**Default VTL basic scalar type**
641 -|(% style="width:509px" %)(((
639 +|SDMX data type (BasicComponentDataType)|Default VTL basic scalar type
640 +|(((
642 642  String
642 +
643 643  (string allowing any character)
644 -)))|(% style="width:312px" %)string
645 -|(% style="width:509px" %)(((
644 +)))|string
645 +|(((
646 646  Alpha
647 +
647 647  (string which only allows A-z)
648 -)))|(% style="width:312px" %)string
649 -|(% style="width:509px" %)(((
649 +)))|string
650 +|(((
650 650  AlphaNumeric
652 +
651 651  (string which only allows A-z and 0-9)
652 -)))|(% style="width:312px" %)string
653 -|(% style="width:509px" %)(((
654 +)))|string
655 +|(((
654 654  Numeric
657 +
655 655  (string which only allows 0-9, but is not numeric so that is can having leading zeros)
656 -)))|(% style="width:312px" %)string
657 -|(% style="width:509px" %)(((
659 +)))|string
660 +|(((
658 658  BigInteger
662 +
659 659  (corresponds to XML Schema xs:integer datatype; infinite set of integer values)
660 -)))|(% style="width:312px" %)integer
661 -|(% style="width:509px" %)(((
664 +)))|integer
665 +|(((
662 662  Integer
663 -(corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647 (inclusive))
664 -)))|(% style="width:312px" %)integer
665 -|(% style="width:509px" %)(((
667 +
668 +(corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647
669 +
670 +(inclusive))
671 +)))|integer
672 +|(((
666 666  Long
667 -(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and +9223372036854775807 (inclusive))
668 -)))|(% style="width:312px" %)integer
669 -|(% style="width:509px" %)(((
674 +
675 +(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and
676 +
677 ++9223372036854775807 (inclusive))
678 +)))|integer
679 +|(((
670 670  Short
681 +
671 671  (corresponds to XML Schema xs:short datatype; between -32768 and -32767 (inclusive))
672 -)))|(% style="width:312px" %)integer
673 -|(% style="width:509px" %)Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|(% style="width:312px" %)number
674 -|(% style="width:509px" %)(((
683 +)))|integer
684 +|Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|number
685 +|(((
675 675  Float
687 +
676 676  (corresponds to XML Schema xs:float datatype; patterned after the IEEE single-precision 32-bit floating point type)
677 -)))|(% style="width:312px" %)number
678 -|(% style="width:509px" %)(((
689 +)))|number
690 +|(((
679 679  Double
692 +
680 680  (corresponds to XML Schema xs:double datatype; patterned after the IEEE double-precision 64-bit floating point type)
681 -)))|(% style="width:312px" %)number
682 -|(% style="width:509px" %)(((
694 +)))|number
695 +|(((
683 683  Boolean
684 -(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of binary-valued logic: {true, false})
685 -)))|(% style="width:312px" %)boolean
686 686  
687 -(% style="width:822.294px" %)
688 -|(% colspan="2" style="width:507px" %)(((
698 +(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of
699 +
700 +binary-valued logic: {true, false})
701 +)))|boolean
702 +
703 +| |(% colspan="2" %)(((
689 689  URI
705 +
690 690  (corresponds to the XML Schema xs:anyURI; absolute or relative Uniform Resource Identifier Reference)
691 -)))|(% colspan="1" style="width:311px" %)string
692 -|(% colspan="2" style="width:507px" %)(((
707 +)))|(% colspan="2" %)string
708 +| |(% colspan="2" %)(((
693 693  Count
710 +
694 694  (an integer following a sequential pattern, increasing by 1 for each occurrence)
695 -)))|(% colspan="1" style="width:311px" %)integer
696 -|(% colspan="2" style="width:507px" %)(((
712 +)))|(% colspan="2" %)integer
713 +| |(% colspan="2" %)(((
697 697  InclusiveValueRange
715 +
698 698  (decimal number within a closed interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue)
699 -)))|(% colspan="1" style="width:311px" %)number
700 -|(% colspan="2" style="width:507px" %)(((
717 +)))|(% colspan="2" %)number
718 +| |(% colspan="2" %)(((
701 701  ExclusiveValueRange
720 +
702 702  (decimal number within an open interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue)
703 -)))|(% colspan="1" style="width:311px" %)number
704 -|(% colspan="2" style="width:507px" %)(((
722 +)))|(% colspan="2" %)number
723 +| |(% colspan="2" %)(((
705 705  Incremental
725 +
706 706  (decimal number the increased by a specific interval (defined by the interval facet), which is typically enforced outside of the XML validation)
707 -)))|(% colspan="1" style="width:311px" %)number
708 -|(% colspan="2" style="width:507px" %)(((
727 +)))|(% colspan="2" %)number
728 +| |(% colspan="2" %)(((
709 709  ObservationalTimePeriod
730 +
710 710  (superset of StandardTimePeriod and TimeRange)
711 -)))|(% colspan="1" style="width:311px" %)time
712 -|(% colspan="2" style="width:507px" %)(((
732 +)))|(% colspan="2" %)time
733 +| |(% colspan="2" %)(((
713 713  StandardTimePeriod
714 -(superset of BasicTimePeriod and ReportingTimePeriod)
715 -)))|(% colspan="1" style="width:311px" %)time
716 -|(% colspan="2" style="width:507px" %)(((
735 +
736 +(superset of BasicTimePeriod and
737 +
738 +ReportingTimePeriod)
739 +)))|(% colspan="2" %)time
740 +| |(% colspan="2" %)(((
717 717  BasicTimePeriod
742 +
718 718  (superset of GregorianTimePeriod and DateTime)
719 -)))|(% colspan="1" style="width:311px" %)date
720 -|(% colspan="2" style="width:507px" %)(((
744 +)))|(% colspan="2" %)date
745 +| |(% colspan="2" %)(((
721 721  GregorianTimePeriod
747 +
722 722  (superset of GregorianYear, GregorianYearMonth, and GregorianDay)
723 -)))|(% colspan="1" style="width:311px" %)date
724 -|(% colspan="2" style="width:507px" %)GregorianYear (YYYY)|(% colspan="1" style="width:311px" %)date
725 -|(% colspan="2" style="width:507px" %)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="1" style="width:311px" %)date
726 -|(% colspan="2" style="width:507px" %)GregorianDay (YYYY-MM-DD)|(% colspan="1" style="width:311px" %)date
727 -|(% colspan="2" style="width:507px" %)(((
749 +)))|(% colspan="2" %)date
750 +| |(% colspan="2" %)GregorianYear (YYYY)|(% colspan="2" %)date
751 +| |(% colspan="2" %)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="2" %)date
752 +| |(% colspan="2" %)GregorianDay (YYYY-MM-DD)|(% colspan="2" %)date
753 +| |(% colspan="2" %)(((
728 728  ReportingTimePeriod
729 -(superset of RepostingYear, ReportingSemester, ReportingTrimester, ReportingQuarter, ReportingMonth, ReportingWeek, ReportingDay)
730 -)))|(% colspan="1" style="width:311px" %)time_period
731 -|(% colspan="2" style="width:507px" %)(((
755 +
756 +(superset of RepostingYear, ReportingSemester,
757 +
758 +ReportingTrimester, ReportingQuarter,
759 +
760 +ReportingMonth, ReportingWeek, ReportingDay)
761 +)))|(% colspan="2" %)time_period
762 +| |(% colspan="2" %)(((
732 732  ReportingYear
764 +
733 733  (YYYY-A1 – 1 year period)
734 -)))|(% colspan="1" style="width:311px" %)time_period
735 -|(% colspan="2" style="width:507px" %)(((
766 +)))|(% colspan="2" %)time_period
767 +| |(% colspan="2" %)(((
736 736  ReportingSemester
769 +
737 737  (YYYY-Ss – 6 month period)
738 -)))|(% colspan="1" style="width:311px" %)time_period
739 -|(% colspan="2" style="width:507px" %)(((
771 +)))|(% colspan="2" %)time_period
772 +| |(% colspan="2" %)(((
740 740  ReportingTrimester
774 +
741 741  (YYYY-Tt – 4 month period)
742 -)))|(% colspan="1" style="width:311px" %)time_period
743 -|(% colspan="2" style="width:507px" %)(((
776 +)))|(% colspan="2" %)time_period
777 +| |(% colspan="2" %)(((
744 744  ReportingQuarter
779 +
745 745  (YYYY-Qq – 3 month period)
746 -)))|(% colspan="1" style="width:311px" %)time_period
747 -|(% colspan="2" style="width:507px" %)(((
781 +)))|(% colspan="2" %)time_period
782 +| |(% colspan="2" %)(((
748 748  ReportingMonth
784 +
749 749  (YYYY-Mmm – 1 month period)
750 -)))|(% colspan="1" style="width:311px" %)time_period
751 -|(% colspan="2" style="width:507px" %)ReportingWeek|(% colspan="1" style="width:311px" %)time_period
752 -|(% colspan="1" style="width:507px" %)(YYYY-Www – 7 day period; following ISO 8601 definition of a week in a year)|(% colspan="2" style="width:312px" %)
753 -|(% colspan="1" style="width:507px" %)(((
786 +)))|(% colspan="2" %)time_period
787 +| |(% colspan="2" %)ReportingWeek|(% colspan="2" %)time_period
788 +| |(% colspan="2" %) |(% colspan="2" %)
789 +| |(% colspan="2" %) |(% colspan="2" %)
790 +|(% colspan="2" %)(YYYY-Www – 7 day period; following ISO 8601 definition of a week in a year)|(% colspan="2" %) |
791 +|(% colspan="2" %)(((
754 754  ReportingDay
793 +
755 755  (YYYY-Dddd – 1 day period)
756 -)))|(% colspan="2" style="width:312px" %)time_period
757 -|(% colspan="1" style="width:507px" %)(((
795 +)))|(% colspan="2" %)time_period|
796 +|(% colspan="2" %)(((
758 758  DateTime
798 +
759 759  (YYYY-MM-DDThh:mm:ss)
760 -)))|(% colspan="2" style="width:312px" %)date
761 -|(% colspan="1" style="width:507px" %)(((
800 +)))|(% colspan="2" %)date|
801 +|(% colspan="2" %)(((
762 762  TimeRange
803 +
763 763  (YYYY-MM-DD(Thh:mm:ss)?/<duration>)
764 -)))|(% colspan="2" style="width:312px" %)time
765 -|(% colspan="1" style="width:507px" %)(((
805 +)))|(% colspan="2" %)time|
806 +|(% colspan="2" %)(((
766 766  Month
808 +
767 767  (~-~-MM; speicifies a month independent of a year; e.g. February is black history month in the United States)
768 -)))|(% colspan="2" style="width:312px" %)string
769 -|(% colspan="1" style="width:507px" %)(((
810 +)))|(% colspan="2" %)string|
811 +|(% colspan="2" %)(((
770 770  MonthDay
813 +
771 771  (~-~-MM-DD; specifies a day within a month independent of a year; e.g. Christmas is December 25^^th^^; used to specify reporting year start day)
772 -)))|(% colspan="2" style="width:312px" %)string
773 -|(% colspan="1" style="width:507px" %)(((
815 +)))|(% colspan="2" %)string|
816 +|(% colspan="2" %)(((
774 774  Day
818 +
775 775  (~-~--DD; specifies a day independent of a month or year; e.g. the 15^^th^^ is payday)
776 -)))|(% colspan="2" style="width:312px" %)string
777 -|(% colspan="1" style="width:507px" %)(((
820 +)))|(% colspan="2" %)string|
821 +|(% colspan="2" %)(((
778 778  Time
823 +
779 779  (hh:mm:ss; time independent of a date; e.g. coffee break is at 10:00 AM)
780 -)))|(% colspan="2" style="width:312px" %)string
781 -|(% colspan="1" style="width:507px" %)(((
825 +)))|(% colspan="2" %)string|
826 +|(% colspan="2" %)(((
782 782  Duration
828 +
783 783  (corresponds to XML Schema xs:duration datatype)
784 -)))|(% colspan="2" style="width:312px" %)duration
785 -|(% colspan="1" style="width:507px" %)XHTML|(% colspan="2" style="width:312px" %)Metadata type – not applicable
786 -|(% colspan="1" style="width:507px" %)KeyValues|(% colspan="2" style="width:312px" %)Metadata type – not applicable
787 -|(% colspan="1" style="width:507px" %)IdentifiableReference|(% colspan="2" style="width:312px" %)Metadata type – not applicable
788 -|(% colspan="1" style="width:507px" %)DataSetReference|(% colspan="2" style="width:312px" %)Metadata type – not applicable
830 +)))|(% colspan="2" %)duration|
831 +|(% colspan="2" %)XHTML|(% colspan="2" %)Metadata type – not applicable|
832 +|(% colspan="2" %)KeyValues|(% colspan="2" %)Metadata type – not applicable|
833 +|(% colspan="2" %)IdentifiableReference|(% colspan="2" %)Metadata type – not applicable|
834 +|(% colspan="2" %)DataSetReference|(% colspan="2" %)Metadata type – not applicable|
789 789  
790 -(% class="wikigeneratedid" id="HFigure142013MappingsfromSDMXdatatypestoVTLBasicScalarTypes" %)
791 -**Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types**
836 +==== Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types ====
792 792  
793 793  When VTL takes in input SDMX artefacts, it is assumed that a type conversion according to the table above always happens. In case a different VTL basic scalar type is desired, it can be achieved in the VTL program taking in input the default VTL basic scalar type above and applying to it the VTL type conversion features (see the implicit and explicit type conversion and the "cast" operator in the VTL Reference Manual).
794 794  
... ... @@ -796,32 +796,39 @@
796 796  
797 797  The following table describes the default conversion from the VTL basic scalar types to the SDMX data types .
798 798  
799 -(% style="width:1073.29px" %)
800 -|(% style="width:207px" %)(((
801 -**VTL basic scalar type**
802 -)))|(% style="width:462px" %)(((
803 -**Default SDMX data type (BasicComponentDataType)**
804 -)))|(% style="width:402px" %)**Default output format**
805 -|(% style="width:207px" %)String|(% style="width:462px" %)String|(% style="width:402px" %)Like XML (xs:string)
806 -|(% style="width:207px" %)Number|(% style="width:462px" %)Float|(% style="width:402px" %)Like XML (xs:float)
807 -|(% style="width:207px" %)Integer|(% style="width:462px" %)Integer|(% style="width:402px" %)Like XML (xs:int)
808 -|(% style="width:207px" %)Date|(% style="width:462px" %)DateTime|(% style="width:402px" %)YYYY-MM-DDT00:00:00Z
809 -|(% style="width:207px" %)Time|(% style="width:462px" %)StandardTimePeriod|(% style="width:402px" %)<date>/<date> (as defined above)
810 -|(% style="width:207px" %)time_period|(% style="width:462px" %)(((
844 +|(((
845 +VTL basic
846 +
847 +scalar type
848 +)))|(((
849 +Default SDMX data type
850 +
851 +(BasicComponentDataType
852 +
853 +)
854 +)))|Default output format
855 +|String|String|Like XML (xs:string)
856 +|Number|Float|Like XML (xs:float)
857 +|Integer|Integer|Like XML (xs:int)
858 +|Date|DateTime|YYYY-MM-DDT00:00:00Z
859 +|Time|StandardTimePeriod|<date>/<date> (as defined above)
860 +|time_period|(((
811 811  ReportingTimePeriod
862 +
812 812  (StandardReportingPeriod)
813 -)))|(% style="width:402px" %)(((
864 +)))|(((
814 814  YYYY-Pppp
866 +
815 815  (according to SDMX )
816 816  )))
817 -|(% style="width:207px" %)Duration|(% style="width:462px" %)Duration|(% style="width:402px" %)(((
869 +|Duration|Duration|(((
818 818  Like XML (xs:duration)
871 +
819 819  PnYnMnDTnHnMnS
820 820  )))
821 -|(% style="width:207px" %)Boolean|(% style="width:462px" %)Boolean|(% style="width:402px" %)Like XML (xs:boolean) with the values "true" or "false"
874 +|Boolean|Boolean|Like XML (xs:boolean) with the values "true" or "false"
822 822  
823 -(% class="wikigeneratedid" id="HFigure142013MappingsfromSDMXdatatypestoVTLBasicScalarTypes-1" %)
824 -**Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types**
876 +==== Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types ====
825 825  
826 826  In case a different default conversion is desired, it can be achieved through the CustomTypeScheme and CustomType artefacts (see also the section Transformations and Expressions of the SDMX information model).
827 827  
... ... @@ -875,7 +875,7 @@
875 875  |N|fixed number of digits used in the preceding textual representation of the month or the day
876 876  | |
877 877  
878 -The default conversion, either standard or customized, can be used to deduce automatically the representation of the components of the result of a VTL Transformation. In alternative, the representation of the resulting SDMX Dataflow can be given explicitly by providing its DataStructureDefinition. In other words, the representation specified in the DSD, if available, overrides any default conversion{{footnote}}The representation given in the DSD should obviously be compatible with the VTL data type.{{/footnote}}.
930 +The default conversion, either standard or customized, can be used to deduce automatically the representation of the components of the result of a VTL Transformation. In alternative, the representation of the resulting SDMX Dataflow can be given explicitly by providing its DataStructureDefinition. In other words, the representation specified in the DSD, if available, overrides any default conversion^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^42^^>>path:#sdfootnote42sym||name="sdfootnote42anc"]](%%)^^.
879 879  
880 880  === 12.4.5 Null Values ===
881 881  
... ... @@ -893,8 +893,10 @@
893 893  
894 894  A different format can be specified in the attribute "vtlLiteralFormat" of the CustomType artefact (see also the section Transformations and Expressions of the SDMX information model).
895 895  
896 -Like in the case of the conversion of NULLs described in the previous paragraph, the overriding assumption is applied, for a certain VTL basic scalar type, if a value is found for the vtlLiteralFormat attribute of the CustomType of such VTL basic scalar type. The overriding assumption is applied for all the literals of a related VTL TransformationScheme.
948 +Like in the case of the conversion of NULLs described in the previous paragraph, the overriding assumption is applied, for a certain VTL basic scalar type, if a value is found for the vtlLiteralFormat attribute of the CustomType of such VTL basic scalar type. The overriding assumption is applied for all the literals of a related VTL
897 897  
950 +TransformationScheme.
951 +
898 898  In case a literal is operand of a VTL Cast operation, the format specified in the Cast overrides all the possible otherwise specified formats.
899 899  
900 900  {{putFootnotes/}}