| 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 |