12 CFR Appendix B to Part 370 - Output Files Structure

Appendix B to Part 370 - Output Files Structure

These output files will include the data necessary for the FDIC to determine deposit insurance coverage in a resolution. A covered institution's information technology system must have the capability to prepare and maintain the files detailed below. These files must be prepared in successive iterations as the FDIC receives additional data from external sources necessary to complete the deposit insurance determinations, and, as it updates pending determinations. The files will be comprised of the following four tables. The unique identifier and government identification are required in all four tables so those tables can be linked where necessary.

A null value, as indicated in the table below, is allowed for fields that are not immediately needed to calculate deposit insurance. To ensure timely calculations for depositor liquidity purposes, the information with null-value designations can be obtained after the initial deposit insurance calculation. As due diligence for recordkeeping progresses throughout the years of ongoing compliance, the FDIC expects that the banks will continue efforts to capture the null-value designations and populate the output file to alleviate the burden at failure. If a null value is allowed in a field, the record should not be placed in the pending file.

These files must be prepared in successive iterations as the covered institution receives additional data from external sources necessary to complete any pending deposit insurance calculations. The unique identifier is required in all four files to link the customer information. All files are pipe delimited. Do not pad leading and trailing spacing or zeros for the data fields.

Customer File. Customer File will be used by the FDIC to identify the customers. One record represents one unique customer.

The data elements will include:

Field name Description Format Null value
allowed?
1. CS_Unique_ID This field is the unique identifier that is the primary key for the depositor data record. It will be generated by the covered institution and there shall not be duplicates Variable Character No.
2. CS_Govt_ID This field shall contain the ID number that identifies the entity based on a government issued ID or corporate filling. Populate as follows: Variable Character No.
- For a United States individual - SSN or TIN
- For a foreign national individual - where a SSN or TIN does not exist, a foreign passport or other legal identification number (e.g., Alien Card)
- For a Non-Individual - the Tax identification Number (TIN), or other register entity number
3. CS_Govt_ID_Type The valid customer identification types are: Character (3) No.
- SSN - Social Security Number
- TIN - Tax Identification Number
- DL - Driver's License, issued by a State or Territory of the United States
- ML - Military ID
- PPT - Valid Passport
- AID - Alien Identification Card
- OTH - Other
4. CS_Type The customer type field indicates the type of entity the customer is at the covered institution. The valid values are: Character (3) Yes.
- IND - Individual
- BUS - Business
- TRT - Trust
- NFP - Non-Profit
- GOV - Government
- OTH - Other
5. CS_First_Name Customer first name. Use only for the name of individuals and the primary contact for entity Variable Character No.
6. CS_Middle_Name Customer middle name. Use only for the name of individuals and the primary contact for entity Variable Character Yes.
7. CS_Last_Name Customer last name. Use only for the name of individuals and the primary contact for entity Variable Character No.
8. CS_Name_Suffix Customer suffix Variable Character Yes.
9. CS_Entity_Name The registered name of the entity. Do not use this field if the customer is an individual Variable Character Yes.
10. CS_Street_Add_Ln1 Street address line 1. The current account statement mailing address of record Variable Character Yes.
11. CS_Street_Add_Ln2 Street address line 2. If available, the second address line Variable Character Yes.
12. CS_Street_Add_Ln3 Street address line 3. If available, the third address line Variable Character Yes.
13. CS_City The city associated with the mailing address Variable Character Yes.
14. CS_State The state for United States addresses or state/province/county for international addresses Variable Character Yes.
- For United States addresses use a two-character state code (official United States Postal Service abbreviations) associated with the mailing address.
- For international address follow that country state code.
15. CS_ZIP The Zip/Postal Code associated with the customer's mailing address Variable Character Yes.
- For United States zip codes, use the United States Postal Service ZIP+4 standard
- For international zip codes follow that standard format of that country.
16. CS_Country The country associated with the mailing address. Provide the country name or the standard International Organization for Standardization (ISO) country code Variable Character Yes.
17. CS_Telephone Customer telephone number. The telephone number on record for the customer, including the country code if not within the United States Variable Character Yes.
18. CS_Email The email address on record for the customer Variable Character Yes.
19. CS_Outstanding_Debt_Flag This field indicates whether the customer has outstanding debt with covered institution. This field may be used by the FDIC to determine offsets. Enter “Y” if customer has outstanding debt with covered institutions, enter “N” otherwise Character (1) Yes.
20. CS_Security_Pledge_Flag This field shall only be used for Government customers. This field indicates whether the covered institution has pledged securities to the government entity, to cover any shortfall in deposit insurance. Enter “Y” if the government entity has outstanding security pledge with covered institutions, enter “N” otherwise Character (1) No.

