FCT_BNK_DV_ACCOUNTS_IN_ARREARS_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(128) 128
2 PERIOD_DT TIMESTAMP 8
3 TIME_PERIOD DATE 4
4 MONTH_START DATE 4
5 PREVIOUS_TIME_PERIOD DATE 4
6 IS_DELINQUENT CHARACTER(1) 1
7 CNT_NO_OF_ACCTS INTEGER 4
8 ACCOUNT_EXISTS_IN_ARREARS_PREV INTEGER 4
9 OUTSTANDING_AMOUNT NUMERIC(38,16) 19
10 TOTAL_AMT DOUBLE PRECISION 8
11 PREVIOUS_MONTH_OUTSTANDING_AMOUNT NUMERIC(38,16) 19
12 OVERDUE_AMOUNT NUMERIC(38,16) 19
13 DPD SMALLINT 2
14 DPD_BUCKET CHARACTER VARYING(10) 10
15 PREV_MON_DPD_BUCKET CHARACTER VARYING(10) 10
16 NO_CHANGE_BUCKET_INDICATOR INTEGER 4
17 CHANGE_BUCKET_INDICATOR INTEGER 4
18 HARDSHIP_INDICATOR CHARACTER VARYING(1) 1
19 HARDSHIP_SUBMITTED INTEGER 4
20 APPROVED_HARDSHIP_ACCOUNT INTEGER 4
21 DELINQUENCY_RSN CHARACTER VARYING(40) 40
22 REASONS CHARACTER VARYING(40) 40
23 CURED INTEGER 4
24 PTP INTEGER 4
25 SALES_USER_ID CHARACTER VARYING(254) 254
26 ORIG_BRANCH CHARACTER VARYING(10) 10
27 SERVICE_BRANCH CHARACTER VARYING(10) 10
28 PRODUCT_CLASS CHARACTER VARYING(2) 2
29 PRODUCT_GRP CHARACTER VARYING(30) 30
30 PRODUCT_OFFER CHARACTER VARYING(120) 120
31 LOAN_SUBPURPOSE CHARACTER VARYING(200) 200
32 ORIG_LOAN_AMT DOUBLE PRECISION 8
33 LOAN_START_DT TIMESTAMP 8
34 MATURITY_DT TIMESTAMP 8
35 LVR DOUBLE PRECISION 8
36 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
37 CHANNEL CHARACTER VARYING(400) 400
38 PRODUCT CHARACTER VARYING(120) 120
39 LOAN_PURPOSE CHARACTER VARYING(200) 200
40 PURPOSE CHARACTER VARYING(200) 200
41 INTEREST_TYPE CHARACTER VARYING(30) 30
42 APPROVED_AMOUNT DOUBLE PRECISION 8
43 VALUE_TIER CHARACTER VARYING(10) 10
44 USAGE_TYPE CHARACTER VARYING(14) 14
45 GROUP_LVR_MV DOUBLE PRECISION 8
46 LVR_GROUP CHARACTER VARYING(9) 9
47 ORIGINATOR_USER_ID CHARACTER VARYING(254) 254
48 CAMPAIGN_INDICATOR INTEGER 4
49 RISK_RATE DOUBLE PRECISION 8
50 MORTGAGE_INSURANCE CHARACTER VARYING(3) 3
51 POLICY_NAME CHARACTER VARYING(250) 250
52 POLICY_EXCEPTION_INDICATOR INTEGER 4
53 INSURANCE_PREMIUM_EXCEPTION INTEGER 4
54 INSURED_AMOUNT DOUBLE PRECISION 8
55 FIRST_PAYMENT_DEFAULT INTEGER 4
56 STATE CHARACTER VARYING(3) 3
57 REGION CHARACTER VARYING(240) 240
58 COST_CENTRE CHARACTER VARYING(240) 240
59 APPROVAL CHARACTER VARYING(50) 50
60 PROCESSING CHARACTER VARYING(50) 50
61 POSTAL CHARACTER VARYING(12) 12
62 ORIG_USERNAME CHARACTER VARYING(201) 201
63 SALES_USERNAME CHARACTER VARYING(201) 201
64 SALES_OFFICER CHARACTER VARYING(201) 201
65 MATURITY_IN_YEARS NUMERIC(24,6) 19
66 ARREARS_IN_MONTHS BIGINT 8
67 ACCT_YEAR BIGINT 8
68 IN_COLLECTIONS CHARACTER(1) 1
69 OUTSTANDING_PERCENTAGE DOUBLE PRECISION 8
70 ARREARS_IN_YEAR BIGINT 8
71 STATUS CHARACTER VARYING(12) 12