FCT_BNK_LN_SETTLEMENT_REPORT_INSIGHT
Description
OBP Origination settlement report for Home personal and business loans including sales officer broker star rating LVR approval date and amount by arrangement creation date and settlement date
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PRODUCT_TYPE_GROUPING | CHARACTER VARYING(16) | 16 |
| 2 | PRODUCT_TYPE | CHARACTER VARYING(14) | 14 |
| 3 | PRODUCT_CODE | CHARACTER VARYING(50) | 50 |
| 4 | SEGMENT | CHARACTER VARYING(30) | 30 |
| 5 | REGION | CHARACTER VARYING(30) | 30 |
| 6 | AREA | CHARACTER VARYING(30) | 30 |
| 7 | BRANCH_CODE | CHARACTER VARYING(24) | 24 |
| 8 | BRANCH_NAME | CHARACTER VARYING(30) | 30 |
| 9 | ARRANGEMENT_CODE | CHARACTER VARYING(50) | 50 |
| 10 | FACILITY_CODE | CHARACTER VARYING(40) | 40 |
| 11 | PRE_APPROVED_FLAG | CHARACTER VARYING(1) | 1 |
| 12 | SALES_OFFICER_ID | CHARACTER VARYING(254) | 254 |
| 13 | SALES_OFFICER_NAME | CHARACTER VARYING(203) | 203 |
| 14 | ARRANGEMENT_CREATION_DATE | TIMESTAMP | 8 |
| 15 | ORIG_UCDTL_APPROVAL_DT | TIMESTAMP | 8 |
| 16 | FACILITY_SETTLEMENT_DATE | TIMESTAMP | 8 |
| 17 | CURRENT_WORKFLOW_STATUS | CHARACTER VARYING(50) | 50 |
| 18 | LENDER_USER_ID | CHARACTER VARYING(254) | 254 |
| 19 | LENDER_USER_NAME | CHARACTER VARYING(203) | 203 |
| 20 | PRIMARY_APPLICANT_ID | CHARACTER VARYING(50) | 50 |
| 21 | PRIMARY_APPLICANT_NAME | CHARACTER VARYING(509) | 509 |
| 22 | BROKER_FLAG | CHARACTER VARYING(14) | 14 |
| 23 | ACCREDITED_BROKER_CODE | CHARACTER VARYING(20) | 20 |
| 24 | ACCREDITED_BROKER_NAME | CHARACTER VARYING(401) | 401 |
| 25 | ACCREDITED_BROKER_SEGMENT | CHARACTER VARYING(50) | 50 |
| 26 | BROKER_CODE | CHARACTER VARYING(40) | 40 |
| 27 | BROKER_NAME | CHARACTER VARYING(250) | 250 |
| 28 | STAR_RATING | CHARACTER VARYING(8) | 8 |
| 29 | LVR | DOUBLE PRECISION | 8 |
| 30 | LVR_GROUP | CHARACTER VARYING(9) | 9 |
| 31 | NBR_FACILITIES | INTEGER | 4 |
| 32 | FACILITY_REPORTING_AMOUNT | DOUBLE PRECISION | 8 |