FCT_BNK_CCI_DATA_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 INS_ID CHARACTER VARYING(20) 20
2 INSURED_AMOUNT DOUBLE PRECISION 8
3 NOMINATED_ACCOUNT CHARACTER VARYING(50) 50
4 PREMIUM_AMOUNT DOUBLE PRECISION 8
5 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
6 PLCY_CANCEL_DATE TIMESTAMP 8
7 COVER_END_DATE TIMESTAMP 8
8 COVER_START_DATE TIMESTAMP 8
9 MIN_DATE TIMESTAMP 8
10 MATURITY_DATE TIMESTAMP 8
11 REASON CHARACTER VARYING(7) 7
12 COVER CHARACTER VARYING(1) 1
13 ACC_CLOSE CHARACTER VARYING(1) 1
14 CANCEL CHARACTER VARYING(1) 1
15 BORR_COUNT BIGINT 8
16 DISB_COV NUMERIC(38,0) 19