FCT_BANK_CAPITAL_AND_RISK

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BANK_CAPITAL_AND_RISK_V

Target Objects (CTAS)

INSNZP02_BANK..FCT_BANK_CAPITAL_AND_RISK_INSIGHT

Synonyms

SDSNZP02_BANK..ESTAT_FCT_BANK_CAPITAL_AND_RISK

Columns
# Name Data Type Length
1 PERIOD_DIM_ID CHARACTER VARYING(200) 200
2 ALL_TIME_SID BIGINT 8
3 CALENDAR_PERIOD_END_DATE TIMESTAMP 8
4 ACCOUNT_NUMBER NUMERIC(28,0) 19
5 ID_NUMBER CHARACTER VARYING(50) 50
6 ORACLE_GL_COST_CENTRE_REGION CHARACTER VARYING(50) 50
7 QRM_ACCOUNT_CM CHARACTER VARYING(50) 50
8 QRM_ACCOUNT CHARACTER VARYING(75) 75
9 CCF_113 CHARACTER VARYING(3) 3
10 CCF_112 CHARACTER VARYING(3) 3
11 CCF_FIRB NUMERIC(5,2) 19
12 EAD_113 INTEGER 4
13 CR_EAD_ECAP INTEGER 4
14 EL_113 CHARACTER VARYING(3) 3
15 EL_ECAP INTEGER 4
16 CR_EL_PM INTEGER 4
17 LGD_113 CHARACTER VARYING(3) 3
18 CR_LGD_TTC NUMERIC(10,6) 19
19 CR_PD_TTC NUMERIC(14,6) 19
20 RISK_WEIGHT_113 CHARACTER VARYING(3) 3
21 RISK_WEIGHT_ECAP CHARACTER VARYING(3) 3
22 RWA_TOTAL_113 INTEGER 4
23 RWA_TOTAL_ECAP INTEGER 4
24 CR_UL_AIRB INTEGER 4
25 UL_ECAP INTEGER 4
26 IRR_CAPITAL_ECAP INTEGER 4
27 IRR_RISK_WEIGHT_ECAP CHARACTER VARYING(3) 3
28 IRR_RWA_TOTAL_ECAP INTEGER 4
29 MR_CAPITAL_ECAP INTEGER 4
30 MR_RISK_WEIGHT_ECAP CHARACTER VARYING(3) 3
31 MR_RWA_TOTAL_ECAP INTEGER 4
32 OR_CAPITAL_ECAP INTEGER 4
33 OR_RISK_WEIGHT_ECAP CHARACTER VARYING(3) 3
34 OR_RWA_TOTAL_ECAP INTEGER 4
35 BR_CAPITAL_ECAP INTEGER 4
36 BR_RISK_WEIGHT_ECAP CHARACTER VARYING(3) 3
37 BR_RWA_TOTAL_ECAP INTEGER 4
38 AGG_CAPITAL_ECAP INTEGER 4
39 AGG_RISK_WEIGHT_ECAP CHARACTER VARYING(3) 3
40 AGG_RWA_TOTAL_ECAP INTEGER 4
41 CR_CAPITAL_ECAP NUMERIC(19,4) 19
42 CR_CAPITAL_AIRB CHARACTER VARYING(3) 3
43 EAD_TOTAL_FIRB NUMERIC(19,4) 19
44 EXPECTED_LOSS_FIRB NUMERIC(19,4) 19
45 RWA_TOTAL_FIRB NUMERIC(19,4) 19
46 UNEXPECTED_LOSS_FIRB NUMERIC(19,4) 19
47 INBA NUMERIC(15,2) 19
48 PROVISION_AMOUNT NUMERIC(15,2) 19
49 PROVISION_AMT_ADJ NUMERIC(15,2) 19
50 PROVISION_AMOUNT_COLLECTIVE NUMERIC(19,4) 19
51 PROVISION_AMOUNT_IFRS NUMERIC(19,4) 19
52 DIV_VAR1 CHARACTER VARYING(3) 3
53 DIV_VAR2 CHARACTER VARYING(3) 3
54 DIV_VAR3 CHARACTER VARYING(3) 3
55 OF_ACCOUNT_CODE CHARACTER VARYING(10) 10
56 OF_ENTITY_CODE CHARACTER VARYING(22) 22
57 OF_PRODUCT_CODE CHARACTER VARYING(10) 10
58 OF_COST_CENTRE_CODE CHARACTER VARYING(10) 10
59 OF_CATEGORY_CODE CHARACTER VARYING(3) 3
60 RISK_WEIGHT_112 CHARACTER VARYING(3) 3
61 RWA_OFF_BAL_112 INTEGER 4
62 RWA_ON_BAL_112 INTEGER 4
63 NET_CREDIT_EXPOSURE_112 CHARACTER VARYING(3) 3
64 AMORTISATION_TYPE_CODE CHARACTER VARYING(20) 20
65 AVERAGE_MONTHLY_BALANCE NUMERIC(15,2) 19
66 BROKER_ORIGINATED_FLAG CHARACTER VARYING(1) 1
67 COUNTERPARTY_NAME CHARACTER VARYING(255) 255
68 CUR_NET_RATE NUMERIC(10,4) 19
69 CURRENT_PAYMENT NUMERIC(15,2) 19
70 DEPOSIT_OFFSET_ACCOUNT NUMERIC(25,0) 19
71 DEPOSIT_OFFSET_BALANCE NUMERIC(15,2) 19
72 DEPOSIT_OFFSET_RATE NUMERIC(9,5) 19
73 FACE_AMT NUMERIC(19,4) 19
74 INTEREST_RATE_CLASSIFICATION CHARACTER VARYING(5) 5
75 SETTLEMENT_DATE TIMESTAMP 8
76 LAST_REPRICE_DATE TIMESTAMP 8
77 LOW_DOC_FLAG CHARACTER VARYING(1) 1
78 LVR_ERM NUMERIC(14,4) 19
79 LVR_ERM_BAND CHARACTER VARYING(20) 20
80 LVR_EST_GROUP NUMERIC(15,4) 19
81 LVR_ORIGINATION NUMERIC(9,2) 19
82 LVR_TARGET CHARACTER VARYING(3) 3
83 MATURITY_DATE TIMESTAMP 8
84 NEXT_REPRICE_DATE TIMESTAMP 8
85 ORIGINATION_DATE TIMESTAMP 8
86 PRODUCT_CODE_1 CHARACTER VARYING(16) 16
87 PRODUCT_CODE_2 CHARACTER VARYING(15) 15
88 SOURCE_SYSTEM CHARACTER VARYING(4) 4
89 TP_ADDON_RATE NUMERIC(8,4) 19
90 TP_BASE_RATE NUMERIC(8,4) 19
91 TP_BASIS_COST NUMERIC(8,4) 19
92 TP_STATUS CHARACTER VARYING(20) 20
93 ORACLE_GL_COST_CENTRE_CHANNEL CHARACTER VARYING(40) 40
94 CR_LGD_PIT CHARACTER VARYING(3) 3
95 CR_PD_PIT CHARACTER VARYING(3) 3
96 PROPERTY_RIGHTS CHARACTER VARYING(25) 25
97 BALANCE_SHEET_INDICATOR CHARACTER VARYING(1) 1
98 CR_PD_SCORE CHARACTER VARYING(50) 50
99 EXPOSURE NUMERIC(15,2) 19
100 INTERNAL_DT_LGD NUMERIC(10,6) 19
101 INTERNAL_TTC_PD NUMERIC(10,6) 19
102 ECAP_BR_RWA_AMA NUMERIC(15,2) 19
103 ECAP_IRR_RWA_AMA NUMERIC(19,4) 19
104 ECAP_MR_RWA_AMA NUMERIC(19,4) 19
105 ECAP_MR_RWA_STD NUMERIC(19,4) 19
106 ECAP_OR_RWA_AMA NUMERIC(19,4) 19
107 ECAP_OR_RWA_STD NUMERIC(19,4) 19
108 TTCPD_RISK_GRADE CHARACTER VARYING(2) 2
109 TTCPD_TOTAL_SCORE NUMERIC(8,3) 19
110 MONTH_ON_BOOK NUMERIC(17,9) 19
111 APRA_ASSET_CLASS CHARACTER VARYING(100) 100
112 APRA_ASSET_CLASS_IRB CHARACTER VARYING(100) 100
113 APRA_OFF_BAL_TRANS_TYPE CHARACTER VARYING(100) 100
114 ECAP_CAPITAL_ADJUSTMENT_AMOUNT NUMERIC(19,4) 19
115 CAPITAL_ADJUSTMENT_RATE NUMERIC(8,4) 19
116 COUNTERPARTY_POSTCODE CHARACTER VARYING(10) 10
117 COUNTERPARTY_STATE CHARACTER VARYING(35) 35
118 CR_LGD_SCORE CHARACTER VARYING(3) 3
119 LGD_SCORE_CP CHARACTER VARYING(3) 3
120 PD_SCORE_CP CHARACTER VARYING(3) 3
121 PORTFOLIO_FIRB CHARACTER VARYING(100) 100
122 PORTFOLIO_CP CHARACTER VARYING(3) 3
123 RISK_WEIGHT_FIRB NUMERIC(8,4) 19
124 RWA_OFF_BAL_FIRB NUMERIC(19,4) 19
125 RWA_ON_BAL_FIRB NUMERIC(19,4) 19
126 DIV_CAPITAL_ECAP INTEGER 4
127 DIV_RWA_TOTAL_ECAP INTEGER 4
128 EAD_ON_BAL NUMERIC(19,4) 19
129 EXPECTED_LOSS NUMERIC(19,4) 19
130 INT_RATE_ADD_ON CHARACTER VARYING(3) 3
131 INTEREST_RATE_BASE NUMERIC(15,4) 19
132 INT_RATE_CUR NUMERIC(10,4) 19
133 INTEREST_RATE_MARGIN NUMERIC(15,4) 19
134 INT_RATE_PENALTY_MARGIN CHARACTER VARYING(3) 3
135 INT_RATE_TYPE CHARACTER VARYING(3) 3
136 LOAN_PURPOSE_CODE CHARACTER VARYING(6) 6
137 TARGET_LVR NUMERIC(7,2) 19
138 MORTGAGE_INSURANCE_INDICATOR CHARACTER VARYING(1) 1
139 OFF_BAL_LIKELY_TO_DRAW_FACTOR NUMERIC(10,4) 19
140 OFF_BAL_PRINCIPAL_AMT NUMERIC(19,4) 19
141 OVERDUE_REVIEW_FLAG CHARACTER VARYING(1) 1
142 PAST_DUE_AMOUNT NUMERIC(15,2) 19
143 PAST_DUE_CATEGORY CHARACTER VARYING(20) 20
144 PAYMENT_FREQUENCY CHARACTER VARYING(30) 30
145 PRODUCT_CODE CHARACTER VARYING(16) 16
146 PRODUCT_DESCRIPTION CHARACTER VARYING(100) 100
147 QRM_PRODUCT_CM CHARACTER VARYING(50) 50
148 RATE_INDEX CHARACTER VARYING(30) 30
149 TP_FUNDING_INDEX CHARACTER VARYING(30) 30
150 TP_IRR_CALCULATION NUMERIC(15,4) 19
151 TP_TRANSFER_SPREAD_CALCULATION NUMERIC(15,4) 19
152 TP_WEIGHTED_AVERAGE_BASE_RATE NUMERIC(8,4) 19
153 TRADING_BOOK_FLAG CHARACTER VARYING(1) 1
154 TRANSFER_RATE NUMERIC(12,6) 19
155 TRANSFER_SPREAD NUMERIC(8,5) 19
156 TARGET_CAPITAL_ADEQUACY NUMERIC(8,4) 19
157 YIELD_CURVE CHARACTER VARYING(30) 30
158 LOOKUP_TYPE CHARACTER VARYING(100) 100
159 BEC_COMBINED_PRODUCT CHARACTER VARYING(100) 100
160 BEC_COMBINED_PRODUCT_GL_HIER CHARACTER VARYING(100) 100