FCT_BNK_CRHDS_CTR_ORGS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 AUTO_ORG_ID CHARACTER VARYING(100) 100
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 AUTO_APPLICANT_ID CHARACTER VARYING(40) 40
4 ORG_ID CHARACTER VARYING(50) 50
5 O_CALL_TYPE CHARACTER VARYING(50) 50
6 O_NAME CHARACTER VARYING(50) 50
7 O_CLASSIFICATION CHARACTER VARYING(50) 50
8 O_ALL_NET_INC_AMT DOUBLE PRECISION 8
9 O_ALL_NET_INC_PER CHARACTER VARYING(50) 50
10 O_NET_AVAIL_INC_AMT DOUBLE PRECISION 8
11 O_NET_AVAIL_INC_PER CHARACTER VARYING(50) 50
12 O_RET_CASH_FLOW_AMT DOUBLE PRECISION 8
13 O_RET_CASH_FLOW_PER CHARACTER VARYING(50) 50
14 O_TOT_CUST_ADV_REPAY_M DOUBLE PRECISION 8
15 O_TOT_CUST_ADV_REPAY_Y DOUBLE PRECISION 8
16 O_TOT_SENS_READY_M DOUBLE PRECISION 8
17 O_TOT_SENS_READY_Y DOUBLE PRECISION 8
18 O_ACT_PROP_INC_M DOUBLE PRECISION 8
19 O_ACT_PROP_INC_Y DOUBLE PRECISION 8
20 O_ALL_PROP_INC_M DOUBLE PRECISION 8
21 O_ALL_PROP_INC_Y DOUBLE PRECISION 8
22 O_AMT_AVAIL_FOR_DS_M DOUBLE PRECISION 8
23 O_AMT_AVAIL_FOR_DS_Y DOUBLE PRECISION 8
24 O_TOT_LOAN_REPAY_ENL_M DOUBLE PRECISION 8
25 O_TOT_LOAN_REPAY_ENL_Y DOUBLE PRECISION 8
26 O_TOT_LOAN_REPAY_INL_M DOUBLE PRECISION 8
27 O_TOT_LOAN_REPAY_INL_Y DOUBLE PRECISION 8
28 O_BUD_SUR_ODEF_ENL_M DOUBLE PRECISION 8
29 O_BUD_SUR_ODEF_ENL_Y DOUBLE PRECISION 8
30 O_BUD_SUR_ODEF_INL_M DOUBLE PRECISION 8
31 O_BUD_SUR_ODEF_INL_Y DOUBLE PRECISION 8
32 O_DISC_INC_M DOUBLE PRECISION 8
33 O_DISC_INC_Y DOUBLE PRECISION 8