Employee Pay 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 (PAY) ​ ​ ​
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 PAY

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 - 10
SEGMENT_ID80A/N - 03Segment ID = PAY
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 PAY SEGMENT
MVA_DATE101A/N - 08FIELD IS BLANK ON PAY SEGMENT
*LAST_PAY_DATE109A/N - 08NOT USED – Blank
*LAST_PAY_TIME117A/N - 04NOT USED – Blank
*LAST_PAY_NO121A/N - 02NOT USED – Blank
*PAY_BASIS123A/N - 01NOT USED – Blank
TIMESHEET_REQD124A/N - 01Timesheet Required Indicator (Y or N)
*TIMESHEET_TURNAROUND125A/N - 01NOT USED – FIELD IS BLANK
*SHIFT_PRINT126A/N - 01NOT USED – FIELD IS BLANK
*SHIFT_DEFAULT127A/N - 01NOT USED – FIELD IS BLANK
*PAYROLL_DIST128A/N - 30NOT USED – FIELD IS BLANK
DIST_PERCENT158N - 05DISTRIBUTION  PCT
BENEFIT_RATE163N - 13If Rate Indicator is 'A', the Adjusted contract salary will display, if not 'A', field is 0 filled.
FED_TAX_EXEMPT176A/N - 01Fed tax Exempt indicator (Y or N)
LOCAL_TAX_EXEMPT177A/N - 01Local tax exempt indicator (Y or N).  Local Tax not currently used, field defaults to N.
STATE_TAX_EXEMPT178A/N - 01State tax exempt indicator (Y or N)
FICA_TAX_EXEMPT179A/N - 01FICA tax exempt indicator (Y or N)
*ASSIGNED_STATE180A/N - 02NOT USED – Blank
RESIDENT_STATE182A/N - 02Taxing state code
*RESIDENT_CITY184A/N - 04NOT USED – Blank
*RESIDENT_COUNTY188A/N - 03NOT USED – Blank
*WCB_CODE191A/N - 04NOT USED – Blank
BANK_DEP195A/N - 01Direct deposit indicator (Y or N)
CK_DDP_TYPE1196A/N - 01Checking #1 - DDP type (U = US), Blank if N/A
CK_DDP_PRE_EXEC1197A/N - 01Checking #1 - DDP status – X – Direct Deposit,  S – Pre-Note Sent, P – Pre-Note updated on MF but not sent on nightly file, Blank if N/A
CK_DDP_METHOD1198A/N - 01Checking #1- DDP method - F =full, P = partial, R = remainder, N= N/A
CK_DDP_AMT1199N - 11Checking #1 - DDP amount, If N/A field is 0 filled. Column 209 is Blank.
CK_DDP_TYPE2210A/N - 01Checking #2 - DDP type (U = US), Blank if N/A
CK_DDP_PRE_EXEC2211A/N - 01Checking #2 - DDP status – X – Direct Deposit,  S – Pre-Note Sent, P – Pre-Note updated on MF but not sent on nightly file, Blank if N/A.
CK_DDP_METHOD2212A/N - 01Checking #2 -  DDP method - F =full, P = partial, R = remainder, N=N/A
CK_DDP_AMT2213N - 11Checking #2 - DDP amount, if N/A field is 0 filled.
SV_DDP_TYPE3224A/N - 01Savings #1 - DDP type (U=US), Blank if N/A
SV_DDP_PRE_EXEC3225A/N - 01Savings #1 - DDP status - X – Direct Deposit,     S – Pre-Note Sent, P – Pre-Note updated on MF but not sent on nightly file, Blank if N/A.
SV_DDP_METHOD3226A/N - 01Savings #1 - DDP method - F =full, P = partial, R = remainder, N=N/A
SV_DDP_AMT3227N - 11Savings #1 - DDP amount, if N/A field is 0 filled.
*DDP_TYPE4238A/N - 01NOT USED - Blank
*DDP_PRE_EXEC4239A/N - 01NOT USED - Blank
*DDP_METHOD4240A/N - 01NOT USED – N=N/A
*DDP_AMT4241N - 11NOT USED - if N/A field is 0 filled. 
*DDP_TYPE5252A/N - 01NOT USED - Blank
*DDP_PRE_EXEC5253A/N - 01NOT USED - Blank
*DDP_METHOD5254A/N - 01NOT USED – N=N/A
*DDP_AMT4255N - 11NOT USED - if N/A field is 0 filled. 
SV_DDP_TYPE6266A/N - 01Savings #2 - DDP type (U=US), Blank if N/A
SV_DDP_PRE_EXEC6267A/N - 01Savings #2 - DDP status - X – Direct Deposit,     S – Pre-Note Sent, P – Pre-Note updated on MF but not sent on nightly file, Blank if N/A.
SV_DDP_METHOD6268A/N - 01Savings #2 - DDP method - F =full, P = partial, R = remainder, N=N/A
SV_DDP_AMT6269N - 11Savings #2 - DDP amount, if N/A field is 0 filled. 
*DDP_TYPE7280A/N - 01NOT USED - Blank
*DDP_PRE_EXEC7281A/N - 01NOT USED - Blank
*DDP_METHOD7282A/N - 01NOT USED – N=N/A
*DDP_AMT7283N - 11NOT USED - if N/A field is 0 filled.
*DDP_TYPE8294A/N - 01NOT USED - Blank
*DDP_PRE_EXEC8295A/N - 01NOT USED - Blank
*DDP_METHOD8296A/N - 01NOT USED – N=N/A
*DDP_AMT8297N - 11NOT USED - if N/A field is 0 filled. 
*DDP_TYPE9308A/N - 01NOT USED - Blank
*DDP_PRE_EXEC9309A/N - 01NOT USED - Blank
*DDP_METHOD9310A/N - 01NOT USED – N=N/A
*DDP_AMT9311N - 11NOT USED - if N/A field is 0 filled. 
*CHECK_NAME322A/N - 01NOT USED, Field Defaults to N
SICK_EARNED323N - 09YTD accrued sick leave
VAC-EARNED332N - 09YTD accrued vacation
*VAC_ACCRUED341N - 09NOT USED - Blank
CUR_NET350N – 11Current payroll net pay
*CHECK_MSG_IND361A/N - 01NOT USED - Blank 
*WORK_DAYS_LOST362N - 04NOT USED – 0 Filled (3 0's) 
*ASSIGNED_CITY366A/N - 04NOT USED - Blank  
*ASSIGNED_COUNTY370A/N - 03NOT USED - Blank   
*MAX_REG_ERN373N – 09NOT USED – Field is 0 filled  
*CUR_REG_ERN382N - 09NOT USED – Field is 0 filled  
*YTD_REG_ERN391N – 11NOT USED – Field is 0 filled  
*RESERVED402N - 05NOT USED - Blank   
*VAC_HRS407N - 09NOT USED/Balance may not be accurate.  Use VAC Balance on NET Segment.   
*SICK_HRS416N - 09NOT USED/Balance may not be accurate.  Use SIC Balance on NET Segment.  
CSS_HRS425N - 09Pay period credited state service hours accrued.
*CSS_ACCRUED434N - 09

NOT USED – Total CSS hours.  Field is 0 filled.  Use CSS hours on Net Segment.

Total Credited state service Hours

*FILLER443A/N - 24NOT USED - Blank    
*VAC_ACCRUAL/CUR_CONTRACT_HB_AMOUNT467N - 11NO LONGER USED – Field is 0 filled
PREV_VAC_ACCRUAL478N - 11Pay period sick accrued
*CPP_QPP_ACCRUAL489N - 11NOT USED – Field is 0 filled 
*UIC_PEN_TYPE500A/N - 01NOT USED - Blank     
*LANG_PREF501A/N - 01NOT USED - Blank    
*PENS_REG_NO502A/N - 09NOT USED - Blank     
*TAX_OPTION511A/N - 01NOT USED - Blank     
*LAST_DATE_WORKED512A/N - 08NOT USED - Blank     
*ADVANCED_CODE520A/N - 01NOT USED - Blank     
*OVT_BANK_IND521A/N - 01NOT USED - Blank     
*CAN_EXEM522N - 02NOT USED - Blank     
*COM_IND524A/N – 01NOT USED - Blank     
*COM_EST_ANN_GROSS525N - 11NOT USED – Field is 0 filled 
*COM_EST_ANN_EXPNS536N - 11NOT USED – Field is 0 filled  
*RESERVED547A/N – 08NOT USED - Blank      
*EXPANSION2555A/N - 20NOT USED - Blank      
TOTAL574