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