FCT_BNK_DV_LODG_TO_SETTLE_MONTH_INSIGHT
Description
Monthly Loan Origination summary of OBP applications by product offer state purpose amounts and stages reached from lodgement to settlement or withdrawal
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | END_OF_MONTH | DATE | 4 |
| 2 | APP_STATUS | CHARACTER VARYING(22) | 22 |
| 3 | GEOGRAPHIC_STATE | CHARACTER VARYING(3) | 3 |
| 4 | REGION | CHARACTER VARYING(240) | 240 |
| 5 | COST_CENTRE_NAME | CHARACTER VARYING(240) | 240 |
| 6 | APPLICATION_CHANNEL | CHARACTER VARYING(400) | 400 |
| 7 | PRODUCT_DESC | CHARACTER VARYING(120) | 120 |
| 8 | PRODUCT_GROUP_NAME | CHARACTER VARYING(105) | 105 |
| 9 | OFFER_NAME | CHARACTER VARYING(120) | 120 |
| 10 | LOAN_PURPOSE_DESCRIPTION | CHARACTER VARYING(200) | 200 |
| 11 | LVR_GROUP | CHARACTER VARYING(50) | 50 |
| 12 | PERS_INV_USAGE_TYPE | CHARACTER VARYING(14) | 14 |
| 13 | INTEREST_RATE_TYPE | CHARACTER VARYING(8) | 8 |
| 14 | FACILITY_REPORTING_AMOUNT | NUMERIC(38,2) | 19 |
| 15 | FACILITY_COUNT | BIGINT | 8 |
| 16 | LODGEMENT_AMOUNT | NUMERIC(38,2) | 19 |
| 17 | UNCOND_APPROVAL_AMOUNT | NUMERIC(38,2) | 19 |
| 18 | READY_TO_SETTLE_AMOUNT | NUMERIC(38,2) | 19 |
| 19 | DISBURSEMENT_AMOUNT | NUMERIC(38,2) | 19 |
| 20 | SETTLEMENT_AMOUNT | NUMERIC(38,2) | 19 |
| 21 | COND_APPROVAL_AMOUNT | NUMERIC(38,2) | 19 |
| 22 | NEW_BUSINESS_AMOUNT | NUMERIC(38,2) | 19 |
| 23 | LODGEMENT_TO_UNCOND_APPROVAL_DAYS | NUMERIC(34,1) | 19 |
| 24 | LODGEMENT_TO_COND_APPROVAL_DAYS | NUMERIC(34,1) | 19 |
| 25 | UNCOND_APPROVAL_TO_DISBURSEMENT_DAYS | NUMERIC(34,1) | 19 |
| 26 | COND_APPROVAL_TO_UNCOND_APP_DAYS | NUMERIC(34,1) | 19 |
| 27 | LODGEMENT_TO_SETTLEMENT_DAYS | NUMERIC(34,1) | 19 |
| 28 | SUBMISSION_TO_AUTO_DECISION_DAYS | NUMERIC(34,1) | 19 |
| 29 | ACCEPT_DECISION_TO_OFFER_ROLLOUT_DAYS | NUMERIC(34,1) | 19 |
| 30 | OFFER_TO_SUBMISSION_COMPLETION_DAYS | NUMERIC(34,1) | 19 |
| 31 | SUBMISSION_COMPL_TO_DISBURSMENT_DAYS | NUMERIC(34,1) | 19 |
| 32 | LODGEMENT_FACILITY_CNT | BIGINT | 8 |
| 33 | UNCOND_FACILITY_CNT | BIGINT | 8 |
| 34 | COND_FACILITY_CNT | BIGINT | 8 |
| 35 | DISBURSEMENT_FACILITY_CNT | BIGINT | 8 |
| 36 | APPLICATION_COUNT | BIGINT | 8 |