SCOContent LeftColumn TopHeader
Employee Earnings Segment

Notes:

The file layout below applies to both the sequential payroll earnings file (AUI.S44.AU444391.PAYEARN) and the PC Downloadable Payroll Earnings File (XXX.S44.AU444940.PEFDWNLD).

The order of the data fields is the same on both files, but the column begin numbers documented below, apply only to the AU444940.PEFDWNLD file.

Most, but not all data fields on the Sequential Payroll Earnings file are moved to AU444940.PEFDWNLD. Data fields marked with an * (asterisk) are on the sequential Payroll Earnings file but not on AU444940.PEFDWNLD.

Example: the Probation Complete Date and the Pay Period End Date are only on the sequential payroll earnings file.

SEGMENT NAME - EMPLOYEE EARNINGS (EAR)
FIELD NAME	COLUMN BEGIN	DATA TYPE (A/Alpha, N/Numeric) FIELD LENGTH	DESCRIPTION
COMPANY_KEY	1	A/N - 03	Agency Number (910 Directory)
PAY_GROUP_KEY	4	A/N - 02	Pay Group 01 – Biweekly (PGR Directory) Pay Group 06 - University Pay Group 20 - Judicial Monthly
PAY_LOCATION_KEY	6	A/N - 04	Pay Location (ORG Directory) - 2 to 4 digit alpha/numeric code that identifies the employee's work area/location within an agency. Field is blank if Pay Location not used.
LAST_NAME	10	A/N - 22	Employee Last Name, includes appendage.
FIRST_NAME	32	A/N - 14	Employee First Name
MIDDLE_NAME	46	A/N - 14	Employee Middle Name
SSN_NO	60	A/N - 09	Social Security Number
KEY_DATE	69	A/N - 08	Regular Pay – Current Payroll Pay Date (CCYYMMDD) MVA's – MVA effective date (CCYYMMDD) Note: Date displays only on EAR, FED, STA, DED, DST and NET segments. Field is 0 filled on BAS, MAD, PAY and POS segments – MVA or Regular Pay.
PAY_TYPE	77	A/N - 01	Identifies the type of payroll activity M – Manual V – Void A – Adjustment Blank – Regular Pay Note: The Field is always blank on the BAS, MAD, PAY and POS segments.
SEGMENT_NO	78	A/N - 02	Segment ID number - 15
SEGMENT_ID	80	A/N - 03	Segment ID = EAR
PAYROLL_NO	83	A/N - 05	Current Payroll Number - year = 2 Digits and the payroll number.
PAY_DATE	88	A/N - 08	Current Payroll - Pay Date (CCYYMMDD)
MVA_PAYROLL_NO	96	A/N - 05	Field is blank unless MVA processed. Manual/Void - Payroll Number Adjusted will display on the EAR, FED, STA, DED, DST and NET segments. Adjustments – Payroll Number Adjusted will display on the EAR, FED, STA, DED and DST segments. The current Payroll Number processing will display on the NET Segment.
MVA_DATE	101	A/N - 08	Field is blank unless MVA processed. Pay Date (CCYYMMDD) for the payroll adjusted will display on the EAR, FED, STA, DED, DST and NET segments.
ER_ID	109	A/N - 03	Earnings ID code
ER_VAR	112	A/N - 03	NOT USED - Blank
ER_CONST	115	A/N - 03	System Earnings ID
LAST_ACTIVE_DATE	118	A/N - 08	Pay Period End Date when earnings was last processed. (CCYYMMDD)
*NO_CASES	126	N - 04	NOT USED – But field contains 3 numbers.
HRS_WRK	130	N - 11	Current payroll earnings hours
AMT_ACC	141	N - 11	Current payroll earnings dollars.
RATE	152	N - 13	Current rate of pay
RATE_DATE	165	A/N - 08	Pay Period end date when earnings was first paid. (CCYYMMDD)
OVERRIDE_SAL	173	N - 13	Override salary amount. If no override field is 0 filled.
OVERRIDE_START_DATE	186	A/N - 08	Begin date of an override salary other earnings (CCYYMMDD). If no override field is blank.
OVERRIDE_END_DATE	194	A/N - 08	End date of an override salary other earnings (CCYYMMDD). If no override field is blank.
*ORIGINAL_AMOUNT	202	N - 09	NO LONGER USED – Field is 0 filled. Original amount of declining balance other earnings
*CUR_BALANCE	211	N - 09	NO LONGER USED – Field is 0 filled. Current balance of declining balance other earnings
*EXPENSE_CLASS	220	A/N - 04	NOT USED – Blank
*FILLER	224	A/N - 13	Filler (13) - Blank
FISCAL_HRS	237	N - 11	Fiscal YTD hours for earnings.
FISCAL_EARNINGS	248	N - 11	Fiscal YTD dollars for earnings.
ACCT_DISTRIBUTION	259	A/N - 30	Payroll Cost Distribution - Index 4, PCA 7 (5 + 2 blanks), Project/Grant 9, Filler 10. *Only cost distribution overrides are reported on this file, default distributions are not.
*ACCRUAL_DISTRIBUTION	289	A/N - 36	NOT USED – 0 Filled (11), then Filler (25)
*PERCENT	325	N - 09	NOT USED – Defaults to 0100.000
*PAY_NO	334	A/N - 02	NOT USED - Blank
POSITION	336	A/N – 10	Employee PCN (4), Filler (6)
*LOCATION	346	A/N - 04	NOT USED - Blank
TOTAL		349

employee earnings segment Employee Earnings Segment // <![CDATA[ _spBodyOnLoadFunctionNames.push("setupPageDescriptionCallout"); // ]]>

SCOContent LeftColumn TopHeaderEmployee Earnings Segment

employee earnings segment Employee Earnings Segment

SCOContent LeftColumn TopHeader
Employee Earnings Segment