PRT_MHTAIL

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 MHCNSTR CHARACTER(1) 1
10 MHPROPLSN CHARACTER(1) 1
11 MHSPEED SMALLINT 2
12 MHMOORED CHARACTER(1) 1
13 MHLIBSI INTEGER 4
14 MHSKLIBSI INTEGER 4
15 MHTYPE CHARACTER(1) 1
16 MHHULLFT SMALLINT 2
17 MHHULLMTR SMALLINT 2
18 MHPOWER SMALLINT 2
19 MHFUEL CHARACTER(1) 1
20 MHRACING CHARACTER(1) 1
21 MHNCBPC SMALLINT 2
22 MHLANDTRN CHARACTER(1) 1
23 MHYEARBLT SMALLINT 2
24 MHHULLMKE CHARACTER(3) 3
25 MHFARESI INTEGER 4
26 POSTCODE INTEGER 4
27 MHCLUB CHARACTER(6) 6
28 MHENGMAKE CHARACTER(3) 3
29 MHENGNO CHARACTER(20) 20
30 MHENGYEAR SMALLINT 2
31 MHTRLMAKE CHARACTER(3) 3
32 MHTRLYEAR SMALLINT 2
33 MHTRLCNST CHARACTER(1) 1
34 MHDESTIN CHARACTER(60) 60
35 MHRPLCMNT CHARACTER(1) 1
36 MHSTORED CHARACTER(1) 1
37 MHEXTEND CHARACTER(1) 1
38 MHCVRTYPE CHARACTER(1) 1
39 MHHULLLEN NUMERIC(3,1) 19
40 MHACCESRY CHARACTER(1) 1
41 MHMODS CHARACTER(1) 1
42 MHHEALTH CHARACTER(1) 1
43 MHSURVEY CHARACTER(1) 1
44 MHPDAMAGE CHARACTER(1) 1
45 MHHIRED CHARACTER(1) 1
46 MHVEHUSE CHARACTER(1) 1
47 MHREG CHARACTER(7) 7
48 MHTRAILER CHARACTER(1) 1
49 MHSKLIB CHARACTER(1) 1
50 MHSIDESC CHARACTER(1) 1
51 MHTHEFTXS INTEGER 4
52 MHRATING CHARACTER(2) 2
53 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
54 RECORD_TYPE CHARACTER VARYING(16) 16
55 COMMIT_TIMESTAMP TIMESTAMP 8
56 EXTRACT_TIMESTAMP TIMESTAMP 8
57 CDC_ID BIGINT 8
58 COMPANY_CDC SMALLINT 2
59 AGREEMENT_TYPE_CDC CHARACTER(3) 3
60 POLICY_CDC INTEGER 4
61 ACTIVTO_CDC DATE 4
62 EFFECTDTE_CDC DATE 4
63 LURN CHARACTER(38) 38
64 LURNSCALE CHARACTER(1) 1
65 NVIC CHARACTER(6) 6
66 VEHCAT CHARACTER(2) 2
67 LUCOVER1 SMALLINT 2
68 LUCOVER2 SMALLINT 2
69 LUCOVER3 SMALLINT 2
70 LUCOVER4 SMALLINT 2
71 LUCOVER5 SMALLINT 2
72 LUCOVER6 SMALLINT 2
73 CNTSUMINS INTEGER 4
74 HSUMINS INTEGER 4
75 HMKTSI INTEGER 4
76 ENYEAR1 SMALLINT 2
77 ENMAKE1 CHARACTER(3) 3
78 ENMODEL1 CHARACTER(40) 40
79 ENFUEL1 CHARACTER(1) 1
80 ENPOWER1 SMALLINT 2
81 ENNO1 CHARACTER(20) 20
82 ENSUMINS1 INTEGER 4
83 ENMKTSI1 INTEGER 4
84 ENNVIC1 CHARACTER(6) 6
85 ENVEHCAT1 CHARACTER(2) 2
86 ENYEAR2 SMALLINT 2
87 ENMAKE2 CHARACTER(3) 3
88 ENMODEL2 CHARACTER(40) 40
89 ENFUEL2 CHARACTER(1) 1
90 ENPOWER2 SMALLINT 2
91 ENNO2 CHARACTER(20) 20
92 ENSUMINS2 INTEGER 4
93 ENMKTSI2 INTEGER 4
94 ENNVIC2 CHARACTER(6) 6
95 ENVEHCAT2 CHARACTER(2) 2
96 TRMODEL CHARACTER(40) 40
97 TRAXLE CHARACTER(1) 1
98 TRLENGTH NUMERIC(3,1) 19
99 TRBRAKES CHARACTER(1) 1
100 TRSUMINS INTEGER 4
101 TRMKTSI INTEGER 4
102 TRNVIC CHARACTER(6) 6
103 TRVEHCAT CHARACTER(2) 2
104 DW_TIMESTAMP TIMESTAMP 8
105 DATACONF CHARACTER(1) 1