PRT_PROPTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 TRANCNT SMALLINT 2
6 EFFECTDTE INTEGER 4
7 ACTIVTO INTEGER 4
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 OCCUPATN CHARACTER VARYING(4) 4
10 LOSSRATIO NUMERIC(11,2) 19
11 VOLEXCESS SMALLINT 2
12 RATESIZE INTEGER 4
13 BUILDSI INTEGER 4
14 CONTSI INTEGER 4
15 STOCKSI INTEGER 4
16 TOBLIQSI INTEGER 4
17 TRANSBHSI INTEGER 4
18 INSAFESI INTEGER 4
19 OTHERSI INTEGER 4
20 CONSTRUCT CHARACTER VARYING(1) 1
21 SECURTY CHARACTER VARYING(1) 1
22 LOCALITY CHARACTER VARYING(2) 2
23 SURVEY CHARACTER VARYING(1) 1
24 SRVYGRD CHARACTER VARYING(3) 3
25 SRVYREF CHARACTER VARYING(12) 12
26 RPLCMNT CHARACTER VARYING(1) 1
27 FLOOD CHARACTER VARYING(2) 2
28 HISTRATE CHARACTER VARYING(4) 4
29 CLAIMCNT SMALLINT 2
30 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 RECORD_TYPE CHARACTER VARYING(16) 16
32 COMMIT_TIMESTAMP TIMESTAMP 8
33 EXTRACT_TIMESTAMP TIMESTAMP 8
34 CDC_ID BIGINT 8
35 COMPANY_CDC SMALLINT 2
36 POLICY_CDC BIGINT 8
37 ACTIVTO_CDC DATE 4
38 EFFECTDTE_CDC DATE 4
39 DW_TIMESTAMP TIMESTAMP 8
40 WALLTYPE CHARACTER(4) 4
41 ROOFTYPE CHARACTER(4) 4
42 FLOORTYPE CHARACTER(4) 4
43 SPRINKLER CHARACTER(1) 1
44 MDREGION CHARACTER(2) 2
45 EQREGION CHARACTER(2) 2
46 SOILTYPE CHARACTER(2) 2
47 REMOTE CHARACTER(2) 2
48 BLDDESIGN CHARACTER(2) 2
49 BLDQUALITY CHARACTER(2) 2
50 CONSTRYR SMALLINT 2
51 VALDATE INTEGER 4
52 LEVELS SMALLINT 2
53 BUILDIV INTEGER 4
54 BUILDIVI INTEGER 4
55 BUILDRV INTEGER 4
56 BUILDRVI INTEGER 4
57 CONTIV INTEGER 4
58 CONTRV INTEGER 4
59 STOCKIV INTEGER 4
60 STOCKSE INTEGER 4
61 OTHERIV INTEGER 4
62 OTHERRV INTEGER 4
63 TOTALIV INTEGER 4
64 EXCESS INTEGER 4
65 EXCESSPC NUMERIC(5,2) 19
66 XSSUBTYPE CHARACTER(1) 1
67 SURVTYP CHARACTER(1) 1
68 SURVDATE INTEGER 4
69 SURVPTS SMALLINT 2
70 UWCATG CHARACTER(2) 2