Employee Mailing Address 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 - MAILING ADDRESS (MAD) ​ ​ ​
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.
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 MAD

 

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 - 07
SEGMENT_ID80A/N - 03Segment ID = MAD
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 MAD
MVA_DATE101A/N - 08FIELD IS BLANK ON MAD
COMPANY 109A/N - 03Agency Number (910 Directory) 
EMPLOYEE SSN 112A/N - 09Social Security Number
STREET121A/N - 32Employee Street Address
CITY153A/N - 20Employee Address - City
STATE CODE173A/N - 02Employee Address – 2 digit State Code
ZIP CODE175A/N - 05Employee Address – 5 digit Zip Code
TOTAL179