FCT_BNK_COLLECTION_HARDSHIP_APP_RELIEF_REPORT_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 2 | COLLECTION_ACCOUNT_ID | CHARACTER(10) | 10 |
| 3 | SOURCE_SYSTEM_CODE | CHARACTER VARYING(10) | 10 |
| 4 | RELIEF_CASE_ID | CHARACTER(10) | 10 |
| 5 | LINKED_HARDSHIP_APP_CASE_ID | CHARACTER VARYING(254) | 254 |
| 6 | EFFECTIVE_DATE | DATE | 4 |
| 7 | APP_CASE_USER_NAME | CHARACTER VARYING(201) | 201 |
| 8 | APP_CASE_USER | CHARACTER VARYING(50) | 50 |
| 9 | RELIEF_CASE_USER_ID | CHARACTER VARYING(255) | 255 |
| 10 | RELIEF_CASE_USER | CHARACTER VARYING(255) | 255 |
| 11 | RELIEF_STATUS | CHARACTER(12) | 12 |
| 12 | RELIEF_STATUS_DESC | CHARACTER VARYING(60) | 60 |
| 13 | DAYS_PAST_DUE | SMALLINT | 2 |
| 14 | DAYS_IN_ARREAR | INTEGER | 4 |
| 15 | ARREAR_BALANCE | NUMERIC(38,16) | 19 |
| 16 | BALANCE | NUMERIC(38,16) | 19 |
| 17 | LOAN_VALUE_RATIO | NUMERIC(5,2) | 19 |
| 18 | NOTICE_DATE_DIA | INTEGER | 4 |
| 19 | NOTICE_DATE_ARREAR_BALANCE | NUMERIC(38,16) | 19 |
| 20 | NOTICE_DATE_BALANCE | NUMERIC(38,16) | 19 |
| 21 | NOTICE_DATE_LVR | NUMERIC(5,2) | 19 |
| 22 | PRODUCT_GROUP | CHARACTER VARYING(20) | 20 |
| 23 | HARDSHIP_REASON | CHARACTER VARYING(254) | 254 |
| 24 | RELIEF_TYPE1 | CHARACTER VARYING(256) | 256 |
| 25 | RELIEF_TYPE2 | CHARACTER VARYING(256) | 256 |
| 26 | RELIEF_TYPE3 | CHARACTER VARYING(256) | 256 |
| 27 | RELIEF_TYPE4 | CHARACTER VARYING(256) | 256 |
| 28 | RELIEF_TYPE5 | CHARACTER VARYING(256) | 256 |
| 29 | RELIEF_TYPE | CHARACTER VARYING(1280) | 1280 |
| 30 | PENDING_STATUS_DATE | DATE | 4 |
| 31 | ARRANGEMENT_PASS_DATE | DATE | 4 |
| 32 | ARRANGEMENT_FAIL_DATE | DATE | 4 |
| 33 | VARIATION_ONLY_DATE | DATE | 4 |
| 34 | RELIEF_CANCELLED_DATE | DATE | 4 |
| 35 | RELIEF_COMPLETE_DATE | DATE | 4 |
| 36 | DAYS_PAST_DUE_BUCKET | CHARACTER VARYING(8) | 8 |
| 37 | LVR_BUCKET | CHARACTER VARYING(7) | 7 |