Military Payroll File Layout - Batch Header, Other Earnings and Separations

 

FIELD NAME


 

COLUMN BEGIN

 

LENGTH/DESCRIPTION

Transaction '000' - Batch Header​​
   
TRANSACTION ID1(A03) Always '000'
BATCH NUMBER4(A05) 5-digit batch number (40000 - 49999)
AGENCY CODE9(A03) 3-digit org code (190)
FILLER12 
PAY LOCATION15(A04) currently '1000'
 PAY GROUP19(A02) always '01' regular bi-weekly
RUN TYPE21(A01) always 'R'
PAY PERIOD NUMBER22(A05) 2-digit year followed by the 3-digit pay period number (example: 08001)
PAY PERIOD END DATE27(A08) format YYYYMMDD
BATCH EMPLOYEE COUNT35(A03) always '001' - batches limited to one employee
BATCH TOTAL HOURS38(A05) total hours in batch - example 80 hours = 00800
FILLER43 
BATCH TOTAL DOLLARS44(A10) total dollars in batch - example 141.35 = 0000014135
FILLER5427 spaces
   
Transaction '081' - One Time Other Earnings​​
TRANSACTION ID1(A03) always '081'
BATCH NUMBER4(A05) optional
AGENCY CODE9(A03) 3-digit org code (190)
FILLER 123 spaces
4 DIGITS OF LAST NAME15(A04) optional
SOCIAL SECURITY NUMBER19(A09) employee's social security number
POSITION CONTROL NUMBER28(A04) valid active position for employee (9000)
EARNINGS TYPE32(A03) 3-digit type of time (SAD)
EFFECTIVE DATE35

(A08) Pay Period Begin Date*

format YYYYMMDD

*Use employee hire date if AO was not pay period begin date

PAY PERIOD AMOUNT43(A11) right justify, zero fill (example: 00000040000 = $400.00
INDEX54(A04) optional
PCA58(A05) optional
FILLER63(A02) always '00'
GRANT/PROJECT65(A09) optional
SAD HOURS74(A05) Number of SAD hours paid - example 84.0 hours = 00840
 FILLER 79(A04) optional
​​​
Transaction '090' - Separation Data​​
TRANSACTION ID3(A03) always '090'
BATCH NUMBER4(A05) optional
AGENCY CODE9(A03) always '190'
FILLER123 spaces
4 DIGITS OF LAST NAME15(A04) optional
SOCIAL SECURITY NUMBER19(A09) employee's social security number
POSITION CONTROL NUMBER23(A04) valid active position for employee - currently '9000'
FILLER263 spaces
SEPARATION REASON292 digit change reason (left justify blank last space)
SEPARATION DATE31(A08) format YYYYMMDD
FILLER3935 spaces