INT_PCSRCPN_HHTAIL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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