FCT_BNK_CRHDS_CTR_APPLICANT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 AUTO_APPLICANT_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 APPLICANT_ID CHARACTER VARYING(40) 40
4 CALL_TYPE CHARACTER VARYING(50) 50
5 NAME CHARACTER VARYING(100) 100
6 MAR_STATUS CHARACTER VARYING(50) 50
7 N_OF_DEPNDS DOUBLE PRECISION 8
8 APP_TYPE CHARACTER VARYING(50) 50
9 GEN_LIVING_COST DOUBLE PRECISION 8
10 PRP_INCM_SOURCE CHARACTER VARYING(50) 50
11 PRP_INCM_OWN_P DOUBLE PRECISION 8
12 PRP_INCM_AMT DOUBLE PRECISION 8
13 PRP_INCM_PERIOD CHARACTER VARYING(50) 50
14 O_CONT_COMM_PER_MON_AMT DOUBLE PRECISION 8
15 O_CONT_COMM_PER_MON_PERIOD CHARACTER VARYING(50) 50
16 TAXABLE_INVEST_INCM_M DOUBLE PRECISION 8
17 TAXABLE_INVEST_INCM_Y DOUBLE PRECISION 8
18 TAXABLE_INCOME_M DOUBLE PRECISION 8
19 TAXABLE_INCOME_Y DOUBLE PRECISION 8
20 TAXTN_EXPENSE_M DOUBLE PRECISION 8
21 TAXTN_EXPENSE_Y DOUBLE PRECISION 8
22 TTL_TAX_FREE_INCM_M DOUBLE PRECISION 8
23 TTL_TAX_FREE_INCM_Y DOUBLE PRECISION 8
24 TTL_OTHER_CON_COM_M DOUBLE PRECISION 8
25 TTL_OTHER_CON_COM_Y DOUBLE PRECISION 8
26 NET_INCM_M DOUBLE PRECISION 8
27 NET_INCM_Y DOUBLE PRECISION 8
28 NET_INCM_INC_PI_M DOUBLE PRECISION 8
29 NET_INCM_INC_PI_Y DOUBLE PRECISION 8
30 APP_SPOUSE_ID CHARACTER VARYING(50) 50