FCT_UNIFIED_BANK_ANALYTICS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER NUMERIC(28,0) 19
2 ID_NUMBER CHARACTER VARYING(50) 50
3 ACCOUNT_STATUS CHARACTER VARYING(50) 50
4 AMORTISATION_TYPE_CODE CHARACTER VARYING(20) 20
5 CLMS_GROUP_NUMBER BIGINT 8
6 DEPOSIT_OFFSET_ACCOUNT NUMERIC(25,0) 19
7 INTEREST_RATE_CLASSIFICATION CHARACTER VARYING(5) 5
8 LOW_DOC_FLAG CHARACTER VARYING(1) 1
9 LOW_DOC_FLAG_ORIGINATION CHARACTER VARYING(1) 1
10 LOAN_PURPOSE_CODE CHARACTER VARYING(6) 6
11 LOAN_SUB_PURPOSE_CODE CHARACTER VARYING(15) 15
12 LVR_ERM NUMERIC(14,4) 19
13 LVR_ERM_BAND CHARACTER VARYING(20) 20
14 MORTGAGE_INSURANCE_INDICATOR CHARACTER VARYING(1) 1
15 OD_SECURED_FLAG CHARACTER VARYING(1) 1
16 PAST_DUE_CATEGORY CHARACTER VARYING(20) 20
17 ORACLE_GL_PRODUCT CHARACTER VARYING(10) 10
18 LOAN_TERM BIGINT 8
19 BANK_GUARANTEE_INDICATOR CHARACTER VARYING(1) 1
20 PRODUCT_CODE_1 CHARACTER VARYING(16) 16
21 PRODUCT_CODE_2 CHARACTER VARYING(65) 65
22 PROPERTY_RIGHTS CHARACTER VARYING(25) 25
23 QRM_ACCOUNT CHARACTER VARYING(75) 75
24 SECUR_LOANS_CAPITAL_RELIEF CHARACTER VARYING(1) 1
25 SOURCE_SYSTEM CHARACTER VARYING(4) 4
26 IMPDPASTDUE_FLAG CHARACTER VARYING(1) 1
27 BROKER_ORIGINATED_FLAG CHARACTER VARYING(1) 1
28 ACCREDITED_BROKER_CODE CHARACTER VARYING(9) 9
29 BROKER_CODE CHARACTER VARYING(9) 9
30 SECONDARY_OFFICER_CODE CHARACTER VARYING(10) 10
31 COMPOSITE_COUNTERPARTY_BDM CHARACTER VARYING(6) 6
32 COUNTERPARTY_BDM BIGINT 8
33 ACCOUNT_BDM CHARACTER VARYING(6) 6
34 ANZSIC_CODE CHARACTER VARYING(4) 4
35 ANZSIC_APRA_CATEGORIES CHARACTER VARYING(50) 50
36 ANZSIC_LEVEL_1 CHARACTER VARYING(100) 100
37 ANZSIC_LEVEL_2 CHARACTER VARYING(100) 100
38 ANZSIC_LEVEL_3 CHARACTER VARYING(130) 130
39 ANZSIC_LEVEL_4 CHARACTER VARYING(100) 100
40 ANZSIC_RBA_CATEGORIES CHARACTER VARYING(100) 100
41 ANZSIC_SML_FINANCE_CAT CHARACTER VARYING(100) 100
42 APRA_CATEGORY BIGINT 8
43 APRA_CLASS BIGINT 8
44 PORTFOLIO_DATE TIMESTAMP 8
45 COMPOSITE_NEXT_REVIEW_DATE TIMESTAMP 8
46 LAST_REPRICE_DATE TIMESTAMP 8
47 MATURITY_DATE TIMESTAMP 8
48 MONTH_ON_BOOK NUMERIC(17,9) 19
49 NEXT_PAYMENT_DATE TIMESTAMP 8
50 NEXT_RATE_REVIEW_DATE TIMESTAMP 8
51 NEXT_REPRICE_DATE TIMESTAMP 8
52 SETTLEMENT_DATE TIMESTAMP 8
53 ORIGINATION_DATE TIMESTAMP 8
54 COUNTERPARTY_POSTCODE CHARACTER VARYING(10) 10
55 COUNTERPARTY_ABS_REGION CHARACTER VARYING(50) 50
56 COUNTERPARTY_RESIDENT_FLAG CHARACTER VARYING(5) 5
57 COUNTERPARTY_GCIS_CUSTOMER_NO NUMERIC(16,0) 19
58 COUNTERPARTY_STATE CHARACTER VARYING(35) 35
59 COUNTERPARTY_TYPE CHARACTER VARYING(50) 50
60 NUM_BORR BIGINT 8
61 BALANCE_SHEET_INDICATOR CHARACTER VARYING(1) 1
62 CUR_NET_RATE NUMERIC(10,4) 19
63 TP_ADDON_RATE NUMERIC(8,4) 19
64 TP_BASE_RATE NUMERIC(8,4) 19
65 TP_BASIS_COST NUMERIC(8,4) 19
66 TP_LIQUIDITY_RATE NUMERIC(8,4) 19
67 ORACLE_GL_COST_CENTRE CHARACTER VARYING(10) 10
68 ORACLE_GL_COST_CENTRE_CHANNEL CHARACTER VARYING(40) 40
69 ORACLE_GL_COST_CENTRE_EGM CHARACTER VARYING(50) 50
70 ORACLE_GL_COST_CENTRE_NAME CHARACTER VARYING(100) 100
71 ORACLE_GL_COST_CENTRE_REGION CHARACTER VARYING(50) 50
72 ORACLE_GL_COST_CENTRE_STATE CHARACTER VARYING(40) 40
73 AVERAGE_MONTHLY_BALANCE NUMERIC(15,2) 19
74 AVAILABLE_CASHBACK NUMERIC(15,2) 19
75 CALC_ADVANCE_AMT NUMERIC(15,2) 19
76 CURRENT_PAYMENT NUMERIC(15,2) 19
77 DEPOSIT_OFFSET_BALANCE NUMERIC(15,2) 19
78 EXPECTED_LOSS NUMERIC(19,4) 19
79 EXPECTED_LOSS_RAROC NUMERIC(19,4) 19
80 EXPOSURE NUMERIC(15,2) 19
81 FACE_AMT NUMERIC(19,4) 19
82 EAD_ON_BAL NUMERIC(19,4) 19
83 LIMIT_CALCULATED NUMERIC(15,2) 19
84 ORIGINAL_LOAN_AMOUNT NUMERIC(15,2) 19
85 PAST_DUE_AMOUNT NUMERIC(15,2) 19
86 TBE NUMERIC(15,2) 19
87 TCE NUMERIC(15,2) 19
88 RWA_OFF_BAL NUMERIC(19,4) 19
89 RWA_ON_BAL NUMERIC(19,4) 19
90 INT_RATE_CUR_VALUE NUMERIC(38,14) 19
91 TP_ADDON_VALUE NUMERIC(38,14) 19
92 TP_BASE_VALUE NUMERIC(38,14) 19
93 TP_BASIS_VALUE NUMERIC(38,14) 19
94 TP_LIQUIDITY_VALUE NUMERIC(38,14) 19
95 TP_SPREAD_VALUE NUMERIC(38,6) 19
96 TP_SPREAD_RATE NUMERIC(13,4) 19
97 TP_SPREAD_TO_BBSW_VALUE NUMERIC(38,6) 19
98 TP_SPREAD_TO_BBSW_RATE NUMERIC(11,4) 19
99 STD_RWA NUMERIC(20,4) 19
100 TD_TERM_LENGTH INTERVAL 12
101 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
102 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
103 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
104 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
105 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
106 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
107 EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
108 FULL_NAME CHARACTER VARYING(201) 201
109 FIRST_NAME CHARACTER VARYING(100) 100
110 PREFERRED_NAME CHARACTER VARYING(100) 100
111 SURNAME CHARACTER VARYING(100) 100
112 POSITION_TITLE CHARACTER VARYING(256) 256
113 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
114 EMPLOYEE_FTE NUMERIC(18,6) 19
115 POSITION_START_DATE TIMESTAMP 8
116 EFFECTIVEDATE TIMESTAMP 8
117 PRODUCT_1_DESC CHARACTER VARYING(100) 100
118 PRODUCT_2_DESC CHARACTER VARYING(100) 100
119 PRODUCT_3_DESC CHARACTER VARYING(100) 100
120 PRODUCT_4_DESC CHARACTER VARYING(100) 100
121 PRODUCT_5_DESC CHARACTER VARYING(100) 100
122 CLMS_CODE NUMERIC(31,0) 19
123 SEC_OFF_CODE NATIONAL CHARACTER VARYING(5) 5
124 BDM_USER_ID NATIONAL CHARACTER VARYING(8) 8
125 BDM_NAME NATIONAL CHARACTER VARYING(100) 100
126 UPFRONT_COMM NUMERIC(38,3) 19
127 TRAIL_COMM NUMERIC(38,3) 19
128 CLAWBACK_COMM NUMERIC(38,3) 19
129 CAP_ADJ_AMOUNT NUMERIC(15,2) 19
130 TP_LIQUIDITY_CALCULATION NUMERIC(15,2) 19
131 TP_LIQUIDITY_RUNOFF_CATEGORY CHARACTER VARYING(50) 50
132 TP_FUNDING_ALLOCATION_RATE NUMERIC(8,4) 19
133 TP_FUNDING_ALLOCATION NUMERIC(19,6) 19
134 CR_RWA_TOTAL_FIRB NUMERIC(19,4) 19
135 ECAP_IRR_CAPITAL NUMERIC(19,4) 19
136 ECAP_MR_CAPITAL NUMERIC(19,4) 19
137 ECAP_OR_CAPITAL NUMERIC(19,4) 19
138 ECAP_BR_CAPITAL NUMERIC(19,4) 19
139 CR_UL_ECAP NUMERIC(19,4) 19
140 COLLATERAL_PRIMARY_ABS_REGION CHARACTER VARYING(255) 255
141 COLLATERAL_PRIMARY_CATEGORY CHARACTER VARYING(50) 50
142 COLLATERAL_PRIMARY_PCODE CHARACTER VARYING(10) 10
143 COLLATERAL_PRIMARY_STATE CHARACTER VARYING(10) 10
144 COLLATERAL_PRIMARY_USE_TYPE CHARACTER VARYING(50) 50
145 CREDIT_RISK_FLAG CHARACTER VARYING(2) 2
146 NET_SALES NUMERIC(15,2) 19
147 COMPOSITE_RATINGS_MODEL_DESC CHARACTER VARYING(10) 10
148 COMPOSITE_CDR CHARACTER VARYING(2) 2
149 COUNTERPARTY_CDR CHARACTER VARYING(2) 2
150 ACCOUNT_CDR CHARACTER VARYING(2) 2
151 SECURITISATION_REPORTABLE CHARACTER VARYING(3) 3
152 TCE_GROUP_ID BIGINT 8
153 CEA_OFF_BAL NUMERIC(19,4) 19
154 DR_CR_FLAG CHARACTER VARYING(9) 9
155 NET_CREDIT_EXPOSURE NUMERIC(15,2) 19
156 COUNTERPARTY_SOURCE_CUSTOMER_NO NUMERIC(16,0) 19
157 IMPAIRED_FLAG_DRS CHARACTER VARYING(1) 1
158 INBA NUMERIC(15,2) 19
159 RISKGRADE_FINEAPPRISKGRADE_SCOR BIGINT 8
160 CTR_OUTCOME NUMERIC(15,2) 19
161 GROSSINCOME NUMERIC(15,2) 19
162 CONNECTED_CUSTOMER_ASSOCIATED CHARACTER VARYING(1) 1
163 SMALL_BUSINESS_SECURITY_CODE CHARACTER VARYING(3) 3
164 PAYMENT_PAUSE_FLAG CHARACTER VARYING(1) 1
165 DYNAMIC_LVR NUMERIC(15,2) 19