Biweekly Labor Distribution File for Requesting Agencies (140 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 being created for:
 
CRA.S44.AU444986.LABORDIS
DHA.S44.AU444986.LABORDIS
DHE.S44.AU444986.LABORDIS
DHF.S44.AU444986.LABORDIS
MED.S44.AU444986.LABORDIS
OLB.S44.AU444986.LABORDIS
VET.S44.AU444986.LABORDIS
VRF.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
FUND CODE131(A04)