FCT_RISK_ADJ_RTN_ON_CAP_INSIGHT
Description
Source Object (CTAS)
Synonyms
INSNZP01_BANK..SYN_FCT_RISK_ADJ_RTN_ON_CAP_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CALENDAR_PERIOD_END_DATE | TIMESTAMP | 8 |
| 2 | BEC_COMBINED_PRODUCT | CHARACTER VARYING(100) | 100 |
| 3 | ACCOUNT_CODE | CHARACTER VARYING(150) | 150 |
| 4 | CATEGORY_CODE | CHARACTER VARYING(150) | 150 |
| 5 | PRODUCT_CODE | CHARACTER VARYING(150) | 150 |
| 6 | ACCOUNT_LEVEL_01_CODE | CHARACTER VARYING(60) | 60 |
| 7 | ACCOUNT_LEVEL_02_NAME | CHARACTER VARYING(240) | 240 |
| 8 | ACCOUNT_LEVEL_03_NAME | CHARACTER VARYING(240) | 240 |
| 9 | ACCOUNT_LEVEL_04_NAME | CHARACTER VARYING(240) | 240 |
| 10 | COST_CENTRE_CODE | CHARACTER VARYING(240) | 240 |
| 11 | BUDGET_TYPE | CHARACTER VARYING(20) | 20 |
| 12 | CATEGORY | CHARACTER VARYING(240) | 240 |
| 13 | EXPENSE_TYPE | CHARACTER VARYING(100) | 100 |
| 14 | EAD_113 | NUMERIC(38,0) | 19 |
| 15 | CR_EAD_ECAP | NUMERIC(38,0) | 19 |
| 16 | RWA_ON_BAL_112 | NUMERIC(38,0) | 19 |
| 17 | RWA_OFF_BAL_112 | NUMERIC(38,0) | 19 |
| 18 | CR_UL_AIRB | NUMERIC(38,0) | 19 |
| 19 | RWA_TOTAL_113 | NUMERIC(38,0) | 19 |
| 20 | UL_ECAP | NUMERIC(38,0) | 19 |
| 21 | RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 22 | EAD_TOTAL_FIRB | NUMERIC(38,4) | 19 |
| 23 | EXPECTED_LOSS_FIRB | NUMERIC(38,4) | 19 |
| 24 | RWA_TOTAL_FIRB | NUMERIC(38,4) | 19 |
| 25 | UNEXPECTED_LOSS_FIRB | NUMERIC(38,4) | 19 |
| 26 | ECAP_IRR_RWA_AMA | NUMERIC(38,4) | 19 |
| 27 | ECAP_MR_RWA_AMA | NUMERIC(38,4) | 19 |
| 28 | ECAP_BR_RWA_AMA | NUMERIC(38,2) | 19 |
| 29 | ECAP_OR_RWA_AMA | NUMERIC(38,4) | 19 |
| 30 | ECAP_MR_RWA_STD | NUMERIC(38,4) | 19 |
| 31 | ECAP_OR_RWA_STD | NUMERIC(38,4) | 19 |
| 32 | MR_RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 33 | IRR_RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 34 | OR_RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 35 | BR_RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 36 | AGG_RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 37 | MR_CAPITAL_ECAP | NUMERIC(38,0) | 19 |
| 38 | IRR_CAPITAL_ECAP | NUMERIC(38,0) | 19 |
| 39 | OR_CAPITAL_ECAP | NUMERIC(38,0) | 19 |
| 40 | BR_CAPITAL_ECAP | NUMERIC(38,0) | 19 |
| 41 | DIV_CAPITAL_ECAP | NUMERIC(38,0) | 19 |
| 42 | AGG_CAPITAL_ECAP | NUMERIC(38,0) | 19 |
| 43 | ECAP_CAPITAL_ADJUSTMENT_AMOUNT | NUMERIC(38,4) | 19 |
| 44 | DIV_RWA_TOTAL_ECAP | NUMERIC(38,0) | 19 |
| 45 | MTD_ACTUAL | NUMERIC(38,19) | 19 |
| 46 | YTD_ACTUAL | NUMERIC(38,19) | 19 |
| 47 | MTD_AVERAGE | NUMERIC(38,2) | 19 |
| 48 | YTD_AVERAGE | NUMERIC(38,2) | 19 |
| 49 | ALLOC_TREASURY_EXT_FEE_INC | NUMERIC(38,19) | 19 |
| 50 | ALLOC_TREASURY_MTM | NUMERIC(38,19) | 19 |
| 51 | ALLOC_TREASURY_ASSETS | NUMERIC(38,19) | 19 |
| 52 | ALLOC_DEPOSITS_EXT_FEE_INC | NUMERIC(38,19) | 19 |
| 53 | ALLOC_DEPOSITS_FEE_COMM_PAID | NUMERIC(38,19) | 19 |
| 54 | ALLOC_TREASURY_TRADING | NUMERIC(38,19) | 19 |
| 55 | ALLOC_TREASURY_FUNDING_CENTER | NUMERIC(38,19) | 19 |
| 56 | ALLOC_IRM_EARNINGS | NUMERIC(38,19) | 19 |
| 57 | ALLOC_OTHERASSETS | NUMERIC(38,19) | 19 |
| 58 | MTD_ACTUAL_BASIS_POINT | NUMERIC(38,6) | 19 |
| 59 | YTD_ACTUAL_BASIS_POINT | NUMERIC(38,6) | 19 |
| 60 | RETURN_EXCESS_CAP | NUMERIC(38,5) | 19 |
| 61 | EL_ECAP | NUMERIC(38,0) | 19 |
| 62 | CR_EL_PM | NUMERIC(38,0) | 19 |
| 63 | MTD_PMB | NUMERIC(38,5) | 19 |
| 64 | YTD_PMB | NUMERIC(38,5) | 19 |