FCT_BNK_HARDSHIP_TRENDS_REPORT_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PORTFOLIO_DATE | TIMESTAMP | 8 |
| 2 | ACCOUNT_NUMBER | NUMERIC(28,0) | 19 |
| 3 | PRODUCT_CODE_1 | CHARACTER VARYING(16) | 16 |
| 4 | PRODUCT_CODE_2 | CHARACTER VARYING(15) | 15 |
| 5 | SOURCE_SYSTEM | CHARACTER VARYING(4) | 4 |
| 6 | PAST_DUE_DAYS | BIGINT | 8 |
| 7 | EXPOSURE | NUMERIC(15,2) | 19 |
| 8 | QRM_ACCOUNT | CHARACTER VARYING(75) | 75 |
| 9 | IMPAIRED_FLAG_DRS | CHARACTER VARYING(1) | 1 |
| 10 | HARDSHIP_STATUS_FLAG | CHARACTER VARYING(1) | 1 |
| 11 | COLLATERAL_PRIMARY_STATE | CHARACTER VARYING(10) | 10 |
| 12 | HARDSHIP_APPLICATION_FLAG | CHARACTER VARYING(1) | 1 |
| 13 | HARDSHIP_RELIEF_FLAG | CHARACTER VARYING(1) | 1 |
| 14 | HARDSHIP_REASON | CHARACTER VARYING(254) | 254 |
| 15 | DPD_BUCKET | CHARACTER VARYING(13) | 13 |
| 16 | LOAN_TYPE | CHARACTER VARYING(2) | 2 |