Difference between revisions of "Edi Create Time Format"
Jump to navigation
Jump to search
(Created page with "By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. T...") |
|||
Line 1: | Line 1: | ||
+ | [[Category:How_To]] | ||
+ | [[Category:How_To V11]] | ||
+ | |||
By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. To enable this behaviour the system property "''edi.forceTimeFormatSeriesAttr.enabled''" needs to be specified and the Data Structure must have a series attribute with the id of "TIME_FORMAT". | By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. To enable this behaviour the system property "''edi.forceTimeFormatSeriesAttr.enabled''" needs to be specified and the Data Structure must have a series attribute with the id of "TIME_FORMAT". | ||
Latest revision as of 05:35, 8 September 2022
By default, reading an EDI data file does not convert the TIME_FORMAT into an attribute in the output data file, however an option exists in Fusion Registry to perform this. To enable this behaviour the system property "edi.forceTimeFormatSeriesAttr.enabled" needs to be specified and the Data Structure must have a series attribute with the id of "TIME_FORMAT".
If both of these conditions are met, then the EDI values are converted in the following manner:
Time Format | EDI Value | ISO Format |
---|---|---|
Yearly | 602 / 702 | P1Y |
Half Yearly | 604 / 704 | P6M |
Quarterly | 608 / 708 | P3M |
Monthly | 610 / 710 | P1M |
Weekly | 616 / 716 | P1W |
Daily | 101 / 102 | P1D |
Minutely | 201 / 203 | PT1M |