Title 12

PART 370 APPENDIX B

Appendix B to Part 370 - Output Files Structure

12:6.0.1.1.21.0.1.11.18 : Appendix B

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.

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.

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.

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.

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.

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.

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.