This page (revision-26) was last changed on 21-Dec-2022 09:14 by Kevin Higgs

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
26 21-Dec-2022 09:14 10 KB Kevin Higgs to previous
25 26-Nov-2021 10:22 10 KB Kevin Higgs to previous | to last
24 26-Nov-2021 10:22 10 KB Kevin Higgs to previous | to last
23 26-Nov-2021 10:22 9 KB Kevin Higgs to previous | to last
22 26-Nov-2021 10:22 9 KB Kevin Higgs to previous | to last
21 26-Nov-2021 10:22 9 KB Kevin Higgs to previous | to last

Page References

Incoming links Outgoing links
IDIF

Version management

Difference between version and

At line 24 changed one line
;[Record Number|??]:This is a user assigned record number. Each record number generates a new line in the interface file. The following are suggested record numbers. You can set up your own numbers.
;[Record Number|RECORD_NUMBER]:This is a user assigned record number. Each record number generates a new line in the interface file. The following are suggested record numbers. You can set up your own numbers.
At line 31 changed 8 lines
;[Field Number|??]:This is a user assigned number.
;[Name|??]:This is a user assigned field name.
;[XML Tag|??]:This optional field is used for XML File Format only. If XML Tag is not specified for XML File, then the Name field is used as XML Tag.
;[Beginning Position|??]:Used if the File Format is a 'Fixed Format'. The Beginning and Ending positions must be continuous without gap.
;[Ending Position|??]:If the File Format = 'Fixed Format', you must specify the Beginning and Ending positions. These positions must be continuous without gap, otherwise an error situation will occur. Beginning/Ending positions are not needed for XML and other file format.
;[Field Type|??]:Field Type can be defined as 'Char', 'Number' or 'Date'.
;[Variable Name|??]:Variable Name is used for outbound interfaces only. You will select from the lexicon [X_INF_VARIABLE_NAME] 35nnnn
;[Sort Sequence|??]:This field specifies the sort sequence for this Record #, Field # and is used for Record # with Record Type = 'Detail Record' only \\For Record # with Record Type = 'Detail Level 1' to 'Detail Level 5', it uses the same Sort from Record Type = 'Detail Record' so that the Detail Level n records are followed after the 'Detail Record'
;[Field Number|FIELD_NUMBER]:This is a user assigned number.
;[Name|FIELD_NAME]:This is a user assigned field name.
;[XML Tag|XML_TAG]:This optional field is used for XML File Format only. If XML Tag is not specified for XML File, then the Name field is used as XML Tag.
;[Beginning Position|FIELD_START_BYTE]:Used if the File Format is a 'Fixed Format'. The Beginning and Ending positions must be continuous without gap.
;[Ending Position|FIELD_END_BYTE]:If the File Format = 'Fixed Format', you must specify the Beginning and Ending positions. These positions must be continuous without gap, otherwise an error situation will occur. Beginning/Ending positions are not needed for XML and other file format.
;[Field Type|FIELD_TYPE]:Field Type can be defined as 'Char', 'Number' or 'Date'.
;[Variable Name|VARIABLE_LK]:Variable Name is used for outbound interfaces only. You will select from the lexicon [X_INF_VARIABLE_NAME] 35nnnn
;[Sort Sequence|SORT_SEQUENCE]:This field specifies the sort sequence for this Record #, Field # and is used for Record # with Record Type = 'Detail Record' only \\For Record # with Record Type = 'Detail Level 1' to 'Detail Level 5', it uses the same Sort from Record Type = 'Detail Record' so that the Detail Level n records are followed after the 'Detail Record'
At line 45 changed 2 lines
;[Format Mask|??]:The format mask is applicable to Numeric and Date field.
;[Record Type|??]:Record Type is typically only used for outbound interfaces. The lexicon [X_RECORD_TYPE] values are:
;[Format Mask|FORMAT_MASK]:The format mask is applicable to Numeric and Date field.
;[Record Type|RECORD_TYPE]:Record Type is typically only used for outbound interfaces. The lexicon [X_RECORD_TYPE] values are:
At line 79 changed 2 lines
;[Record Identifier|??]:This field is not currently used.
;[Constant Value|??]:If the Variable Name = 'Constant Value', this field specifies the Constant Value to be used.
;[Record Identifier|RECORD_IDENTIFIER]:This field is not currently used.
;[Constant Value|CONSTANT_VALUE]:If the Variable Name = 'Constant Value', this field specifies the Constant Value to be used.
At line 86 changed one line
;[Print Zero Rule|??]:This field is applicable to the Numeric field only and is used for Record Type = 'Detail Record'.
;[Add to UK Set|ADD_TO_UK]:Used to manually add columns to the destination tables' UK column set by toggling the 'Add to UK set' check box. This will only add the column as a UK column to the existing UK set for the destination table. It will not act as a UK set override.
;[Print Zero Rule|PRINT_ZERO_RULE]:This field is applicable to the Numeric field only and is used for Record Type = 'Detail Record'.
At line 91 changed 4 lines
;[XML Tag Option|??]:This is applicable to the XML file, if the Variable Name = 'XML begin Tag' or 'XML end Tag'. This field option indicates if the XML Tag should be written. This field is tied to the fixed lexicon [X_XML_TAG_OPTION].
;[Accum Option|??]: This field is applicable to the Numeric field only and is used for Record Type = 'Detail Record'. This field indicates if this Record #, Field # amount should be accumulated or not. e.g. if the field is a 'Pay Number' or 'Check Number', then do not accumulate \\If the field is 'Element Value' or 'PC Amount', then you may want to accumulate to avoid writing too much detail per element or per pay component.
;[Total Option|??]: This field is applicable to the Numeric field only and is used for Record Type = Detail Record, Detail Level n. This field indicates if this Record #, Field # amount should be totaled for Header or Trailer record. e.g. if the field is a 'FTE' or 'Rate of Pay', then do not totaled \\If the field is 'Statistics Amount' or 'User Calc Amount', then you may want to calculate the total for Trailer record. The Total Option field is tied to the fixed lexicon [X_TOTAL_OPTION].
;[Derivation Expression|??]:This field specifies the derivation expression for the Variable name.
;[XML Tag Option|XML_TAG_OPTION]:This is applicable to the XML file, if the Variable Name = 'XML begin Tag' or 'XML end Tag'. This field option indicates if the XML Tag should be written. This field is tied to the fixed lexicon [X_XML_TAG_OPTION].
;[Accum Option|ACCUM_OPTION]: This field is applicable to the Numeric field only and is used for Record Type = 'Detail Record'. This field indicates if this Record #, Field # amount should be accumulated or not. e.g. if the field is a 'Pay Number' or 'Check Number', then do not accumulate \\If the field is 'Element Value' or 'PC Amount', then you may want to accumulate to avoid writing too much detail per element or per pay component.
;[Total Option|TOTAL_OPTION]: This field is applicable to the Numeric field only and is used for Record Type = Detail Record, Detail Level n. This field indicates if this Record #, Field # amount should be totaled for Header or Trailer record. e.g. if the field is a 'FTE' or 'Rate of Pay', then do not totaled \\If the field is 'Statistics Amount' or 'User Calc Amount', then you may want to calculate the total for Trailer record. The Total Option field is tied to the fixed lexicon [X_TOTAL_OPTION].
;[Derivation Expression|DERIVATION_EXPRESSION]:This field specifies the derivation expression for the Variable name.