OBP24_CZ_SC_OR_CTR_HOUSEHOLD

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_CZ_SC_OR_CTR_HOUSEHOLD

Columns
# Name Data Type Length
1 HOUSEHOLD_ID CHARACTER VARYING(100) 100
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 H_NOF_ADULTS SMALLINT 2
4 H_NOF_DEPND SMALLINT 2
5 H_TOT_ACT_OCC_INCM_M DOUBLE PRECISION 8
6 H_TOT_ACT_OCC_INCM_Y DOUBLE PRECISION 8
7 H_TOT_ALW_OCC_INCM_M DOUBLE PRECISION 8
8 H_TOT_ALW_OCC_INCM_Y DOUBLE PRECISION 8
9 H_TOT_ACT_ASST_INCM_M DOUBLE PRECISION 8
10 H_TOT_ACT_ASST_INCM_Y DOUBLE PRECISION 8
11 H_TOT_ALW_ASST_INCM_M DOUBLE PRECISION 8
12 H_TOT_ALW_ASST_INCM_Y DOUBLE PRECISION 8
13 H_TOT_LVG_EXP_M DOUBLE PRECISION 8
14 H_TOT_LVG_EXP_Y DOUBLE PRECISION 8
15 H_TOT_TAX_INCM_M DOUBLE PRECISION 8
16 H_TOT_TAX_INCM_Y DOUBLE PRECISION 8
17 H_AMT_AVL_DBT_SERV_M DOUBLE PRECISION 8
18 H_AMT_AVL_DBT_SERV_Y DOUBLE PRECISION 8
19 H_TOT_OTH_CONT_COM_M DOUBLE PRECISION 8
20 H_TOT_OTH_CONT_COM_Y DOUBLE PRECISION 8
21 H_TOT_CUS_ADV_REPY_M DOUBLE PRECISION 8
22 H_TOT_CUS_ADV_REPY_Y DOUBLE PRECISION 8
23 H_TOT_SENS_REPY_M DOUBLE PRECISION 8
24 H_TOT_SENS_REPY_Y DOUBLE PRECISION 8
25 H_TOT_TAX_FREE_INCM_M DOUBLE PRECISION 8
26 H_TOT_TAX_FREE_INCM_Y DOUBLE PRECISION 8
27 H_NET_INCM_M DOUBLE PRECISION 8
28 H_NET_INCM_Y DOUBLE PRECISION 8
29 H_NET_INCM_INC_PRP_INCM_M DOUBLE PRECISION 8
30 H_NET_INCM_INC_PRP_INCM_Y DOUBLE PRECISION 8
31 H_ACT_PROP_INCM_M DOUBLE PRECISION 8
32 H_ACT_PROP_INCM_Y DOUBLE PRECISION 8
33 H_ALW_PROP_INCM_M DOUBLE PRECISION 8
34 H_ALW_PROP_INCM_Y DOUBLE PRECISION 8
35 H_TOT_LN_REPY_EXL_NEW_LN_M DOUBLE PRECISION 8
36 H_TOT_LN_REPY_EXL_NEW_LN_Y DOUBLE PRECISION 8
37 H_TOT_LN_REPY_INL_NEW_LN_M DOUBLE PRECISION 8
38 H_TOT_LN_REPY_INL_NEW_LN_Y DOUBLE PRECISION 8
39 H_BUG_SUR_DEF_EXL_NEW_LN_M DOUBLE PRECISION 8
40 H_BUG_SUR_DEF_EXL_NEW_LN_Y DOUBLE PRECISION 8
41 H_BUG_SUR_DEF_INL_NEW_LN_M DOUBLE PRECISION 8
42 H_BUG_SUR_DEF_INL_NEW_LN_Y DOUBLE PRECISION 8
43 H_DISC_INCM_M DOUBLE PRECISION 8
44 H_DISC_INCM_Y DOUBLE PRECISION 8
45 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
46 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
47 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
48 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8