FCT_BNK_QRM_HARDSHIP_APPLICATION_INSIGHT
Description
OBP list of hardship cases and accounts with request dates outcomes and status
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CASE_ID | CHARACTER(10) | 10 |
| 2 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 3 | SOURCE_SYSTEM | CHARACTER VARYING(10) | 10 |
| 4 | HARDSHIP_DATE_OUTCOME_ADVISED | DATE | 4 |
| 5 | HARDSHIP_DATE_REQUEST_RECEIVED | DATE | 4 |
| 6 | HARDSHIP_DURATION_OF_ASSISTANCE | INTEGER | 4 |
| 7 | HARDSHIP_OUTCOME | CHARACTER(12) | 12 |
| 8 | HARDSHIP_REASON_CODE | CHARACTER VARYING(254) | 254 |
| 9 | HARDSHIP_REGULATED_FLAG | CHARACTER(1) | 1 |
| 10 | HARDSHIP_STATE | CHARACTER VARYING(6) | 6 |
| 11 | HARDSHIP_STATUS_FLAG | CHARACTER(12) | 12 |
| 12 | HARDSHIP_PARTY_ID | CHARACTER(10) | 10 |
| 13 | FINALIZATION_TYPE | CHARACTER VARYING(254) | 254 |