Account File. The Account File contains the deposit ownership rights and capacities information, allocated balances, insured amounts, and uninsured amounts. The balances are in U.S. dollars. The Account file is linked to the Customer File by the CS_Unique_ID.

The data elements will include:

Field name Description Format Null value
allowed?
1. CS_Unique_ID This field is the unique identifier that is the primary key for the depositor data record. It will be generated by the covered institution and there cannot be duplicates Variable Character No.
2. DP_Acct_Identifier Deposit account identifier. The primary field used to identify a deposit account Variable Character No.
The account identifier may be composed of more than one physical data element to uniquely identify a deposit account
3. DP_Right_Capacity Account ownership categories Character (4) No.
- SGL - Single accounts
- JNT - Joint accounts
- REV - Revocable trust accounts
- IRR - Irrevocable trust accounts
- CRA - Certain retirement accounts
- EBP - Employee benefit plan accounts
- BUS - Business/Organization accounts
- GOV1, GOV2, GOV3 - Government accounts (public unit accounts)
- MSA - Mortgage servicing accounts for principal and interest payments
- DIT - Accounts held by a depository institution as the trustee of an irrevocable trust
- ANC - Annuity contract accounts
- PBA - Public bond accounts
- BIA - Custodian accounts for American Indians
- DOE - Accounts of an IDI pursuant to the Bank Deposit Financial Assistance Program of the Department of Energy
4. DP_Prod_Cat Product category or classification
- DDA - Demand Deposit Accounts
- NOW - Negotiable Order of Withdrawal
- 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
Character (3) Yes. For credit card accounts with a credit balance that create a deposit liability, use a NULL value for this field.
5. DP_Allocated_Amt The current balance in the account at the end of business on the effective date of the file, allocated to a specific owner in that insurance category Decimal (14,2) No.
For JNT accounts, this is a calculated field that represents the allocated amount to each owner in JNT category
For REV accounts, this is a calculated field that represents the allocated amount to each owner-beneficiary in REV category
For other accounts with only one owner, this is the account current balance
This balance shall not be reduced by float or holds. For CDs and time deposits, the balance shall reflect the principal balance plus any interest paid and available for withdrawal not already included in the principal (do not include accrued interest)
6. DP_Acc_Int Accrued interest allocated similarly as data field #5 DP_Allocated_Amt Decimal (14,2) No.
The amount of interest that has been earned but not yet paid to the account as of the date of the file
7. DP_Total_PI Total amount adding #5 DP_Allocated_Amt and #6 DP_Acc_Int Decimal (14,2) No.
8. DP_Hold_Amount Hold amount on the account Decimal (14,2) No.
The available balance of the account is reduced by the hold amount. It has no effect on current balance (ledger balance)
9. DP_Insured_Amount The insured amount of the account Decimal (14,2) No.
10. DP_Uninsured_Amount The uninsured amount of the account Decimal (14,2) No.
11. DP_Prepaid_Account_Flag This field indicates a prepaid account with covered institution. Enter “Y” if account is a prepaid account with covered institutions, enter “N” otherwise Character (1) No.
12. DP_PT_Account_Flag This field indicates a pass-through account with covered institution. Enter “Y” if account is a pass-through with covered institutions, enter “N” otherwise Character (1) No.
13. DP_PT_Trans_Flag This field indicates whether the fiduciary account has sub-accounts that have transactional features. Enter “Y” if account has transactional features, enter “N” otherwise Character (1) No.

Account Participant File. The Account Participant File will be used by the FDIC to identify account participants, to include the official custodian, beneficiary, bond holder, mortgagor, or employee benefit plan participant, for each account and account holder. One record represents one unique account participant. The Account Participant File is linked to the Account File by CS_Unique_ID and DP_Acct_Identifier.

The data elements will include:

