FCT_SDW_TM1_PORTFOLIO_PIT_SUMM_V
Description
Target Objects (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(45) | 45 |
| 26 | OWNER_OCCUPIED_INVESTMENT_IND | CHARACTER VARYING(24) | 24 |
| 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 | PBAL_MEASURE | CHARACTER VARYING(17) | 17 |
| 35 | PBAL_VALUE | NUMERIC(38,2) | 19 |
| 36 | IAC_MEASURE | CHARACTER VARYING(27) | 27 |
| 37 | IAC_VALUE | NUMERIC(38,8) | 19 |
| 38 | EAC_MEASURE | CHARACTER VARYING(28) | 28 |
| 39 | EAC_VALUE | NUMERIC(38,8) | 19 |
| 40 | IMM_MEASURE | CHARACTER VARYING(28) | 28 |
| 41 | IMM_VALUE | NUMERIC(38,8) | 19 |
| 42 | EMM_MEASURE | CHARACTER VARYING(29) | 29 |
| 43 | EMM_VALUE | NUMERIC(38,8) | 19 |
| 44 | UNEARNED_INT_MTD | NUMERIC(38,2) | 19 |
| 45 | TRAN_INTEREST | NUMERIC(38,2) | 19 |