| 1 |
HARDSHIP_CASE_ID |
CHARACTER(10) |
10 |
| 2 |
CASE_TYPE_CD |
CHARACTER(12) |
12 |
| 3 |
CASE_CATEGORY |
CHARACTER(4) |
4 |
| 4 |
PERSON_ID |
CHARACTER(10) |
10 |
| 5 |
OBP_PARTY_ID |
CHARACTER VARYING(40) |
40 |
| 6 |
COLLECTION_ACCOUNT_ID |
CHARACTER(10) |
10 |
| 7 |
HOST_SYSTEM |
CHARACTER VARYING(10) |
10 |
| 8 |
ACCOUNT_NUMBER |
CHARACTER VARYING(40) |
40 |
| 9 |
CURRENT_STATUS |
CHARACTER(12) |
12 |
| 10 |
CURRENT_STATUS_DESC |
CHARACTER VARYING(60) |
60 |
| 11 |
NEXT_ACTION |
TIMESTAMP |
8 |
| 12 |
NEXT_ACTION_DATE |
CHARACTER(12) |
12 |
| 13 |
NO_OF_ACTIVE_ACCOUNTS |
BIGINT |
8 |
| 14 |
NO_OF_HRD_ACCOUNTS |
BIGINT |
8 |
| 15 |
OUTSTANDING_AMOUNT |
NUMERIC(38,16) |
19 |
| 16 |
OVERLIMIT_AMOUNT |
NUMERIC(38,16) |
19 |
| 17 |
DISBURSEMENT_AMOUNT |
NUMERIC(38,16) |
19 |
| 18 |
OVERDUE_AMOUNT |
NUMERIC(38,16) |
19 |
| 19 |
APPLICATION_DATE |
DATE |
4 |
| 20 |
EFFECTIVE_DATE |
DATE |
4 |
| 21 |
EXPIRY_DATE |
DATE |
4 |
| 22 |
EXTENDED_EXPIRY_DATE |
DATE |
4 |
| 23 |
NOTICE_DATE |
DATE |
4 |
| 24 |
FOS_COMPLAINT |
CHARACTER VARYING(254) |
254 |
| 25 |
RELIEF_PERIOD_IN_MONTHS |
CHARACTER VARYING(254) |
254 |
| 26 |
HARDSHIP_REASON |
CHARACTER VARYING(254) |
254 |
| 27 |
CANCEL_REASON |
CHARACTER VARYING(254) |
254 |
| 28 |
CLOSE_REASON |
CHARACTER VARYING(254) |
254 |
| 29 |
DECLINE_REASON |
CHARACTER VARYING(254) |
254 |
| 30 |
COMPLETED_REASON |
CHARACTER VARYING(254) |
254 |
| 31 |
REASON_DESCRIPTION |
CHARACTER VARYING(254) |
254 |
| 32 |
RELIEF_CASE_CREATED_FLAG |
CHARACTER VARYING(254) |
254 |
| 33 |
APPLICATION_PASS_FAIL_FLAG |
CHARACTER VARYING(254) |
254 |
| 34 |
CREATED_BY |
CHARACTER VARYING(255) |
255 |
| 35 |
CREATED_DATE |
TIMESTAMP |
8 |
| 36 |
APPLICATION_APPROVED_BY |
CHARACTER VARYING(255) |
255 |
| 37 |
APPLICATION_APPROVED_DATE |
TIMESTAMP |
8 |
| 38 |
APPROVED_BY_COMMENTS |
CHARACTER VARYING(254) |
254 |
| 39 |
RELIEF_FINALISATION |
CHARACTER VARYING(254) |
254 |
| 40 |
LINKED_HARDSHIP_APP_CASE_ID |
CHARACTER VARYING(254) |
254 |
| 41 |
RELIEF_TYPE_1 |
CHARACTER VARYING(254) |
254 |
| 42 |
RELIEF_TYPE_2 |
CHARACTER VARYING(254) |
254 |
| 43 |
RELIEF_TYPE_3 |
CHARACTER VARYING(254) |
254 |
| 44 |
RELIEF_TYPE_4 |
CHARACTER VARYING(254) |
254 |
| 45 |
RELIEF_TYPE_5 |
CHARACTER VARYING(254) |
254 |
| 46 |
FINALISATION_TYPE |
CHARACTER VARYING(254) |
254 |
| 47 |
PENDING_STATUS_DATE |
TIMESTAMP |
8 |
| 48 |
ASSESSMENT_DATE |
TIMESTAMP |
8 |
| 49 |
PENDING_INFO_DATE |
TIMESTAMP |
8 |
| 50 |
PENDING_APPROVAL_DATE |
TIMESTAMP |
8 |
| 51 |
PENDING_CONFIRMATION_DATE |
TIMESTAMP |
8 |
| 52 |
REVIEW_DATE |
TIMESTAMP |
8 |
| 53 |
SUPERVISOR_DATE |
TIMESTAMP |
8 |
| 54 |
APPLY_RELIEF_DATE |
TIMESTAMP |
8 |
| 55 |
DECLINED_DATE |
TIMESTAMP |
8 |
| 56 |
CANCELLED_DATE |
TIMESTAMP |
8 |
| 57 |
COMPLETE_DATE |
TIMESTAMP |
8 |
| 58 |
APPROVED_DATE |
TIMESTAMP |
8 |
| 59 |
RELIEF_CANCELLED_DATE |
TIMESTAMP |
8 |
| 60 |
CLOSED_DATE |
TIMESTAMP |
8 |
| 61 |
ARRANGEMENT_PASS_DATE |
TIMESTAMP |
8 |
| 62 |
ARRANGEMENT_FAIL_DATE |
TIMESTAMP |
8 |
| 63 |
RELIEF_COMPLETE_DATE |
TIMESTAMP |
8 |
| 64 |
VARIATION_ONLY_DATE |
TIMESTAMP |
8 |
| 65 |
EFFECTIVE_START_TIMESTAMP |
TIMESTAMP |
8 |
| 66 |
EFFECTIVE_END_TIMESTAMP |
TIMESTAMP |
8 |
| 67 |
IS_CURRENT |
CHARACTER VARYING(1) |
1 |
| 68 |
BUSINESS_END_OF_DAY_DATE |
DATE |
4 |
| 69 |
IS_CURRENT_FOR_END_OF_DAY |
CHARACTER VARYING(1) |
1 |