Chat with an FTB Representative

Method 2 Inquiry File - To Be Matched Against Financial Institution Accounts

This is the record layout for the Inquiry File (list of child support debtors) provided by FTB to be matched against accounts held by financial institutions.

The FTB Inquiry File must be matched against all open accounts maintained by the institution and all account owners, including secondary owners. Note that institutions must match this file against accounts not normally considered for 1099 Reporting, including non-interest bearing accounts and accounts earning less than $10 of interest or dividends.

Inquiry Files contain only 3 kinds of records:

"D" A Record identifying the year and month the file was created by FTB.
"I" The basic inquiry record, identifying the person to be matched.
"T" The total record showing the number of inquiry records on this file.

All records will have a length of 9 characters and will be blocked in groups of 100 records. These records are further defined below:

Inquiry File "D" Record

Position Size Description Comments/Format

001 1 Record Type Constant "D"
002-007 6 Year and Month File Generated CCYYMM
008 1 Data Match File Indicator Constant "M"
009-099 91 Blanks  

 

Position Size Description
001 1 Record Year
Enter "D"
002-007 6 Year and Month Generated
Enter the year and month (century format) that the Inquiry File was generated. For example, July of 2007 would be entered as 200707.

Inquiry File "I" Record

Position Size Description Comments/Format

001 1 Record Type Constant "I"  
002-010 9 Inquiry Social Security Number  
011-020 10 State Pass-Back Information  
021-040 20 Inquiry Last Name  
041-056 16 Inquiry First Name  
057-071 15 Case Pass-Back Information  
072-076 5 FIPS Code Pass-Back Information  
077-099 23 Additional State Pass-Back Information  

 

Position Size Description
001 1 Record Type
Enter "I"
002-010 9 Inquiry Social Security Number (SSN)
This field contains the SSN of the person to be matched. A match is to be reported by the financial institution for each account that is owned by someone with the same SSN entered here. It is possible that a single SSN will appear more than once on the Inquiry File. These multiple entries will be differentiated by Case Pass-Back Information entered in positions 057-071 of this "I" Record. If a match occurs, the account information should be submitted as a separate "B" Record on the financial institution's Match File for each time the individual SSN (and Case Pass-Back Information) appears on the FTB Inquiry File.
011-020 10 State Pass-Back Information
This field is a 10-digit alphanumeric entry (may be blank) which has significance to FTB in its administration of the Data Match System. This information must be passed back to FTB if a match is found. If this field is blank, blanks are passed back on the financial institution's Match File "B" Record.
021-040 20 Inquiry Last Name
This is the last name of the person whose SSN is entered in positions 002-010 of this "I" Record. This field is left-justified and unused positions are filled with blanks. If there is more than one "I" Record with the same SSN in the Inquiry File, the multiple records are distinguished by the Case Pass-Back Information in positions 057-071 for CA matching purposes. Matches identified by a financial institution for a corresponding SSN should be reported by the financial institution even if the name in the financial institution's record does not match the inquiry record.
041-056 16 Inquiry First Name.
This is the first name of the person whose SSN is entered in positions 002-010 of this "I" Record. The field is left-justified and any unused positions are filled with blanks.
057-071 15 Case Pass-Back Information
This 18-digit alphanumeric field (may be blank) has significance to FTB for its child support case administration. This field must be passed back to FTB if a match is found. If this field is blank, blanks are passed-back on the financial institution's Match File "B" Record.
072-076 5 FIPS Code Pass-Back Information
This field is a 5-digit alphanumeric field that contains the FIPS code of the state that is inquiring about the SSN. This information must be passed back to the state if a match is found. This code is used to determine which state will receive the match account information of Multistate financial institutions. The code for California is 06.

Method 2 Inquiry File "T" Record

Position Size Description Comments/Format

001 1 Record Type Constant "T"
002-011 10 Number of Inquiry Records on this file Numeric
012-099 88 Blank  

The Inquiry File contains highly confidential data. Do not write over or add files to the Inquiry File. All Method 2 filers are to return the Inquiry File to FTB either with their Data Match File or separately.