| 1 |
HARDSHIP_APPLN_CASE_ID |
CHARACTER(10) |
10 |
| 2 |
PARTY_ID |
CHARACTER VARYING(40) |
40 |
| 3 |
ACCOUNT_NUMBER |
CHARACTER VARYING(40) |
40 |
| 4 |
PRODUCT_GROUP |
CHARACTER VARYING(30) |
30 |
| 5 |
DAYS_PAST_DUE |
SMALLINT |
2 |
| 6 |
PERIOD_DT |
DATE |
4 |
| 7 |
DAYS_IN_ARREARS |
INTEGER |
4 |
| 8 |
DPD_BUCKET |
CHARACTER VARYING(8) |
8 |
| 9 |
NO_OF_ASSOCIATED_ACCOUNTS |
BIGINT |
8 |
| 10 |
HOST_SYSTEM |
CHARACTER VARYING(10) |
10 |
| 11 |
MOST_CURRENT_HARDSHIP_CASES |
CHARACTER VARYING(60) |
60 |
| 12 |
NOTICE_DATE |
DATE |
4 |
| 13 |
ASSESSMENT_DUE_DATE |
DATE |
4 |
| 14 |
RELIEF_EXPIRY_DATE |
DATE |
4 |
| 15 |
BALANCE_ACROSS_ACCOUNTS_HARDSHIP |
NUMERIC(38,16) |
19 |
| 16 |
ARRERS_BALANCE_HARDSHIP |
NUMERIC(38,16) |
19 |
| 17 |
BALANCE |
NUMERIC(38,16) |
19 |
| 18 |
ARRERS_BALANCE |
NUMERIC(38,16) |
19 |
| 19 |
NOTICE_DATE_BALANCE |
NUMERIC(38,16) |
19 |
| 20 |
NOTICE_DATE_ARRERS_BALANCE |
NUMERIC(38,16) |
19 |
| 21 |
REASON_FOR_HARDSHIP |
CHARACTER VARYING(254) |
254 |
| 22 |
CANCEL_REASON |
CHARACTER VARYING(254) |
254 |
| 23 |
DECLINE_REASON |
CHARACTER VARYING(254) |
254 |
| 24 |
STATE |
CHARACTER VARYING(6) |
6 |
| 25 |
ASSESSOR |
CHARACTER VARYING(201) |
201 |
| 26 |
PENDING_DATE |
TIMESTAMP |
8 |
| 27 |
ASSESSMENT_DATE |
TIMESTAMP |
8 |
| 28 |
CANCELLED_DATE |
TIMESTAMP |
8 |
| 29 |
PENDING_INFO_DATE |
TIMESTAMP |
8 |
| 30 |
PENDING_APPROVAL_DATE |
TIMESTAMP |
8 |
| 31 |
APPROVED_DATE |
TIMESTAMP |
8 |
| 32 |
PENDING_CONFIRMATION_DATE |
TIMESTAMP |
8 |
| 33 |
REVIEW_DATE |
TIMESTAMP |
8 |
| 34 |
DECLINED_DATE |
TIMESTAMP |
8 |
| 35 |
SUPERVISOR_DATE |
TIMESTAMP |
8 |
| 36 |
APPLY_RELIEF_DATE |
TIMESTAMP |
8 |
| 37 |
COMPLETE_DATE |
TIMESTAMP |
8 |
| 38 |
RELIEF_CANCELLED_DATE |
TIMESTAMP |
8 |
| 39 |
CLOSED_DATE |
TIMESTAMP |
8 |
| 40 |
CASE_CATEGORY |
CHARACTER(4) |
4 |