Appendix C to Part 360 - Deposit File Structure

Appendix C to Part 360 - Deposit File Structure

This is the structure for the data file to provide deposit data to the FDIC. 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 deposit file type and the date of the extract. The files will be encrypted using an FDIC-supplied algorithm. The FDIC will transmit to the covered institution the encryption algorithm over FDICconnect.

The total deposit balances and the number of deposit accounts in each deposit file must be reconciled to the subsidiary system control totals.

The FDIC intends to fully utilize a covered institution's understanding of its customers and the data maintained around deposit accounts. Should additional information be available to the covered institution to help the FDIC more quickly complete its insurance determination process, it may add this information to the end of this data file. Should additional data elements be provided, a complete data dictionary for these elements must be supplied along with a description of how this information could be best used to establish account ownership or insurance category.

The deposit data elements provide information specific to deposit account balances and account data. The sequencing of these elements, their physical data structures and the field data format and field length must be provided to the FDIC along with the data structures identified below.

A header record will also be required at the beginning of this file. This record will contain the number of accounts to be included in this file, the maximum number of characters contained in largest account title field maintained within the deposit file and the maximum number of characters contained in largest address field maintained within the deposit file.

Note:

Each record must contain the account title/name and current account statement mailing address. Fields 17-33 relate to the account name and address information. Some systems provide for separate fields for account title/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. Populate fields that best fit the system's data, either fields 17-27 or fields 28-33.

Field name	Field description	Comments	Format
1. DP__Acct__Identifier	Account Identifier The primary field used to identify the account. This field may be the Account Number.	The Account Identifier may be composed of more than one physical data element. If multiple fields are required to identify the account, data should be placed in separate fields and the FDIC instructed how these fields are combined to uniquely identify the account.	Character (25).
2. DP__Acct__Identifier - 2	Account Identifier - 2 If necessary, the second element used to identify the account.		Character (25).
3. DP__Acct__Identifier - 3	Account Identifier - 3 If necessary, the third element used to identify the account.		Character (25).
4. DP__Acct__Identifier - 4	Account Identifier - 4 If necessary, the fourth element used to identify the account.		Character (25).
5. DP__Acct__Identifier - 5	Account Identifier - 5 If necessary, the fifth element used to identify the account.		Character (25).
6. DP__Sub__Acct__Identifier	Sub-Account Identifier If available, the sub-account identifier for the account.	The Sub-Account Identifier may identify separate deposits tied to this account where there are different processing parameters such as interest rates or maturity dates, but all owners are the same.	Character (25).
7. DP__Bank__No	Bank Number The bank number assigned to the deposit account.		Character (15).
8. DP__Tax__ID	Tax ID The tax identification number maintained on the account.	For consumer accounts, typically, this would be the primary account holder's social security number (“SSN”). For business accounts it would be the federal tax identification number (“TIN”). Hyphens are optional in this field.	Character (15).
9. DP__Tax__Code	Tax ID Code The type of the tax identification number. Possible values are: • S = Social Security Number. • T = Federal Tax Identification Number. • O = Other.	Generally deposit systems have flags or indicators set to indicate whether the number is an SSN or TIN.	Character (1).
10. DP__Branch	Branch Number The branch or office associated with the account.	In lieu of a branch number this field may represent a specialty department or division.	Character (15).
11. DP__Cost__Center	Cost Center or G/L Code The identifier used for organization reporting or ownership of the account. Insert null value if the cost center is not carried in the deposit record.	This field ties to the general ledger accounts.	Character (20).
12. DP__Dep__Type	Deposit Type Indicator The type of deposit by office location. Possible values are: • D = Deposit (Domestic). • F = Foreign Deposit.	A deposit - also called a “domestic deposit” - includes only deposit liabilities payable in the United States, typically those deposits maintained in a domestic office of an insured depository institution, as defined in section 3(l) of the Federal Deposit Insurance Act (12 U.S.C. 1813(l)). A foreign deposit is a deposit liability in a foreign branch payable solely at a foreign branch or branches.	Character (1).
13. DP__Currency__Type	Currency Type The ISO 4217 currency code.		Character (3).
14. DP__Ownership__Ind	Customer Ownership Indicator The type of ownership at the account level. Possible values are: • S = Single. • J = Joint Account. • P = Partnership account. • C = Corporation. • B = Brokered Deposits. • I = IRA Accounts. • U = Unincorporated Association. • R = Revocable Trust. • IR = Irrevocable Trust. • G = Government Accounts. • E = Employee Benefit Plan Accounts. • O = Other.	Single: Accounts owned by an individual and those accounts held as Minor Accounts, Estate Accounts, Non-Minor Custodian/Guardian Accounts, Attorney in Fact Accounts and Sole Proprietorships Joint Account: Accounts owned by two or more individuals, but does not include the ownership of a Payable on Death Account or Trust Account. Partnership Account: Accounts owned by a Partnership Corporation: Accounts owned by a Corporation (e.g. Inc., L.L.C., or P.C.). Brokered Deposits: Accounts placed by a deposit broker who acts as an intermediary for the actual owner or sub-broker. IRA Accounts: Accounts for which the owner has the right to direct how the funds are invested including Keoghs and other Self-Directed Retirement Accounts.	Character (2).
		Unincorporated Association: An account owned by an association of two or more persons formed for some religious, educational, charitable, social or other non-commercial purpose.
		Revocable Trusts: Including PODs and formal revocable trusts (e.g. Living Trusts, Intervivos Trusts or Family Trusts).
		Irrevocable Trusts: Accounts held by a trust established by statute or written trust in which the grantor relinquishes all power to revoke the trust.
		Government Accounts: Accounts owned by a government entity (e.g. City, State, County or Federal government entities and their sub-divisions).
		Employee Benefit Plan: Accounts established by the administrator of an Employee Benefit Plan including defined contribution, defined benefit and employee welfare plans.
		Other Accounts: Accounts owned by an entity not described above.
