FCT_PI_HOME_CLAIM_MANAGEMENT_FINANCIALS_INSIGHT_TWB

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_DATE TIMESTAMP 8
2 REPORT_GROUP CHARACTER VARYING(60) 60
3 REPORT_GROUP1 CHARACTER VARYING(100) 100
4 REPORT_GROUP2 CHARACTER VARYING(100) 100
5 REPORT_GROUP3 CHARACTER VARYING(100) 100
6 REPORT_GROUP4 CHARACTER VARYING(100) 100
7 LOSS_GROUP CHARACTER VARYING(50) 50
8 SUBLOSS_GROUP CHARACTER VARYING(100) 100
9 RISK_STATE_NAME CHARACTER VARYING(256) 256
10 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
11 MAX_COMMIT_TIMESTAMP_EOM DATE 4
12 BRAND CHARACTER VARYING(256) 256
13 LOSSCAUSE_MGMT CHARACTER VARYING(256) 256
14 OP_LOB CHARACTER VARYING(256) 256
15 LARGE_LOSS_INDICATOR CHARACTER VARYING(256) 256
16 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
17 GROSS_INCURRED_BAND CHARACTER VARYING(256) 256
18 TEAM CHARACTER VARYING(256) 256
19 LOB CHARACTER VARYING(15) 15
20 ASSESSED_PATH CHARACTER VARYING(50) 50
21 ASSESSED_PROCESS CHARACTER VARYING(50) 50
22 OP_NET_INCURRED_EX_GST NUMERIC(38,6) 19
23 TOTAL_PAYMENTS_EX_GST_COST NUMERIC(18,2) 19
24 OUTSTANDING_ESTIMATES_EX_GST NUMERIC(18,2) 19
25 TOTAL_RECOVERIES_EX_GST NUMERIC(18,2) 19
26 RECOVERY_ESTIMATES_EX_GST NUMERIC(18,2) 19
27 NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
28 EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
29 NEW_CLAIM_COUNT NUMERIC(38,6) 19
30 CURR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
31 PRIOR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
32 PRIOR_1FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
33 PRIOR_2FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
34 CURR_FY_LOSS_NEW_CLAIM_COUNT INTEGER 4
35 PRIOR_FY_LOSS_ACTIVE_END_COUNT INTEGER 4
36 PRIOR_FY_LOSS_NEW_CLAIM_COUNT INTEGER 4
37 PRIOR_MONTH_LODGED_NET_INCURRED_EX_GST NUMERIC(18,2) 19
38 NON_CUM_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
39 CURR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
40 PRIOR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
41 PRIOR_MONTH_LODGED_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
42 OUTSTANDING_ESTIMATES_MOVEMENT_EX_GST NUMERIC(18,2) 19
43 PRIOR_FY_LOSS_NEW_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
44 PRIOR_FY_LOSS_NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
45 PRIOR_FY_LOSS_EXISTING_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
46 PRIOR_FY_LOSS_EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
47 EXISTING_NON_LARGE_NIC NUMERIC(18,2) 19
48 EXISTING_LARGE_NIC NUMERIC(18,2) 19
49 PCP_OP_NET_INCURRED_EX_GST NUMERIC(18,2) 19
50 PCP_TOTAL_PAYMENTS_EX_GST_COST NUMERIC(18,2) 19
51 PCP_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(18,2) 19
52 PCP_TOTAL_RECOVERIES_EX_GST NUMERIC(18,2) 19
53 PCP_RECOVERY_ESTIMATES_EX_GST NUMERIC(18,2) 19
54 PCP_NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
55 PCP_EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
56 PCP_NEW_CLAIM_COUNT INTEGER 4
57 PCP_PRIOR_MONTH_LODGED_NET_INCURRED_EX_GST NUMERIC(18,2) 19
58 PCP_PRIOR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
59 PCP_PRIOR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
60 PCP_PRIOR_MONTH_LODGED_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
61 PCP_OUTSTANDING_ESTIMATES_MOVEMENT_EX_GST NUMERIC(18,2) 19
62 PCP_NON_CUM_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
63 PCP_PRIOR_FY_LOSS_ACTIVE_END_COUNT INTEGER 4
64 PCP_EXISTING_NON_LARGE_NIC NUMERIC(18,2) 19
65 PCP_EXISTING_LARGE_NIC NUMERIC(18,2) 19
66 MTD_ACTUAL NUMERIC(38,4) 19
67 MTD_BUDGET NUMERIC(38,4) 19
68 MTD_FORECAST NUMERIC(38,4) 19
69 MTD_PCP NUMERIC(38,4) 19
70 QTD_ACTUAL NUMERIC(38,4) 19
71 QTD_BUDGET NUMERIC(38,4) 19
72 QTD_FORECAST NUMERIC(38,4) 19
73 QTD_PCP NUMERIC(38,4) 19
74 YTD_ACTUAL NUMERIC(38,4) 19
75 YTD_BUDGET NUMERIC(38,4) 19
76 YTD_FORECAST NUMERIC(38,4) 19
77 YTD_PCP NUMERIC(38,4) 19
78 MTD_QTD_ACTUALS NUMERIC(38,4) 19
79 MTD_YTD_ACTUALS NUMERIC(38,4) 19
80 MTD_QTD_BUDGET NUMERIC(38,4) 19
81 MTD_YTD_BUDGET NUMERIC(38,4) 19
82 MTD_QTD_FORECAST NUMERIC(38,4) 19
83 MTD_YTD_FORECAST NUMERIC(38,4) 19
84 MTD_YTD_PCP NUMERIC(38,4) 19
85 MTD_QTD_PCP NUMERIC(38,4) 19