TCC-02-06a.htm, Supplement to Financial Data Match Specifications Handbook

Giving Hope and Support to America's Children

Supplement to Financial Data Match Specifications Handbook

Listed below are common format errors on MSFI Response Files:

The first record of the Response File must be the 'A' Record. It is necessary for every Response File to contain at least one 'A' Record.
Ensure that the record type = 'A', 'B' or 'T'

Listed below are common errors on the A Record:

Position 007-015--Institution TIN (FEIN)

Provide your institution's TIN (FEIN)

Position 032--Test/Corr Indicator

Provide a valid test/corr indicator

Position 050-089--Institution Name

Provide your financial institution's name

Position 131-210--Institution Street Address

Provide your financial institution's full address; Street, City, State and Zip Code

Position 211-219--Reporting Agent/Transmitter TIN (FEIN)

Provide a valid Transmitter TIN (FEIN). MSFI must always provide a

transmitter TIN even if the MSFI is transmitting for itself.

Position 371--Data Match File Indicator

Provide Data Match Indicator 'M'

Listed below are common errors on the B Record:

Position 015-023--Matched SSN

Enter a numeric SSN. The SSN entered should be the one matched from the Inquiry File.

Position 162-201--Matched Name

Enter the name on the account from the financial institution account records.

Note: Do NOT return the name that was sent to you on the Inquiry File.

Position 322-326--FIPS Code Pass-Back Information

Insert the two-letter abbreviation of the state where the account is located.

Note: Do NOT enter the state where the account holder resides.

Position 327-349--Additional State Pass-Back Information

You may leave this field blank.

Position 351-357--Account Balance

Enter the whole dollar amount that is in the account. Do NOT include decimals. If the balance is $0 or less, provide 0s in the field.

Position 358--Match Flag

Provide a valid match flag indicator:

Enter a '0' if the institution did not attempt to match the last name from the Inquiry file to the name on the account.

Enter a '1' if the first four letters of the last name on the account and the first four letters of the last name on the Inquiry File are the same.

Enter a '2' if the first four letter of the last name on the account and the first four letters of the last name on the Inquiry file are not the same.

Position 360--Closed Account Indicator

New field introduced at the request of both states and MSFIs. By populating this field, MSFIs will reduce the number of freeze & seize actions on closed accounts.

Enter '0' if the account is open.

Enter '1' if the account is closed.

Position 361--Account Balance Indicator

Enter a valid account balance indicator:

Enter '0' if the account balance (to be entered in positions 351-357) is not provided.

Enter '1' if the balance reported in positions 351-357 is the average balance on the account.

Enter '2' if the balance reported in positions 351-357 is the current balance (as of the date the response record is created).

Position 371-380--State Pass-Back Information

You may leave this field blank.

Position 381-382--Account Type

To avoid receiving invalid freeze & seize requests from states, please ensure the accuracy of the account type information.

Position 383-397--Case Pass-Back

You may leave this field blank.

Position 401--Payee Indicator

Enter a valid payee indicator:

Enter '0' if the SSN matched from the Inquiry File is the sole or only owner of the account.

Enter '1' if the matched SSN from the Inquiry File is the secondary owner of the account.

Enter '2' if the matched SSN from the Inquiry File is the primary owner of the account, but there are secondary owners of the same account.

T Record Alert

Position 002-011--Number of Inquiry Records on this File

Provide the total number of records reported by the MSFI in whole numbers.

Download FREE Adobe Acrobat® Reader™ to view PDF files located on this site.