FCT_BNK_QBE_POLICY_CANCELLATION_INSIGHT
Description
OBP LMI home loan insurance policy cancellation on closed facilities with close date and customer name and address details for active QBE insurance
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | LMI_POLICY_NUMBER | CHARACTER VARYING(20) | 20 |
| 2 | FACILITY_ID | CHARACTER VARYING(30) | 30 |
| 3 | ASSOCIATED_LOAN_ACCOUNTS | CHARACTER VARYING(40) | 40 |
| 4 | SURNAME | CHARACTER VARYING(50) | 50 |
| 5 | FIRST_NAMES | CHARACTER VARYING(50) | 50 |
| 6 | ADDRESS_OF_SECURITY_PROPERTY | CHARACTER VARYING(255) | 255 |
| 7 | DATE_OF_CLOSURE | TIMESTAMP | 8 |
| 8 | ADDRESS_TO_POST_REFUND | CHARACTER VARYING(1072) | 1072 |