SCOContent LeftColumn TopHeader
Employee Federal 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 - FEDERAL (FED)
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.
PAY_TYPE	77	A/N - 01	Identifies the type of payroll activity Blank – Regular Pay M – Manual V – Void A - Adjustment Note: The Field is always blank on the BAS, MAD, PAY and POS segments.
SEGMENT_NO	78	A/N - 02	Segment ID number- 20
SEGMENT_ID	80	A/N - 03	Segment ID = FED
PAYROLL_NO	83	A/N - 05	Payroll Number - year = 2 Digits and the payroll number.
PAY_DATE	88	A/N - 08	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.
LAST_ACT_DATE	109	A/N - 08	Pay Period End Date of Payroll Processed (CCYYMMDD)
TAX_STATUS	117	A/N - 01	Marital status used for Federal tax calculations: M, S or X
EXEMPTIONS	118	N - 03	Number of Federal tax exemptions claimed
*FD_ADDL_TYPE	121	A/N - 01	NOT USED - Blank
ADDL_PCT	122	N - 07	Federal Additional withholding amount – Letter 'A' followed by 5 numbers. If no Additional Federal withholding field is blank.
*CONT_FACTOR	129	N - 07	NOT USED – Field is 0 filled
CUR_HRS	136	N - 09	Employee current Federal tax hours
CUR_GROSS	145	N - 11	Employee current gross wages
CUR_TXBL	156	N - 11	Employee current Federal taxable wages
CUR/TAX	187	N - 11	Employee current Federal tax withheld
CUR_FICA_TXBL_EMP	178	N - 11	Employee current SSDI taxable wages
CUR_SSDI_TAX_EMP	189	N - 11	Employee current SSDI tax withheld
CUR_SSDI_TXBL_CO	200	N - 11	Employer current SSDI taxable earnings
CUR_SSDI_TAX_CO	211	N - 11	Employer current SSDI Tax withheld
CUR_SSHI_TAX_EMP	222	N - 11	Employee current SSHI tax withheld
CUR_SSHI_TAX_CO	233	N - 11	Employer current SSHI tax withheld
FD_OTHER_COMP	244	N - 11	Wages paid after employee is deceased. If no deceased wages field is 0 filled.
YTD_FED_TAX	255	N - 11	Employee YTD Federal tax withheld
YTD_SSDI_TAX	266	N - 11	Employee YTD SSDI FICA tax withheld
YTD_GROSS_BASIS	277	N - 11	Employee YTD gross wages
YTD_FED_TXBL	288	N - 11	Employee YTD Federal taxable wages
YTD_SSDI_TXBL	299	N - 11	Employee YTD SSDI taxable wages
YTD_SSHI_TAX	310	N - 11	Employee YTD SSHI tax withheld
*FICA_DIST_EMP	321	A/N - 30	NOT USED - Blank
*FICA_DIST_CO	351	A/N - 30	NOT USED - Blank
*FUI_DIST	381	A/N - 30	NOT USED - Blank
*FED_ACCRUAL	411	A/N - 30	NOT USED - Blank
*FICA_ACCRUAL	441	A/N - 30	NOT USED - Blank
*FUI_ACCRUAL	471	A/N - 30	NOT USED - Blank
*PAY_NUMBER	501	A/N - 02	NOT USED - Blank
FILLER_FOR_EXPANSION	503	A/N - 45	NOT USED - Blank
TOTAL	547

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

SCOContent LeftColumn TopHeaderEmployee Federal Segment

employee federal segment Employee Federal Segment

SCOContent LeftColumn TopHeader
Employee Federal Segment