This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia Urtan

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
79 20-Sep-2023 14:24 81 KB Lilia Urtan to previous
78 05-May-2023 13:45 81 KB Lilia Urtan to previous | to last
77 21-Mar-2023 10:08 80 KB Kevin Higgs to previous | to last
76 26-Nov-2021 10:22 80 KB kparrott to previous | to last
75 26-Nov-2021 10:22 80 KB khiggs to previous | to last
74 26-Nov-2021 10:22 80 KB khiggs to previous | to last
73 26-Nov-2021 10:22 79 KB khiggs to previous | to last
72 26-Nov-2021 10:22 79 KB khiggs to previous | to last
71 26-Nov-2021 10:22 79 KB khiggs to previous | to last
70 26-Nov-2021 10:22 79 KB rmorrell to previous | to last
69 26-Nov-2021 10:22 79 KB rforbes to previous | to last
68 26-Nov-2021 10:22 78 KB jmyers to previous | to last
67 26-Nov-2021 10:22 78 KB jmyers to previous | to last
66 26-Nov-2021 10:22 78 KB jmyers to previous | to last
65 26-Nov-2021 10:22 78 KB jmyers to previous | to last
64 26-Nov-2021 10:22 78 KB jmyers to previous | to last
63 26-Nov-2021 10:22 78 KB jmyers to previous | to last
62 26-Nov-2021 10:22 78 KB jmyers to previous | to last
61 26-Nov-2021 10:22 79 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 571 changed one line
!Setup Step 2 - Define Interface Format in [IDIF]
!!Setup Step 2 - Define Interface Format in [IDIF]
At line 576 changed one line
You should use (Copy Definition) to copy into a different Interface code and then enter your own company data.
The starter script SEED_IDIF_HL$BE_ELIG_TOTAL.sql is provided to load in example of a fixed format interface file. You should use (Copy Definition) to copy into a different Interface code and then enter your own company data.
At line 578 changed 2 lines
- The starter script SEED_IDIF_HL$BE_ELIG_TOTAL.sql is provided to load in example of a fixed format interface file
- the user should use [Copy Definition] to copy into a different Interface Code and then enter their own company data
IDIF Field Descriptions:
*The maximum length of a file size is 10000 bytes.
*The maximum length of a file size with Sort Sequence is 4000 bytes.
At line 582 added 8 lines
|Code|User defined Interface Code\\ \\If IDIF layout is supplied by High Line, Interface Code begins with HL$
|Interface Type|Must be 35 – EEM/EAS Interface
|File Format|Specifies one of the File Formats from look up list
|Form Type|Please select ‘Not Specified’ from look up list, Form Type is not used for UEEF
|Description|User defined description
|File Name|Specifies the default file name, otherwise file name is entered on UEEF parameter
|File Creation Number|Not used
|Taxation Level||Please select ‘Not Specified’ from look up list, Taxation Level is not used for UEEF
At line 582 removed 17 lines
IDIF field descriptions:
The maximum length of a file size is 10000 bytes.
The maximum length of a file size with Sort Sequence is 4000 bytes.
Code: - user defined Interface Code
- if IDIF layout is supplied by High Line, Interface Code begins with HL$
Interface Type: - must be 35 – EEM/EAS Interface
File Format: - specifies one of the File Formats from look up list
Form Type: - please select ‘Not Specified’ from look up list, Form Type is not used for UEEF
Description: - user defined description
File Name: - specifies the default file name, otherwise file name is entered on UEEF parameter
File Creation Number: - not used
Taxation Level: - please select ‘Not Specified’ from look up list, Taxation Level is not used for UEEF
At line 606 changed 3 lines
1 – 29 Header Records
30 – 69 Detail Records
70 – 99 Trailer Records or Update Records
1 – 29 Header Records
30 – 69 Detail Records
70 – 99 Trailer Records or Update Records
At line 617 changed one line
Beginning Position - if File Format = ‘Fixed Format’, the user must specify the Beginning position
Beginning Position - if File Format = ‘Fixed Format’, the user must specify the Beginning position
At line 619 changed one line
Ending Position - if File Format = ‘Fixed Format’, the user must specify the Ending position
Ending Position - if File Format = ‘Fixed Format’, the user must specify the Ending position
At line 625 changed one line
Field Type - can be ‘Char’, ‘Number’ or ‘Date’
Field Type - can be ‘Char’, ‘Number’ or ‘Date’
At line 630 changed 2 lines
- 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’
- 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 633 changed 3 lines
- then 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
- then 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
At line 640 changed one line
- Sort Sequence is not supported if the IDIF format contains ‘Employee Header’ or ‘Employee Summary because the Sorting of the Detail Record cannot carry it’s associated Employee Header/Summary Record
- Sort Sequence is not supported if the IDIF format contains ‘Employee Header’ or ‘Employee Summary because the Sorting of the Detail Record cannot carry it’s associated Employee Header/Summary Record
At line 645 changed 7 lines
00 – Not Specified - not applicable for this Interface type
01 – Header Record - generate Header records at begin of file
10 – Employer Header - not used for UEEF
11 – Employer Summary - not used for UEEF
12 – Employer Header2 - not used for UEEF
13 – Employer Summary2 - not used for UEEF
14 – Employee Header - generate Employee Header at the
00 – Not Specified - not applicable for this Interface type
01 – Header Record - generate Header records at begin of file
10 – Employer Header - not used for UEEF
11 – Employer Summary - not used for UEEF
12 – Employer Header2 - not used for UEEF
13 – Employer Summary2 - not used for UEEF
14 – Employee Header - generate Employee Header at the
At line 653 changed one line
15 – Employee Summary - generate Employee Summary at the
15 – Employee Summary - generate Employee Summary at the
At line 655 changed 9 lines
16 – Pay Header Begin - not used for UEEF
17 – Pay Header Summary - not used for UEEF
20 – Detail Record - generate Employee Detail record
21 – Detail Level 1 - Detail Level 1 to 5 hangs beneath
22 – Detail Level 2 the Employee Detail record and loops
23 – Detail Level 3 through BE plans or Contacts etc
24 – Detail Level 4 depending on UEEF parameter
25 – Detail Level 5 Interface Level selection criteria
30 – Detail Summary - wraps up for Employee Detail record
16 – Pay Header Begin - not used for UEEF
17 – Pay Header Summary - not used for UEEF
20 – Detail Record - generate Employee Detail record
21 – Detail Level 1 - Detail Level 1 to 5 hangs beneath
22 – Detail Level 2 the Employee Detail record and loops
23 – Detail Level 3 through BE plans or Contacts etc
24 – Detail Level 4 depending on UEEF parameter
25 – Detail Level 5 Interface Level selection criteria
30 – Detail Summary - wraps up for Employee Detail record
At line 665 changed 2 lines
80 – Total Record - not used
90 – Trailer Record - generate Trailer records at end of file
80 – Total Record - not used
90 – Trailer Record - generate Trailer records at end of file
At line 668 changed one line
91 – Qualify Record - should be used for Record Number 0
91 – Qualify Record - should be used for Record Number 0
At line 671 changed one line
92 – Update Record - should be defined at the end of the IDIF definition
92 – Update Record - should be defined at the end of the IDIF definition
At line 677 changed 7 lines
Constant Value - if Variable Name = ‘Constant Value’, this field specifies the Constant Value to be used
- if Variable Name = ‘User Calc’, this field specifies the User Calc Name
- if Variable Name = ‘UDF (xxx)’, this field specifies the User Defined Field Name
- if Variable Name = ‘Statistics Amt’, this field specifies the Statistics Code
- if Variable Name = ‘Element’, this field specifies the Element Code
- if 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
Constant Value - if Variable Name = ‘Constant Value’, this field specifies the Constant Value to be used
- if Variable Name = ‘User Calc’, this field specifies the User Calc Name
- if Variable Name = ‘UDF (xxx)’, this field specifies the User Defined Field Name
- if Variable Name = ‘Statistics Amt’, this field specifies the Statistics Code
- if Variable Name = ‘Element’, this field specifies the Element Code
- if 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
At line 685 changed one line
Print Zero Rule - applicable to Numeric field only, use for Record Type = ‘Detail Record’
Print Zero Rule - applicable to Numeric field only, use for Record Type = ‘Detail Record’
At line 687 changed one line
- e.g. if the field is from ‘Statistics Amount’ and the amount is zero, the user may not want to report this amount
- e.g. if the field is from ‘Statistics Amount’ and the amount is zero, the user may not want to report this amount
At line 689 changed one line
- 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
- 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
At line 691 changed 3 lines
00 – Not Specified
01 – Print Zero Amounts
02 – Don’t Print Zeros
00 – Not Specified
01 – Print Zero Amounts
02 – Don’t Print Zeros
At line 695 changed one line
XML Tag option - applicable to XML file, if Variable Name = ‘XML begin Tag’or ‘XML end Tag’, this field option indicates if the XML Tag should be written
XML Tag option - applicable to XML file, if Variable Name = ‘XML begin Tag’or ‘XML end Tag’, this field option indicates if the XML Tag should be written
At line 697 changed 3 lines
00 – Not Specified
01 – Optional, omit tag if null
02 – Mandatory, always write
00 – Not Specified
01 – Optional, omit tag if null
02 – Mandatory, always write
At line 701 changed one line
Accum Option - applicable to Numeric field only, use for Record Type = ‘Detail Record’
Accum Option - applicable to Numeric field only, use for Record Type = ‘Detail Record’
At line 703 changed one line
- e.g. if the field is a ‘Pay Number’ or ‘Check Number’, then do not accumulate
- e.g. if the field is a ‘Pay Number’ or ‘Check Number’, then do not accumulate
At line 705 changed one line
- if 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
- if 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
At line 709 changed one line
- e.g. if the field is a ‘FTE’ or ‘Rate of Pay’, then do not totaled
- e.g. if the field is a ‘FTE’ or ‘Rate of Pay’, then do not totaled
At line 711 changed one line
- if field is ‘Statistics Amount’ or ‘User Calc Amount’, then you may want to calculate the total for Trailer record
- if field is ‘Statistics Amount’ or ‘User Calc Amount’, then you may want to calculate the total for Trailer record
At line 713 changed 2 lines
00 – Not Specified
01 – Calculate Total
00 – Not Specified
01 – Calculate Total