Title 12

PART 360 APPENDIX F

Appendix F to Part 360 - Customer File Structure

12:6.0.1.1.11.0.1.12.9 : Appendix F

Appendix F to Part 360 - Customer File Structure

This is the structure of the data file to provide to the FDIC information related to each customer who has an account or sub-account reported in the deposit data or sweep/automated credit account file. If data or information are not maintained or do not apply, a null value in the appropriate field should be indicated. The file will be in a tab-or pipe-delimited ASCII format. Each file name will contain the institution's FDIC Certificate Number, an indication that it is a customer file type and the date of the extract. The files will be encrypted using an FDIC-supplied algorithm. The FDIC will transmit the encryption algorithm over FDICconnect.

Note:

Each record must contain the customer's name and permanent legal address. Fields 4-12 relate to the customer name for individuals only. Fields 13-14 relate to the customer name for entities other than individuals. Some systems provide for separate fields for name, street address, city, state, ZIP, and country, all of which are parsed out. Others systems may simply provide multiple lines for name, street address, city, state, ZIP, with no distinction. In this case, certain name and address data elements must be parsed and provided in the appropriate fields.

Field name	Field description	Comments	Format
1. CS_Cust_Identifier	Customer Identifier		Character (25).
	The unique field used by the institution to identify the customer
2. CS_Tax_ID	Customer Tax ID Number	Hyphens are optional in this field	Character (11).
	The tax identification number on record for the customer
3. CS_Tax_Code	Customer Tax ID Code		Character (1).
	The type of the tax identification number of the customer. Possible values are:
	• S = Social Security Number
	• T = Federal Tax Identification Number
	• O = Other
4. CS_Name_Line - 1	Individual Customer Name Line 1		Character (100).
	If available, the free-form name narrative of the customer, first line
5. CS_Name_Line - 2	Individual Customer Name Line 2		Character (100).
	If available, the free-form name narrative of the customer, second line.
6. CS_Last_Name	Individual Customer Last Name For individuals, the customer's last name.	This field is required if the data element is in the institution's records. If necessary, data should be parsed from fields 4 or 5 to obtain this element	Character (50).
7. CS_First_Name	Individual Customer First Name For individuals, the customer's first name.	This field is required if the data element is in the institution's records. If necessary, data should be parsed from fields 4 or 5 to obtain this element	Character (50).
8. CS_Middle_Name	Individual Customer Middle Name For individuals, the customer's middle name.	This field is required if the data element is in the institution's records. If necessary, data should be parsed from fields 4 or 5 to obtain this element	Character (50).
9. CS_Suffix	Individual Professional Suffix For individuals, the suffix designating customer's academic, professional or honorary status, such as Esq., Ph.D., M.D., and D.D.S.	This field is required if the data element is in the institution's records. If necessary, data should be parsed from fields 4 or 5 to obtain this element	Character (20).
10. CS_Generation	Individual Generational Suffix For individuals, the suffix designating the customer's generational status, such as Jr., Sr. or III.	This field is required if the data element is in the institution's records. If necessary, data should be parsed from fields 4 or 5 to obtain this element	Character (10).
11. CS_Prefix	Individual Customer Prefix For individuals, the prefix of the customer, such as Rev., Dr., Mrs., Mr. or Ms.	This field is required if the data element is in the institution's records. If necessary, data should be parsed from fields 4 or 5 to obtain this element	Character (10).
12. CS_Birth_Dt	Individual Customer Birth Date		Date (YYYYMMDD).
	For individuals, the customer's birth date
13. CS_Ent_Name_Line - 1	Entity Name Line 1		Character (100).
	For entities other than individuals, the free-form name narrative of the customer, first line
14. CS_Ent_Name_Line - 2	Entity Name Line 2		Character (100).
	If available for entities other than individuals, the free-form name narrative of the customer, second line
15. CS_Nar_Addr_Line - 1	Customer Address Line 1		Character (100).
	If available, the free-form permanent legal address narrative for the customer, line one
16. CS_Nar_Addr_Line - 2	Customer Address Line 2		Character (100).
	If available, the free-form permanent legal address narrative of the customer, line two
17. CS_Nar_Addr_Line - 3	Customer Address Line 3		Character (100).
	If available, the free-form permanent legal address narrative of the customer, line three
18. CS_Street_Address - 1	Street Address Line 1 The permanent legal address of the customer, line one.	This field is required. If necessary, data should be parsed from fields 16 or 17 to obtain this element	Character (100).
19. CS_Street_Address - 2	Street Address Line 2 The permanent legal address of the customer, line two.	This field is required. If necessary, data should be parsed from fields 16 or 17 to obtain this element	Character (100).
20. CS_City	City The city associated with the permanent legal address.	This field is required. If necessary, data should be parsed from fields 16 or 17 to obtain this element	Character (25).
21. CS_State	State The state abbreviation associated with the permanent legal address.	This field is required. If necessary, data should be parsed from fields 16 or 17 to obtain this element. Use a two-character state code (official U.S. Postal Service abbreviations)	Character (2).
22. CS_ZIP	ZIP The ZIP + 4 code associated with the permanent legal address.	This field is required. If necessary, data should be parsed from fields 16 or 17 to obtain this element. If the “ + 4” code is not available, provide only the 5-digit ZIP code. Hyphens are optional in this field	Character (10).
23. CS_Country	Country The country associated with the permanent legal address.	This field is required. If necessary, data should be parsed from fields 16 or 17 to obtain this element. Provide the name of the country or the standard IRS country code	Character (10).
24. CS_Telephone	Customer Telephone Number		Character (20).
	The telephone number on record for the customer
25. CS_Email	Customer Email Address		Character (150).
	The e-mail address on record for the customer