The following tables indicate the layout available. All items without a field number or a start position are user optional information.

Record Type 10 – Net Pay Split / Notification Information#

Field	Start Position	Max Length	Field Name	INF Variable Number	Notes
1	1	2	Record Type Code		‘10’
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
		02	Payment Rule Type	0065	01-Cash, 02-Check, 03-Deposit
		10	Check/Deposit Number	0067
		20	Amount	0068
		100	Amount String	0069
		1	Prenote	0070	Y/N
		50	Paid to Order of	0071
		2	Bank Account Type	0072	01-Savings, 02- Checking
		30	Bank Account Number	0073
		16	Bank Transit Code	0074
		50	Bank Name	0075

---

Record Type 20 - Disbursement#

Field	Start Position	Max Length	Field Name	INF Variable Number	Notes
1	1	2	Record Type Code		‘20’
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	Government Code	0008
		50	Middle Name	0009
		4	Salutation	0010
		4	Rank	0011
		50	Address 1	0012
		50	Address 2	0013
		50	Locality	0014
		16	Zip/Postal	0015
		50	Mail Address 1	0016
		50	Mail Address 2	0017
		50	Mail Locality	0018
		16	Mail Zip/Postal	0019
		30	Mail State/Province	0020
		30	State/Province	0021
		30	Country	0022
		30	Home Tax Jurisdiction	0023
		16	School District	0024
		16	Home GEO Code	0025
		2	Employment Type	0026
		30	Employment Type Lex	0027
		11	Original Hire Date	0028
		11	Termination Date	0029
		16	Job Code	0030
		50	Job Title	0031
		16	Position Code	0032
		50	Position Title	0033
		50	Department Name	0034
		16	Work Locn Code	0035
		50	Work Locn Desc	0036
		16	Pay Dest Locn Code	0037
		30	Pay Dest Locn Desc	0038
		30	Work Tax Jurisdiction	0039
		16	Salary Range Code	0040
		50	Salary Range Desc	0041
		16	Unit Code	0042
		50	Unit Description	0043
		16	Group Code	0044
		50	Group Description	0045
50	1041	16	Work Rule Code	0046
51	1057	16	Employment Status Code	0047
52	1073	30	Employment Status Desc	0048
53	1103	16	Work GEO Code	0049
54	1119	50	Entity Name	0051
55	1149	11	Seniority Date	0054
56	1160	10	Hours per Day	0055
57	1170	10	Hours per Week	0056
58	1180	50	First Name	0005
59	1210	50	Last Name	0004
60	1240	20	Prime Wage	0057
61	1260	2	Prime Wage Basis	0058
62	1262	30	Prime Wage Basis Lex	0159
63	1278	11	Period Begin Date	0162
64	1289	11	Period End Date	0163
65	1300	20	Gross Pay	0062
66	1320	20	Total Deductions	0063
67	1340	20	Net Pay	0064

---

Record Type 30 – US Pay Rules#

There will be ONLY one record for each disbursement. Each pay has its pay rules determined by the Work Tax Jurisdiction in the pay header. Although there may be more than one pay for a given disbursement (Consolidation), only the first pay is used for ‘categorizing’ the disbursement.

Field	Start Position	Max Length	Field Name	INF Variable Number	Notes
1	1	2	Record Type Code		‘30’
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	Number of Exemptions – Federal	0076
		4	Number of Exemptions – State	0077
		4	Number of Exemptions 2 –State	0078
		4	Number of Exemptions Local	0079
		2	Federal Filing Status	0080
		30	Federal Filing Status Lex	0081
		2	State Filing Status	0082
		30	State Filing Status Lex	0083
		2	Local Filing Status	0084
		30	Local Filing Status Lex	0085
		15	Additional Tax Federal	0086

---

Record Type 40,50,60, and 70 – Pay Component Summaries#

These record types are all identical in format and contain only the total for each pay component from the ‘Pay Stub’ table. Each contains the pay components as defined by the ‘Pay Stub Elements’ for earnings, deductions, benefits, and other.

The pay stub elements are defined at the ‘Payroll’ level.

Field	Start Position	Max Length	Field Name	INF Variable Number	Notes
1	1	2	Record Type Code		40,50,60, or 70
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	PC Code	0087
		30	PC Abbreviation	0088
		50	PC Description	0089
		20	Current Amount	0090
		20	YTD Amount	0091

---

Record Type 41 – Earnings Rate Detail#

This record type contains current Disbursement Pay Stub and Pay Stub Details.

Field	Start Position	Max Length	Field Name	INF Variable Number	Notes
1	1	2	Record Type Code		41
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	PC Code	0087
		30	PC Abbreviation	0088
		50	PC Description	0089
		20	Rate*	0092	Pay Stub Details
		2	Rate Basis *	0093	Pay Stub Details
		30	Rate Basis Lex *	0094	Pay Stub Details
		20	Associated Time *	0095	Pay Stub Details
		2	Time Basis *	0096	Pay Stub Details
		30	Time Basis Lex *	0097	Pay Stub Details
		20	Detail Amount *	0098	Pay Stub Details
		20	Current Amount **	0090	Pay Stub
		20	YTD Amount **	0091	Pay Stub

* These columns will be populated in all records for the pay component.

** These columns are populated into all records for a pay component even though they are totals for the pay component. Clients should actually print this ONLY once for each pay component.

---

Record Type 45,55,65, and 75 – Pay Line Details#

These record types are all identical in format, and contain ‘Pay Line Detail’ information. Pay Line Details are selected defined by the ‘Pay Stub Elements’ for earnings, deductions, benefits, and other.

These records contain all the intricate detail for each pay component in the respective element.

Field	Start Position	Max Length	Field Name	INF Variable Number	Notes
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 #

Click to create a new notes page