FCT_BUSINESS_RISK_SETTING_RETAIL_INSIGHT
Description
Source Object (CTAS)
Synonyms
INSNZP01_BANK..SYN_FCT_BUSINESS_RISK_SETTING_RETAIL_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PORTFOLIO_DATE | TIMESTAMP | 8 |
| 2 | BROKER_ORIGINATED_FLAG | CHARACTER VARYING(6) | 6 |
| 3 | AMORTISATION_TYPE_CODE | CHARACTER VARYING(13) | 13 |
| 4 | PRODUCT_1_DESC | CHARACTER VARYING(100) | 100 |
| 5 | PRODUCT_2_DESC | CHARACTER VARYING(100) | 100 |
| 6 | PRODUCT_3_DESC | CHARACTER VARYING(100) | 100 |
| 7 | PRODUCT_4_DESC | CHARACTER VARYING(100) | 100 |
| 8 | PRODUCT_CODE_2 | CHARACTER VARYING(65) | 65 |
| 9 | SECUR_LOANS_CAPITAL_RELIEF | CHARACTER VARYING(1) | 1 |
| 10 | QRM_ACCOUNT | CHARACTER VARYING(75) | 75 |
| 11 | LOAN_PURPOSE_CODE | CHARACTER VARYING(6) | 6 |
| 12 | LOAN_SUB_PURPOSE_CODE | CHARACTER VARYING(15) | 15 |
| 13 | LOW_DOC_FLAG | CHARACTER VARYING(8) | 8 |
| 14 | LOW_DOC_FLAG_ORIGINATION | CHARACTER VARYING(12) | 12 |
| 15 | PROPERTY_RIGHTS | CHARACTER VARYING(14) | 14 |
| 16 | PAST_DUE_CATEGORY | CHARACTER VARYING(20) | 20 |
| 17 | MORTGAGE_INSURANCE_INDICATOR | CHARACTER VARYING(1) | 1 |
| 18 | ORACLE_GL_COST_CENTRE_STATE | CHARACTER VARYING(40) | 40 |
| 19 | COUNTERPARTY_ABS_REGION | CHARACTER VARYING(50) | 50 |
| 20 | COUNTERPARTY_POSTCODE | CHARACTER VARYING(10) | 10 |
| 21 | COUNTERPARTY_STATE | CHARACTER VARYING(35) | 35 |
| 22 | ORACLE_GL_COST_CENTRE_REGION | CHARACTER VARYING(50) | 50 |
| 23 | COUNTERPARTY_RESIDENT_FLAG | CHARACTER VARYING(5) | 5 |
| 24 | COLLATERAL_PRIMARY_PCODE | CHARACTER VARYING(10) | 10 |
| 25 | COLLATERAL_PRIMARY_STATE | CHARACTER VARYING(10) | 10 |
| 26 | COLLATERAL_PRIMARY_CATEGORY | CHARACTER VARYING(50) | 50 |
| 27 | COLLATERAL_PRIMARY_ABS_REGION | CHARACTER VARYING(255) | 255 |
| 28 | COLLATERAL_PRIMARY_USE_TYPE | CHARACTER VARYING(50) | 50 |
| 29 | ORIGINATION_MTH | CHARACTER VARYING(200) | 200 |
| 30 | TIME_ON_BOOK | CHARACTER VARYING(11) | 11 |
| 31 | RETAIL_EXPOSURE | NUMERIC(38,2) | 19 |
| 32 | EXPOSURE_TIER | CHARACTER VARYING(15) | 15 |
| 33 | NBR_ACCTS | BIGINT | 8 |
| 34 | AVERAGE_BALANCE | NUMERIC(38,2) | 19 |
| 35 | FACE_AMT | NUMERIC(38,4) | 19 |
| 36 | PRODUCT_GROUP | CHARACTER VARYING(4) | 4 |
| 37 | RISK_GRADE | CHARACTER VARYING(1) | 1 |
| 38 | CTR_AMOUNT | CHARACTER VARYING(1) | 1 |
| 39 | LVR_ERM | NUMERIC(14,4) | 19 |
| 40 | LVR_ERM_BAND | CHARACTER VARYING(20) | 20 |
| 41 | ACCOUNT_NUMBER | NUMERIC(28,0) | 19 |
| 42 | NET_CREDIT_EXPOSURE | NUMERIC(15,2) | 19 |
| 43 | CALC_ADVANCE_AMT | NUMERIC(15,2) | 19 |
| 44 | RWA_ON_BAL | NUMERIC(19,4) | 19 |
| 45 | RWA_OFF_BAL | NUMERIC(19,4) | 19 |
| 46 | IMPAIRED_FLAG_DRS | CHARACTER VARYING(1) | 1 |
| 47 | INBA | NUMERIC(15,2) | 19 |