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

Identifies the type of payroll activity

       M – Manual

       V – Void

       A – Adjustment

       Blank – Regular Pay

 

Note:  The Field is always blank on the BAS, MAD, PAY and POS segments.      

SEGMENT_NO78A/N - 02Segment ID number - 90
SEGMENT_ID80A/N - 03Segment ID = NET
PAYROLL_NO83A/N - 05Current Payroll Number - year = 2 Digits and the payroll number.
PAY_DATE88A/N - 08Current Payroll - Pay Date (CCYYMMDD)
MVA_PAYROLL_NO96A/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 – The current Payroll Number processing will display on the NET Segment.  The Payroll Number Adjusted will display on the EAR, FED, STA, DED and DST segments.  . 

MVA_DATE101A/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.  

CUR_HRS109N - 11Total hours – current payroll (includes SFT, Ext OT, etc.)
CUR_AMT120N - 11Net pay – current payroll
LAST_ACT_DATE131A/N - 08

AU444940.PEFDWNLD - NOT USED – Field is blank.

AU444391.PAYEARN File – Pay Period End Date    (CCYYMMDD) – current payroll.

*ACCT_DISTRIBUTION139A/N - 30NOT USED – Blank
*ACCRUAL_DISTRIBUTION169A/N - 30NOT USED - Blank
POSTING_DATE199A/N - 08Payroll posting date (CCYYMMDD)
SICK_EARNED207N – 09Sick leave earned as of this payroll activity.  If no leave earned field is 0 filled.
VAC_EARNED216N – 09Vacation earned as of this payroll activity.  If no leave earned field is 0 filled.
CSS_EARNED225N – 09Credited state service earned as of this payroll activity.  If no CSS earned field is 0 filled.
SICK_BAL234N – 09Statewide sick leave balance as of this payroll activity.
VAC_BAL243N - 01Statewide vacation balance as of this payroll activity.
CSS_BAL252N - 11Statewide credited state service as of this payroll activity.
COV COMP_BAL263N – 09Agency Total Covered comp time balance as of this payroll activity.  If no Balance field is 0 filled.
EAL_BAL272N – 09Agency RHH balance as of this payroll activity.  If no Balance field is 0 filled.
ON_CALL_BAL281N – 09Agency on-call balance as of this payroll activity.  If no Balance field is 0 filled.
EX COMP BAL290N – 09Agency Exempt Comp time balance.  If no Balance field is 0 filled.
FILLER298A/N – 47 
*PAY_NUMBER337A/N - 02NOT USED - Blank
TOTAL338