FCT_BNK_TM1_CREDIT_RISK_PRVN_SUMM_INSIGHT
Description
Regulatory Reporting Insight used in TM1. Credit Risk Information
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PERIOD_DIM_ID | BIGINT | 8 |
| 2 | VERSION_DIM_ID | BIGINT | 8 |
| 3 | OF_ENTITY_CODE | CHARACTER VARYING(150) | 150 |
| 4 | OF_CATEGORY_CODE | CHARACTER VARYING(150) | 150 |
| 5 | OF_ACCOUNT_CODE | CHARACTER VARYING(150) | 150 |
| 6 | OF_INTERCOMPANY_CODE | CHARACTER VARYING(150) | 150 |
| 7 | OF_PRODUCT_CODE | CHARACTER VARYING(150) | 150 |
| 8 | OF_COST_CENTRE_CODE | CHARACTER VARYING(150) | 150 |
| 9 | IMPAIRED_FLAG | CHARACTER VARYING(24) | 24 |
| 10 | INBA_EXIST | CHARACTER VARYING(5) | 5 |
| 11 | SPECIFIC_PROVISION_FLAG | CHARACTER VARYING(5) | 5 |
| 12 | ASSET_QUALITY | CHARACTER VARYING(256) | 256 |
| 13 | PAST_DUE_BAND | CHARACTER VARYING(30) | 30 |
| 14 | PAYMENT_PERFORMANCE_TYPE_DESC | CHARACTER VARYING(28) | 28 |
| 15 | RESTRUCTURED_INDICATOR_DESC | CHARACTER VARYING(24) | 24 |
| 16 | CREDIT_MANAGEMENT_TYPE_DESC | CHARACTER VARYING(26) | 26 |
| 17 | CORE_NON_CORE_FLAG_DESC | CHARACTER VARYING(27) | 27 |
| 18 | OWNER_OCCUPIED_INVESTMENT_DESC | CHARACTER VARYING(100) | 100 |
| 19 | ANZSIC_DIVISION | CHARACTER VARYING(256) | 256 |
| 20 | COUNTERPARTY_TYPE | CHARACTER VARYING(256) | 256 |
| 21 | MATERIALITY_BAND_DESC | CHARACTER VARYING(42) | 42 |
| 22 | COMMERCIAL_PTY_TYPE_DESC | CHARACTER VARYING(256) | 256 |
| 23 | COMMERCIAL_PTY_EXPOSURE_FLAG | CHARACTER VARYING(27) | 27 |
| 24 | SDW_IGNITE_SOURCE | CHARACTER(1) | 1 |
| 25 | MEASURE | CHARACTER VARYING(29) | 29 |
| 26 | VALUE | DOUBLE PRECISION | 8 |