Biweekly Labor Distribution File for Requesting Agencies (180 byte record length) FileXXX4986

Purpose:  Downloadable Labor Distribution file, in format suitable for PC input.
 
FREQUENCY:Biweekly
CREATED IN JOB(S):AU444940
 

 
Files are currently created for:
 
FGA.S44.AU444986.LABORDIS
HGH.S44.AU444986.LABORDIS
 

Note:  The BiWeekly Labor Distribution File Layout is the same for the 140 byte record length and the 180 byte record length through Column 130. 

  • 140 Byte Record has FUND Code in Column 131 through 134
  • 180 Byte Record does not have the FUND Code in Column 131 but has additional fields in Column 131 through Column 179
 
Labor Distribution File Layout:
FIELD NAMECOLUMN BEGINLENGTH/DESCRIPTION
   
AGENCY CODE1(A03)
PAY GROUP4(A02)
SSN6(A09)
LAST NAME15(A22)
FIRST NAME37(A14)
MIDDLE INITIAL51(A01)
PAY DATE52(A11) DD-MMM-YYYY
PAY LOCATION63(A04)
PAYROLL NUMBER67(A05) 2-digit year and PR#
PCN72(A04)
INDEX76(A04)
PCA80(A05)
GRANT NUMBER85(A06)
GRANT PHASE91(A02)
PROJECT NUMBER93(A06)
PROJECT PHASE99(A02)
SUBOBJECT CODE 101(A04) accounting code
EARNINGS ID or BENEFIT CODE105(A04)
EARNING or BENEFIT AMOUNT109(A11) -ZZZZZZZ.99
HOURS WORKED120(A11) -ZZZZZZZ.99
STARS ENTITY131(A01)
BATCH DEPT132(A03) agency code
BATCH DATE 135(A08) run date
BATCH TYPE143(A01) always G
BATCH NUMBER 144(A03) agency code
BATCH SEQUENCE147starts with 00001
BATCH DUP152(A01) always 0
FISCAL YEAR153(A04)
DIST INDICATOR157

(A01) O = earnings code 

C = employer cost

PAY TYPE158(A01) Blank = Reg, M = Manual, V = Void, A = Adjustment
MVA PAY NUMBER159(A5) payroll # of original action
MVA PAY DATE164(A08) MVA pay date
ACTION DATE172(A08) MVA date within the 'MVA Pay Number' of the original action