This page (revision-10) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 10 KB RForbes to previous LMTD INTERFACE FORMAT ==> DATA LOADER IDIF FORMAT
9 26-Nov-2021 10:22 10 KB RForbes to previous | to last Updates based on experiences
8 26-Nov-2021 10:22 9 KB RForbes to previous | to last
7 26-Nov-2021 10:22 9 KB RForbes to previous | to last
6 26-Nov-2021 10:22 9 KB JAiken to previous | to last
5 26-Nov-2021 10:22 9 KB JEscott to previous | to last
4 26-Nov-2021 10:22 9 KB JEscott to previous | to last
3 26-Nov-2021 10:22 8 KB JEscott to previous | to last
2 26-Nov-2021 10:22 8 KB JEscott to previous | to last
1 26-Nov-2021 10:22 2 KB JEscott to last

Page References

Incoming links Outgoing links
DATA LOADER IDIF FORMAT
DATA LOADER IDIF FORMAT

Version management

Difference between version and

At line 3 added 2 lines
Unless explicitly noted, IDIF fields are not used/referenced by the LMTD based functions ([LBEN], [LPTS], etc)
At line 6 changed 3 lines
;[Interface Type|INTERFACE_TYPE]:Please select Not Specified; this is not used for LMTD.
;[File Format|FIELD_DELIMITER]:Please select Not Specified; this is not used for LMTD.
;[Form Type|FORM_TYPE]:Please select Not Specified; this is not used for LMTD.
;[Interface Type|INTERFACE_TYPE]:Please select Not Specified; this is not used for LMTD. Selecting any other value will give a false sense of what variables are available.
At line 11 changed 8 lines
;[File Creation Number|FILE_CREATION_NUMBER]:This field is not used for LMTD.
;[Taxation Level|TAXATION_LEVEL]:Please select Not Specified; this is not used for LMTD.
;[Record Number|RECORD_NUMBER]:The 'Rec#' column is always set to '1', unless defining header or trailer records.
;[Field Number|FIELD_NUMBER]:This is a user-assigned number. For delimited files, the sequence of the field number is important, as it identifies each successive field.
;[Name|FIELD_NAME]:This field is composed of two parts: a table alias and a column name. For example, DCO.COUNTRY_CODE is a valid field name for a DIF Data Loader interface format. The table alias must be a valid table alias for a Business Class in the HL system. The column name does not need to be valid.
;[XML Tag|XML_TAG]:This not currently supported for LMTD.
;[Beginning Position|FIELD_START_BYTE]:If the source file data is 'Character Delimited', you must specify the Beginning position as '-1'.
;[Ending Position|FIELD_END_BYTE]:If the source file data is 'Character Delimited', you must specify the Ending position as '-1'.
;[Record Number|RECORD_NUMBER]: This field identifies the different record layouts. Numbers must be sequential without gap. Header records must be defined first, with a record type of "Header". Trailer records must be defined after the data record, with a record type of "Trailer"
;[Field Number|FIELD_NUMBER]: This field identifies the order of the fields and must be sequential, without a gap. For delimited fields, every column must be defined as there is no mechanism to skip fields.
;[Name|FIELD_NAME]:This field is composed of two parts: a [table alias|TABLE_ALIAS] and a column name. For example, DCO.COUNTRY_CODE is a valid field name for a DIF Data Loader interface format. The table alias must be a valid table alias for a Business Class in the HL system. The column name does not need to be valid. For fields that are linked via ID, you must construct the sequence of tables to get to the value on the file. For example, BEL.EEM_ID.EID_ID.PERSON_CODE is used when loading the P2K_BE_ELECTIONS table (BEL) to identify the employee by PERSON_CODE which comes from the Employment record link (EEM_ID) to the Identity record link (EID_ID)
;[Beginning Position|FIELD_START_BYTE]:If the source file data is 'Character Delimited', you must specify the Beginning position as '-1'. If the source file data is fixed position, this would indicate the starting character from the left for this field.
;[Ending Position|FIELD_END_BYTE]:If the source file data is 'Character Delimited', you must specify the Ending position as '-1'. If the source file data is fixed position, this would indicate the ending character from the left for this field.
At line 20 removed 3 lines
;[Variable Name|??]:This field is not used for LMTD.
;[Sort Sequence|SORT_SEQUENCE]:This field is not used for LMTD.
;[Format Mask|FORMAT_MASK]:This field is not used for LMTD.
At line 24 removed one line
;[Record Identifier|RECORD_IDENTIFIER]:This field is not used for LMTD.
At line 26 changed 5 lines
;[Print Zero Rule|PRINT_ZERO_RULE]:This field is not used for LMTD.
;[XML Tag option|XML_TAG_OPTION]:This field is not used for LMTD.
;[Accum Option|ACCUM_OPTION]:This field is not used for LMTD.
;[Total Option|TOTAL_OPTION]:This field is not used for LMTD.
;[Derivation Expression|DERIVATION_EXPRESSION]:Supported in release 4.07.14+
;[Derivation Expression|DERIVATION_EXPRESSION]: Derivation expressions may be used to reference the current field or other fields on the same record. Any [PL/SQL internal function|CALLABLE FUNCTION] or data base function may be used.
This page (revision-10) was last changed on 26-Nov-2021 10:22 by RForbesTop