INT_PCSRCPN_MHTAIL

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