PRT_HST_HHTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER(1) 1
9 HHCNSTRYR SMALLINT 2
10 HHCNSTR CHARACTER(1) 1
11 HHDWELTYP CHARACTER(1) 1
12 HHFLOOD CHARACTER(1) 1
13 HHOCUPYAS CHARACTER(1) 1
14 HHRPLCMNT CHARACTER(1) 1
15 HHALARM CHARACTER(1) 1
16 HHDOORLCK CHARACTER(1) 1
17 HHKEYWIND CHARACTER(1) 1
18 HHGRLWIND CHARACTER(1) 1
19 HHBLDSIZE SMALLINT 2
20 HHSAFE CHARACTER(1) 1
21 HHFFOOD SMALLINT 2
22 HHCYCLONE CHARACTER(1) 1
23 HHLIABLTY INTEGER 4
24 HHPERLIAB CHARACTER(1) 1
25 HHNEIGHBW CHARACTER(1) 1
26 HHSECDISC SMALLINT 2
27 HHFLOODLD SMALLINT 2
28 HHRENTED CHARACTER(1) 1
29 HHMLTDISC CHARACTER(2) 2
30 HHSURVEY CHARACTER(1) 1
31 HHDOORSEC CHARACTER(1) 1
32 HHWATER CHARACTER(1) 1
33 HHACCIDCV CHARACTER(1) 1
34 HHUNCNSTR CHARACTER(1) 1
35 HHUNOCUPY CHARACTER(1) 1
36 HHUNOCDTE INTEGER 4
37 HHBLDCOND CHARACTER(1) 1
38 HHBUSNUSE CHARACTER(1) 1
39 HHTOOLSI NUMERIC(9,0) 19
40 HHVISTRSI NUMERIC(9,0) 19
41 HHACREAGE CHARACTER(1) 1
42 HHPRFSTR CHARACTER(1) 1
43 HHVOLXS INTEGER 4
44 HHBIRTHDTE INTEGER 4
45 HHTIMERENT CHARACTER(1) 1
46 HHTIMELOC CHARACTER(1) 1
47 HHAGE NUMERIC(3,0) 19
48 LURN CHARACTER(38) 38
49 LURNSCALE CHARACTER(1) 1
50 HHROOF CHARACTER(1) 1
51 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 RECORD_TYPE CHARACTER VARYING(16) 16
53 COMMIT_TIMESTAMP TIMESTAMP 8
54 EXTRACT_TIMESTAMP TIMESTAMP 8
55 CDC_ID BIGINT 8
56 REFID CHARACTER(15) 15
57 PETCOVER SMALLINT 2
58 MOTORBURN CHARACTER(1) 1
59 SAFETYNET CHARACTER(1) 1
60 BOND CHARACTER(1) 1
61 PROPMNGNT CHARACTER(1) 1
62 NOUNITS SMALLINT 2
63 HERITAGE CHARACTER(4) 4
64 HHPOOL CHARACTER(1) 1
65 OUTBUILDING CHARACTER(1) 1
66 SERVICES CHARACTER(2) 2
67 SENIORCARD CHARACTER(1) 1
68 LEVELS CHARACTER(2) 2
69 CONSTRSTD CHARACTER(1) 1
70 LANDSLOPE CHARACTER(1) 1
71 BEDROOMS SMALLINT 2
72 BEDSIZE CHARACTER(1) 1
73 BATHROOMS SMALLINT 2
74 AIRCOND CHARACTER(1) 1
75 GRANNYFLAT CHARACTER(1) 1
76 TENNISCRT CHARACTER(1) 1
77 VERDADECK CHARACTER(1) 1
78 CARSCOVR CHARACTER(2) 2
79 WATERTANK CHARACTER(1) 1
80 MINREBUILD INTEGER 4
81 ESTREBUILD INTEGER 4
82 TENANTPRO CHARACTER(1) 1
83 DW_TIMESTAMP TIMESTAMP 8
84 COMPANY_CDC SMALLINT 2
85 POLICY_CDC INTEGER 4
86 ACTIVTO_CDC DATE 4
87 EFFECTDTE_CDC DATE 4
88 AGREEMENT_TYPE_CDC CHARACTER(3) 3
89 FLOORTYPE CHARACTER(1) 1
90 LIFTTYPE CHARACTER(1) 1
91 RECFACILITY CHARACTER(1) 1
92 CRC CHARACTER(1) 1
93 CRCSTATUS CHARACTER(1) 1
94 FLOODRISK CHARACTER(1) 1
95 ADDRCHANGE CHARACTER(1) 1
96 STRATAIND CHARACTER(1) 1
97 DATACONF CHARACTER(1) 1
98 NODWELL SMALLINT 2
99 EQCOVERSI INTEGER 4
100 HEARAIDS CHARACTER(1) 1
101 WINDGLASS CHARACTER(1) 1
102 ROOFIMPR CHARACTER(1) 1
103 WINDSTD CHARACTER(1) 1
104 WINDPROOF CHARACTER(1) 1
105 ROLLERDOOR CHARACTER(1) 1
106 RESILSURV CHARACTER(1) 1
107 CYCLPREP CHARACTER(1) 1
108 TECHNOLOGY CHARACTER(1) 1
109 SHEDUPGR CHARACTER(1) 1
110 HOMEASSIST CHARACTER(1) 1
111 HOMEASSTTS TIMESTAMP 8