FCT_BUSINESS_REVENUE_INSIGHT
Description
Source Object (CTAS)
Synonyms
INSNZP01_BANK..SYN_FCT_BUSINESS_REVENUE_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PORTFOLIO_DATE | TIMESTAMP | 8 |
| 2 | MANAGED_ACC_NO | NUMERIC(28,0) | 19 |
| 3 | COUNTERPARTY_BDM | BIGINT | 8 |
| 4 | QRM_ACCOUNT | CHARACTER VARYING(75) | 75 |
| 5 | BDM_USER_ID | NATIONAL CHARACTER VARYING(8) | 8 |
| 6 | BDM_NAME | NATIONAL CHARACTER VARYING(100) | 100 |
| 7 | MANAGED | CHARACTER VARYING(9) | 9 |
| 8 | NBR_ACCTS | BIGINT | 8 |
| 9 | FACE_AMT | NUMERIC(38,4) | 19 |
| 10 | EXPOSURE | NUMERIC(38,2) | 19 |
| 11 | ORACLE_GL_COST_CENTRE | CHARACTER VARYING(10) | 10 |
| 12 | COST_CENTRE_LEVEL_01_NAME | CHARACTER VARYING(240) | 240 |
| 13 | COST_CENTRE_LEVEL_02_NAME | CHARACTER VARYING(240) | 240 |
| 14 | COST_CENTRE_LEVEL_03_NAME | CHARACTER VARYING(240) | 240 |
| 15 | COST_CENTRE_LEVEL_04_NAME | CHARACTER VARYING(240) | 240 |
| 16 | COST_CENTRE_LEVEL_05_NAME | CHARACTER VARYING(240) | 240 |
| 17 | COST_CENTRE_LEVEL_06_NAME | CHARACTER VARYING(240) | 240 |
| 18 | PRODUCT_1_DESC | CHARACTER VARYING(100) | 100 |
| 19 | PRODUCT_2_DESC | CHARACTER VARYING(100) | 100 |
| 20 | PRODUCT_3_DESC | CHARACTER VARYING(100) | 100 |
| 21 | PRODUCT_4_DESC | CHARACTER VARYING(100) | 100 |
| 22 | PRODUCT_5_DESC | CHARACTER VARYING(100) | 100 |
| 23 | BALANCE_SHEET_INDICATOR | CHARACTER VARYING(1) | 1 |
| 24 | INT_RATE_CUR_VALUE | NUMERIC(38,14) | 19 |
| 25 | TP_BASE_VALUE | NUMERIC(38,14) | 19 |
| 26 | TP_ADDON_VALUE | NUMERIC(38,14) | 19 |
| 27 | TP_BASIS_VALUE | NUMERIC(38,14) | 19 |
| 28 | TP_LIQUIDITY_VALUE | NUMERIC(38,14) | 19 |
| 29 | TP_SPREAD_TO_BBSW_VALUE | NUMERIC(38,6) | 19 |
| 30 | TP_SPREAD_VALUE | NUMERIC(38,6) | 19 |
| 31 | STD_RWA | NUMERIC(38,4) | 19 |
| 32 | EXPECTED_LOSS | NUMERIC(38,4) | 19 |
| 33 | EXPECTED_LOSS_RAROC | NUMERIC(38,4) | 19 |
| 34 | CLMS_GROUP_NUMBER | BIGINT | 8 |
| 35 | AVERAGE_MONTHLY_BALANCE | NUMERIC(38,2) | 19 |
| 36 | UPFRONT_COMM | NUMERIC(38,3) | 19 |
| 37 | TRAIL_COMM | NUMERIC(38,3) | 19 |
| 38 | CLAWBACK_COMM | NUMERIC(38,3) | 19 |
| 39 | CAP_ADJ_AMOUNT | NUMERIC(38,2) | 19 |
| 40 | TP_LIQUIDITY_CALCULATION | NUMERIC(38,2) | 19 |
| 41 | TP_LIQUIDITY_RUNOFF_CATEGORY | CHARACTER VARYING(50) | 50 |
| 42 | TP_FUNDING_ALLOCATION_RATE | NUMERIC(8,4) | 19 |
| 43 | TP_FUNDING_ALLOCATION | NUMERIC(38,6) | 19 |
| 44 | CR_RWA_TOTAL_FIRB | NUMERIC(38,4) | 19 |
| 45 | ECAP_IRR_CAPITAL | NUMERIC(38,4) | 19 |
| 46 | ECAP_MR_CAPITAL | NUMERIC(38,4) | 19 |
| 47 | ECAP_OR_CAPITAL | NUMERIC(38,4) | 19 |
| 48 | ECAP_BR_CAPITAL | NUMERIC(38,4) | 19 |
| 49 | CR_UL_ECAP | NUMERIC(38,4) | 19 |