FCT_BNK_COLLECTION_HARDSHIP_APPLN_REPORT_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

Applications for Hardship support by account with the case and application details (removes duplication from mutiple customers)

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_COLLECTION_HARDSHIP_APPLN_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 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