Attachment H Technical Specifications
DOR has 4 categories of information:
1. Paper Checks –
2. Direct Deposit – these specs are attached
3. Stored Value/Debit Card Refunds –
4. ACH – we use standard international NACHA standards for this processing.
This section provides an outline of the expected interfaces that a Bank needs to be able implement for the State of Georgia. It is possible that not all of the interfaces listed below will be necessary, depending on required functionalities and the capabilities of the Bank. This section should be considered a “starting point” to build from.
This section assumes that an interface allowing the secure transmission of files between DOR and the Bank will exist. DOR has in the past used both SFTP and ConnectDirect as a secure transmission method, and either will work for this purpose.
Direct Deposit Credit File
Interface 1: File Header Record
Field / Position / Size / Contents / Field Name / Entry Information1 / 01-01 / 1 / “1” / Record Type Code / Code identifying the File Header Record is “1”
2 / 02-03 / 2 / “01” / Priority Code / Currently, only “01” is used
3 / 04-13 / 10 / NNNNNNNNNN / Immediate Origin / This number identifies your Bank of America processing site (TX is 11000025, Virginia 051000017, and California 121108250).
4 / 14-23 / 10 / NNNNNNNNNN / Immediate Destination / Your 10-digit Company ID number assigned by BofA
5 / 24-29 / 6 / YYMMDD / File Creation Date / The date we created the report:
“YY” = Last two digits of the Year
“MM” = Month in two digits
“DD” = Day in two digits
6 / 30-33 / 4 / HHMM / File Creation Date / Time of day we created the file. This field is used to distinguish among report files if you submit more than one per day:
“HH = Hour based on a 24 hr clock
“MM” = Minutes in two digits
7 / 34-34 / 1 / UPPER CASE A-Z / File ID Modifier / Code to distinguish among multiple input files. Label the first (or only) file “A” and continue in sequence.
8 / 35-37 / 3 / “094” / Record Size / Number of bytes per record
9 / 38-39 / 2 / “10” / Blocking Factor / Number of records per block
10 / 40-40 / 1 / “1” / Format Code / Currently, only “1” is used
11 / 41-63 / 23 / Alphanumeric / Bank Name / Describes BofA as the originating financial institution (e.g. “BOFA SAN FRANCISCO”). Assigned by Bank of America.
12 / 64-86 / 23 / Alphanumeric / Company Name / Your company’s name, up to 23 characters including spaces.
13 / 87-94 / 8 / Alphanumeric / Reference Code / Left Blank
Interface 2: Company/Batch Header Record
Field / Position / Size / Contents / Field Name / Entry Information1 / 01-01 / 1 / “5” / Record Type Code / Code identifying the Company/Batch Header Record is “5”
2 / 02-04 / 3 / “200” / Service Class Code / Identifies the type of entries in the batch. Code “200” indicates debit, credit and prenotification entries.
3 / 05-20 / 16 / “GA DEPT OF REVEN” / Company Name / Company Name.
4 / 21-40 / 20 / Alphanumeric / Company Discretionary Data / Empty
5 / 41-50 / 10 / 1586002015 / Company Identification / 10-digit Company ID Number
6 / 51-53 / 3 / “PPD” / Standard Entry Class Code
7 / 54-63 / 10 / “TAX REFUND” / Company Entry Description / Description of the purpose of the entries
8 / 64-69 / 6 / “000000” / Company Descriptive Date / Date you chose to identify the entries for descriptive purposes only.
9 / 70-75 / 6 / YYMMDD / Effective Entry Date / The intended settlement date for this batch of items, as designated by RDFI.
“YY” = Last two digits of the Year
“MM” = Month in two digits
“DD” = Day in two digits
10 / 76-78 / 3 / Blank / Settlement Date
11 / 79-79 / 1 / “1” / Originator Status Code / Identifies the Originator as a non-Federal Government entity (or “2” a Federal Government entity)
12 / 80-88 / 9 / “010610005” / Originating DFI Identification / The Routing Number of the institution sending this entry (the RDFI in your original entry).
13 / 89-95 / 7 / Numeric / Batch Number / Assigned by the institution preparing this entry.
Interface 3: Entry Detail Record
One Entry Detail Record is created for each entry. It contains the information required to post the entry to the receiver’s account.
Field / Position / Size / Contents / Field Name / Entry Information1 / 01-01 / 1 / “6” / Record Type Code / Code for the Entry Detail Record is “6”
2 / 02-03 / 2 / Numeric / Transaction Code / The Transaction Code is the value you sent less 1, except for pre-notifications which are less 2. Return and NOC value codes are: 21, 26, 31 or 36.
3 / 04-11 / 8 / TTTTAAAA / RDFI Transit Routing/ABA Number / First eight digits of the transit Routing/ABA number.
4 / 12-12 / 1 / Numeric / Transit Routing Check Digit / The ninth character in the Transit Routing/ABA number, of the Routing Number above.
5 / 13-29 / 17 / Alphanumeric / DFI Account Number / Account Number
6 / 30-39 / 10 / $$$$$$$$¢¢ / Amount / Entry amount in dollars with two decimal places. Amount will be 10 zeros for non-dollar pre-notification entries
7 / 40-54 / 15 / Alphanumeric / Individual Identification Number/Check Serial Number / Taxpayer ID, for individuals it is the SSN.
8 / 55-76 / 22 / Alphanumeric / Individual Name/ Receiving Company Name / Name of Receiver, left justified.
9 / 77-78 / 2 / Alphanumeric / Reserved / This field is blank
10 / 79-79 / 1 / Numeric / Addenda Record Indicator / “0” = No addenda supplied.
11 / 80-94 / 15 / Numeric / Trace Number / ‘061’ concatenated with serial number. E.g. ‘061000050000001’
Interface 4: Batch Control Record
The Company/Batch Control Record concludes the batch and contains the dollar totals for the Entry Detail Records in the batch and item count for Entry Detail and Addenda records in the batch.
Field / Position / Size / Contents / Field Name / Entry Information1 / 01-01 / 1 / “8” / Record Type Code / Code identifying the Company/ Batch Header Record is “8”
2 / 02-04 / 3 / “200”, / Service Class Code / Identifies the type of entries in the batch.
3 / 05-10 / 6 / Numeric / Entry/
Addenda Count / Total number of Entry Detail Records (Record Type “6”) and Addenda Records (Record Type “7”) in the batch. Requires 6 positions, right-justified, left zero-filled.
4 / 11-20 / 10 / Numeric / Entry Hash / Total of eight-character Transit Routing/ABA numbers in the batch (field 3 of the Entry Detail Record) without including the Transit Routing Check Digit. This value is the ten low-order (right most) digits of this number.
5 / 21-32 / 12 / $$$$$$$$$$¢¢ / Total Debit Entry Dollar Amount in Batch / Dollar total of debit entries in the batch. If none, the field is zero-filled. It is right justified, left zero-filled without a decimal.
6 / 33-44 / 12 / $$$$$$$$$$¢¢ / Total Credit Entry Dollar Amount in Batch / Dollar total of credit entries in the batch. If none, zero-fill the field. It is right justified, left zero-filled without a decimal.
7 / 45-54 / 10 / NNNNNNNNNN / Company Identification / ‘1586002015’
8 / 55-73 / 19 / Alphanumeric / Reserved / This field left blank.
9 / 74-79 / 6 / Alphanumeric / Reserved / This field left blank.
10 / 80-87 / 8 / NNNNNNNN / Originating DFI Identification / ‘06100005’
11 / 88-94 / 7 / Numeric / Batch Number / Number of the batch for which this is a control record. Will equal Field 13 of the Company/Batch Header Record and will be sequential.
File Control Record
Field / Position / Size / Contents / Field Name / Entry Information1 / 01-01 / 1 / “9” / Record Type Code / Code identifying the File Control Record is “9”
2 / 02-07 / 6 / “000001” / Batch Count / Total number of Company/Batch Header Records (Record Type “5”) in the file.
3 / 08-13 / 6 / Numeric / Block Count / Total number of physical blocks in the file, including the File Header and File Control Records.
4 / 14-21 / 8 / Numeric / Entry/ Addenda Count / Total number of Entry Detail Records and Addenda Records (Record Type “6” and “7”) in the file.
5 / 22-31 / 10 / Numeric / Entry Hash / Total of eight character Transit Routing/ABA numbers in the file (Field 3 of the Entry Detail Record) without the Transit Routing Check Digit. This value is the 10 low-order (right most) digits of this number.
6 / 32-43 / 12 / $$$$$$$$$$¢¢ / Total Debit Entry Dollar Amount in File / ‘0’
7 / 44-55 / 12 / $$$$$$$$$$¢¢ / Total Credit Entry Dollar Amount in File / Dollar total of credit entries in the file, right-justified, left zero-filled with no decimal point. If none, the field will be zero-filled.
8 / 56-94 / 39 / Blank / Reserved / Leave this field blank.
Interface 5: Electronic (ACH) Refund
Name / Variable Type / Description / Length / FormatCreation Date / Date / Date file was created / 8 / mmddyyyy
EX: July 8th, 2011 as "07082011"
Requisition Number / String / Number assigned to file to associate refunds with AP in finance / 10 / Right Justified, Space-Filled
EX:" 1234567"
Refund Count Total / Number / Total number of refund records within file / 6 / Right Justified, Zero-Filled
EX: "000153", "025000"
Refund Amount Total / Decimal / Total amount of all refund records within file / 12 / ##########, implied decimal point for the last two digits, left-filled with zeroes
EX: $30,080,150.23 as "003008015023"
Interface 6: Initial Refund Batch Creation
Frequency
Must be processed any time that refund batching is processed. Currently, this is a daily ITS (Integrated Tax Solution) process and twice a week process in legacy (Mainframe Systems). A Bank should be able to handle daily processing of this file.
Header Record
Name / Variable Type / Description / Length / FormatCreation Date / Date / Date file was created / 8 / mmddyyyy
EX: July 8th, 2011 as "07082011"
Requisition Number / String / Number assigned to the file to associate refunds with AP in finance / 10 / Right Justified, Space-Filled
EX:" 1234567"
Refund Count Total / Number / Total number of refund records within file / 6 / Right Justified, Zero-Filled
EX: "000153", "025000"
Refund Amount Total / Decimal / Total amount of all refund records within file / 12 / ##########, implied decimal point for the last two digits, left-filled with zeroes
EX: $30,080,150.23 as "003008015023"
Details Records
Name / Variable Type / Description / Length / FormatRefund ID / String / Unique identifier for refund / 12 / Left-Justified, space-filled
EX: "R12345678910", "R51231 "
Primary Taxpayer ID / String / SSN of prime taxpayer / 9 / EX: "555123456"
Tax Year / String / Tax Year of Refund / 4 / EX: "2010", "2012"
Issue Date / Date / The date the refund is being issued / 8 / mmddyyyy
EX: July 8th, 2011 as "07082011"
Amount / Decimal / The amount of the refund / 10 / ##########, implied decimal point for the last two digits, left-filled with zeroes
EX: $20,150.19 as "0002015019"
Joint Indicator / String / Indicates whether the refund is single or joint / 1 / S' for single, 'J' for joint
Primary Taxpayer First Name / String / First name of primary taxpayer / 20 / Left-justified, space-filled
EX: "Jim ", "Hillary "
Primary Taxpayer Last Name / String / Last name of primary taxpayer / 20 / Left-justified, space-filled
EX: "Jackson ", "Smith "
Street 1 - Address / String / First line of street address / 35 / Left-justified, space-filled
EX: "123 Fake Street "
Street 2 - Address / String / Second line of street address / 35 / Left-justified, space-filled
EX: "Apartment #C "
City - Address / String / City part of address / 35 / Left-justified, space-filled
EX: "New York City "
State - Address / String / 2-digit State Identifier for address / 2 / EX: "GA", "CA"
Zip - Address / String / Zip Code for address / 9 / Left-justified, space-filled, may be 5 or 9 digit USPS zip
EX: "30345 ", "305441296"
Attention - Address / String / Optional attention line for mailing address / 35 / Left-justified, space-filled,
EX: "C/O Jim Taxpayer ", "Estate of Jill Taxpayer "
Joint Taxpayer ID / String / SSN of joint taxpayer / 9 / Empty for single refunds
EX: "555123456", " "
Joint Taxpayer First Name / String / First name of joint taxpayer / 20 / Left-justified, space-filled, empty for single refunds
EX: "Jim ", "Hillary ", " "
Joint Taxpayer Last Name / String / Last name of joint taxpayer / 20 / Left-justified, space-filled, empty for single refunds
EX: "Jackson ", "Smith ", " "
Additional Notes
This file would be used to generate the stored value cards. The DOR Finance Office will receive a requisition report when this file is created with the total amount of the refunds requested. The funds would need to be transferred to the Bank to cover the refunds. There would not be any additional files generated by DOR as part of the issuance process – the Bank would be expected to distribute the funds provided by DOR to the debit card accounts in the amounts provided on this file.
Interface 7: Refund Batch Response
Purpose
Allows ITS to update internal records with the debit card number assigned by the Bank for each refund issued. Could also be used for exception processing if a stored value/debit card was not issued for some reason.
Header Record