FCT_BNK_COLLECTION_HARDSHIP_APPLN_CUST_LEVEL_REPORT_V
Description
Target Objects (CTAS)
SDSNZP05_BANK..FCT_BNK_COLLECTION_HARDSHIP_APPLN_CUST_LEVEL_REPORT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | HARDSHIP_APPLN_CASE_ID | CHARACTER(10) | 10 |
| 2 | PARTY_ID | CHARACTER VARYING(40) | 40 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | COLLECTION_ACCOUNT_ID | CHARACTER VARYING(10) | 10 |
| 5 | PRODUCT_GROUP | CHARACTER VARYING(30) | 30 |
| 6 | NO_OF_ASSOCIATED_ACCOUNTS | BIGINT | 8 |
| 7 | STATUS | CHARACTER VARYING(60) | 60 |
| 8 | MOST_CURRENT_STATUS | CHARACTER VARYING(60) | 60 |
| 9 | NOTICE_DATE | DATE | 4 |
| 10 | APPLICATION_DATE | DATE | 4 |
| 11 | RELIEF_EXPIRY_DATE | DATE | 4 |
| 12 | ARRERS_BALANCE | NUMERIC(38,16) | 19 |
| 13 | BALANCE_ACROSS_ACCOUNTS_HARDSHIP | NUMERIC(38,16) | 19 |
| 14 | REASON_FOR_HARDSHIP | CHARACTER VARYING(254) | 254 |
| 15 | CANCEL_REASON | CHARACTER VARYING(254) | 254 |
| 16 | DECLINE_REASON | CHARACTER VARYING(254) | 254 |
| 17 | STATE | CHARACTER VARYING(6) | 6 |
| 18 | ASSESSOR | CHARACTER VARYING(201) | 201 |
| 19 | PENDING_DATE | DATE | 4 |
| 20 | ASSESSMENT_DATE | DATE | 4 |
| 21 | PENDING_INFO_DATE | DATE | 4 |
| 22 | PENDING_APPROVAL_DATE | DATE | 4 |
| 23 | APPROVED_DATE | DATE | 4 |
| 24 | PENDING_CONFIRMATION_DATE | DATE | 4 |
| 25 | REVIEW_DATE | DATE | 4 |
| 26 | SUPERVISOR_DATE | DATE | 4 |
| 27 | APPLY_RELIEF_DATE | DATE | 4 |
| 28 | DECLINED_DATE | DATE | 4 |
| 29 | CANCELLED_DATE | DATE | 4 |
| 30 | COMPLETE_DATE | DATE | 4 |
| 31 | RELIEF_CANCELLED_DATE | DATE | 4 |
| 32 | CLOSED_DATE | DATE | 4 |
| 33 | CREATED_BY | CHARACTER VARYING(255) | 255 |
| 34 | APPROVED_BY_COMMENTS | CHARACTER VARYING(254) | 254 |