This is version 1 2 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

IDIF Field Descriptions:#

Code

This is a user-defined Interface Code. If the IDIF layout is supplied the Interface Code begins with HL$

Interface Type

This must be 35 - EEM/EAS Interface

File Format

This field allows you to select one of the File Formats from the look up list

Form Type

Please select 'Not Specified' from the look up list. Form Type is not used for UBEF

Description

This is a user-defined description

File Name

This field specifies the default file name, otherwise the file name is entered on UBEF parameter

File Creation Number

This field is not used

Taxation Level

Please select 'Not Specified' from the look up list. Taxation Level is not used for UBEF

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, however, you can set up your own numbers.

Record Number	Interface File Records Generated
0	Qualify Records
1 - 29	Header Records
30 - 69	Detail Records
70 - 99	Trailer Records

Field Number This is a user assigned number

Name

This is a user assigned field name

XML Tag

This field is used for XML File Format only (Optional). If the XML Tag is not specified for XML File, then the Name field is used as XML Tag

Beginning Position

If the file format = 'Fixed Format', you must specify the Beginning position

Ending Position

If the file format = 'Fixed Format', you must specify the Ending position

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

This field can be 'Char', 'Number' or 'Date'

Variable Name;Select from the lexicon X_INF_VARIABLE_NAME 35nnnn, referring to lexicon list above

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'

e.g. Interface File need to sort by: Department, Employee First Name, Last Name

For the Fld# entry that specify 'Department', enter sort sequence: 100

For the Fld# that specify 'Employee First Name', enter sort sequence: 150

For the Fld# that specify 'Employee Last Name', enter sort sequence: 200

All sort sequences must be entered on entries with the same record number

Sort sequence is not supported for XML file format because XML file may specify many different Record # to generate XML begin and end tags and the XML tags are not able to sort along with the data

Format Mask

This field is applicable to Numeric and Date field

Record Type

This must be used for this Interface Type. Lexicon X_RECORD_TYPE.

Record Identifier

This field is not used for this Interface Type

Constant Value

If the variable name = 'Constant Value', this field specifies the Constant Value to be used

If the variable name = 'UserCalc', this field specifies the UserCalc Name

If the variable name = 'Statistics Amt', this field specifies the Statistics Code

If the variable name = 'Element', this field specifies the Element Code

If the variable name = 'Total Value', this field specifies the Rec# and Field # of the Detail Records to be totaled

e.g. Record # 50 Field 70 is to be totaled and Total option = 'Calculate Total', then the Trailer record can report the 'Total Value', Constant value should be 5070

Print Zero Rule

This is applicable to Numeric field only; use for Record Type = 'Detail Record'. If amount is zero, this field indicates to include this amount in the interface file or not

e.g. if the field is from 'Statistics Amount' and the amount is zero, you may not want to report this amount

If all numeric amounts are zero within one Record# and the Print Zero Rule are set to 'Do not Print zeros' for each field, then this entry will not be reported on interface file. Lexicon X_PRINT_ZERO_RULE

XML Tag

option This is applicable to XML file, if the variable name = 'XML begin Tag'or 'XML end Tag', this field option indicates if the XML Tag should be written. Lexicon X_XML_TAG_OPTION

Accum Option

This is applicable to the Numeric field only and is used for Record Type = 'Detail Record'

This 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 is applicable to the Numeric field only and is used for Record Type = Detail Record, Detail Level

This 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 'UserCalc Amount', then you may want to calculate the total for Trailer record. Lexicon X_TOTAL_OPTION

Derivation Expression

This field specifies the derivation expression for the variable