CFD_TCFDD_HOME_INS_PH_ADTNL_DTL

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 HME_INS_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 CRNT_TXN_NUM CHARACTER VARYING(10) 10
5 INTN_CLIENT_NUM INTEGER 4
6 PREV_INSD_IND CHARACTER VARYING(3) 3
7 PREV_INSRR_ID BIGINT 8
8 PREV_INSRR_CODE CHARACTER VARYING(20) 20
9 NEW_BUS_SRC_ID BIGINT 8
10 NEW_BUS_SRC_CODE CHARACTER VARYING(20) 20
11 FIRE_BRIGADE_AREA_ID BIGINT 8
12 FIRE_BRIGADE_AREA_CODE CHARACTER VARYING(20) 20
13 INSD_OCCUP_ID BIGINT 8
14 INSD_OCCUP_CODE CHARACTER VARYING(20) 20
15 SEC_DOOR_IND CHARACTER VARYING(3) 3
16 BUS_USE_IND CHARACTER VARYING(3) 3
17 NEIGHBOURHOOD_WATCH_IND CHARACTER VARYING(3) 3
18 BLDG_SIZE_NUM INTEGER 4
19 RENTED_IND CHARACTER VARYING(3) 3
20 PRFSNL_STORAGE_IND CHARACTER VARYING(3) 3
21 UNDER_CNSTRCTN_RNVTN_IND CHARACTER VARYING(3) 3
22 UNOCUPD_IND CHARACTER VARYING(3) 3
23 UNOCUPNCY_STRT_DATE TIMESTAMP 8
24 TOOLS_SUM_INSD_AMT NUMERIC(18,6) 19
25 VISITOR_EFFECTS_SUM_INSD_AMT NUMERIC(18,6) 19
26 OWNR_OCUPR_LIAB_AMT NUMERIC(18,6) 19
27 FLD_COV_LDNG_PCTAGE NUMERIC(10,4) 19
28 WATER_TANK_INSTLD_IND CHARACTER VARYING(3) 3
29 BLDG_SRVY_IND CHARACTER VARYING(3) 3
30 BLDG_COND_IND CHARACTER VARYING(3) 3
31 SAFE_LCKR_IND CHARACTER VARYING(3) 3
32 CUST_CHNL_REF_CODE CHARACTER VARYING(20) 20
33 SUM_INSD_TYP_ID BIGINT 8
34 SUM_INSD_TYP_CODE CHARACTER VARYING(20) 20
35 XS_RSN_ID BIGINT 8
36 XS_RSN_CODE CHARACTER VARYING(20) 20
37 BUS_TXN_CMPLTN_IND CHARACTER VARYING(3) 3
38 MISC_RBTE_PCTAGE NUMERIC(10,4) 19
39 MISC_LDNG_PCTAGE NUMERIC(10,4) 19
40 TXN_PREM_CALC_OVRDE_RSN_ID BIGINT 8
41 TXN_PREM_CALC_OVRDE_RSN_CODE CHARACTER VARYING(20) 20
42 ANN_PREM_CALC_OVRDE_RSN_ID BIGINT 8
43 ANN_PREM_CALC_OVRDE_RSN_CODE CHARACTER VARYING(20) 20
44 SNPSHT_DATE TIMESTAMP 8
45 DATA_LOAD_DATE TIMESTAMP 8
46 SRC_SYS_ID CHARACTER VARYING(5) 5
47 LOAD_ID BIGINT 8
48 DISC_GRP_ID BIGINT 8
49 DISC_GRP_CODE CHARACTER VARYING(20) 20
50 POL_REN_NOTICE_STAT_IND CHARACTER VARYING(1) 1
51 POL_REN_NOTICE_TYP_CODE CHARACTER VARYING(1) 1
52 RISK_CVRG_GRP_CODE CHARACTER VARYING(2) 2
53 TXN_IMG_FLG CHARACTER VARYING(1) 1
54 POL_LOCK_UID CHARACTER VARYING(20) 20
55 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
56 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
57 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
58 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8