| # |
Name |
Data Type |
Length |
| 1 |
POLICY_NUMBER |
CHARACTER VARYING(39) |
39 |
| 2 |
POLICY_TERM |
INTEGER |
4 |
| 3 |
VEHICLE_CLASS |
CHARACTER(4) |
4 |
| 4 |
USER_TRANSACTION_TYPE |
CHARACTER VARYING(510) |
510 |
| 5 |
TRANSACTION_TYPE |
CHARACTER VARYING(510) |
510 |
| 6 |
TRANSACTION_DATE |
INTEGER |
4 |
| 7 |
ITEMPREM_EFFECTDTE |
INTEGER |
4 |
| 8 |
ITEMPREM_RETAILPREM |
NUMERIC(15,6) |
19 |
| 9 |
ITEMPREM_STCHARGE |
NUMERIC(15,6) |
19 |
| 10 |
ITEMPREM_GST |
NUMERIC(15,6) |
19 |
| 11 |
CALCULATED_ITEMPREM_AMT |
NUMERIC(17,6) |
19 |
| 12 |
OTHRPREM_BASICPRM |
NUMERIC(11,2) |
19 |
| 13 |
OTHRPREM_CHARGES |
NUMERIC(11,2) |
19 |
| 14 |
OTHRPREM_GST |
NUMERIC(11,2) |
19 |
| 15 |
CALCULATED_OTHRPREM_AMT |
NUMERIC(13,2) |
19 |
| 16 |
CALCULATED_VARIANCE |
NUMERIC(18,6) |
19 |
| 17 |
ROW_RANK |
BIGINT |
8 |