15. DP__Prod__Cat	Product Category The product classification. Possible values are:	Product Category is sometimes referred to as “application type” or “system type”.	Character (3).
	• DDA = Non-Interest Bearing Checking accounts.
	• NOW = Interest Bearing Checking accounts.
	• MMA = Money Market Deposit Accounts.
	• SAV = Other savings accounts.
	• CDS = Time Deposit accounts and Certificate of Deposit accounts, including any accounts with specified maturity dates that may or may not be renewable.
16. DP__Stat__Code	Status Code Status or condition of the account. Possible values are:		Character (1).
	• O = Open.
	• D = Dormant.
	• I = Inactive.
	• E = Escheatment.
	• A = Abandoned.
	• C = Closing.
	• R = Restricted/Frozen/Blocked.
17. DP__Acct__Title - 1	Account Title Line 1 Account styling or titling of the account.	These data will be used to identify the owners and beneficiaries of the account.	Character (100).
18. DP__Acct__Title - 2	Account Title Line 2 If available, the second account title line.		Character (100).
19. DP__Acct__Title - 3	Account Title Line 3 If available, the third account title line.		Character (100).
20. DP__Acct__Title - 4	Account Title Line 4 If available, the fourth account title line.		Character (100).
21. DP__Street__Add__Ln - 1	Street Address Line 1 The current account statement mailing address of record.		Character (100).
22. DP__Street__Add__Ln - 2	Street Address Line 2 If available, the second mailing address line.		Character (100).
23. DP__Street__Add__Ln - 3	Street Address Line 3 If available, the third mailing address line.		Character (100).
24. DP__City	City The city associated with the mailing address.		Character (50).
25. DP__State	State The state abbreviation associated with the mailing address.	Use a two-character state code (official U.S. Postal Service abbreviations).	Character (2).
26. DP__ZIP	ZIP The ZIP + 4 code associated with the mailing address.	If the “ + 4” code is not available provide only the 5-digit ZIP code. Hyphens are optional in this field.	Character (10).
27. DP__Country	Country The country associated with the mailing address.	Provide the country name or the standard IRS country code.	Character (10).
28. DP__NA__Line - 1	Name/Address Line 1 Alternate name/address format for the current account statement mailing address of record, first line.	Fields 28-33 are to be used if address data are not parsed to populate Fields 17-27.	Character (100).
29. DP__NA__Line - 2	Name/Address Line 2 Alternate name/address format, second line.		Character (100).
30. DP__NA__Line - 3	Name/Address Line 3 Alternate name/address format, third line.		Character (100).
31. DP__NA__Line - 4	Name/Address Line 4 Alternate name/address format, fourth line.		Character (100).
32. DP__NA__Line - 5	Name/Address Line 5 Alternate name/address format, fifth line.		Character (100).
33. DP__NA__Line - 6	Name/Address Line 6 Alternate name/address format, sixth line.		Character (100).
34. DP__Cur__Bal	Current Balance The current balance in the account at the end of business on the effective date of this file.	This balance should not be reduced by float or holds. For CDs and time deposits, the balance should reflect the principal balance plus any interest paid and available for withdrawal not already included in the principal (do not include accrued interest). The total of all current balances in this file should reconcile to the total deposit trial balance totals or other summary reconciliation of deposits performed by the institution.	Decimal (14,2).
35. DP__Int__Rate	Interest Rate The current interest rate in effect for interest bearing accounts.	Interest rate should be expressed in decimal format, i.e., 2.0% should be represented as 0.020000000.	Decimal (10,9).
36. DP__Acc__Int	Accrued Interest The amount of interest that has been earned but not yet paid to the account as of the date of the file.		Decimal (14,2).
37. DP__Lst__Int__Pd	Date Last Interest Paid The date through which interest was last paid to the account.		Date (YYYYMMDD).
38. DP__Lst__Deposit	Date Last Deposit The date of the last deposit transaction posted to the account.	For example, a deposit that included checks and/or cash.	Date (YYYYMMDD).
39. DP__Int__Term__No	Interest Term Number The number of months in the current interest term.		Decimal (3,0).
40. DP__Nxt__Mat	Date of Next Maturity For CD and time deposit accounts, the next date the account is to mature.	For non-renewing CDs that have matured and are waiting to be redeemed this date may be in the past.	Date (YYYYMMDD).
41. DP__Open__DT	Account Open Date The date the account was opened.	If the account had previously been closed and re-opened, this should reflect the most recent re-opened date.	Date (YYYYMMDD).
42. DP__Sweep__Code	Sweep Code		Character (1).
	Indicates if the account is a sweep account. Possible values are:
	• Y = Yes.
	• N = No.
