INT_BANK_PORTFOLIO

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_BANK_PORTFOLIO_V

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(15) 15
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 BIGINT 8
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_RATE NUMERIC(13,4) 19
96 TP_SPREAD_VALUE NUMERIC(38,6) 19
97 TP_SPREAD_TO_BBSW_RATE NUMERIC(11,4) 19
98 TP_SPREAD_TO_BBSW_VALUE NUMERIC(38,6) 19
99 STD_RWA NUMERIC(20,4) 19
100 TD_TERM_LENGTH INTERVAL 12
101 CAP_ADJ_AMOUNT NUMERIC(15,2) 19
102 TP_LIQUIDITY_CALCULATION NUMERIC(15,2) 19
103 TP_LIQUIDITY_RUNOFF_CATEGORY CHARACTER VARYING(50) 50
104 TP_FUNDING_ALLOCATION_RATE NUMERIC(8,4) 19
105 TP_FUNDING_ALLOCATION NUMERIC(19,6) 19
106 CR_RWA_TOTAL_FIRB NUMERIC(19,4) 19
107 ECAP_IRR_CAPITAL NUMERIC(19,4) 19
108 ECAP_MR_CAPITAL NUMERIC(19,4) 19
109 ECAP_OR_CAPITAL NUMERIC(19,4) 19
110 ECAP_BR_CAPITAL NUMERIC(19,4) 19
111 CR_UL_ECAP NUMERIC(19,4) 19
112 COLLATERAL_PRIMARY_ABS_REGION CHARACTER VARYING(255) 255
113 COLLATERAL_PRIMARY_CATEGORY CHARACTER VARYING(50) 50
114 COLLATERAL_PRIMARY_PCODE CHARACTER VARYING(10) 10
115 COLLATERAL_PRIMARY_STATE CHARACTER VARYING(10) 10
116 COLLATERAL_PRIMARY_USE_TYPE CHARACTER VARYING(50) 50
117 CREDIT_RISK_FLAG CHARACTER VARYING(2) 2
118 NET_SALES NUMERIC(15,2) 19
119 COMPOSITE_RATINGS_MODEL_DESC CHARACTER VARYING(10) 10
120 COMPOSITE_CDR CHARACTER VARYING(2) 2
121 COUNTERPARTY_CDR CHARACTER VARYING(2) 2
122 ACCOUNT_CDR CHARACTER VARYING(2) 2
123 SECURITISATION_REPORTABLE CHARACTER VARYING(3) 3
124 TCE_GROUP_ID BIGINT 8
125 CEA_OFF_BAL NUMERIC(19,4) 19
126 DR_CR_FLAG CHARACTER VARYING(9) 9
127 NET_CREDIT_EXPOSURE NUMERIC(15,2) 19
128 COUNTERPARTY_SOURCE_CUSTOMER_NO NUMERIC(16,0) 19
129 IMPAIRED_FLAG_DRS CHARACTER VARYING(1) 1
130 INBA NUMERIC(15,2) 19
131 OFF_BAL_PRINCIPAL_AMT NUMERIC(19,4) 19
132 SMALL_BUSINESS_SECURITY_CODE CHARACTER VARYING(3) 3
133 PAYMENT_PAUSE_FLAG CHARACTER VARYING(1) 1
134 DYNAMIC_LVR NUMERIC(15,2) 19