FCT_BNK_DV_SALES_SUMMARY_MONTH_DEP_INSIGHT
Description
Monthly OBP Term Deposits and CASA sales measure summary by cost centre account type state business segment channel and product groups
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SALES_MEASURE_DATE | DATE | 4 |
| 2 | SALES_MEASURE | CHARACTER VARYING(50) | 50 |
| 3 | ACCOUNT_TYPE | CHARACTER VARYING(12) | 12 |
| 4 | BUDGET_OR_DEPOSIT | CHARACTER VARYING(8) | 8 |
| 5 | GEOGRAPHIC_STATE | CHARACTER VARYING(3) | 3 |
| 6 | REGION | CHARACTER VARYING(240) | 240 |
| 7 | COST_CENTRE_NAME | CHARACTER VARYING(240) | 240 |
| 8 | BUSINESS_LENDING_SEGMENT_L2 | CHARACTER VARYING(240) | 240 |
| 9 | BUSINESS_LENDING_SEGMENT_L3 | CHARACTER VARYING(240) | 240 |
| 10 | APPLICATION_CHANNEL | CHARACTER VARYING(400) | 400 |
| 11 | SOURCE_PRODUCT_L2 | CHARACTER VARYING(100) | 100 |
| 12 | SOURCE_PRODUCT_L3_DESC | CHARACTER VARYING(100) | 100 |
| 13 | SOURCE_PRODUCT_L4_DESC | CHARACTER VARYING(100) | 100 |
| 14 | PRODUCT_DESC | CHARACTER VARYING(120) | 120 |
| 15 | PRODUCT_GROUP_DESC | CHARACTER VARYING(120) | 120 |
| 16 | OFFER_DESC | CHARACTER VARYING(120) | 120 |
| 17 | ACTUAL_AMOUNT | DOUBLE PRECISION | 8 |
| 18 | BUDGET_AMOUNT | NUMERIC(38,0) | 19 |
| 19 | ACTUAL_AMOUNT_PREV_MONTH | DOUBLE PRECISION | 8 |
| 20 | PORTFOLIO | DOUBLE PRECISION | 8 |
| 21 | PORTFOLIO_GROWTH | DOUBLE PRECISION | 8 |
| 22 | REAL_GROWTH | DOUBLE PRECISION | 8 |
| 23 | BDGT_PORTFOLIO | NUMERIC(38,0) | 19 |
| 24 | BDGT_REAL_GROWTH | NUMERIC(38,0) | 19 |
| 25 | AVG_REAL_GROWTH | DOUBLE PRECISION | 8 |