Employee Position 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 POSITION (POS) ​ ​ ​
FIELD NAMECOLUMN BEGIN

DATA TYPE

(A/Alpha, N/Numeric)

FIELD LENGTH

DESCRIPTION
COMPANY_KEY1A/N - 03Agency Number (910 Directory)
PAY_GROUP_KEY4A/N - 02

Pay Group 01 – Biweekly (PGR Directory)

Pay Group 06 - University

Pay Group 20 - Judicial Monthly

PAY_LOCATION_KEY6A/N - 04Pay 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_NAME10A/N - 22Employee Last Name, includes appendage.
FIRST_NAME32A/N - 14Employee First Name
MIDDLE_NAME46A/N - 14Employee Middle Name
SSN_NO60A/N - 09Social Security Number
KEY_DATE69A/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_TYPE77A/N - 01

FIELD IS BLANK ON POS

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_NO78A/N - 02Segment ID number - 13
SEGMENT_ID80A/N - 03Segment ID = POS
PAYROLL_NO83A/N - 05Payroll Number - year = 2 Digits and the payroll number.
PAY_DATE88A/N - 08Pay Date (CCYYMMDD)
MVA_PAYROLL_NO96A/N - 05FIELD IS BLANK ON POS
MVA_DATE101A/N - 08FIELD IS BLANK ON POS
POSITION_NO109 A/N – 04Employee's Position Control Number (PCN)
*FILLER113 A/N - 06NOT USED - Blank      
POSITION_SEQ119A/N - 02Identifies the order of actions to be processed against an employee position (400) transaction.
POS_TITLE_OVERRIDE121A/N - 20Employee's Position Class code description (CLS Directory)
JURISDICTION141A/N - 01Jurisdiction code - C = classified, N = non-classified. (PTT Directory)
APPOINTMENT TYPE142A/N - 01A = acting, B = probationary, E = elected, etc.  (PTT Directory)
EMPLOYMENT_TYPE143A/N – 01B = board member, D = declared, E = elected, etc.  (PTT Directory)
PERMANENCY144A/N - 01Suffix code - N = not applicable, U = underfill, H = agency head.  (PPT Directory)
*GRANT_FLAG145A/N – 01 NOT USED - Blank
POSITION_STATUS146A/N - 01Pay status - A =active, B = inactive with pay, etc. (PMS Directory)
WORKING_STATUS147A/N – 02Work type - determined by pay period hours and FTE  (WKS Directory)
*TENURE_STATUS149A/N - 01NOT USED – Field defaults to N
FULL_TIME_EQUIV150N - 05FTE – Number of months an employee is expected to work divided by 12. (WKS Directory)
*FULL_TIME_TEACH_EQUIV155N - 05NOT USED – Field is 0 filled (0.00) 
JOB_CLASS_OVERRIDE160A/N - 10Numeric Class code – Employee's numeric class code. (CLS Directory) 5 0's followed by 5 numbers.
*EEO_OVERRIDE170A/N - 03NOT USED - Blank 
*EEO_SUB_OVERRIDE173A/N - 03NOT USED - Blank 
FLSA_OVERRIDE176A/N - 01Employee's FLSA Code -Fair Labor Standards Act (FLS Directory)
SALARY_SCHEDULE177A/N - 01Employee pay schedule
SALARY_GRADE178A/N - 02Employee pay grade
*SALARY_STEP180A/N - 02

NO LONGER USED with H Schedule, Field is Blank.

Employee pay step

PAY_CODE182A/N - 01DSP only - Y = yes pay, N = no pay
TIMESHEET_REQD183A/N - 01Y = time must be entered, N = time is generated unless time is submitted.
PAY_BASIS184A/N - 01Pay rate indicator – H = hourly, D = daily, etc.  (PBS Directory)
*CONTRACT_SALARY_BASIS185A/N - 01NOT USED – Field is Blank
RATE186N - 13Employee's rate of Pay.  Used in conjunction with rate indicator, pay schedule and pay grade.
RATE_OVERRIDE199N – 13Override pay rate. If no override field is 0 filled.
BENEFIT_RATE_ADJ_CONTRACT_SAL212N - 13Adjusted contract salary for annual employees. If rate indicator is not 'A' field is 0 filled.
CONTRACT_SALARY225N – 13Annual contract salary amount.  If rate indicator is not A field is 0 filled.
ANNUAL_EQUIV_SALARY238N - 13Annual equivalent salary (system generated)
STD_HOURS251A/N – 07

