RITS Drawdown File Layout 

IPAC Format for RITS Outgoing File to OPM
2

File Identifier Record

APPLICATION: RITS 

FILE: RITS Drawdown Download File 

FLOW: Output from RITS Drawdown Process 

RECORD: File Record Type 

APPLICATION DATA 

Field Required Length Start Column End Column Type Value/Description Validation

Record Type * 1 1 1 Char ‘1’

Zero Filler * 579 2 580 Num ‘0’

File Identifier Record

APPLICATION: RITS 

FILE: RITS Drawdown Download File

FLOW: Output from RITS Drawdown Process 

RECORD: 2812 Transaction Header Record 

APPLICATION DATA 

Field Required Length Start Column End Column Type Value/Description Validation

Record Type * 1 1 1 Char ‘5’
3

Payroll Office Number 8 2 9 Num

Report Number Last 3 10 12 Char

Payment Period Start Date 6 13 18 Date

Payment Period End Date 6 19 24 Date

Payroll Paid Date 6 25 30 Date

Zero Filler 4 31 34 Num

Regular Health Benefit 

Withholding 

11 35 45 Zoned Decimal

Regular Heath Benefit 

Contribution 

11 46 56 Zoned Decimal

Field Required Length Start Column End Column Type Value/Description Validation

Life Basic Withholding 11 57 67 Zoned Decimal 

Life Basic Contribution 11 68 78 Zoned Decimal 

Life Additional Withholding 11 79 89 Zoned Decimal 

Life Standard Withholding 11 90 100 Zoned Decimal 

Life Family Withholding 11 101 111 Zoned Decimal 

Life Post Retirement Withholding 11 112 122 Zoned Decimal

CSRS Retirement Withholding 11 123 133 Zoned Decimal 

CSRS Retirement Contribution 11 134 144 Zoned Decimal 
4

CSRS Military/Civilian Service 

Credit 

11 145 155 Zoned Decimal 

CSRS Reemployed 

Salary Offset 

11 156 166 Zoned Decimal 

FERS Regular Withholding 11 167 177 Zoned Decimal 

Field Required Length Start Column End Column Type Value/Description Validation

FERS Regular Contribution 11 178 188 Zoned Decimal

FERS Military Reserves 

Technicians Withholding 

11 189 199 Zoned Decimal 

FERS Military Reserves 

Technicians Contribution 

11 200 210 Zoned Decimal

FERS Special Withholding 11 211 221 Zoned Decimal

FERS Special Contribution 11 222 232 Zoned Decimal

FERS Reemployed Offset 11 233 243 Zoned Decimal

Zero Filler 10 244 253 Num

FERS Military Deposits 11 254 264 Zoned Decimal

Grand Total 13 265 277 Zoned Decimal

Zero Filler 2 278 279 Num

Field Required Length Start Column End Column Type Value/Description Validation

Health Benefit

Coverage Withholding

11 280 290 Zoned Decimal
5

Health Benefit 

Coverage Contribution

11 291 301 Zoned Decimal

FERS RAE Regular Withholdings 11 302 312 Zoned Decimal

FERS RAE Regular Contributions 11 313 323 Zoned Decimal

FERS RAE Military 

Reserve Withholdings 

11 324 334 Zoned Decimal

FERS RAE Military 

Reserve Contributions

11 335 345 Zoned Decimal

FERS RAE Special Withholdings 11 346 356 Zoned Decimal

FERS RAE Special Contributions 11 357 367 Zoned Decimal

FERS RAE Reemployed Offset 11 368 378 Zoned Decimal 

FERS RAE Military Deposit 11 379 389 Zoned Decimal 

FERS FRAE Regular Withholdings 11 390 400 Zoned Decimal

Field Required Length Start

Column

End Column Type Value/Description Validation

FERS FRAE Regular Contributions 11 401 411 Zoned Decimal

FERS FRAE Military 

Reserve Withholdings

11 412 422 Zoned Decimal

FERS FRAE Military 

Reserve Contributions

11 423 433 Zoned Decimal
6

FERS FRAE Special Withholdings 11 434 444 Zoned Decimal

FERS FRAE Special Contributions 11 445 455 Zoned Decimal

FERS FRAE Reemployed 

Offset

11 456 466 Zoned Decimal

FERS FRAE Military Deposit 11 467 477 Zoned Decimal

Zero Filler 103 478 580 Num

File Identifier Record

APPLICATION: RITS 

FILE: RITS Drawdown Download File

FLOW: Output from RITS Drawdown Process 

RECORD: 2812 Transaction Detail Record 

APPLICATION DATA

Field Required Length Start Column End Column Type Value/Description Validation

Record Type * 1 1 1 Char ‘3’

PO Number 8 2 9 Num

Trailer Switch 1 10 10 Num

Zero Filler 3 11 13 Num
7

Health Benefit Code 1 5 14 18 Char

Health Benefit Amount 1 11 19 29 Zoned Decimal

Health Benefit Code 2 5 30 34 Char

Health Benefit Amount 2 11 35 45 Zoned Decimal

Health Benefit Code 3 5 46 50 Char

Field Required Length Start Column End Column Type Value/Description Validation

Health Benefit Amount 3 11 51 61 Zoned Decimal

Health Benefit Code 4 5 62 66 Char

Health Benefit Amount 4 11 67 77 Zoned Decimal

Health Benefit Code 5 5 78 82 Char

Health Benefit Amount 5 11 83 93 Zoned Decimal

