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

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 26-Nov-2021 10:22 14 KB JEscott to previous
25 26-Nov-2021 10:22 14 KB JEscott to previous | to last
24 26-Nov-2021 10:22 14 KB JEscott to previous | to last
23 26-Nov-2021 10:22 14 KB JEscott to previous | to last
22 26-Nov-2021 10:22 14 KB JEscott to previous | to last
21 26-Nov-2021 10:22 14 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
UPDIF INTERFACE FORMAT
UPDIF INTERFACE FORMAT

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
\\
At line 29 added one line
----
At line 100 added one line
----
At line 127 added one line
----
At line 151 added one line
----
At line 184 added one line
----
At line 192 added 187 lines
|1| 1| 2| Record Type Code | |45, 55, 65, or 75
|2| 3| 16| Entity Code| 0060|
|3| 20| 30| Pay Destination| 0001|
|4 |50 |16| Department| 0002|
|5| 66| 60| Full Name |0003|
|6| 126| 16| Person Code |0006|
|7| 142| 4 |Pay Number |0051|
|8| 146| 11| Pay Issue Date| 0007|
|9| 157| 4| Number of Checks |0052|
|10| 161| 4| Number of Deposits |0053|
|11| 165| 174| Check Number |0160|
| | |4 |Pay Component |0087|
| | |30| PC Abbreviation| 0088|
| | |50| PC Description |0089|
| | |2| PC Detail Type| 0099| Pay Line Detail
| | |30| PC Detail Type Lex |0100| Pay Line Detail
| | |2| PC Action| 0101| Pay Line Detail
| | |30| PC Action Lex| 0102| Pay Line Detail
| | |2| PC Calc Method| 0103| Pay Line Detail
| | |30| PC Calc Method Lex| 0104| Pay Line Detail
| | |50| PC Detail Description| 0105| Pay Line Detail
| | |2| PC Rate Source| 0106| Pay Line Detail
| | |30| PC Rate Source Lex| 0107| Pay Line Detail
| | |20| Wage Rate| 0108| Pay Line Detail
| | |2| Wage Rate Basis| 0109| Pay Line Detail
| | |30| Wage Rate Basis Lex| 0110| Pay Line
| | |20| Amount| 0111| Pay Line Detail
| | |2| Pay Point Type| 0112| Pay Line
| | |30| Pay Point Type Lex| 0113| Pay Line
| | |2| Pay Point Task| 0114| Pay Line
| | |30| Pay Point Task Lex| 0115| Pay Line
| | |4| Pay Point Sequence| 0116| Pay Line
| | |11| Start Date| 0117| Pay Line
| | |11| End Date| 0118| Pay Line
| | |16| Assignment Code| 0119| Pay Line
| | |50| Assignment Title| 0120| Pay Line
| | |16| Position Code| 0121| Pay Line
| | |50| Position Title| 0122| Pay Line
| | |16| Job Code| 0123| Pay Line
| | |50| Job Title| 0124| Pay Line
| | |16| Department Code| 0125| Pay Line
| | |50| Department Name| 0126| Pay Line
| | |16| Leave Policy Code| 0127| Pay Line
| | |16| User Calc Code| 0128| Pay Line
| | |16| Plan Code |0129| Pay Line
| | |30| Work Tax Jurisdiction| 0130| Pay Line
| | |16| Work GEO Code| 0131 |Pay Line
----
!Record Type 80 – Arrears (rarely used)
This record contains all arrears remaining in the Sundry table at the time the interface file is created.
||Field ||Start\\Position||Max\\Length|| Field Name||INF\\Variable\\Number||Notes
|1| 1| 2| Record Type Code| | ‘80’
|2| 3| 16| Entity Code| 0060|
|3| 20| 30| Pay Destination| 0001|
|4| 50| 16| Department |0002|
|5| 66| 60 |Full Name| 0003|
|6| 126| 16| Person Code| 0006|
|7| 142| 4| Pay Number| 0051|
|8| 146| 11| Pay Issue Date| 0007|
|9| 157| 4| Number of Checks| 0052|
|10| 161| 4| Number of Deposits| 0053|
|11| 165| 174| Check Number| 0160|
| | |4| Pay Component| 0087|
| | |30| PC Abbreviation| 0088|
| | |50| PC Description| 0089|
| | |20| Arrears Amount| 0132|
| | |50| Reference Information| 0133| Originating Pay - Back\\reference
----
!Record Type 90 - Statistics (occasionally used)
This record type contains the balance of all statistical pay components. The balance is taken at the time the interface file is created.
||Field ||Start\\Position||Max\\Length|| Field Name||INF\\Variable\\Number||Notes
|1| 1| 2| Record Type Code | |‘90’
|2| 3| 16| Entity Code |0060|
|3| 20| 30| Pay Destination| 0001|
|4| 50| 16| Department| 0002|
|5| 66| 60| Full Name| 0003|
|6| 126| 16| Person Code| 0006|
|7| 142| 4| Pay Number |0051|
|8| 146| 11| Pay Issue Date| 0007|
|9| 157| 4| Number of Checks| 0052|
|10| 161| 4| Number of Deposits| 0053|
|11| 165| 174| Check Number |0160|
| | |16| Stat Code| 0134|
| | |30| Stat Abbreviation| 0135|
| | |50| Stat Description |0136|
| | |4| Stat Type| 0137|
| | |30| Stat Type Lex| 0138|
| | |2| Stat Action| 0139|
| | |30| Stat Action Lex| 0140|
| | |20| Stat Amount| 0142|
----
!Record Type 100 - Accruals
This record type contains the accrual balances of all leave types. Although a disbursement can be for many pays, these balances are representative of the last pay processed, thereby providing the most accurate balances.
||Field ||Start\\Position||Max\\Length|| Field Name||INF\\Variable\\Number||Notes
|1| 1| 2| Record Type Code | |‘100’
|2| 3| 16| Entity Code| 0060|
|3| 20| 30| Pay Destination |0001|
|4| 50| 16| Department |0002|
|5| 66| 60| Full Name| 0003|
|6| 126| 16| Person Code| 0006|
|7| 142| 4 |Pay Number| 0051|
|8 |146| 11| Pay Issue Date| 0007|
|9| 157| 4| Number of Checks| 0052|
|10| 161| 4| Number of Deposits| 0053|
|11| 165| 174| Check Number| 0160|
| | |11| Evaluation Date| 0143|
| | |16| Leave Type Code| 0144|
| | |50| Leave Type Description| 0145|
| | |2| Leave Policy Basis| 0146|
| | |30| Leave Policy Basis Lex| 0147|
| | |20| Prior Year Time Adj| 0148|
| | |20| Prior Year Amt Adj| 0149|
| | |20| Curr Year Time\\Entitlement|0150|
| | |20| Curr Year Amount\\Earned|0151|
| | |20| Curr Year Time Taken| 0152|
| | |20| Curr Time Owing| 0153|
| | |20| Curr amount Owing| 0154|
| | |20| Termination Time Owing| 0155|
| | |20| Termination Amount\\Owing|0156|
| | |20| Prior Year Time Owing| 0157|
----
!Record Type 110 – Disbursement Messages (optional)
This record type contains messages issued by ‘Disbursement’ UserCalcs.
||Field ||Start\\Position||Max\\Length|| Field Name||INF\\Variable\\Number||Notes
|1| 1| 2| Record Type Code| | 110
|2| 3| 16| Entity Code |0060|
|3| 20| 30| Pay Destination| 0001|
|4| 50| 16| Department| 0002|
|5| 66| 60| Full Name |0003|
|6| 126| 16| Person Code| 0006|
|7| 142| 4| Pay Number| 0051|
|8| 146| 11| Pay Issue Date |0007|
|9| 157| 4| Number of Checks| 0052|
|10| 161| 4| Number of Deposits| 0053|
|11| 165| 174| Check Number| 0160|
| | |200| Message| 0158|
See the Disbursement Messages section in the [HOW TO SET UP FOR DISBURSEMENTS] page to see how to create the message.
----
!Record Type 120 – User Fields (optional)
Any number of user fields can be selected here. A separate entry in the ‘Format Definition’ is required for each user field to be included.
Presently, user fields attached to the tables listed below are available to this function. To place a user field into the extract file, you must place a field into record type ‘120’ using variable ‘0161 User Field Value’.
As in the example below, place the Table Name and User Field Code (separated by a comma) in the ‘Derivation Expression’.
||Field ||Start\\Position||Max\\Length|| Field Name||INF\\Variable\\Number||Notes
|1| 1| 2| Record Type Code| | 120
|2| 3| 16| Entity Code| 0060|
|3| 20| 30| Pay Destination| 0001|
|4| 50| 16| Department |0002|
|5| 66| 60| Full Name| 0003|
|6| 126| 16| Person Code| 0006|
|7| 142| 4| Pay Number| 0051|
|8| 146| 11| Pay Issue Date |0007|
|9| 157| 4| Number of Checks| 0052|
|10| 161| 4| Number of Deposits| 0053|
|11| 165| 174| Check Number| 0160|
| | | |Value| 0161| p2k_hr_employments,\\license number
!Tables Available for User Field Extraction:
|[P2K_PR_PAY_HEADERS]| [P2K_PR_PAY_PERIODS]| [P2K_PR_US_PAY_RULES]
|[P2K_HR_IDENTITIES]| [P2K_CM_ENTITIES] |[P2K_CM_ENTITY_DETAILS]
|[P2K_HR_PERSONALS] |[P2K_HR_EMPLOYMENTS]| [P2K_HR_ASSIGNMENTS]
|[P2K_HR_ASSIGNMENT_DETAILS] |[P2K_PR_PAYROLLS]| [P2K_CM_STATE_PROVINCES]
|[P2K_CM_COUNTRIES] |[P2K_CM_TAX_JURISDICTIONS] |[P2K_CM_SCHOOL_DISTRICTS]
|[P2K_CM_JOBS] |[P2K_CM_JOB_DETAILS]| [P2K_CM_POSITIONS]
|[P2K_CM_POSITION_DETAILS]| [P2K_CM_DEPARTMENTS]| [P2K_CM_DEPARTMENT_DETAILS]
|[P2K_CM_LOCATIONS] |[P2K_SA_SALARY_RANGES] |[P2K_CM_UNITS]
|[P2K_CM_UNIT_DETAILS]| [P2K_CM_GROUPS]| [P2K_CM_GROUP_DETAILS]
|[P2K_CM_WORK_RULES] |[P2K_CM_EMPLOYMENT_STATUSES]
----
![Notes|Edit:Internal.UPDIF+INTERFACE+FORMAT]
[{InsertPage page='Internal.UPDIF+INTERFACE+FORMAT' default='Click to create a new notes page'}]
This page (revision-26) was last changed on 26-Nov-2021 10:22 by JEscottTop