FCT_BNK_QBE_POLICY_CANCELLATION_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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