OBP24_CZ_SC_OR_CTR_AGGR_SUMMARY

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_CZ_SC_OR_CTR_AGGR_SUMMARY

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(100) 100
2 FINANCIAL_ANALYSIS_ID CHARACTER VARYING(50) 50
3 T_ACT_OCC_INC_M DOUBLE PRECISION 8
4 T_ACT_OCC_INC_Y DOUBLE PRECISION 8
5 T_ALL_OCC_INC_M DOUBLE PRECISION 8
6 T_ALL_OCC_INC_Y DOUBLE PRECISION 8
7 T_ACT_ASS_INC_M DOUBLE PRECISION 8
8 T_ACT_ASS_INC_Y DOUBLE PRECISION 8
9 T_ALL_ASS_INC_M DOUBLE PRECISION 8
10 T_ALL_ASS_INC_Y DOUBLE PRECISION 8
11 T_TAX_EXP_M DOUBLE PRECISION 8
12 T_TAX_EXP_Y DOUBLE PRECISION 8
13 T_TAX_FREE_INC_M DOUBLE PRECISION 8
14 T_TAX_FREE_INC_Y DOUBLE PRECISION 8
15 T_ACT_PRO_INC_M DOUBLE PRECISION 8
16 T_ACT_PRO_INC_Y DOUBLE PRECISION 8
17 T_ALL_PRO_INC_M DOUBLE PRECISION 8
18 T_ALL_PRO_INC_Y DOUBLE PRECISION 8
19 T_NIE_PRO_INC_M DOUBLE PRECISION 8
20 T_NIE_PRO_INC_Y DOUBLE PRECISION 8
21 T_NII_PRO_INC_M DOUBLE PRECISION 8
22 T_NII_PRO_INC_Y DOUBLE PRECISION 8
23 T_AGG_BSOD_EXC_NL_M DOUBLE PRECISION 8
24 T_AGG_BSOD_EXC_NL_Y DOUBLE PRECISION 8
25 T_AGG_BSOD_INC_NL_M DOUBLE PRECISION 8
26 T_AGG_BSOD_INC_NL_Y DOUBLE PRECISION 8
27 T_LIV_EXP_M DOUBLE PRECISION 8
28 T_LIV_EXP_Y DOUBLE PRECISION 8
29 T_OTH_CON_COM_M DOUBLE PRECISION 8
30 T_OTH_CON_COM_Y DOUBLE PRECISION 8
31 T_EX_CON_FIN_COM_M DOUBLE PRECISION 8
32 T_EX_CON_FIN_COM_Y DOUBLE PRECISION 8
33 T_CUST_ADV_REPAY_M DOUBLE PRECISION 8
34 T_CUST_ADV_REPAY_Y DOUBLE PRECISION 8
35 T_HOH_SENS_REPAY_M DOUBLE PRECISION 8
36 T_HOH_SENS_REPAY_Y DOUBLE PRECISION 8
37 O_AMT_AVA_FD_SER_M DOUBLE PRECISION 8
38 O_AMT_AVA_FD_SER_Y DOUBLE PRECISION 8
39 T_NEW_SEN_REPAY_M DOUBLE PRECISION 8
40 T_NEW_SEN_REPAY_Y DOUBLE PRECISION 8
41 T_NEW_CON_REPAY_M DOUBLE PRECISION 8
42 T_NEW_CON_REPAY_Y DOUBLE PRECISION 8
43 T_NEW_CON_AK_FEE_M DOUBLE PRECISION 8
44 T_NEW_CON_AK_FEE_Y DOUBLE PRECISION 8
45 AGG_DIS_INC_M DOUBLE PRECISION 8
46 AGG_DIS_INC_Y DOUBLE PRECISION 8
47 T_ALL_NET_INC_M DOUBLE PRECISION 8
48 T_ALL_NET_INC_Y DOUBLE PRECISION 8
49 T_NET_AVA_INC_M DOUBLE PRECISION 8
50 T_NET_AVA_INC_Y DOUBLE PRECISION 8
51 T_RET_CSHFLOW_M DOUBLE PRECISION 8
52 T_RET_CSHFLOW_Y DOUBLE PRECISION 8
53 T_AGG_LR_EXC_NL_M DOUBLE PRECISION 8
54 T_AGG_LR_EXC_NL_Y DOUBLE PRECISION 8
55 T_AGG_LR_INC_NL_M DOUBLE PRECISION 8
56 T_AGG_LR_INC_NL_Y DOUBLE PRECISION 8
57 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
58 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
59 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
60 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8