FCT_BNK_DV_SALES_SUMMARY_MONTH_INSIGHT
Description
Monthly Summary of OBP Loan sales and Opportunities by Cost centre state product offer channel purpose rate type bussiness segment and sales officer and team
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SALES_MEASURE_DATE | DATE | 4 |
| 2 | SALES_MEASURE | CHARACTER VARYING(256) | 256 |
| 3 | GEOGRAPHIC_STATE | CHARACTER VARYING(3) | 3 |
| 4 | REGION | CHARACTER VARYING(240) | 240 |
| 5 | COST_CENTRE_NAME | CHARACTER VARYING(240) | 240 |
| 6 | BUSINESS_LENDING_SEGMENT_L2 | CHARACTER VARYING(240) | 240 |
| 7 | BUSINESS_LENDING_SEGMENT_L3 | CHARACTER VARYING(240) | 240 |
| 8 | APPLICATION_CHANNEL | CHARACTER VARYING(400) | 400 |
| 9 | SOURCE_PRODUCT_L2 | CHARACTER VARYING(100) | 100 |
| 10 | PRODUCT_DESC | CHARACTER VARYING(120) | 120 |
| 11 | PRODUCT_GROUP_DESC | CHARACTER VARYING(120) | 120 |
| 12 | OFFER_DESC | CHARACTER VARYING(120) | 120 |
| 13 | LOAN_PURPOSE | CHARACTER VARYING(200) | 200 |
| 14 | LVR_GROUP | CHARACTER VARYING(50) | 50 |
| 15 | PERS_INV_USAGE_TYPE | CHARACTER VARYING(14) | 14 |
| 16 | INTEREST_RATE_TYPE | CHARACTER VARYING(30) | 30 |
| 17 | SECTION_NAME | CHARACTER VARYING(100) | 100 |
| 18 | TEAM_NAME | CHARACTER VARYING(100) | 100 |
| 19 | SALES_OFFICER_CODE | CHARACTER VARYING(254) | 254 |
| 20 | SALES_OFFICER_NAME | CHARACTER VARYING(201) | 201 |
| 21 | ACTUAL_AMOUNT | DOUBLE PRECISION | 8 |
| 22 | BUDGET_AMOUNT | NUMERIC(38,0) | 19 |
| 23 | ACTUAL_AMOUNT_PREV_MONTH | DOUBLE PRECISION | 8 |
| 24 | DISBURSEMENT_AMT | DOUBLE PRECISION | 8 |
| 25 | REAL_GROWTH | DOUBLE PRECISION | 8 |
| 26 | AVG_DISBURSEMENT_PER_SALES_PERSON | DOUBLE PRECISION | 8 |
| 27 | AVG_DISBURSEMENT_AMT | DOUBLE PRECISION | 8 |
| 28 | DISBURSEMENT_BUDGET | NUMERIC(38,0) | 19 |
| 29 | OPPORTUNITY_SALES_AMT | DOUBLE PRECISION | 8 |
| 30 | CLOSED_WIN_CNT | NUMERIC(38,0) | 19 |
| 31 | OPPORTUNITY_CNT | NUMERIC(38,0) | 19 |
| 32 | CLOSED_LOST_CNT | NUMERIC(38,0) | 19 |
| 33 | OPPORTUNITY_CLOSE_CNT | NUMERIC(38,0) | 19 |