EFT DEBIT RECORD LAYOUT

DEBIT FILE “HEADER” RECORD
DEBIT FILE - 200 Bytes (Header Record On The Debit File Sent To OST)
DESCRIPTION / TYPE / POSITION / LENGTH / VALUE
1. Agency Account Number / Numeric / 1 - 7 / 7 / ‘0000000'
2. Sending Agency Number / Alpha / 8 - 10 / 3 / 3-digit sending agency number
3. File Creation Date / Numeric / 11 – 18 / 8 / YYYYMMDD
4. File Creation Time / Numeric / 19 - 24 / 6 / HHMMSS
5. File Load Name / Alpha / 25 – 32 / 8 / ‘200DBXXX’ where XXX=3-digit agency number
6. Record Type / Alpha / 33 - 38 / 6 / ‘HEADER’
7. Filler / Alpha / 39 - 200 / 162 / Spaces
DEBIT FILE “DETAIL” RECORD
DEBIT INPUT FILE (RECEIVED FROM USER AGENCIES) 200 BYTES
Input File:
1.  TRE.PDE.EFTACH.FILE (from TRCK020P)
2.  TRE.PEF.A2174000.RESOURCE.DEBIT (TREFRESU)
3.  TRE.PEF.A21*
DESCRIPTION / TYPE / POSITION / LENGTH / VALUE
1. PARTICIPANT NUMBER / Alpha / 1 - 15 / 15 / Required, left justify, space fill
2. AGENCY NUMBER / Alpha / 16 - 19 / 4 / Required, example 1740= 0740
3. FILLER / Alpha / 20 – 20 / 1 / Space Fill
4. CLASS CODE / Alpha / 21 - 23 / 3 / Required, Class Code assigned by OST
5. REFERENCE NUMBER / Numeric / 24 - 29 / 6 / Optional
6. DOLLAR AMOUNT / Numeric / 30 - 39 / 10 / Required, 2 Decimal Places,
COBOL PICTURE 9(8)V99
7. EFFECTIVE DATE / Numeric / 40 - 45 / 6 / Required, YYMMDD,
Can not be Saturday, Sunday, or Holiday. Must be greater than current processing day.
8. ACCOUNT NUMBER / Alpha / 46 - 62 / 17 / Participant’s Bank Account Number. Required for new participants and changes. Left Justify, space fill.
9. BANK NUMBER / Alpha / 63 - 71 / 9 / Participant’s Bank Routing Number.
Required for New Participants and changes.
10. SAVINGS/CHECKING / Alpha / 72 – 72 / 1 / Participant’s Account Type
C for checking, S for Savings, G for General Ledger
11. FILLER / Alpha / 73 - 86 / 14 / Space Fill
12. ACH ADDENDA INFO / Alpha / 87 - 166 / 80 / Optional - Participant’s addenda information,
13. PARTICIPANT NAME / Alpha / 167 – 191 / 25 / Name of Participant
14. FILLER / Alpha / 192 - 200 / 9 / For Future Use . Space Fill
FILE “TRAILER” RECORD
DEBIT FILE - 200 Bytes (Trailer Record On The Debit File Sent To OST)
DESCRIPTION / TYPE / POSITION / LENGTH / VALUE
1. Account Number / Numeric / 1 - 7 / 7 / ‘9999999'
2. Effective Date / Numeric / 8 – 13 / 6 / YYMMDD
3. Total Number Records / Numeric 9(9) / 14 - 22 / 9 / Right Justify
4. Total Dollar Amount / Numeric 9(9)V99 / 23 - 33 / 11 / Right Justify
2 Decimal Places
5. Filler / Alpha / 34 - 200 / 167 / Spaces

J:\Function\CORE\32 - ACES Replacement\Record Layouts\Debit - EFTDebit 200bytes with HeaderRecord.docx 7/3/2012 3:23 PM