Standard hours in a pay period (WKS Directory)

Biweekly = 80.00 hours

Monthly = 173.3 hours

*WITHHOLDINGS1258A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS2259A/N – 01NOT USED – Field is Blank
*WITHHOLDINGS3260A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS4261A/N - 01NOT USED – Field is Blank
UNEMP_IND_SW262A/N - 01Wages subject to Unemployment - Y = Yes, N = No
*WITHHOLDINGS6263A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS7264A/N – 01NOT USED – Field is Blank
*WITHHOLDINGS8265A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS9266A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS10267A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS10268A/N – 01NOT USED – Field is Blank
*WITHHOLDINGS12269A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS13270A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS14271A/N - 01NOT USED – Field is Blank
*WITHHOLDINGS15272A/N - 01NOT USED – Field is Blank
*DIST_PERCENT273N - 05NOT USED ON THIS SEGMENT – Field defaults to distribution percent of 1.00.  Distribution codes and percent are on the position Control file.
*PAYROLL_DIST278 A/N - 30NOT USED – Field is Blank
LEAVE_CODE308A/N - 03Employee Leave Code. (PLV Directory)
*LEAVE_TYPE310A/N - 02NOT USED – Field is Blank
*TERM_REASON312A/N - 02NOT USED – Field is Blank
*ASSIGNED_LOCATION313A/N - 04NOT USED – Field is Blank
*ORG_CODE317A/N - 10NOT USED – Field is Blank
*UNION_CODE327A/N - 04NOT USED – Field is Blank
*UNION_FLAG331A/N - 01NOT USED – Field is Blank
POS_EFF_DATE332A/N - 08Employee's current position effective date (CCYYMMDD)
*POS_END_DATE340A/N - 08NOT USED – Field is Blank
*APPROVAL_DATE348A/N - 08NOT USED – Field is Blank
STATUS_DATE356A/N - 08Process date (CCYYMMDD)
RETURN_DATE364A/N - 08Retroactive date (CCYYMMDD).  If no retro date field is blank.
*INCREMENT_DATE372A/N - 08NOT USED – Field is Blank
*LAST_REVIEW_DATE380A/N - 08NOT USED – Field is Blank
*NEXT_REVIEW_DATE388A/N - 08NOT USED – Field is Blank
*PROMOTABILITY_DATE396A/N - 08NOT USED – Field is Blank
RATE_OVERRIDE_STARTS404A/N - 08Override start date.
RATE_OVERRIDE_ENDS412A/N - 08Override end date.
*PROMOTABILITY_CODE420A/N - 01NOT USED – Field is Blank
*PERFORMANCE_RATING421A/N - 03NOT USED – Field is Blank
*FUTURE_CHG_STATUS424A/N - 01NOT USED – Field is Blank
*FUTURE_CHG_DATE425A/N - 08NOT USED – Field is Blank
VAC_PCT433N - 07

NO LONGER USED – Field is 0 filled

CONTRACT_HB_PCT

VAC_ACCRUED440N – 09NO LONGER USED – Field is 0 filled CONTRACT_HB_ACCRUED
CHANGE_REASON449A/N - 02Employee's current position change reason.
COMP_ACCRUE_SW451A/N - 01Comp accrue switch (Y or N)
EAL_ACCRUE_SW452A/N - 01RHH accrue switch (Y or N)
SHIFT_DIFF_SW453A/N - 02Shift Pay switch  (Y or N) 
*MESSAGE_CODE_4455A/N - 02NOT USED – Field is Blank
*DUAL_INCUMBENT457A/N - 01NOT USED – Field is Blank
*EVAL_LINE_OVERRIDE458A/N - 03NOT USED – Field is Blank
*TOTAL_JOB_POINT461N - 06NOT USED – Field is 0 filled with 5 0's
*RESERVED467A/N - 05NOT USED – Field is Blank
IPC_REGISTER_NBR472A/N - 08DHR register number for classified appointments.  If no register number field is blank.
*FILLER480A/N - 12NOT USED – Field is Blank 
TOTAL491