SCOContent LeftColumn TopHeader
Employee Deduction 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 - DEDUCTION (DED)
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 - 35
SEGMENT_ID	80	A/N - 03	Segment ID = DED
PAYROLL_NO	83	A/N - 05	Payroll Number - year = 2 Digits and the payroll number.
PAY_DATE	88	A/N - 08	Pay Date (CCMMYYDD)
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.
DED_ID	109	A/N - 03	Deduction ID/Code (DED Directory)
DED_VAR	112	A/N - 03	3 Digit Deduction Variable (DEV Directory). If no Variable field is blank.
DED_CONST	115	A/N - 03	System Deduction ID (DID Directory)
*RESERVED _1	118	A/N - 02	NOT USED - Blank
*LAST_ACTIVE_DATE	120	A/N - 08	NO LONGER USED – Blank Date this deduction was last Taken (CCYYMMDD)
EFF_START_DATE	128	A/N - 08	Deduction Effective Date (CCYYMMDD)
EFF_END_DATE	136	A/N - 08	Deduction End Date (CCYYMMDD)
STATUS	144	A/N - 01	Y = Active , N – Not Active
RATE	145	N - 13	Amount or rate for this deduction, If deduction has variable, field is 0 filled.
SCHEDULE	158	A/N - 02	Applicability Code/Deduction Schedule
LAST_CHG_DATE	160	A/N - 08	Date this deduction was last changed (CCYYMMDD)
*MEMBERSHIP_DATE	168	A/N - 08	NOT USED - Blank
*WITH_DATE	176	A/N - 08	NOT USED - Blank
*SUSP_DATE	184	A/N - 08	NOT USED - Blank
*SUSP_PERIOD	192	A/N - 04	NOT USED – 0 filled
*ADDL_AMT	196	N - 11	NOT USED – 0 filled
SINGLE_LIMIT	207	N - 11	Deduction Limit Amount. If no limit on deduction field is 0 filled.
OVERRIDE_AMT	218	N - 11	Deduction override amount. If no override field is 0 filled.
OVERRIDE_START_DATE	229	A/N - 08	Deduction override start date (CCYYMMDD). If no override field is blank.
OVERRIDE_END_DATE	237	A/N - 08	Deduction override end date (CCYYMMDD). If no override field is blank.
CUR_EMP_CONT	245	N - 11	Current Payroll - Employee Deduction amount taken.
MTD_EMP_CONT	256	N -11	MTD - Employee deduction amount taken.
YTD_EMP_CONT	267	N -11	YTD - Employee deduction amount taken.
ITD_EMP_CONT	278	N -11	Inception to date - Employee deduction amount taken.
CURRENT_CO_CONT	289	N -11	Current Payroll - Employer deduction contribution. If no employer contribution field is 0 filled.
MTD_CO_CONT	300	N -11	MTD - Employer deduction contribution. If no employer contribution field is 0 filled.
YTD_CO_CONT	311	N -11	YTD employer deduction contribution. If no employer contribution field is 0 filled.
ITD_CO_CONT	322	N -11	Inception to date employer deduction contribution. If no employer contribution field is 0 filled.
CUR_NOT_TAKEN	333	N -11	Deductions that could not be taken - for reporting only. Field is 0 filled.
*ITD NOT TAKEN	344	N -11	NOT USED – 0 Filled. Column 354 is Blank.
*BUY_BACK_IND	355	A/N - 01	NOT USED – Blank
*BUY_BACK_DATE	356	A/N - 08	NOT USED – Blank
*YEARLY_VEST_DATE	364	A/N - 06	NOT USED – Blank
*ACTUAL_VEST_DATE	370	A/N - 06	NOT USED - Blank
*PREV_CR_SERV	376	A/N - 07	NOT USED – Deductions 100 and 909 show 00.00, all other deductions are Blank.
*JS_OPTION	383	A/N - 01	NOT USED – Blank
*JS_OPTION_TYPE	384	A/N - 02	NOT USED – Blank
*JS_OPTION_DATE	386	A/N - 06	NOT USED - Blank
*CUR_EARNING	392	N -11	Current Payroll - Retirement gross earnings. Amount is updated each payroll but no longer used.
*MTD_EARNING	403	N -11	MTD - Retirement gross earnings. Amount is updated each payroll but no longer used.
*YTD_EARNING	414	N -11	YTD - Retirement gross earnings. Amount is updated each payroll but no longer used.
*ITD_EARNING	425	N -11	Inception to date - Retirement gross earnings. Amount is updated each payroll but no longer used.
*PART_EARNINGS	436	N -11	NOT USED – Field contains a Dollar amount.
*CUR_INTEREST	447	N -11	NOT USED – 0 filled
*PREV_INTEREST	458	N -11	NOT USED – 0 filled
*BENEFIT_ACCUM	469	N -11	NOT USED – 0 filled
*SV_CUR_EARNING	480	N -11	NOT USED – Blank
"SV_MTD_EARNING	491	N -01	NOT USED – Blank
*SV_YTD_EARNING	502	N -01	NOT USED – Blank
*SV_ITD_EARNING	513	N -01	NOT USED - Blank
*FILLER	524	A/N - 44	NOT USED - Blank
*BOND_DENOM	564	A/N - 03	NO LONGER USED – Blank Bond denomination (50/100/500/1000)
*BOND_BALANCE	571	N - 11	NO LONGER USED – Blank Dollar balance remaining towards the purchase of the next bond.
*BOND_PERIOD_TO_BALANCE	582	N - 11	NO LONGER USED – Blank The dollar amount accumulated from the last pay period processed.
*FILLER	593	A/N - 51	NOT USED - Blank
*PA_EMP_COVERAGE	644	A/N - 04	NOT USED - Blank
*PA_SPS_COVERAGE	648	A/N - 04	NOT USED - Blank
*FILLER	652	A/N - 58	NOT USED - Blank
*TR_EM_COVERAGE	710	A/N - 03	NOT USED - Blank
*FILLER	713	A/N - 56	NOT USED - Blank
*ACCT_DIST_EMP	769	A/N - 30	NOT USED - Blank
*ACCT_DIST_CO	799	A/N - 30	NOT USED - Blank
*ACCRUAL_DISTRIBUTION	829	A/N - 30	NOT USED - Blank
*PAY_NUMBER	859	A/N - 02	NOT USED - Blank
*ADR_PTR	861	A/N - 03	NOT USED - Blank
FILLER	864	A/N - 30	NOT USED - Blank
TOTAL	893

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

SCOContent LeftColumn TopHeaderEmployee Deduction Segment

employee deduction segment Employee Deduction Segment

SCOContent LeftColumn TopHeader
Employee Deduction Segment