This page (revision-64) was last changed on 19-Mar-2024 10:20 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
64 19-Mar-2024 10:20 113 KB Kevin Higgs to previous
63 19-Mar-2024 10:13 63 KB Kevin Higgs to previous | to last
62 19-Mar-2024 10:05 63 KB Kevin Higgs to previous | to last
61 19-Mar-2024 10:04 63 KB Kevin Higgs to previous | to last

Page References

Incoming links Outgoing links
UPPHF
UPPHF

Version management

Difference between version and

At line 194 changed 9 lines
Code: - user defined Interface Code
- if IDIF layout is supplied by the system, the Interface Code begins with HL$
Interface Type: - must be 32 - Pay History 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 UPPHF
Description: - user defined description
File Name: - specifies the default file name, otherwise file name is entered on UPPHF parameter
File Creation Number: - not used
Taxation Level: - please select 'Not Specified' from look up list, Taxation Level is not used for UPPHF
;Code:User defined Interface Code\\If IDIF layout is supplied by the system, the Interface Code begins with HL$
;Interface Type:Must be 32 - Pay History 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 UPPHF
;Description:User defined description
;File Name:Specifies the default file name, otherwise file name is entered on UPPHF parameter
;File Creation Number:Not used
;Taxation Level:Please select 'Not Specified' from look up list, Taxation Level is not used for UPPHF
;Record Number:User assigned Record Number\\Each Record Number generates a new line in the interface file.\\The followings are suggested Record Numbers, user can set up their own numbers.
||Record Number||Interface File Records generated
|0|Qualify Records
|1 - 29|Header Records
|30 - 69|Detail Records
|70 - 99|Trailer Records or Update Records
;Field Number:User assigned number
;Name:User assigned field name
;XML Tag:Optional, 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:If File Format = 'Fixed Format', you must specify the Beginning position
;Ending Position:If 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:Indicate the result of the Field Variable is a type of 'Char', 'Number' or 'Date'
;Variable Name:Select from lexicon X_INF_VARIABLE_NAME 32nnnn, refer to lexicon list above
;Sort Sequence:Specifies the Sort Sequence for this Record #, Field #\\ \\Use 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\\- 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\\ \\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.\\ \\Sort Sequence is not supported if the IDIF format contains 'Pay Header Begin' or 'Pay Header Summary' because the Sorting of the Detail Record cannot carry it's associated Header/Summary Record
;Format Mask:Applicable to Numeric and Date field
;Record Type:Optional, may be used for this Interface Type\\ \\If Record Type is not specified, the following Record Number range are used:
||Record Number||Interface File Records generated
|0|Qualify Records
|1 - 29|Header Records
|30 - 69|Detail Records
| 70 - 99|Trailer Records\\ \\If Record Type is specified, lexicon X_RECORD_TYPE values are:
|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 UPPHF
|11 - Employer Summary|Not used for UPPHF
|12 - Employer Header 2|Not used for UPPHF
|13 - Employer Summary 2|Not used for UPPHF
|14 - Employee Header|Not used for UPPHF
|15 - Employee Summary|Not used for UPPHF
|16 - Pay Header Begin|Generate records at beginning of each Pay Header
|17 - Pay Header Summary|Generate records at the end of each Pay Header
|20 - Detail Record|Generate Pay Header interface records
|21 - Detail Level 1|Detail Level 1 is used for Journal Entries
|22 - Detail Level 2|Not used for UPPHF
|23 - Detail Level 3|Not used for UPPHF
|24 - Detail Level 4|Not used for UPPHF
|25 - Detail Level 5|Not used for UPPHF
|30 - Detail Summary|Not used for UPPHF
|80 - Total Record|Not used for UPPHF
|90 - Trailer Record|Generate Trailer records at end of file\\ \\May contain File totals, record counts etc
|91 - Qualify Record|Should be used for Record Number 0\\ \\The Qualify records are performed at the beginning of every Pay Header to qualify the Pay Header\\ \\You can use derivation expression to BYPASS certain criteria
|92 - Update Record|Should be defined at the end of the IDIF definition\\ \\In non-Trial mode, the UDF can be Inserted or Updated as defined in the Variable Name and Constant Value field\\ \\You can use derivation expression to BYPASS certain criteria for Update
;Record Identifier:Not used for this Interface Type
At line 204 removed 79 lines
Record Number - user assigned Record Number
- each Record Number generates a new line in the interface file
The followings are suggested Record Numbers, user can set up their own numbers.
Record Number Interface File Records generated
0 Qualify Records
1 - 29 Header Records
30 - 69 Detail Records
70 - 99 Trailer Records or Update Records
Field Number - user assigned number
Name - user assigned field name
XML Tag - optional, 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 - if File Format = 'Fixed Format', the user must specify the Beginning position
Ending Position - if File Format = 'Fixed Format', the user 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 - indicate the result of the Field Variable is a type of 'Char', 'Number' or 'Date'
Variable Name - select from lexicon X_INF_VARIABLE_NAME 32nnnn, refer to lexicon list above
Sort Sequence - specifies the Sort Sequence for this Record #, Field #
- use 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
- 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
- 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
- Sort Sequence is not supported if the IDIF format contains ‘Pay Header Begin’ or ‘Pay Header Summary’ because the Sorting of the Detail Record cannot carry it’s associated Header/Summary Record
Format Mask - applicable to Numeric and Date field
Record Type - optional, may be used for this Interface Type
- if Record Type is not specified, the following Record Number range are used:
Record Number Interface File Records generated
0 Qualify Records
1 – 29 Header Records
30 – 69 Detail Records
70 – 99 Trailer Records
- if Record Type is specified, lexicon X_RECORD_TYPE values are:
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 UPPHF
11 – Employer Summary - not used for UPPHF
12 – Employer Header 2 - not used for UPPHF
13 – Employer Summary 2 - not used for UPPHF
14 – Employee Header - not used for UPPHF
15 – Employee Summary - not used for UPPHF
16 – Pay Header Begin - generate records at beginning of each Pay Header
17 – Pay Header Summary - generate records at the end of each Pay Header
20 – Detail Record - generate Pay Header interface records
21 – Detail Level 1 - Detail Level 1 is used for Journal Entries
22 – Detail Level 2 - not used for UPPHF
23 – Detail Level 3 - not used for UPPHF
24 – Detail Level 4 - not used for UPPHF
25 – Detail Level 5 - not used for UPPHF
30 – Detail Summary - not used for UPPHF
80 – Total Record - not used for UPPHF
90 – Trailer Record - generate Trailer records at end of file
- may contain File totals, record counts etc
91 – Qualify Record - should be used for Record Number 0
- the Qualify records are performed at the beginning of every Pay Header to qualify the Pay Header
- user can use derivation expression to BYPASS certain criteria
92 – Update Record - should be defined at the end of the IDIF definition
- in non-Trial mode, the UDF can be Inserted or Updated as defined in the Variable Name and Constant Value field
- user can use derivation expression to BYPASS certain criteria for Update
Record Identifier - not used for this Interface Type
This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin HiggsTop