| # |
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 |