| 1 |
MEASURE |
CHARACTER VARYING(22) |
22 |
| 2 |
REPORT_GROUP |
CHARACTER VARYING(60) |
60 |
| 3 |
REPORT_GROUP1 |
CHARACTER VARYING(100) |
100 |
| 4 |
REPORT_GROUP2 |
CHARACTER VARYING(100) |
100 |
| 5 |
REPORT_DATE |
TIMESTAMP |
8 |
| 6 |
BRAND |
CHARACTER VARYING(256) |
256 |
| 7 |
RISK_STATE_NAME |
CHARACTER VARYING(256) |
256 |
| 8 |
LOSSCAUSE_MGMT |
CHARACTER VARYING(256) |
256 |
| 9 |
OP_LOB |
CHARACTER VARYING(256) |
256 |
| 10 |
LOSS_GROUP |
CHARACTER VARYING(50) |
50 |
| 11 |
NEW_CLAIM_COUNT |
NUMERIC(38,6) |
19 |
| 12 |
PCP_NEW_CLAIM_COUNT |
NUMERIC(38,2) |
19 |
| 13 |
MCT_1DP |
DATE |
4 |
| 14 |
OP_NET_INCURRED_EX_GST |
NUMERIC(38,6) |
19 |
| 15 |
PCP_OP_NET_INCURRED_EX_GST |
NUMERIC(38,6) |
19 |
| 16 |
NET_MOVEMENT_COUNT |
NUMERIC(38,0) |
19 |
| 17 |
PCP_NET_MOVEMENT_COUNT |
NUMERIC(38,0) |
19 |
| 18 |
NET_INCURRED_EX_GST |
NUMERIC(32,6) |
19 |
| 19 |
PCP_NET_INCURRED_EX_GST |
NUMERIC(32,6) |
19 |
| 20 |
FULFILLED_CLAIM_LIFE |
NUMERIC(38,0) |
19 |
| 21 |
FULFILLED_CLAIM_COUNT |
BIGINT |
8 |
| 22 |
PCP_FULFILLED_CLAIM_COUNT |
NUMERIC(38,6) |
19 |
| 23 |
PCP_FULFILLED_CLAIM_LIFE |
NUMERIC(38,6) |
19 |
| 24 |
MTD_ACTUAL |
NUMERIC(38,4) |
19 |
| 25 |
MTD_BUDGET |
NUMERIC(38,4) |
19 |
| 26 |
MTD_FORECAST |
NUMERIC(38,4) |
19 |
| 27 |
MTD_PCP |
NUMERIC(38,4) |
19 |
| 28 |
QTD_ACTUAL |
NUMERIC(38,4) |
19 |
| 29 |
QTD_BUDGET |
NUMERIC(38,4) |
19 |
| 30 |
QTD_FORECAST |
NUMERIC(38,4) |
19 |
| 31 |
QTD_PCP |
NUMERIC(38,4) |
19 |
| 32 |
YTD_ACTUAL |
NUMERIC(38,4) |
19 |
| 33 |
YTD_BUDGET |
NUMERIC(38,4) |
19 |
| 34 |
YTD_FORECAST |
NUMERIC(38,4) |
19 |
| 35 |
YTD_PCP |
NUMERIC(38,4) |
19 |
| 36 |
REPORT_FINANCIAL_YEAR |
INTEGER |
4 |
| 37 |
PRIOR_MONTH_TIMING |
CHARACTER VARYING(200) |
200 |
| 38 |
PRIOR_QUARTER_TIMING |
CHARACTER VARYING(2) |
2 |
| 39 |
PRIOR_QUARTER_LAST_MONTH |
TIMESTAMP |
8 |
| 40 |
PRIOR_QUARTER_START_MONTH |
TIMESTAMP |
8 |
| 41 |
CURRENT_FINANCIAL_YEAR |
INTEGER |
4 |
| 42 |
PRIOR_MONTH_QUARTER |
TIMESTAMP |
8 |
| 43 |
FIRST_DATE |
DATE |
4 |
| 44 |
LAST_DATE |
DATE |
4 |
| 45 |
SUNDAY_TD |
INTEGER |
4 |
| 46 |
MONDAY_TD |
INTEGER |
4 |
| 47 |
TUESDAY_TD |
INTEGER |
4 |
| 48 |
WEDNESDAY_TD |
INTEGER |
4 |
| 49 |
THURSDAY_TD |
INTEGER |
4 |
| 50 |
FRIDAY_TD |
INTEGER |
4 |
| 51 |
SATURDAY_TD |
INTEGER |
4 |
| 52 |
SUNDAY_PM |
INTEGER |
4 |
| 53 |
MONDAY_PM |
INTEGER |
4 |
| 54 |
TUESDAY_PM |
INTEGER |
4 |
| 55 |
WEDNESDAY_PM |
INTEGER |
4 |
| 56 |
THURSDAY_PM |
INTEGER |
4 |
| 57 |
FRIDAY_PM |
INTEGER |
4 |
| 58 |
SATURDAY_PM |
INTEGER |
4 |
| 59 |
SUN_TD |
NUMERIC(12,1) |
19 |
| 60 |
SUN_PM |
NUMERIC(12,1) |
19 |
| 61 |
MON_TD |
NUMERIC(13,1) |
19 |
| 62 |
MON_PM |
NUMERIC(13,1) |
19 |
| 63 |
TUE_TD |
NUMERIC(13,1) |
19 |
| 64 |
TUE_PM |
NUMERIC(13,1) |
19 |
| 65 |
WED_TD |
NUMERIC(13,1) |
19 |
| 66 |
WED_PM |
NUMERIC(13,1) |
19 |
| 67 |
THUR_TD |
NUMERIC(13,1) |
19 |
| 68 |
THUR_PM |
NUMERIC(13,1) |
19 |
| 69 |
FRI_TD |
NUMERIC(13,1) |
19 |
| 70 |
FRI_PM |
NUMERIC(13,1) |
19 |
| 71 |
SAT_TD |
NUMERIC(12,1) |
19 |
| 72 |
SAT_PM |
NUMERIC(12,1) |
19 |