| 1 |
EXTRACT_DATE |
TIMESTAMP |
8 |
| 2 |
ACCOUNTING_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 3 |
LICENSE |
CHARACTER VARYING(50) |
50 |
| 4 |
POLICY_STAGE_LEVEL1 |
CHARACTER VARYING(20) |
20 |
| 5 |
DISTRIBUTION_CHANNEL_NAME |
CHARACTER VARYING(100) |
100 |
| 6 |
YOUNGEST_DRIVER_AGE_BANDS |
CHARACTER VARYING(8) |
8 |
| 7 |
MOTOR_INSURANCE_TYPE_NAME |
CHARACTER VARYING(60) |
60 |
| 8 |
MOTOR_INSURER |
CHARACTER VARYING(60) |
60 |
| 9 |
MOTOR_INSURANCE_YEARS |
CHARACTER VARYING(10) |
10 |
| 10 |
YEARS_LICENCED |
CHARACTER VARYING(10) |
10 |
| 11 |
ITCE_STATUS |
CHARACTER VARYING(34) |
34 |
| 12 |
RISK_REGION_NAME |
CHARACTER VARYING(100) |
100 |
| 13 |
AT_FAULT_ACCIDENT_GROUP |
CHARACTER VARYING(10) |
10 |
| 14 |
SCHEME_VEHICLE_CLASS_LEVEL2 |
CHARACTER VARYING(67) |
67 |
| 15 |
VEHICLE_AGE_BANDS |
CHARACTER VARYING(5) |
5 |
| 16 |
POLICY_TERM |
INTEGER |
4 |
| 17 |
DISCOUNT_LOADED |
CHARACTER VARYING(18) |
18 |
| 18 |
RENEWAL_TERMS |
CHARACTER VARYING(12) |
12 |
| 19 |
ISSUED_RENEWAL |
BIGINT |
8 |
| 20 |
TOTAL_PAID_POLICY_COUNT |
BIGINT |
8 |
| 21 |
TOTAL_PAID_POLICY_PREMIUM |
NUMERIC(38,2) |
19 |
| 22 |
INFORCE_POLICIES_FOR_SEGMENT |
BIGINT |
8 |
| 23 |
INFORCE_PREMIUM_FOR_SEGMENT |
NUMERIC(38,2) |
19 |
| 24 |
PRIOR_QTD_ISSUED_RENEWAL |
BIGINT |
8 |
| 25 |
PRIOR_QTD_TOTAL_PAID_POLICY_COUNT |
BIGINT |
8 |
| 26 |
PRIOR_QTD_TOTAL_PAID_POLICY_PREMIUM |
NUMERIC(38,2) |
19 |
| 27 |
PRIOR_QTD_INFORCE_POLICIES_FOR_SEGMENT |
BIGINT |
8 |
| 28 |
PRIOR_QTD_INFORCE_PREMIUM_FOR_SEGMENT |
NUMERIC(38,2) |
19 |
| 29 |
PCP_ISSUED_RENEWAL |
BIGINT |
8 |
| 30 |
PCP_TOTAL_PAID_POLICY_COUNT |
BIGINT |
8 |
| 31 |
PCP_TOTAL_PAID_POLICY_PREMIUM |
NUMERIC(38,2) |
19 |
| 32 |
PCP_INFORCE_POLICIES_FOR_SEGMENT |
BIGINT |
8 |
| 33 |
PCP_INFORCE_PREMIUM_FOR_SEGMENT |
NUMERIC(38,2) |
19 |