CFD_TCFDD_HOME_INSURANCE_PH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 HME_INS_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
3 PRDT_SYS_CODE CHARACTER VARYING(10) 10
4 PRDT_HOLDNG_ID BIGINT 8
5 POL_NUM CHARACTER VARYING(20) 20
6 CVRG_NUM CHARACTER VARYING(6) 6
7 TRM_ID CHARACTER VARYING(20) 20
8 CRNT_TXN_NUM CHARACTER VARYING(4) 4
9 REVL_IND CHARACTER VARYING(1) 1
10 CVRG_TYP_CODE CHARACTER VARYING(3) 3
11 CMPY_CODE CHARACTER VARYING(20) 20
12 PRDT_CLASS_CODE CHARACTER VARYING(1) 1
13 PRDT_BRND_CODE CHARACTER VARYING(20) 20
14 AGNT_CHCK_DGT CHARACTER VARYING(10) 10
15 AGNT_ADDR_CODE CHARACTER VARYING(2) 2
16 AGNT_ID BIGINT 8
17 BRCH_ID BIGINT 8
18 CHNL_ID BIGINT 8
19 FNNCER_NAM_1 CHARACTER VARYING(100) 100
20 SERV_IC_NAM CHARACTER VARYING(100) 100
21 CVRG_STAT_ID BIGINT 8
22 CANCEL_RSN_ID BIGINT 8
23 OCCU_TYP_ID BIGINT 8
24 BLDG_TYP_ID BIGINT 8
25 WALL_TYP_ID BIGINT 8
26 ROOF_TYP_ID BIGINT 8
27 POL_STAT_ID BIGINT 8
28 PAYT_FREQ_ID BIGINT 8
29 RISK_INSD_STATE_CODE CHARACTER VARYING(3) 3
30 TXN_INFORCE_IND BIGINT 8
31 FRST_RISK_IND BIGINT 8
32 POL_STRT_DATE TIMESTAMP 8
33 CVRG_RENEWED_DATE TIMESTAMP 8
34 CVRG_EXPIRY_DATE TIMESTAMP 8
35 CVRG_CHG_EFF_DATE TIMESTAMP 8
36 CVRG_CHG_EXPIRY_DATE TIMESTAMP 8
37 TXN_EFF_DATE TIMESTAMP 8
38 RISK_BRTH_DATE TIMESTAMP 8
39 LURN CHARACTER VARYING(40) 40
40 LURN_SCALE CHARACTER VARYING(1) 1
41 BLDG_BUILT_YR CHARACTER VARYING(4) 4
42 PET_COV_ID BIGINT 8
43 SAFETY_NET_ID BIGINT 8
44 ALM_INSTALL_IND CHARACTER VARYING(1) 1
45 DEAD_LOCK_IND CHARACTER VARYING(1) 1
46 WNDW_LOCK_IND CHARACTER VARYING(1) 1
47 BAR_GRILL_IND CHARACTER VARYING(1) 1
48 SMOKE_ALM_IND CHARACTER VARYING(1) 1
49 HERITAGE_LISTED_IND CHARACTER VARYING(1) 1
50 WKEND_USE_IND CHARACTER VARYING(1) 1
51 SENIOR_DISC_IND CHARACTER VARYING(1) 1
52 MULTI_POL_DISC_IND CHARACTER VARYING(1) 1
53 OVR_55_DISC_IND CHARACTER VARYING(1) 1
54 FUSION_CODE CHARACTER VARYING(1) 1
55 ACDNTAL_DMG_IND CHARACTER VARYING(1) 1
56 COMBINED_DISC_IND CHARACTER VARYING(1) 1
57 SENIOR_CRD_IND CHARACTER VARYING(1) 1
58 STAFF_DISC_IND CHARACTER VARYING(1) 1
59 FENCE_COV_IND CHARACTER VARYING(1) 1
60 ALM_DISC_IND CHARACTER VARYING(1) 1
61 RETIREE_DISC_IND CHARACTER VARYING(1) 1
62 POL_DISC_IND CHARACTER VARYING(4) 4
63 SECURE_DISC_IND CHARACTER VARYING(1) 1
64 DOMESTIC_WRKRS_COMPNSTN_IND BIGINT 8
65 STAFF_FAMILY_DISC_IND BIGINT 8
66 FLOOD_CODE CHARACTER VARYING(2) 2
67 RISK_ADDR_LNE_1_TEXT CHARACTER VARYING(40) 40
68 RISK_ADDR_LNE_2_TEXT CHARACTER VARYING(40) 40
69 UNT_FLAT_NUM CHARACTER VARYING(10) 10
70 STREET_NUM_FROM_TEXT CHARACTER VARYING(4) 4
71 STREET_NUM_TO_TEXT CHARACTER VARYING(4) 4
72 STREET_NAM CHARACTER VARYING(30) 30
73 STREET_ABBREV CHARACTER VARYING(4) 4
74 RISK_SUBURB_NAM CHARACTER VARYING(50) 50
75 RISK_INSD_PCODE CHARACTER VARYING(4) 4
76 SRC_CVRG_CODE CHARACTER VARYING(4) 4
77 RISK_DESC CHARACTER VARYING(5) 5
78 FIRE_AND_BURGLARY_IND CHARACTER VARYING(4) 4
79 SPCL_ITMS_UNT_CNT BIGINT 8
80 BLDG_SUM_INSD_AMT NUMERIC(18,6) 19
81 FIXTR_FITTINGS_SUM_INSD_AMT NUMERIC(18,6) 19
82 CTS_SUM_INSD_AMT NUMERIC(18,6) 19
83 CTS_INTN_SUM_INSD_AMT NUMERIC(18,6) 19
84 CTS_OUTSIDE_SUM_INSD_AMT NUMERIC(18,6) 19
85 GEN_COV_SUM_INSD_AMT NUMERIC(18,6) 19
86 VOLUN_XS_AMT NUMERIC(18,6) 19
87 XS_AMT NUMERIC(18,6) 19
88 GEN_CVRG_XS_AMT NUMERIC(18,6) 19
89 LLORD_FIXTURE_FITTINGS_XS_AMT NUMERIC(18,6) 19
90 PUNITIVE_XS_AMT NUMERIC(18,6) 19
91 EARTHQUAKE_XS_AMT NUMERIC(18,6) 19
92 THFT_XS_AMT NUMERIC(18,6) 19
93 WATER_DMG_XS_AMT NUMERIC(18,6) 19
94 NO_CLM_DISC_PCTAGE NUMERIC(10,4) 19
95 EFF_STRT_DATE TIMESTAMP 8
96 EFF_END_DATE TIMESTAMP 8
97 SNPSHT_DATE TIMESTAMP 8
98 DATA_LOAD_DATE TIMESTAMP 8
99 SRC_SYS_ID CHARACTER VARYING(5) 5
100 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
101 LOAD_ID BIGINT 8
102 PRDT_ID BIGINT 8
103 PRDT_VAR_CODE CHARACTER VARYING(3) 3
104 CNSTRCTN_PERD_ID DOUBLE PRECISION 8
105 VIDEO_SURV_IND CHARACTER VARYING(1) 1
106 SEC_GUARD_IND CHARACTER VARYING(1) 1
107 ELECT_ACCESS_IND CHARACTER VARYING(1) 1
108 OLDEST_INSD_GNDR_IND CHARACTER VARYING(1) 1
109 CMPLT_RPLCMNT_COV_STAT_CODE CHARACTER VARYING(20) 20
110 ESTMD_RPLCMNT_COST_AMT NUMERIC(18,6) 19
111 HH_RATING_NUM_YRS DOUBLE PRECISION 8
112 HH_RATING_NUM CHARACTER VARYING(2) 2
113 PRDT_STAT_CODE CHARACTER VARYING(20) 20
114 INS_STRT_DATE TIMESTAMP 8
115 INS_END_DATE TIMESTAMP 8
116 ADDR_REF_NUM BIGINT 8
117 BUS_DIV_ID BIGINT 8
118 DERIVED_TXN_NUM DOUBLE PRECISION 8
119 OLD_PRDT_ID DOUBLE PRECISION 8
120 OLD_POL_NUM CHARACTER VARYING(20) 20
121 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
122 OLD_PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
123 OLD_CVRG_NUM CHARACTER VARYING(4) 4
124 POL_END_CONSNT_IND CHARACTER VARYING(1) 1
125 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
126 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
127 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
128 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8