FCT_BNK_QRM_ILP_DAILY_MASTER_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP extract consumed by QRM providing loan account details at account grain

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 KEY_COID CHARACTER VARYING(1) 1
3 KEY_PROD CHARACTER VARYING(30) 30
4 KEY_ACCT CHARACTER VARYING(40) 40
5 FACILITY_ID CHARACTER VARYING(40) 40
6 ACCT_STATUS CHARACTER VARYING(50) 50
7 ANZSIC_CODE CHARACTER VARYING(4) 4
8 BILL_TYPE CHARACTER VARYING(128) 128
9 BILL_FREQUENCY CHARACTER VARYING(30) 30
10 BILL_PERIOD CHARACTER VARYING(30) 30
11 BILL_AMOUNT NUMERIC(18,2) 19
12 SUB_PRDCT_CD CHARACTER VARYING(30) 30
13 ORIG_BR CHARACTER VARYING(10) 10
14 SRVC_BR CHARACTER VARYING(240) 240
15 DT_OPENED CHARACTER VARYING(200) 200
16 DT_CLOSED CHARACTER VARYING(200) 200
17 SETTLEMENT_DATE CHARACTER VARYING(200) 200
18 DT_CURR_MAT CHARACTER VARYING(200) 200
19 DC_LOAN_TRM BIGINT 8
20 SECUR_STATUS CHARACTER VARYING(1) 1
21 SECUR_POOL CHARACTER VARYING(10) 10
22 SHORT_NAME CHARACTER VARYING(300) 300
23 COST_CENTER CHARACTER VARYING(240) 240
24 ACCRED_BRKR_CDE CHARACTER VARYING(20) 20
25 BROKER_CD CHARACTER VARYING(20) 20
26 PRIM_OFFICER CHARACTER VARYING(50) 50
27 SECONDARY_OFFICER CHARACTER VARYING(40) 40
28 APPROVAL_DATE CHARACTER VARYING(200) 200
29 CURR_BAL NUMERIC(35,2) 19
30 CALC_AMT_DUE NUMERIC(35,2) 19
31 AVL_CASHBACK NUMERIC(35,2) 19
32 NBR_DAY_PDUE DOUBLE PRECISION 8
33 EFF_DT_LST_PYMT CHARACTER VARYING(200) 200
34 ANNUAL_RATE DOUBLE PRECISION 8
35 AMT_ACCR_NOBL NUMERIC(35,2) 19
36 UNRND_PPMT_AMT NUMERIC(35,2) 19
37 CALC_AVAIL_BAL NUMERIC(35,2) 19
38 MORTGAGE_INS_INDICATOR CHARACTER VARYING(1) 1
39 INS_CMPY CHARACTER VARYING(50) 50
40 TOT_AMT_PDUE NUMERIC(35,2) 19
41 TOT_NBR_TM_PDUE BIGINT 8
42 LOAN_PUR CHARACTER VARYING(40) 40
43 LOAN_SUB_PUR CHARACTER VARYING(10) 10
44 LOW_DOC_FLAG CHARACTER VARYING(1) 1
45 NXT_DUE_DT CHARACTER VARYING(200) 200
46 AMT_ORIG_LOAN NUMERIC(35,2) 19
47 CAP_RATE_END_DATE CHARACTER VARYING(200) 200
48 LNDG_POLICY CHARACTER VARYING(1) 1
49 PROP_RHT CHARACTER VARYING(1) 1
50 GL_TYP_CD CHARACTER VARYING(31) 31
51 OFF_IDS_ACCT CHARACTER VARYING(16) 16
52 OFF_IDS_PRODUCT CHARACTER VARYING(30) 30
53 OFF_IDS_RATE DOUBLE PRECISION 8
54 OFF_STATUS CHARACTER VARYING(1) 1
55 ADJUSTABLE_TYPE_CD CHARACTER VARYING(30) 30
56 CL_LFR_LAST_RATE_CHANGE_DATE CHARACTER VARYING(200) 200
57 NXT_RT_CHG_DT CHARACTER VARYING(1) 1
58 AGGR_NET_BAL_MTD NUMERIC(35,2) 19
59 AGGR_DAY_MTD NUMERIC(38,0) 19
60 START_DATE CHARACTER VARYING(1) 1
61 END_DATE CHARACTER VARYING(1) 1
62 ORIG_LVR DOUBLE PRECISION 8
63 CALC_ADVANCE_AMT NUMERIC(35,2) 19
64 WRITE_OFF_DATE CHARACTER VARYING(200) 200
65 WRITE_OFF_REASON_CODE CHARACTER VARYING(255) 255
66 BALANCE_BEFORE_CLOSING NUMERIC(35,2) 19
67 REPOSSESSION_DATE CHARACTER VARYING(200) 200
68 MORTGAGE_INSURED_AMOUNT NUMERIC(35,2) 19
69 LN_APPL_NBR CHARACTER VARYING(50) 50
70 INT_ONLY_TERM_MTHS INTEGER 4
71 PAYMENT_TYPE CHARACTER VARYING(22) 22
72 IS_SPLIT CHARACTER(1) 1
73 RELATED_SPLITS CHARACTER VARYING(40) 40
74 PRODUCT_INT_RATE NUMERIC(8,5) 19
75 INT_CAPITALISED_FL CHARACTER VARYING(1) 1
76 REGULATED_FLAG CHARACTER(1) 1
77 LOAN_AMT DOUBLE PRECISION 8
78 FILE_DATE CHARACTER VARYING(200) 200
79 FIXED_RATE_TERM BIGINT 8
80 TOTAL_WRT_OFF_AMT_MTD DOUBLE PRECISION 8
81 CUM_WRT_OFF_AMT DOUBLE PRECISION 8
82 FEE_ARREARS_AMT DOUBLE PRECISION 8
83 IO_START_DATE CHARACTER VARYING(200) 200
84 IO_END_DATE CHARACTER VARYING(200) 200
85 PAYMENT_PAUSE_FLAG CHARACTER VARYING(1) 1
86 ONLINE_CHANNEL_FLAG CHARACTER VARYING(1) 1