| 1 |
PERIOD_DIM_ID |
CHARACTER VARYING(200) |
200 |
| 2 |
ACCOUNT_NUMBER |
CHARACTER VARYING(200) |
200 |
| 3 |
ONBAL_ACCRUED_INTEREST |
NUMERIC(19,4) |
19 |
| 4 |
ONBAL_ALLOCATED_CASH_COLL_VAL |
NUMERIC(19,4) |
19 |
| 5 |
ANZSIC_CODE |
CHARACTER VARYING(4) |
4 |
| 6 |
APRA_CGY |
CHARACTER VARYING(10) |
10 |
| 7 |
APRA_CLSS_ONBAL |
CHARACTER VARYING(22) |
22 |
| 8 |
APRA_AST_CLSS_ONBAL |
CHARACTER VARYING(100) |
100 |
| 9 |
APRA_ASSET_CLASS_IRB |
CHARACTER VARYING(100) |
100 |
| 10 |
APRA_COUNTERPARTY_TYPE |
CHARACTER VARYING(100) |
100 |
| 11 |
APRA_OFF_BAL_TXN_TYPE |
CHARACTER VARYING(100) |
100 |
| 12 |
APRA_SUB_CGY_ONBAL |
CHARACTER VARYING(10) |
10 |
| 13 |
EXT_RATING_LONG_TERM |
CHARACTER VARYING(5) |
5 |
| 14 |
LGD_CATEGORY_PRESCRIBED |
CHARACTER VARYING(80) |
80 |
| 15 |
SECURITISATION_RISK_SUB_CATEGORY |
CHARACTER VARYING(100) |
100 |
| 16 |
OFF_BAL_NOTIONAL_REDRAW_AMT |
NUMERIC(15,2) |
19 |
| 17 |
AVAILABLE_CASHBACK |
NUMERIC(15,2) |
19 |
| 18 |
BALANCE_SHEET_INDICATOR |
CHARACTER VARYING(1) |
1 |
| 19 |
BANK_GUARANTEE_INDICATOR |
CHARACTER VARYING(1) |
1 |
| 20 |
CANCELLABLE_UNDRAWN |
CHARACTER VARYING(11) |
11 |
| 21 |
CANCELLABLE_REDRAW |
CHARACTER VARYING(9) |
9 |
| 22 |
CREDIT_CONV_FACTOR_GUAR |
NUMERIC(5,2) |
19 |
| 23 |
CREDIT_CONV_FACTOR_UNDRAWN |
NUMERIC(5,2) |
19 |
| 24 |
CREDIT_EQUIVALENT_GUAR_AMT |
NUMERIC(19,4) |
19 |
| 25 |
CREDIT_EQUIVALENT_UNDRAWN_AMT |
NUMERIC(19,4) |
19 |
| 26 |
CREDIT_EQUIVALENT_REDRAW_AMT |
INTEGER |
4 |
| 27 |
CERTAIN_DRAWDOWN |
CHARACTER VARYING(20) |
20 |
| 28 |
CERTAIN_DRAWDOWN_REDRAW |
CHARACTER VARYING(20) |
20 |
| 29 |
CLMS_GROUP_NAME |
CHARACTER VARYING(100) |
100 |
| 30 |
CLMS_GROUP_NUMBER |
BIGINT |
8 |
| 31 |
COUNTERPARTY_COUNTRY_DESCRIPTION |
CHARACTER VARYING(50) |
50 |
| 32 |
CREDIT_CONV_FACTOR_REDRAW |
INTEGER |
4 |
| 33 |
CCF_FIRB |
NUMERIC(5,2) |
19 |
| 34 |
EAD_TOTAL_FIRB |
NUMERIC(19,4) |
19 |
| 35 |
RISK_WEIGHT_FIRB |
NUMERIC(32,24) |
19 |
| 36 |
ECAP_CR_EAD |
NUMERIC(19,4) |
19 |
| 37 |
EXPECTED_LOSS_FIRB |
NUMERIC(19,4) |
19 |
| 38 |
ECAP_CR_EL |
NUMERIC(19,4) |
19 |
| 39 |
LGD_FIRB |
NUMERIC(14,6) |
19 |
| 40 |
LGD_TTC |
NUMERIC(10,6) |
19 |
| 41 |
LGD_PERCENTAGE |
NUMERIC(18,6) |
19 |
| 42 |
PD_TTC_FIRB |
NUMERIC(14,6) |
19 |
| 43 |
PD_PERCENTAGE |
NUMERIC(18,6) |
19 |
| 44 |
RWA_OFF_BAL_FIRB |
NUMERIC(19,4) |
19 |
| 45 |
RWA_ON_BAL_FIRB |
NUMERIC(19,4) |
19 |
| 46 |
RWA_TOTAL_FIRB |
NUMERIC(19,4) |
19 |
| 47 |
ECAP_CR_RWA_TOTAL |
NUMERIC(19,4) |
19 |
| 48 |
UNEXPECTED_LOSS_FIRB |
NUMERIC(19,4) |
19 |
| 49 |
ECAP_CR_CAPITAL |
NUMERIC(19,4) |
19 |
| 50 |
DRAWN_STATUS |
CHARACTER VARYING(20) |
20 |
| 51 |
ONBAL_EAD_POST_CRM_AMOUNT |
NUMERIC(19,4) |
19 |
| 52 |
ONBAL_FACE_AMOUNT |
NUMERIC(19,4) |
19 |
| 53 |
FACE_VALUE |
NUMERIC(19,4) |
19 |
| 54 |
FORWARD_STARTING |
CHARACTER VARYING(9) |
9 |
| 55 |
IMPAIRED_FLAG_DRS_ONBAL |
CHARACTER VARYING(1) |
1 |
| 56 |
ONBAL_INBA_AMOUNT |
NUMERIC(15,2) |
19 |
| 57 |
LOW_DOC_FLAG |
CHARACTER VARYING(1) |
1 |
| 58 |
LVR_ERM |
NUMERIC(14,4) |
19 |
| 59 |
MORTGAGE_INSURANCE_INDICATOR |
CHARACTER VARYING(1) |
1 |
| 60 |
OFF_BAL_UNDRAWN_PRINCIPAL_AMT |
NUMERIC(19,4) |
19 |
| 61 |
OFF_BAL_GUAR_PRINCIPAL_AMT |
NUMERIC(19,4) |
19 |
| 62 |
COUNTERPARTY_TYPE |
CHARACTER VARYING(50) |
50 |
| 63 |
ACR_INT_OF_ACCOUNT_CODE |
CHARACTER VARYING(10) |
10 |
| 64 |
INBA_OF_ACCOUNT_CODE |
CHARACTER VARYING(10) |
10 |
| 65 |
PNP_OF_ACCOUNT_CODE |
CHARACTER VARYING(10) |
10 |
| 66 |
OF_ENTITY_CODE |
CHARACTER VARYING(22) |
22 |
| 67 |
OF_COST_CENTRE_CODE |
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 |
OF_PRODUCT_CODE |
CHARACTER VARYING(10) |
10 |
| 74 |
PORTFOLIO_DATE |
TIMESTAMP |
8 |
| 75 |
PRODUCT_CODE_1 |
CHARACTER VARYING(16) |
16 |
| 76 |
PRODUCT_DESCRIPTION |
CHARACTER VARYING(100) |
100 |
| 77 |
CREDIT_PRODUCT_GROUP |
CHARACTER VARYING(25) |
25 |
| 78 |
PROPERTY_RIGHTS |
CHARACTER VARYING(25) |
25 |
| 79 |
ONBAL_SPECFC_PRVN_AMOUNT |
NUMERIC(15,2) |
19 |
| 80 |
PROVISION_AMT_GTEE |
NUMERIC(15,2) |
19 |
| 81 |
PEOPLESOFT_GL_BUSINESS_UNIT |
CHARACTER VARYING(10) |
10 |
| 82 |
QRM_ACCOUNT_GTEE |
CHARACTER VARYING(75) |
75 |
| 83 |
QRM_ACCOUNT |
CHARACTER VARYING(75) |
75 |
| 84 |
QRM_ACCOUNT_CM |
CHARACTER VARYING(50) |
50 |
| 85 |
REDRAW_AVAILABLE |
CHARACTER VARYING(1) |
1 |
| 86 |
RISK_WEIGHT |
NUMERIC(6,4) |
19 |
| 87 |
COUNTERPARTY_MNEMONIC |
CHARACTER VARYING(10) |
10 |
| 88 |
RWA_OFF_BAL_GUAR_AMOUNT |
NUMERIC(19,4) |
19 |
| 89 |
RWA_OFF_BAL_UNDRAWN_AMOUNT |
NUMERIC(19,4) |
19 |
| 90 |
RWA_OFF_BAL_REDRAW_AMOUNT |
INTEGER |
4 |
| 91 |
RWA_ON_BAL |
NUMERIC(19,4) |
19 |
| 92 |
SECURITISATION_STATUS |
CHARACTER VARYING(1) |
1 |
| 93 |
COUNTERPARTY_NAME |
CHARACTER VARYING(255) |
255 |
| 94 |
SOURCE_CURRENCY |
CHARACTER VARYING(5) |
5 |
| 95 |
SOURCE_SYSTEM |
CHARACTER VARYING(4) |
4 |
| 96 |
TENOR |
CHARACTER VARYING(10) |
10 |
| 97 |
TRADING_BOOK_FLAG |
CHARACTER VARYING(1) |
1 |
| 98 |
OF_CATEGORY_CODE |
CHARACTER VARYING(3) |
3 |
| 99 |
APRA_ASSET_CODE_CONCAT |
CHARACTER VARYING(44) |
44 |
| 100 |
APRA_ASSET_CODE |
CHARACTER VARYING(145) |
145 |
| 101 |
APRA_ASSET_CLASS_DESC |
CHARACTER VARYING(100) |
100 |
| 102 |
ONBAL_EAD_BEFORE_CRM_AMOUNT |
NUMERIC(22,4) |
19 |
| 103 |
IRB_ONBAL_EAD_BEFORE_CRM_AMOUNT |
NUMERIC(19,4) |
19 |
| 104 |
IRB_ONBAL_EAD_AFTER_CRM_AMOUNT |
NUMERIC(19,4) |
19 |
| 105 |
IRB_ONBAL_PD_PREWEIGHTED_AVERAGE |
NUMERIC(38,10) |
19 |
| 106 |
IRB_ONBAL_LGD_PREWEIGHTED_AVERAGE |
NUMERIC(38,10) |
19 |
| 107 |
IRB_ONBAL_FIRMSIZE_PREWEIGHTED_AVERAGE |
NUMERIC(36,8) |
19 |
| 108 |
IRB_OFFBAL_LGD_PREWEIGHTED_AVERAGE |
NUMERIC(38,10) |
19 |
| 109 |
IRB_OFFBAL_PD_PREWEIGHTED_AVERAGE |
NUMERIC(38,10) |
19 |
| 110 |
IRB_OFFBAL_FIRMSIZE_PREWEIGHTED_AVERAGE |
NUMERIC(36,8) |
19 |
| 111 |
IRB_OFFBAL_EAD_BEFORE_CRM_AMOUNT |
NUMERIC(19,4) |
19 |
| 112 |
IRB_OFFBAL_EAD_AFTER_CRM_AMOUNT |
NUMERIC(19,4) |
19 |
| 113 |
IRB_TOTAL_EAD_AFTER_CRM_AMOUNT |
NUMERIC(20,4) |
19 |
| 114 |
IRB_RWA_OFF_BAL_REDRAW_AMOUNT |
INTEGER |
4 |
| 115 |
IRB_RWA_OFF_BAL_UNDRAWN_AMOUNT |
NUMERIC(19,4) |
19 |
| 116 |
IRB_RWA_OFF_BAL_GUAR_AMOUNT |
NUMERIC(19,4) |
19 |
| 117 |
IRB_TOTAL_RWA_OFF_BAL |
NUMERIC(19,4) |
19 |
| 118 |
IRB_RWA_ON_BAL |
NUMERIC(19,4) |
19 |
| 119 |
IRB_CREDIT_EQUIVALENT_REDRAW_AMT |
INTEGER |
4 |
| 120 |
IRB_CREDIT_EQUIVALENT_UNDRAWN_AMT |
NUMERIC(19,4) |
19 |
| 121 |
IRB_CREDIT_EQUIVALENT_GUAR_AMT |
NUMERIC(19,4) |
19 |
| 122 |
IRB_TOTAL_CREDIT_EQUIVALENT_AMT |
NUMERIC(19,4) |
19 |
| 123 |
IRB_OFF_BAL_NOTIONAL_GUAR_AMT |
NUMERIC(19,4) |
19 |
| 124 |
IRB_OFF_BAL_NOTIONAL_UNDRAWN_AMT |
NUMERIC(19,4) |
19 |
| 125 |
IRB_ONBAL_EL_LOSS_AMT |
NUMERIC(38,23) |
19 |
| 126 |
IRB_OFF_BAL_EL_LOSS_AMT |
NUMERIC(38,23) |
19 |
| 127 |
IRB_ONBAL_MAT_PREWEIGHTED_AVG_YRS |
NUMERIC(36,10) |
19 |
| 128 |
IRB_OFFBAL_MAT_PREWEIGHTED_AVG_YRS |
NUMERIC(36,10) |
19 |
| 129 |
OFF_BAL_NOTIONAL_GUAR_AMT |
NUMERIC(19,4) |
19 |
| 130 |
OFF_BAL_NOTIONAL_UNDRAWN_AMT |
NUMERIC(19,4) |
19 |
| 131 |
IRB_OFF_BAL_NOTIONAL_REDRAW_AMT |
NUMERIC(15,2) |
19 |
| 132 |
INTEREST_RATE_CLASSIFICATION |
CHARACTER VARYING(5) |
5 |
| 133 |
SLOTTING_RATING |
BIGINT |
8 |
| 134 |
IRB_OFFBAL_NOTIONAL_AMT |
NUMERIC(20,4) |
19 |