SCOContent LeftColumn TopHeader
Employee Base 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 BASE (BAS)
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	FIELD IS BLANK ON BAS 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 - 05
SEGMENT_ID	80	A/N - 03	Segment ID = BAS
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 ON BAS SEGMENT
MVA_DATE	101	A/N - 08	FIELD IS BLANK ON BAS SEGMENT
COMPANY - KEY	109	A/N - 03	Agency Number (910 Directory)
EMPLOYEE SSN	112	A/N - 09	Social Security Number
*ORG_CODE	121	A/N - 10	NOT USED - Blank
PAY_GROUP	131	A/N - 02	Pay Group 01 – Biweekly (PGR Directory) Pay Group 06 - University Pay Group 20 - Judicial Monthly
SOC_SEC	133	A/N - 09	Social Security Number
SEX	142	A/N - 01	Employee Sex Code – M or F
RACE	143	A/N - 01	Employee Race Code (RAC Directory)
*CITIZENSHIP	144	A/N - 02	NOT USED - Blank
HANDICAP_CODE	146	A/N - 02	Veteran Type Code (HCC Directory)
*HANDICAP_RSTR	148	A/N - 03	NOT USED - Blank
*MARITAL_STATUS	151	A/N - 01	NOT USED - Blank
BIRTH_DATE	152	A/N - 08	Birth Date (CCYYMMDD)
*EMPLOYEE_STARS_STS	160	A/N - 01	NOT USED - Blank
*EMPLOYEE_STARS_STS_RSN	161	A/N - 02	NOT USED - Blank
PAY_STATUS	163	A/N - 01	NOT USED - Blank
*COMPANY_STATUS	164	A/N - 01	NOT USED - Blank
*WORK_STS	165	A/N - 02	NOT USED - Blank
STATUS_IN_JOB	167	(A/N - 01	Insurance Tier Level – 0, 1 or 2
*JOB_STATUS	168	A/N - 02	NOT USED - Blank
*HIRE_SOURCE	170	A/N - 02	NOT USED - Blank
ORIGINAL_HIRE_DATE	172	A/N - 08	Employee's Original Hire Date (CCYYMMDD)
SENIORITY_DATE	180	A/N - 08	NOT USED – As of July, 2018 Note: The LHD displays in this field for some but not all employees. DP could not determine what the date may have been was used for, only that we no longer populate this field with a date.
LATEST_HIRE_DATE	188	A/N - 08	Employee's Latest Hire Date (CCYYMMDD)
*ELIG_DATE	196	A/N - 08	NOT USED - Blank
*ELIG_SERV_DATE	204	A/N - 08	NOT USED - Blank
*EARLY_RETIRE_DATE	212	A/N - 08	NOT USED - Blank
*PROJECT_RETIRE_DATE	220	A/N - 08	NOT USED - Blank
*ACTUAL_RETIRE_DATE	228	A/N - 08	NOT USED - Blank
*CR_SERVICE_DATE	236	A/N – 08	NOT USED - Blank
*DEAD_SERVICE	244	A/N - 07	NOT USED – 0 filled 00.000
*PRIOR_SERVICE	251	A/N – 07	NOT USED – 0 filled 00.000
*JOB_CODE	258	A/N - 06	NOT USED - Blank
*ALT_JOB_CODE	264	A/N - 06	NOT USED - Blank
*SALARY_GRADE	270	A/N - 02	NOT USED - Blank
*EEO_OVERRIDE_PRE	272	A/N - 01	NOT USED - Blank
*EEO_OVERRIDE_SUF	273	A/N - 02	NOT USED – Blank
*EEO_SUB_PRE	275	A/N - 01	NOT USED – Blank
*EEO_SUB_SUF	276	A/N - 02	NOT USED – Blank
*FLSA_OVERRIDE	278	A/N - 01	NOT USED – Blank
*ICC_OVERRIDE	279	A/N - 02	NOT USED – Blank
*ORG_CHART_ALPHA_KEY	281	A/N - 10	NOT USED – Blank
*OFFICE_ADDRESS	291	A/N - 07	NOT USED – Blank
*OFFICE_AC_PHONE	298	A/N - 10	NOT USED – Blank
*OFFICE_EXT	308	A/N - 04	NOT USED – Blank
*OFFICE_ALT_EXT	312	A/N - 04	NOT USED – Blank
*MAIL_INDS	316	A/N - 05	NOT USED – Blank
*BADGE	321	A/N - 05	NOT USED - Blank
ASSIGNED_LOCATION	326	A/N - 04	Assigned Work Location (LOC Directory)
*WORK_LOCATION	330	A/N - 04	NOT USED - Blank
PAY_LOCATION	334	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.
*AFFL_ACTION_LOCATION	338	A/N - 02	NOT USED - Blank
*PHYSICAL_CHECKUP	340	A/N - 01	NOT USED – Blank
*PHYSICAL_DATE	341	A/N - 08	NOT USED - Blank
*PHYSICAL_FREQ	349	A/N - 01	NOT USED - Blank
*LAST_REVIEW_DATE	360	A/N - 08	NOT USED - Blank
*NEXT_REVIEW_DATE	358	A/N - 08	NOT USED - Blank
*PERFORMANCE	366	A/N - 03	NOT USED - Blank
*PROMOTABILITY	369	A/N - 01	NOT USED - Blank
*PROMOTABILITY_DATE	370	A/N - 08	AU444940.PEFDWNLD - NOT USED - Field is Blank AU444391.PAYEARN File – Probation Complete Date
*UNION_FLG	378	A/N - 01	NOT USED - Blank
*UNION_CODE	379	A/N - 04	NOT USED - Blank
*UNION_DATE	383	A/N - 08	NOT USED - Blank
*UNION_DEDUCT	391	A/N - 01	NOT USED - Blank
*LEAVE_DATE	392	A/N - 08	NOT USED - Blank
*RETURN_DATE	400	A/N - 08	NOT USED - Blank
*REHIRE_IND	408	A/N - 01	NOT USED - Blank
*EXIT_INTERVIEW	409	A/N - 01	NOT USED - Blank
*EXIT_REASON	410	A/N - 02	NOT USED - Blank
DEATH_DATE	412	A/N - 08	Date employee was deceased (CCYYMMDD)
MED_ELIG	420	A/N - 01	Health eligibility indicator E = eligible, N = not eligible
MED_OPT	421	A/N - 02	Health Insurance Plan (from PLS Directory)
LIFE_ELG	423	A/N - 01	Life insurance eligibility indicator E = eligible, N = not eligible
LIFE_OPT	424	A/N - 02	Life Insurance Plan (from PLS Directory)
*DLIFE_ELG	426	A/N - 01	NOT USED - Blank
*DLIFE_OPT	427	A/N - 02	NOT USED - Blank
*PAI_ELG	429	A/N - 01	NOT USED - Blank
*PAI_OPT	430	A/N - 02	NOT USED - Blank
PEN_ELG	432	A/N - 01	Retirement eligibility indicator E = eligible, N = not eligible
PEN_OPT	433	A/N - 02	Retirement Plan (from PLS Directory)
*LTD_ELG	435	A/N - 01	NOT USED - Blank
*LTD_OPT	436	A/N - 02	NOT USED - Blank
*SAV_ELG	438	A/N - 01	NOT USED - Blank
*SAV_OPT	439	A/N - 02	NOT USED - Blank
*BOND_ELG	441	A/N - 01	NOT USED - Blank
*BOND_OPT	442	A/N - 02	NOT USED - Blank
DENTAL_ELG	444	A/N - 01	Dental insurance eligibility indicator - E = eligible, N = not eligible
DENTAL_OPT	445	A/N - 02	Dental insurance Plan
*MISC3_ELG	447	A/N - 01	NOT USED - Blank
*MISC3_OPT	448	A/N - 02	NOT USED - Blank
*MISC4_ELG	450	A/N - 01	NOT USED - Blank
*MISC4_OPT	451	A/N - 02	NOT USED - Blank
*MISC5_ELG	453	A/N - 01	NOT USED - Blank
*MISC5_OPT	454	A/N - 02	NOT USED - Blank
*PENSION_CODE	456	A/N - 04	NOT USED - Blank
VET_STATUS	460	A/N - 01	Veteran status Y or N (from VET Directory)
*CAREER_REVISION_PRINT	461	A/N - 01	NOT USED - Blank
REVISION_PRINT	462	A/N - 01	View Pay Stub Online Indicator Y or N
REQUEST_PRINT	463	A/N - 01	View W-2 Online Indicator Y or N
LINE_CHANGE	464	A/N - 30	NOT USED - Blank
DATE_MARRIED	494	A/N - 08	NOT USED - Blank
TELEPHONE	502	A/N - 10	NOT USED - Blank
REC_STATUS	512	A/N - 01	Employee status - C = complete, E = error, I = incomplete
*TRAVEL ACCIDENTS	513	A/N - 03	NOT USED – However, Program IPRT210 populates this field with 050 from original INSCI code
*RESERVED	516	A/N - 16	NOT USED - Blank
8MO_TEMP_DATE	532	A/N - 08	8 - mo temp anniversary date (CCYYMMDD) If no 8 Mo Temp Date, field is 0 filled
8MO_TEMP_CSS_HOURS 4.1	540	A/N - 07	Cumulative 8 - mo temp hours. If no 8 Mo Temp Hours, Field is 0 filled, Column 546 blank.
AGY_CSS_HOURS 7.2	547	A/N - 11	Employee CSS hours with this agency, Column 557 blank.
PROB_APPT_DATE	558	A/N - 08	Date appointed to probationary status (CCYYMMDD)
PROB_CSS-Hours 4.1	566	A/N - 07	Probationary CSS Hours, If no Probationary Hours, field is 0 filled, Column 572 blank
*FILLER	573	A/N - 22	NOT USED - Blank
*BIRTH_COUNTRY	595	A/N - 02	NOT USED - Blank
*TITLE	597	A/N - 04	NOT USED - Blank
*VISA_EXPIRY_DATE	601	A/N - 08	NOT USED - Blank
*VISA_STATUS_CODE	609	A/N - 01	NOT USED - Blank
*EVAL_LINE_OVERRIDE	610	A/N - 03	NOT USED - Blank
*TOTAL_JOB_POINTS	613	A/N - 06	NOT USED 0 filled with 5 0's, Column 618 is blank.
*RESERVED_2	619	A/N - 14	NOT USED - Blank
*EXPANSION_2	633	A/N - 20	NOT USED - Blank
TOTAL	652

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

SCOContent LeftColumn TopHeaderEmployee Base Segment

employee base segment Employee Base Segment

SCOContent LeftColumn TopHeader
Employee Base Segment