Health Benefit Code 6 5 94 98 Char

Health Benefit Amount 6 11 99 109 Zoned Decimal

Health Benefit Code 7 5 110 114 Char

Health Benefit Amount 7 11 115 125 Zoned Decimal

Health Benefit Code 8 5 126 130 Char

Health Benefit Amount 8 11 131 141 Zoned Decimal

Health Benefit Code 9 5 142 146 Char
8

Health Benefit Amount 9 11 147 157 Zoned Decimal

Field Required Length Start Column End Column Type Value/Description Validation

Health Benefit Code 10 5 158 162 Char

Health Benefit Amount 10 11 163 173 Zoned Decimal

Health Benefit Code 11 5 174 178 Char

Health Benefit Amount 11 11 179 189 Zoned Decimal

Health Benefit Code 12 5 190 194 Char

Health Benefit Amount 12 11 195 205 Zoned Decimal

Health Benefit Code 13 5 206 210 Char

Health Benefit Amount 13 11 211 221 Zoned Decimal

Health Benefit Code 14 5 222 226 Char

Health Benefit Amount 14 11 227 237 Zoned Decimal

Health Benefit Code 15 5 238 242 Char

Health Benefit Amount 15 11 243 253 Zoned Decimal

Health Benefit Code 16 5 254 258 Char

Field Required Length Start Column End Column Type Value/Description Validation

Health Benefit Amount 16 11 259 269 Zoned Decimal
9

Health Benefit Code 17 5 270 274 Char

Health Benefit Amount 17 11 275 285 Zoned Decimal

Health Benefit Code 18 5 286 290 Char

Health Benefit Amount 18 11 291 301 Zoned Decimal

Health Benefit Code 19 5 302 306 Char

Health Benefit Amount 19 11 307 317 Zoned Decimal

Health Benefit Code 20 5 318 322 Char

Health Benefit Amount 20 11 323 333 Zoned Decimal

Health Benefit Code 21 5 334 338 Char

Health Benefit Amount 21 11 339 349 Zoned Decimal

Health Benefit Code 22 5 350 354 Char

Health Benefit Amount 22 11 355 365 Zoned Decimal

Field Required Length Start Column End Column Type Value/Description Validation

Health Benefit Code 23 5 366 370 Char

Health Benefit Amount 23 11 371 381 Zoned Decimal

Health Benefit Code 24 5 382 386 Char

Health Benefit Amount 24 11 387 397 Zoned Decimal

Health Benefit Code 25 5 398 402 Char
10

Health Benefit Amount 25 11 403 413 Zoned Decimal

Health Benefit Code 26 5 414 418 Char

Health Benefit Amount 26 11 419 429 Zoned Decimal

Health Benefit Code 27 5 430 434 Char

Health Benefit Amount 27 11 435 445 Zoned Decimal

Health Benefit Code 28 5 446 450 Char

Health Benefit Amount 28 11 451 461 Zoned Decimal

Health Benefit Code 29 5 462 466 Char

Health Benefit Amount 29 11 467 477 Zoned Decimal

Field Required Length Start Column End Column Type Value/Description Validation

Health Benefit Code 30 5 478 482 Char

Health Benefit Amount 30 11 483 493 Zoned Decimal

Zero Filler 87 494 580 Num
11

File Identifier Record

APPLICATION: RITS 

FILE: RITS Drawdown Download File

FLOW: Output from RITS Drawdown Process 

RECORD: 2812 Transaction C Record 

APPLICATION DATA

Field Required Length Start Column End Column Type Value/Description Validation

Record Type * 1 1 1 Char ‘C’

Total Block Amount 13 2 15 Zoned Decimal

Zero Filler 566 16 580 Num

File Identifier Record

APPLICATION: RITS 

FILE: RITS Drawdown Download File

FLOW: Output from RITS Drawdown Process 

RECORD: Drawdown File Transport Record 
12

APPLICATION DATA

Field Required Length Start Column End Column Type Value/Description Validation

Secure Transport ALC * 8 1 8 Char ‘N’

PO Number 8 2 9 Num

Under Score One 1 9 9 Char

Secure Transport File 

Name 

8 10 17 Char

Underscore Two 1 18 18 Char

Secure Transport Batch ID Pre Fix 1 19 19 Char

Secure Transport Batch ID 16 20 35 Num

Underscore Three 1 36 36 Char

Field Required Length Start Column End Column Type Value/Description Validation

Secure Transport File Date 8 37 44 Date

Underscore Four 1 45 45 Char

Secure Transport File Time 4 46 49 Time

Underscore 5 1 50 50 Char

Secure Transport FileName Suffix 1 51 51 Char

Secure Transport File Extension 4 52 55 Char

 
13

File Identifier Record

APPLICATION: RITS 

FILE: RITS Drawdown Download File

FLOW: Output from RITS Drawdown Process 

RECORD: RITS Download Trailer Record 

APPLICATION DATA

Field Required Length Start Column End Column Type Value/Description Validation

Record Type * 1 1 1 Char ‘F’

Total Tape Amount 13 2 14 Zoned Decimal

Zero Filler 566 15 580 Num

Revision History

Version Date Revision Notes

0.1 1/8/13 Initial Draft 

1.0 9/24/13 Finalized version approved, Effective date 12/14/13 

1.1 11/7/13 Document formatting changes 

1.2 6/24/14 Included new FERS FRAE categories 

1.3 7/22/14 Document formatting changes

1.4 5/16/19 Document formatting changes, removed app overview; no changes to layout information