43. DP__Hold__To__Post	Full Hold on the account: Indicator if all postings to this account are restricted. Possible values are:		Character (1).
	• Y = Yes.
	• N = No.
44. DP__Issue__Val__Amt	Issued Value Amount The value of the current CD when issued.	For CDs only.	Decimal (14,2).
45. DP__Int__CD__Cde	Type of Interest for CD	For CDs only.	Character (1).
	Possible values are:
	• C = Rate Change Allowed.
	• N = Rate Change Not Allowed.
	• R = Change Rate to Default at Renewal.
	• T = Rate Change Allowed Only During the Term.
46. DP__IRA__Cde	IRA Code The type of IRA. Possible values are: • C = Corporate Retirement • E = Educational IRA. • I = IRA Account. • K = Keogh Account. • R = Roth IRA Account. • S = SEP Account. • T = Transitional Roth IRA. • V = Versa Account. • H = Health Savings Account.	Optional code field to be used if available to help further identify the types of IRA accounts.	Character (1).
47. DP__Deposit__Class__Type	Deposit Class Type The deposit class. Possible values are:	The institution may also use more or fewer class types.	Character (10).
	• RTL = Retail.
	• FED = Federal government.
	• STATE = State government.
	• COMM = Commercial.
	• CORP = Corporate.
	• BANK = Bank Owned.
	• DUE TO = Other Banks.
48. DP__Product__Class__Cde	Deposit Class Codes The deposit class codes. Possible values are: RTL • 1 = Payable on Death. • 2 = Individual. • 3 = Living Trust - Intervivos or Family. • 4 = Irrevocable Trust (includes Educational IRAs). • 5 = Estate. • 6 = Attorney in Fact. • 7 = Minor - (includes all variations of Uniform Gifts to Minor Accounts). • 8 = Bankruptcy Personal. • 9 = Pre-Need Burial. • 10 = Escrow. • 11 = Representative Payee/Beneficiary. • 12 = Sole Proprietorship. • 13 = Joint. • 14 = Non-Minor Custodian/Guardian. • 15 = Other Retail.	These Product Class codes are used in conjunction with the Deposit Class Types in field 51. This field is to be used in concert with fields 12 and 13 identified above to enable the financial institution to capture more detailed information concerning account types. It is the intent of the FDIC to have the financial institution map its detailed account types to the codes identified in this field. The institution may also use additional codes, but in this event the institution must supply the detailed description and code value for each additional code used. If no additional account product type detail is available then this field should be left blank.	Character (2).
	FED • 16 = FHA. • 17 = Federal Government. STATE • 18 = City. • 19 = State. • 20 = County, Clerk of Court. • 21 = Other State. COMMERCIAL • 22 = Business Escrow. • 23 = Bankruptcy. • 24 = Club. • 25 = Church. • 26 = Unincorporated Association. • 27 = Unincorporated Non-Profit. • • 28 = Other Commercial. CORPORATION • 29 = Business Trust. • 30 = Business Agent. • 31 = Business Guardian. • 32 = Incorporated Association. • 33 = Incorporated Non-Profit. • 33 = Incorporated Non-Profit. • 34 = Corporation. • 35 = Corporate Partnership. • 36 = Corporate Partnership Trust. • 37 = Corporate Agent. • 38 = Corporate Guardian. • 39 = Pre-Need Funeral Trust. • 40 = Limited Liability Incorporation. • 41 = LLC partnership. • 42 = Lawyer Trust. • 43 = Realtor Trust. • 44 = Other Corporation. BANK • 45 = Certified & Official Checks, Money Orders, Loan Disbursements Checks, and Expense Checks. • 46 = ATM Settlement. • 47 = Other Bank Owned Accounts. DUE TO (Other Banks) • 48 = Due to U.S. Banks. • 49 = Due to U.S. Branches of Foreign Banks. • 50 = Due to Other Depository Institutions. • 51 = Due to Foreign Banks. • 52 = Due to Foreign Branches of U.S. banks. • 53 = Due to Foreign Governments and Official Institutions.

[73 FR 41197, July 17, 2008]