Field name Description Format Null value
allowed?
1. CS_Unique_ID This field is the unique identifier that is the primary key for the depositor data record. It will be generated by the covered institution and there shall not be duplicates Variable Character No.
2. DP_Acct_Identifier Deposit account identifier. The primary field used to identify a deposit account
The account identifier may be composed of more than one physical data element to uniquely identify a deposit account
Variable Character No.
3. DP_Right_Capacity Account ownership categories Character (4) No.
- SGL - Single accounts
- JNT - Joint accounts
- REV - Revocable trust accounts
- IRR - Irrevocable trust accounts
- CRA - Certain retirement accounts
- EBP - Employee benefit plan accounts
- BUS - Business/Organization accounts
- GOV1, GOV2, GOV3 - Government accounts (public unit accounts)
- MSA - Mortgage servicing accounts for principal and interest payments
- DIT - Accounts held by a depository institution as the trustee of an irrevocable trust
- ANC - Annuity contract accounts
- PBA - Public bond accounts
- BIA - Custodian accounts for American Indians
- DOE - Accounts of an IDI pursuant to the Bank Deposit Financial Assistance Program of the Department of Energy
4. DP_Prod_Category Product category or classification Character (3) Yes.
- DDA - Demand Deposit Accounts
- NOW - Negotiable Order of Withdrawal
- 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
5. AP_Allocated_Amount Amount of funds attributable to the account participant as an account holder (e.g., Public account holder of a public bond account) or the amount of funds entitled to the beneficiary for the purpose of insurance determination (e.g., Revocable Trust) Decimal (14,2) No.
6. AP_Participant_ID This field is the unique identifier for the Account Participant. It will be generated by the covered institution and there shall not be duplicates. If the account participant is an existing bank customer, this field is the same as CS_Unique_ID field Variable Character No.
7. AP_Govt_ID This field shall contain the ID number that identifies the entity based on a government issued ID or corporate filing. Populate as follows: Variable Character No.
- For a United States individual - Legal identification number (e.g., SSN, TIN, Driver's License, or Passport Number)
- For a foreign national individual - where a SSN or TIN does not exist, a foreign passport or other legal identification number (e.g., Alien Card)
- For a Non-Individual - the Tax identification Number (TIN), or other register entity number
8. AP_Govt_ID_Type The valid customer identification types are: Character (3) No.
- SSN - Social Security Number
- TIN - Tax Identification Number
- DL - Driver's License, issued by a State or Territory of the United States
- ML - Military ID
- PPT - Valid Passport
- AID - Alien Identification Card
- OTH - Other
9. AP_First_Name Customer first name. Use only for the name of individuals and the primary contact for entity Variable Character No.
10. AP_Middle_Name Customer middle name. Use only for the name of individuals and the primary contact for entity Variable Character Yes.
11. AP_Last_Name Customer last name. Use only for the name of individuals and the primary contact for entity Variable Character No.
12. AP_Entity_Name The registered name of the entity. Do not use this field if the participant is an individual Variable Character Yes.
13. AP_Participant_Type This field is used as the participant type identifier. The field will list the “beneficial owner” type: Character (3) Yes.
- OC - Official Custodian
- BEN - Beneficiary
- BHR - Bond Holder
- MOR - Mortgagor
- EPP - Employee Benefit Plan Participant

Pending File. The Pending File contains the information needed for the FDIC to contact the owner or agent requesting additional information to complete the deposit insurance calculation. Each record represents a deposit account.

The data elements will include:

Field name Description Format Null value allowed?
1. CS_Unique_ID This field is the unique identifier that is the primary key for the depositor data record. It will be generated by the covered institution and there cannot be duplicates Variable Character No.
2. Pending_Reason Reason code for the account to be included in Pending file Character (5) No.
For deposit account records maintained by the bank, use the following codes
- A - agency or custodian
- B - beneficiary
- OI - official item
- RAC - right and capacity code
For alternative recordkeeping requirements, use the following codes
- ARB - depository organization for brokered deposits (Brokered deposit has the same meaning as provided in 12 CFR 337.6(a)(2))
- ARBN - non-depository organization for brokered deposits (Brokered deposit has the same meaning as provided in 12 CFR 337.6(a)(2))
- ARCRA - certain retirement accounts
- AREBP - employee benefit plan accounts
- ARM - mortgage servicing for principal and interest payments
- ARO - other deposits
- ARTR - trust accounts
The FDIC needs these codes to initiate the collection of needed information
3. DP_Acct_Identifier Deposit account identifier. The primary field used to identify a deposit account
The account identifier may be composed of more than one physical data element to uniquely identify a deposit account
Variable Character No.
4. DP_Right_Capacity Account ownership categories Character (4) Yes.
- SGL - Single accounts
- JNT - Joint accounts
- REV - Revocable trust accounts
- IRR - Irrevocable trust accounts
- CRA - Certain retirement accounts
- EBP - Employee benefit plan accounts
- BUS - Business/Organization accounts
- GOV1, GOV2, GOV3 - Government accounts (public unit accounts)
- MSA - Mortgage servicing accounts for principal and interest payments
- DIT - Accounts held by a depository institution as the trustee of an irrevocable trust
- ANC - Annuity contract accounts
- PBA - Public bond accounts
- BIA - Custodian accounts for American Indians
- DOE - Accounts of an IDI pursuant to the Bank Deposit Financial Assistance Program of the Department of Energy
5. DP_Prod_Category Product category or classification Character (3) Yes.
- DDA - Demand Deposit Accounts
- NOW - Negotiable Order of Withdrawal
- 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
6. DP_Cur_Bal Current balance - The current balance in the account at the end of business on the effective date of the file Decimal (14,2) No.
This balance shall not be reduced by float or holds. For CDs and time deposits, the balance shall reflect the principal balance plus any interest paid and available for withdrawal not already included in the principal (do not include accrued interest)
7. DP_Acc_Int Accrued interest Decimal (14,2) No.
The amount of interest that has been earned but not yet paid to the account as of the date of the file
8. DP_Total_PI Total of principal and accrued interest Decimal (14,2) No.
9. DP_Hold_Amount Hold amount on the account Decimal (14,2) No.
The available balance of the account is reduced by the hold amount. It has no impact on current balance (ledger balance)
10. DP_Prepaid_Account_Flag This field indicates a prepaid account with covered institution. Enter “Y” if account is a prepaid account, enter “N” otherwise Character (1) No.
11. CS_Govt_ID This field shall contain the ID number that identifies the entity based on a government issued ID or corporate filing. Populate as follows: Variable Character No.
- For a United States individual SSN or TIN
- For a foreign national individual - where a SSN or TIN does not exist, a foreign passport or other legal identification number (e.g., Alien Card)
- For a Non-Individual - the Tax identification Number (TIN), or other register entity number
12. CS_Govt_ID_Type The valid customer identification types: Character (3) No.
- SSN - Social Security Number
- TIN - Tax Identification Number
- DL - Driver's License, issued by a State or Territory of the United States
- ML - Military ID
- PPT - Valid Passport
- AID - Alien Identification Card
- OTH - Other
13. CS_First_Name Customer first name. Use only for the name of individuals and the primary contact for entity Variable Character No.
14. CS_Middle_Name Customer middle name. Use only for the name of individuals and the primary contact for entity Variable Character Yes.
15. CS_Last_Name Customer last name. Use only for the name of individuals and the primary contact for entity Variable Character No.
16. CS_Name_Suffix Customer suffix Variable Character Yes.
17. CS_Entity_Name The registered name of the entity. Do not use this field if the customer is an individual Variable Character Yes.
18. CS_Street_Add_Ln1 Street address line 1. The current account statement mailing address of record Variable Character No.
19. CS_Street_Add_Ln2 Street address line 2. If available, the second address line Variable Character Yes.
20. CS_Street_Add_Ln3 Street address line 3. If available, the third address line Variable Character Yes.
21. CS_City The city associated with the mailing address Variable Character Yes.
22. CS_State The state for United States addresses or state/province/county for international addresses Variable Character Yes.
- For United States addresses use a two-character state code (official United States Postal Service abbreviations) associated with the mailing address
- For international address follow that country state code
23. CS_ZIP The Zip/Postal Code associated with the customer's mailing address Variable Character Yes.
- For United States zip codes, use the United States Postal Service ZIP+4 standard
- For international zip codes follow the standard format of that country
24. CS_Country The country associated with the mailing address. Provide the country name or the standard International Organization for Standardization (ISO) country code Variable Character Yes.
25. CS_Telephone Customer telephone number. The telephone number on record for the customer, including the country code if not within the United States Variable Character Yes.
26. CS_Email The email address on record for the customer Variable Character Yes.
27. CS_Outstanding_Debt_Flag This field indicates whether the customer has outstanding debt with covered institution. This field may be used to determine offsets. Enter “Y” if customer has outstanding debt with covered institutions, enter “N” otherwise Character (1) Yes.
28. CS_Security_Pledge_Flag This field indicates whether the CI has pledged securities to the government entity, to cover any shortfall in deposit insurance. Enter “Y” if the government entity has outstanding security pledge with covered institutions, enter “N” otherwise. This field shall only be used for Government customers Character (1) No.
29. DP_PT_Account_Flag This field indicates a pass-through account with covered institution. Enter “Y” if account is a pass-through with covered institutions, enter “N” otherwise Character (1) No.
30. PT_Parent_Customer_ID This field contains the unique identifier of the parent customer ID who has the fiduciary responsibility at the covered institution Variable Character No.
31. DP_PT_Trans_Flag This field indicates whether the fiduciary account has sub-accounts that have transactional features. Enter “Y” if account has transactional features, enter “N” otherwise Character (1) No.