ACH Extract File Format

Field Name

Columns

Length

Description/Format

File Header Record

Record Type

1

1

'1'

Priority code

2-3

2

'2'

Destination Bank ID

4-13

10

This is entered into CLM under Office Management/System Configuration Parameters/ACH Parameters.

Sending School ID

14-23

10

This is entered into CLM under Office Management/System Configuration Parameters/ACH Parameters.

Transmission date

24-29

6

YYMMDD (current date)

Transmission time

30-33

4

HHMM (current time)

File ID Modifier

34

1

'A'

Record Size

35-37

3

'094'

Format Code

38

1

'1'

Bank Name

39-61

23

This is entered into CLM under Office Management/System Configuration Parameters/ACH Parameters.

School Name

62-84

23

STAFF.ORGANIZATION

Reference code

85-92

8

Blank

Company Batch Header Record

Record Type

1

1

'5'

Service class code

2-4

3

'200'

School Name

5-20

16

STAFF.ORGANIZATION

Discretionary data

21-40

20

Blank

Company ID

41-50

10

This is entered into CLM under Office Management/System Configuration Parameters/ACH Parameters.

Standard entry class

51-53

3

'PPD'

Company entry description

54-63

10

STAFF.MISCASCII2 (if MISCASCII2 is blank/null, use 'STUDLOANS')

Company descriptive date

64-69

6

YYMMDD (transaction date entered by user at run-time)

Effective entry date

70-75

6

YYMMDD (transaction date entered by user at run-time)

Filler (reserved)

76-78

3

Blanks

Originator status code

79

1

'1'

Destination bank ID

80-87

8

This is entered into CLM under Office Management/System Configuration Parameters/ACH Parameters.

Batch number

88-94

7

'0000001'

Detail Record

Record type

1

1

'6'

Bank transaction code

2-3

2

ACH.BANK_TRANSCODE ("22" - DDA credit, "23" - DDA credit prenote, "27" - DDA debit, "28" - DDA debit prenote, "32" - savings credit, "33" - savings credit prenote, "37" - savings debit, "38" - savings debit prenote)

Bank FRD/ABA#

4-11

8

This is entered into CLM in Borrower Services/ACH Accounts.

MOD 10 Check digit

12

1

Check digit calculated on ACH.BANK_FRD_ABA

Borrower Bank account #

13-29

17

This is entered into CLM in Borrower Services/ACH Accounts.

Amount of transaction

30-39

10

LOANFINC.PAYAMT (prenotes should send a zero dollar amount)

Borrower SSN

40-54

15

This is from the borrower’s record.

Borrower Name

55-76

22

This is from the borrower’s record.

Discretionary data

77-78

2

Blanks

Addenda record indicator

79

1

'0' (zero)

Trace number

80-87

8

(Bank ID #)

Sequence #

88

1

'0' (zero)

Ascending record sequence #

89-94

6

Record #. Only count type 6 records

Company Batch Trailer Record/Record type 8 (one per file)

Record type

1

1

'8'

Service class

2-4

3

'200'

Total # detail records

5-10

6

Only count type 6 records

Hash count

11-20

10

Sum of all ACH.BANK_FRD_ABA

Total debit amount

21-32

12

Sum of LOANFINC.PAYAMT

Total credit amount

33-44

12

'000000000000'

Company ID

45-54

10

STAFF.MISCASCII1 (if MISCASCII1 is blank/null, use STAFF.MEMBER_ID

Filler (reserved)

55-79

25

Blanks

Bank ID #

80-86

7

This is entered into CLM under Office Management/System Configuration Parameters/ACH Parameters.

Batch number

87-93

7

'0000001'

File Trailer Record/Record type 9 (one per file)

Record type

1

1

'9'

Batch count

2-7

6

'000001'

Block count

8-13

6

How many blocks of 10 records based on total # of records in the file? i.e. 9 records = 1 block; 13 records = 2 blocks. Right justified; zero filled

# of detail records

14-21

8

Total # of detail records; right justified; zero filled

Hash count

22-31

10

Sum of all ACH.BANK_FRD_ABA; right justified; zero filled

Total debit amount

32-43

12

Sum of LOANFINC.PAYAMT; right justified; zero filled

Total credit amount

44-55

12

'000000000000'

Filler

56-94

39

All Blank