FCT_BNK_PL_LODGEMENTS_MONTHLY_INSIGHT
Description
OBP Monthly summary of Personal loan lodgements by branch purpose and secured or unsecured with number of facilities and summed facility amount
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | MONTH_END_DATE | DATE | 4 |
| 2 | TYPE | CHARACTER VARYING(10) | 10 |
| 3 | SALES_BRANCH_LVL4_DESC | CHARACTER VARYING(240) | 240 |
| 4 | LOAN_PURPOSE_DESC | CHARACTER VARYING(200) | 200 |
| 5 | SEC_OR_UNSEC_FLAG | CHARACTER VARYING(1) | 1 |
| 6 | FACILITY_CODE | BIGINT | 8 |
| 7 | FACILITY_REPORTING_AMOUNT | DOUBLE PRECISION | 8 |