FCT_BNK_CRHDS_REPO_CASE_OVERVIEW_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CASE_ID | CHARACTER(10) | 10 |
| 2 | ACCOUNT_NUMBER_CNT | BIGINT | 8 |
| 3 | FIRST_REPO_DATE | CHARACTER VARYING(50) | 50 |
| 4 | REPO_ACCT_BAL | CHARACTER VARYING(50) | 50 |
| 5 | REPO_SECURITY_CNT | BIGINT | 8 |
| 6 | FIRST_REPO_DATE_AGAINST_SECU | CHARACTER VARYING(50) | 50 |
| 7 | REPO_SECURITY_STATE | CHARACTER VARYING(1) | 1 |
| 8 | SALE_DATE | CHARACTER VARYING(50) | 50 |
| 9 | SALE_PRICE | CHARACTER VARYING(50) | 50 |
| 10 | LMI_CLAIM_DATE | CHARACTER VARYING(50) | 50 |
| 11 | LMI_CLAIM_VALUE | CHARACTER VARYING(50) | 50 |
| 12 | LMI_CLAIM_PAID_DATE | CHARACTER VARYING(50) | 50 |
| 13 | LMI_CLAIM_PAID_VALUE | CHARACTER VARYING(50) | 50 |
| 14 | WRITEOFF_VALUE | NUMERIC(36,18) | 19 |
| 15 | WRITEOFF_DATE | TIMESTAMP | 8 |
| 16 | CASE_STATUS | CHARACTER(12) | 12 |