| 1 |
CLAIMNUMBER |
CHARACTER VARYING(40) |
40 |
| 2 |
CLAIMORDER |
BIGINT |
8 |
| 3 |
EXPOSUREID |
BIGINT |
8 |
| 4 |
POLICYNUMBER |
CHARACTER VARYING(40) |
40 |
| 5 |
PRODUCTTYPE |
BIGINT |
8 |
| 6 |
LOSSTYPE |
BIGINT |
8 |
| 7 |
POLICYCOVERAGE |
BIGINT |
8 |
| 8 |
ITEMNO |
INTEGER |
4 |
| 9 |
LINEOFBUSINESS |
BIGINT |
8 |
| 10 |
CHANNEL |
CHARACTER VARYING(20) |
20 |
| 11 |
FIRST_EFFECTIVE_DT_POLICY |
DATE |
4 |
| 12 |
EFFECTIVE_DT_CURRENT_TERM |
DATE |
4 |
| 13 |
DATE_POLICY_EXPIRE |
DATE |
4 |
| 14 |
MVBRAND |
BIGINT |
8 |
| 15 |
PREMIUMPAYMENT_MODE |
BIGINT |
8 |
| 16 |
INS_RESPONSIBILITY_CENTRE |
CHARACTER VARYING(4) |
4 |
| 17 |
SERVICE_CENTRE |
CHARACTER VARYING(4) |
4 |
| 18 |
VEHICLE_NVIC |
CHARACTER VARYING(15) |
15 |
| 19 |
MAKE |
CHARACTER VARYING(60) |
60 |
| 20 |
MODEL |
CHARACTER VARYING(80) |
80 |
| 21 |
MARKETVALUE_OR_SUM_INS |
CHARACTER VARYING(1) |
1 |
| 22 |
SUMINS_MKTVAL |
NUMERIC(18,2) |
19 |
| 23 |
VEHICLEYEAR |
BIGINT |
8 |
| 24 |
SC_COVERAGESOURCEKEY |
CHARACTER VARYING(40) |
40 |
| 25 |
SC_PREMIUMCLASS |
BIGINT |
8 |
| 26 |
VEHICLECOVERAGETYPE |
BIGINT |
8 |
| 27 |
BROKER |
CHARACTER VARYING(120) |
120 |
| 28 |
AGENT |
CHARACTER VARYING(120) |
120 |