FCT_BNK_TM1_PORTFOLIO_PIT_SUMM
Description
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PERIOD_DIM_ID | BIGINT | 8 |
| 2 | YR_PER | CHARACTER VARYING(401) | 401 |
| 3 | OF_ENTITY_CODE | CHARACTER VARYING(150) | 150 |
| 4 | OF_INTERCOMPANY_CODE | CHARACTER VARYING(150) | 150 |
| 5 | OF_ACCOUNT_PBAL | CHARACTER VARYING(150) | 150 |
| 6 | OF_ACCOUNT_IAC | CHARACTER VARYING(150) | 150 |
| 7 | OF_ACCOUNT_EAC | CHARACTER VARYING(150) | 150 |
| 8 | OF_ACCOUNT_IMM | CHARACTER VARYING(150) | 150 |
| 9 | OF_ACCOUNT_EMM | CHARACTER VARYING(150) | 150 |
| 10 | OF_CATEGORY_PBAL | CHARACTER VARYING(150) | 150 |
| 11 | OF_CATEGORY_IAC | CHARACTER VARYING(150) | 150 |
| 12 | OF_CATEGORY_EAC | CHARACTER VARYING(150) | 150 |
| 13 | OF_CATEGORY_IMM | CHARACTER VARYING(150) | 150 |
| 14 | OF_CATEGORY_EMM | CHARACTER VARYING(150) | 150 |
| 15 | OF_PRODUCT_PBAL | CHARACTER VARYING(150) | 150 |
| 16 | OF_PRODUCT_IAC | CHARACTER VARYING(150) | 150 |
| 17 | OF_PRODUCT_EAC | CHARACTER VARYING(150) | 150 |
| 18 | OF_PRODUCT_IMM | CHARACTER VARYING(150) | 150 |
| 19 | OF_PRODUCT_EMM | CHARACTER VARYING(150) | 150 |
| 20 | OF_COST_CENTRE_PBAL | CHARACTER VARYING(150) | 150 |
| 21 | OF_COST_CENTRE_IAC | CHARACTER VARYING(150) | 150 |
| 22 | OF_COST_CENTRE_EAC | CHARACTER VARYING(150) | 150 |
| 23 | OF_COST_CENTRE_IMM | CHARACTER VARYING(150) | 150 |
| 24 | OF_COST_CENTRE_EMM | CHARACTER VARYING(150) | 150 |
| 25 | SOURCE_PRODUCT_TREE | CHARACTER VARYING(92) | 92 |
| 26 | OWNER_OCCUPIED_INVESTMENT_IND | CHARACTER VARYING(100) | 100 |
| 27 | SECURED_FLAG | CHARACTER VARYING(5) | 5 |
| 28 | LOAN_PURPOSE | CHARACTER VARYING(256) | 256 |
| 29 | ORIG_TERM_MAT_CODE | CHARACTER VARYING(61) | 61 |
| 30 | RSDL_TERM_MAT_CODE | CHARACTER VARYING(61) | 61 |
| 31 | INTEREST_RATE_TERM_CODE | CHARACTER VARYING(61) | 61 |
| 32 | COUNTERPARTY_TYPE | CHARACTER VARYING(256) | 256 |
| 33 | CUSTOMER_COUNTRY_DESCRIPTION | CHARACTER VARYING(256) | 256 |
| 34 | SDW_IGNITE_SOURCE | CHARACTER VARYING(4) | 4 |
| 35 | PBAL_MEASURE | CHARACTER VARYING(17) | 17 |
| 36 | PBAL_VALUE | DOUBLE PRECISION | 8 |
| 37 | IAC_MEASURE | CHARACTER VARYING(27) | 27 |
| 38 | IAC_VALUE | DOUBLE PRECISION | 8 |
| 39 | EAC_MEASURE | CHARACTER VARYING(28) | 28 |
| 40 | EAC_VALUE | DOUBLE PRECISION | 8 |
| 41 | IMM_MEASURE | CHARACTER VARYING(28) | 28 |
| 42 | IMM_VALUE | DOUBLE PRECISION | 8 |
| 43 | EMM_MEASURE | CHARACTER VARYING(29) | 29 |
| 44 | EMM_VALUE | DOUBLE PRECISION | 8 |