FCT_BANK_PORTFOLIO_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BANK_PORTFOLIO

Synonyms

INSNZP01_BANK..SYN_FCT_BANK_PORTFOLIO_INSIGHT

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 CAP_ADJ_AMOUNT NUMERIC(15,2) 19
127 TP_LIQUIDITY_CALCULATION NUMERIC(15,2) 19
128 TP_LIQUIDITY_RUNOFF_CATEGORY CHARACTER VARYING(50) 50
129 TP_FUNDING_ALLOCATION_RATE NUMERIC(8,4) 19
130 TP_FUNDING_ALLOCATION NUMERIC(19,6) 19
131 CR_RWA_TOTAL_FIRB NUMERIC(19,4) 19
132 ECAP_IRR_CAPITAL NUMERIC(19,4) 19
133 ECAP_MR_CAPITAL NUMERIC(19,4) 19
134 ECAP_OR_CAPITAL NUMERIC(19,4) 19
135 ECAP_BR_CAPITAL NUMERIC(19,4) 19
136 CR_UL_ECAP NUMERIC(19,4) 19
137 COLLATERAL_PRIMARY_ABS_REGION CHARACTER VARYING(255) 255
138 COLLATERAL_PRIMARY_CATEGORY CHARACTER VARYING(50) 50
139 COLLATERAL_PRIMARY_PCODE CHARACTER VARYING(10) 10
140 COLLATERAL_PRIMARY_STATE CHARACTER VARYING(10) 10
141 COLLATERAL_PRIMARY_USE_TYPE CHARACTER VARYING(50) 50
142 CREDIT_RISK_FLAG CHARACTER VARYING(2) 2
143 NET_SALES NUMERIC(15,2) 19
144 COMPOSITE_RATINGS_MODEL_DESC CHARACTER VARYING(10) 10
145 COMPOSITE_CDR CHARACTER VARYING(2) 2
146 COUNTERPARTY_CDR CHARACTER VARYING(2) 2
147 ACCOUNT_CDR CHARACTER VARYING(2) 2
148 SECURITISATION_REPORTABLE CHARACTER VARYING(3) 3
149 TCE_GROUP_ID BIGINT 8
150 CEA_OFF_BAL NUMERIC(19,4) 19
151 DR_CR_FLAG CHARACTER VARYING(9) 9
152 NET_CREDIT_EXPOSURE NUMERIC(15,2) 19
153 COUNTERPARTY_SOURCE_CUSTOMER_NO NUMERIC(16,0) 19
154 IMPAIRED_FLAG_DRS CHARACTER VARYING(1) 1
155 INBA NUMERIC(15,2) 19
156 RISKGRADE_FINEAPPRISKGRADE_SCOR BIGINT 8
157 CTR_OUTCOME NUMERIC(15,2) 19
158 GROSSINCOME NUMERIC(15,2) 19
159 OFF_BAL_PRINCIPAL_AMT NUMERIC(19,4) 19
160 SMALL_BUSINESS_SECURITY_CODE CHARACTER VARYING(3) 3
161 PAYMENT_PAUSE_FLAG CHARACTER VARYING(1) 1
162 DYNAMIC_LVR NUMERIC(15,2) 19