FCT_BNK_LN_PLCCI_CLOSED_LOAN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 POLICY_NUMBER CHARACTER VARYING(50) 50
2 LOAN_PRODUCT CHARACTER VARYING(30) 30
3 LOAN_ACCOUNT_NUMBER CHARACTER VARYING(16) 16
4 DATE_LOAN_ISSUED CHARACTER VARYING(10) 10
5 BORROWER_SHORT_NAME CHARACTER VARYING(25) 25
6 ORIGINAL_LOAN_AMOUNT CHARACTER VARYING(10) 10
7 DATE_PAID_OFF CHARACTER VARYING(200) 200
8 INS_ID CHARACTER VARYING(20) 20
9 FACILITY_ID CHARACTER VARYING(20) 20