| Field Name | Field Order | Description | Data Format | Allowed Values | Example Values |
| SNAPSHOT_DATE | 1 | The last day of the month corresponding to the month in which the data is relevant. | Integer | Date formatted as YYYYMMDD integer | 20231231 |
| INVESTMENT_ID | 2 | Provide the actual CUSIP if applicable. For money market funds, mutual funds or individual equity security a ticker symbol can be provided. Otherwise provide tokenized unique account number that is kept constant across reporting periods and can be used to track the account. | Text (150 characters or less) | Any text | ABC123456 |
| CONFORM_INVESTMENT_ACCOUNT | 3 | Indicates whether the investment is part of the credit union's employee benefit plan or charitable donation accounts. An example of option 4 is a vendor required stock purchase or other investment (e.g., credit card processor requiring stock purchase). |
Integer | 1. Employee benefit plan 2. Charitable donation account 3. Liquidity Investment Portfolio 4. Required investment in counterparty or service provider 5. Other |
1 |
| CONFORM_INVESTMENT_TYPE | 4 | Indicates whether the investment instrument is consolidated as part of a member trust or other wrapper account. Investments that are not included in either should be reported as option 4. | Integer | 1. Member Trust 2. Wrapper 3. Other 4. Not Applicable |
1 |
| CONFORM_INSTRUMENT_TYPE | 5 | The type of investment product. Items 15 and 16 only be selected when CONFORM_INVESTMENT_ACCOUNT is "Employee benefit plan" (option 1). Use item 6 (Non-agency asset backed securities) for private mortgage backed securities, private commercial mortgage backed securities and other non-agency asset backed securities. |
Integer | 1. Agency Bullet 2. Agency Callable 3. Agency MBS/Passthrough 4. Agency CMOs 5. Agency CMBS 6. Non-agency Asset Backed Securities 7. Debt securities issued by depositories, banks or credit unions 8. Other Corporate Bonds 9. Municipal Bonds 10. US Treasuries 11. SBA Securities 12. Equity Securities 13. Other Securities 14. FHLB Stock 15. Split-dollar life insurance - endorsement 16. Split-dollar life insurance - collateral assignment 17. Other insurance 18 Supranational Organization 19. All other investments |
1 |
| CONFORM_ACCOUNTING_DESIGNATION | 6 | The accounting designation assigned to the instrument. | Integer | 1. Equity Securities 2. Trading Debt Securities 3. Available for Sale 4. Held to Maturity 5. Other |
1 |
| CONFORM_INT_PAY_FREQ | 7 | The interval of time (quarterly, monthly, bi-monthly, etc.) indicating how frequently the investment's coupon is paid. | Integer | 1. Weekly 2. Bi-weekly/Semi-Monthly 3. Monthly 4. Bi-monthly 5. Quarterly 6. Semi-annually 7. Annually 8 - Other |
1 |
| CONFORM_RATE_ADJ_FREQ | 8 | Frequency the rate adjusts after the first rate adjustment date. | Integer | 1. Daily 2. Weekly 3. Bi-weekly/Semi-Monthly 4. Monthly 5. Bi-monthly 6. Quarterly 7. Semi-annually 7. Annually 8. 3 Years 9. 5 Years 10. Other |
1 |
| CONFORM_INT_RATE_TYPE | 9 | The type of interest rate associated with the loan (e.g. Fixed, Variable, etc.) | Integer | 1. Fixed 2. Variable 3. Hybrid 4. Step |
1 |
| CONFORM_INT_RATE_INDEX | 10 | The name of the index from which the interest rate resets. If the loan is a fixed rate loan, please report a null value (blank between delimiters). | Integer | 1. PRIME 2. LIBOR 3. Treasury 4. 11TH COFI 5. SOFR 6. Counterparty cost of funds 7.- Fed Funds Rate 8. CODI 9. FHLB 10. Other |
9 |
| INT_GROSS_MARGIN | 11 | The rate spread added to an index value to determine the fully indexed interest rate. If account is fixed rate, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 1.1234 |
| RATE_LIFE_CAP | 12 | The maximum interest rate to which the account may adjust. If there is no rate cap, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 13.9999 |
| RATE_LIFE_FLOOR | 13 | The minimum interest rate to which the account may adjust. If there is no rate floor, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 2.1256 |
| ORIG_PAR_VALUE | 14 | Original par value of the investment at settlement. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_PAR_VALUE | 15 | Current par value of the investment. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_BOOK_VALUE | 16 | Investment's carrying value/amortized cost basis. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_MARKET_VALUE | 17 | Investment's market value. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_BOOK_PRICE | 18 | The per unit carrying price/amortized cost. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_MARKET_PRICE | 19 | The per unit market price. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| ORIG_PURCHASE_PRICE | 20 | The per unit price paid to purchase the investment. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_CASH_SURRENDER | 21 | The instrument's cash surrender value (if applicable). Provide for split-dollar life insurance instruments. Otherwise, provide a null value (report as blank between delimiters). | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| SETTLEMENT_DATE | 22 | The date the legal transfer of the investment was executed. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| TRADE_DATE | 23 | The date the investment trade was placed. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| MATURITY_DATE | 24 | The final payment date of a loan or other financial instrument, at which point the principal (and all remaining interest) is due to be paid. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| FIRST_INT_PAY_DATE | 25 | The date that the investment's first coupon payment is due. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| FIRST_RATE_ADJ_DATE | 26 | The initial date when the investment's interest rate (coupon) will adjust. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| CURR_INT_RATE | 27 | The investment's current coupon rate. If the investment is an equity or other investment without a coupon rate, provide a null value (blank between delimiters). | Decimal | Decimal number with up to 4 places to right of decimal. | 4.3475 |
| PLEDGED_FLAG | 28 | Indicates whether the investment is pledged as collateral for a loan. | Text (1 character) | Y or N | Y |
| PLEDGE_DESC | 29 | Description of the loan the investment is pledged against. | Text (60 characters) | Any Text | Loan XYZ |
| NEXT_CALL_DATE | 30 | Next date that the issuer can recall the investment. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| CONFORM_DAY_COUNT | 31 | Convention used to calculate accrued interst on the investment. | Integer | 1. 30/360 2. 30/365 3. Actual/360 4. Actual/365 5. Actual/Actual 6. Other |
1 |
| CONFORM_ISSUER_TYPE | 32 | The type of the issuer. | Integer | 1. Bank 2. Natural Person Credit Union 3. Corporate Credit Union 4. Federal Reserve 5. Federal Home Loan Bank 6. U.S. Government 7. Central Liquidity Facility 8. Agency 9. Other |
1 |
| ISSUER_NAME | 33 | Name of the entity that issued the investment. | Text (100 characters of less) | Any text | XYZ Financial |
| CONFORM_EXTERNAL_RATER | 34 | The external rating service that provided rating of the investment instrument. | Integer | 1. Fitch 2. Moody's 3. S&P 4. Other |
1 |
| ORIG_EXTERNAL_RATING | 35 | The instrument's external rating grade at settlement. | Text( 5 characters or less) | Any text | AAA |
| CURR_EXTERNAL_RATING | 36 | The instrument's current external rating grade. | Text( 5 characters or less) | Any text | AAA |
| CURR_CREDIT_LOSS_ALLOWANCE | 37 | The current credit loss allowance associated with the investment instrument. Reported values should align in the aggregate with Allowance for Credit Loss on Investment Securities in the Call Report. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| Field Name | Field Order | Description | Data Format | Allowed Values | Example Values |
| SNAPSHOT_DATE | 1 | The last day of the month corresponding to the month in which the data is relevant. | Integer | Date formatted as YYYYMMDD integer | 20231231 |
| ACCOUNT_ID | 2 | Tokenized unique account number, used to track the account. This should remain the same across reporting periods for the same account. It should not be the actual account number. | Text (150 characters or less) | Any text | ABC123456 |
| CONFORM_ACCOUNT_TYPE | 3 | Denotes type of cash or cash equivalent asset account. | Integer | 1. Checking 2. Savings 3. Money Market 4. CD 5. IRA 6. Brokered CD 7. Cash on Hand 8. Other Term Deposit 9. All Other Deposits |
1 |
| ACCOUNT_DESCRIPTION | 4 | Short description of product to help differentiate between different cash and cash equivalent products used. | Text (100 characters or less) | Any text | Premier Business Checking |
| CONFORM_ACCOUNT_PROVIDER | 5 | Denotes the type of financial institution that the cash or cash equivalent account is through. | Integer | 1. Bank 2. Natural Person Credit Union 3. Corporate Credit Union 4. Federal Reserve 5. Federal Home Loan Bank 6. Central Liquidity Facility 7. Other |
1 |
| ACCOUNT_PROVIDER_NAME | 6 | Name of the account provider. | Text (60 characters or less) | Any text | Chase Bank |
| CONFORM_INT_PAY_FREQ | 7 | The interval of time (quarterly, monthly, bi-monthly, etc.) indicating how frequently the interest payment is earned. | Integer | 1. Daily 2. Weekly 3. Bi-weekly/Semi-monthly 4. Monthly 5. Bi-monthly 6. Quarterly 7. Semi-annually 8. Annually 9. At maturity 10. Other |
4 |
| CONFORM_INT_RATE_TYPE | 8 | The type of interest rate associated with the loan (e.g. Fixed, Variable, etc.) | Integer | 1. Fixed 2. Variable 3. Hybrid 4. Step |
1 |
| CONFORM_INT_RATE_INDEX | 9 | The name of the index from which the interest rate resets. If the loan is a fixed rate loan, please report a null value (blank between delimiters). | Integer | 1. PRIME 2. LIBOR 3. TREASURY 4. 11TH COFI 5. SOFR 6. Counterparty cost of funds 7.- Fed Funds Rate 8. CODI 9. FHLB 10. OTHER |
9 |
| CONFORM_RATE_ADJ_FREQ | 10 | Frequency the rate adjusts after the first rate adjustment date. If the borrowing is fixed rate (CONFORM_INT_RATE_TYPE = 1) then this field should be coded 10 (Never). | Integer | 1. Daily 2. Weekly 3. Bi-weekly/Semi-Monthly 4. Monthly 5. Bi-monthly 6. Quarterly 7. Semi-annually 7. Annually 8. 3 Years 9. 5 Years 10. Never 11. One time 12. Other |
1 |
| FIRST_INT_PAY_DATE | 11 | The date that the account's first coupon payment is due. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| FIRST_RATE_ADJ_DATE | 12 | The initial date in which the account's interest rate will adjust. If the account is not scheduled to adjust provide a null value (blank between delimiters). For CDs with bump up rates, use this field to provide the first bump up date. | Integer | Date formatted as YYYYMMDD integer | 20310617 |
| INT_GROSS_MARGIN | 13 | The rate spread added to an index value to determine the fully indexed interest rate. If account is fixed rate, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 1.1234 |
| RATE_LIFE_CAP | 14 | The maximum interest rate to which the account may adjust. If there is no rate cap, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 13.9999 |
| RATE_LIFE_FLOOR | 15 | The minimum interest rate to which the account may adjust. If there is no rate floor, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 2.1256 |
| ORIG_TERM | 16 | Contractual length of time required for the deposit in months. Leave blank if the ACCOUNT_TYPE corresponds to a non-maturity product. | Integer | A whole number | 12 |
| ORIG_DATE | 17 | The date the account was initiated. | Integer | Date formatted as YYYYMMDD integer | 20240311 |
| MATURITY_DATE | 18 | Maturity date of term deposit. For non-maturity deposit account provide a null value (blank between delimiters). | Integer | Date formatted as YYYYMMDD integer | 20240617 |
| CURR_BAL | 19 | Current account balance. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| CURR_INT_RATE | 20 | The accounts current interest rate. If the account has a tiered interest rate, report the weighted average across all the tiers. Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 3.1625 |
| Field Name | Field Order | Description | Data Format | Allowed Values | Example Values | Chris Comment |
| SNAPSHOT_DATE | 1 | The last day of the month corresponding to the month in which the data is relevant. | Integer | Date formatted as YYYYMMDD integer | 20231231 | |
| ACCOUNT_ID | 2 | Tokenized unique account number, used to track the account. This should remain the same across reporting periods for the same account. It should not be the actual account number. | Text (150 characters or less) | Any text | ABC123456 | |
| CONFORM_PRODUCT_TYPE | 3 | The type of account or product according to a standard list of product types. | Integer | 1. Closed End Loan 2.Line of Credit 3. Hybrid |
1 | |
| ACCOUNT_DESCRIPTION | 5 | Short description of product to help differentiate between different borrowing products used. | Text (100 characters or less) | Any text | FHLB Advance | |
| CONFORM_ACCOUNT_PROVIDER | 6 | Denotes the type of financial institution that the cash or cash equivalent account is through. | Integer | 1. Bank 2. Natural Person Credit Union 3. Corporate Credit Union 4. Federal Reserve 5. Federal Home Loan Bank 6. Central Liquidity Facility 7. Other |
1 | |
| ACCOUNT_PROVIDER_NAME | 7 | Name of the account provider. | Text (60 characters or less) | Any text | FHLB Atlanta | |
| CONFORM_PRINCIPAL_PAY_FREQ | 8 | The interval of time (quarterly, monthly, bi-monthly, etc.) indicating how frequently the principal payment is due. | Integer | 1. Daily 2. Weekly 3. Bi-weekly/Semi-monthly 4. Monthly 5. Bi-monthly 6. Quarterly 7. Semi-annually 8. Annually 9. At maturity 10. Other |
3 | |
| CONFORM_INT_PAY_FREQ | 9 | The interval of time (quarterly, monthly, bi-monthly, etc.) indicating how frequently the interest payment is due. | Integer | 1. Daily 2. Weekly 3. Bi-weekly/Semi-monthly 4. Monthly 5. Bi-monthly 6. Quarterly 7. Semi-annually 8. Annually 9. At maturity 10. Other |
3 | |
| FIRST_INT_PAY_DATE | 10 | The date that the account's first coupon payment is due. | Integer | Date formatted as YYYYMMDD integer | 20310617 | |
| FIRST_PRINCIPAL_PAY_DATE | 11 | The date that the first payment of the account is/was due. | Integer | Date formatted as YYYYMMDD integer | 20310617 | |
| FIRST_RATE_ADJ_DATE | 12 | The initial date in which the account's interest rate will adjust. | Integer | Date formatted as YYYYMMDD integer | 20310617 | |
| CONFORM_INT_RATE_TYPE | 13 | The type of interest rate associated with the loan (e.g. Fixed, Variable, etc.) | Integer | 1. Fixed 2. Variable 3. Hybrid 4. Step |
1 | |
| CONFORM_RATE_ADJ_FREQ | 14 | Frequency the rate adjusts after the first rate adjustment date. If the borrowing is fixed rate (CONFORM_INT_RATE_TYPE = 1) then this field should be coded 10 (Never). | Integer | 1. Daily 2. Weekly 3. Bi-weekly/Semi-Monthly 4. Monthly 5. Bi-monthly 6. Quarterly 7. Semi-annually 7. Annually 8. 3 Years 9. 5 Years 10. Never 11. One time 12. Other |
1 | |
| CONFORM_INT_RATE_INDEX | 15 | The name of the index from which the interest rate resets. If the loan is a fixed rate loan, please report a null value (blank between delimiters). | Integer | 1. PRIME 2. LIBOR 3. Treasury 4. 11TH COFI 5. SOFR 6. Counterparty cost of funds 7.- Fed Funds Rate 8. CODI 9. FHLB 10. Other |
9 | |
| INT_GROSS_MARGIN | 16 | The rate spread added to an index value to determine the fully indexed interest rate. If account is fixed rate, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 1.1234 | |
| RATE_LIFE_CAP | 17 | The maximum interest rate to which the account may adjust. If there is no rate cap, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 13.9999 | |
| RATE_LIFE_FLOOR | 18 | The minimum interest rate to which the account may adjust. If there is no rate floor, report a null value (blank between delimiters). Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 2.1256 | |
| CONFORM_CALL_PUT | 19 | Denotes if borrowing the callable and puttable status of the borrowing. | Integer | 1. Callable 2. Puttable 3. Callable and Puttable 4. Neither |
4 | |
| CONFORM_COLLATERAL_TYPE | 20 | Denotes the type of collateral securing the loan. If the borrowing is not collateralized report a value of 6. | Integer | 1. Mortgage loans 2. Other loans 3. Real estate 4. Securities 5. Other collateral 6. Not collateralized |
1 | |
| ORIG_DATE | 22 | The date the borrowing was initiated/settled. | Integer | Date formatted as YYYYMMDD integer | 20240311 | |
| MATURITY_DATE | 23 | The final payment date of a loan or other financial instrument, at which point the principal (and all remaining interest) is due to be paid. | Integer | Date formatted as YYYYMMDD integer | 20310617 | |
| ORIG_TERM | 24 | Original period in months over which a loan agreement is in force, and before or at the end of which the loan should be repaid. For open end line of credit, leave this as null (report blank between delimiters). | Integer | A whole number | 120 | |
| AMORT_TERM | 25 | Loan Amortization Term in Months. | Integer | A whole number | 120 | |
| IO_TERM | 26 | The length of time (in months) during which the borrower pays only the interest on the principal balance. If the loan does not have an interest only repayment period, report a null value (blank between delimiters). | Integer | A whole number | 12 | |
| PPAY_PNLTY_TERM | 27 | The duration in months for which the loan is subject to a Prepayment Penalty. If the borrowing is not subject to a prepayment penalty, report a null value (blank between delimiters). | Integer | A whole number | 120 | |
| PREPAY_LOCKOUT_END_DATE | 28 | Prepayment Lock-out end date. If there is no prepayment lockout, report a null value (blank between delimters). If the prepayment lockout period covers the life of the loan, report the same date as the MATURITY_DATE field. | Integer | Date formatted as YYYYMMDD integer | 20310617 | |
| CURR_BAL | 29 | Current account balance. Report the outstanding balance of all draws against borrowing capacity. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 | |
| CURR_PLEDGED_ASSETS | Value of assets pledged to secure borrowing. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 | ||
| CURR_INT_RATE | 30 | The accounts current interest rate. Report 3.1625 not 0.031625. | Decimal | Decimal number with up to 4 places to right of decimal. | 3.1625 |
| Field Name | Field Order | Description | Data Format | Allowed Values | Example Values |
| SNAPSHOT_DATE | 1 | The last day of the month corresponding to the month in which the data is relevant. | Integer | Date formatted as YYYYMMDD integer | 20231231 |
| CC_BAL | 2 | Total balance of credit card portfolio. | Decimal | Decimal number with up to 2 places to right of the decimal. | 100.25 |
| REVOLVE_BAL | 3 | Balance of the portfion of the credit card portfolio classified as a revolving account. | Decimal | Decimal number with up to 2 places to right of the decimal. | 73.25 |
| REVOLVE_BAL_PCT | 4 | Percent of the credit card portfolio's total balance in accounts classified as revolving. Calculated as CC_BAL / REVOLVE_BAL |
Decimal | Decimal number with up to 4 places to right of the decimal. | 73.0673 |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |