FCT_PI_HOME_CLAIM_MANAGEMENT_SUMMARY_INSIGHT

Database

SDSNZP01

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(256) 256
4 REPORT_GROUP2 CHARACTER VARYING(256) 256
5 REPORT_GROUP3 CHARACTER VARYING(256) 256
6 REPORT_GROUP4 CHARACTER VARYING(256) 256
7 REPORT_GROUP5 CHARACTER VARYING(256) 256
8 REPORT_GROUP6 CHARACTER VARYING(256) 256
9 REPORT_GROUP7 CHARACTER VARYING(256) 256
10 CLAIM_ID BIGINT 8
11 CLAIM_NUMBER CHARACTER VARYING(40) 40
12 LOSS_GROUP CHARACTER VARYING(15) 15
13 SUBLOSS_GROUP CHARACTER VARYING(18) 18
14 RISK_REGION CHARACTER VARYING(256) 256
15 RISK_STATE_NAME CHARACTER VARYING(256) 256
16 RISK_POSTCODE CHARACTER VARYING(60) 60
17 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
18 CLAIM_STATUS CHARACTER VARYING(256) 256
19 LOSS_LIMIT_BANDING CHARACTER VARYING(256) 256
20 CLAIM_TYPE CHARACTER VARYING(256) 256
21 ADJUSTER_TEAM CHARACTER VARYING(256) 256
22 BRAND CHARACTER VARYING(256) 256
23 OP_LOB CHARACTER VARYING(256) 256
24 PRODUCT_NAME CHARACTER VARYING(256) 256
25 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
26 CLAIM_AGE_DAYS INTEGER 4
27 FINALISED_CLAIM_AGE_BAND CHARACTER VARYING(256) 256
28 CLAIM_AGE_BAND CHARACTER VARYING(256) 256
29 MAX_TRANSACTION_DATE DATE 4
30 AGE_MOVEMENT_DAYS INTEGER 4
31 ASBESTOS_FLAG CHARACTER VARYING(256) 256
32 MOULD_FLAG CHARACTER VARYING(256) 256
33 TEMP_ACCOMMODATION_FLAG CHARACTER VARYING(256) 256
34 MEDIA_SENSITIVITY CHARACTER VARYING(256) 256
35 INSURED_CONTACT_NAME CHARACTER VARYING(256) 256
36 EVENT_TYPE CHARACTER VARYING(256) 256
37 EXPOSURE_TYPE CHARACTER VARYING(256) 256
38 LOSSCAUSE_MGMT CHARACTER VARYING(256) 256
39 LOSSCAUSE_OPR CHARACTER VARYING(256) 256
40 LARGE_LOSS_INDICATOR CHARACTER VARYING(256) 256
41 ONLINE_LODGEMENT_FLAG CHARACTER VARYING(256) 256
42 GROSS_INCURRED_BAND CHARACTER VARYING(256) 256
43 MANAGEMENT_CLAIM_COUNT INTEGER 4
44 RECOVERY_CLAIM_COUNT INTEGER 4
45 FIRST_RECEIPT_FLG BIGINT 8
46 ASSESS_FLAG CHARACTER VARYING(256) 256
47 FIRST_PAYMENT_DATE TIMESTAMP 8
48 FIRST_VENDOR_PAYMENT_DATE TIMESTAMP 8
49 FIRST_CASH_PAYMENT_DATE TIMESTAMP 8
50 CASH_SETTLEMENT_DATE DATE 4
51 REPAIR_COMPLETED_DATE DATE 4
52 SUPPLY_COMPLETED_DATE DATE 4
53 FULFILMENT_COMPLETED_DATE DATE 4
54 LODGEMENT_DATE DATE 4
55 CLOSE_DATE DATE 4
56 TEAM CHARACTER VARYING(256) 256
57 FIN_EXPOSURE_TYPE CHARACTER VARYING(256) 256
58 RECOVERY_COST_CATEGORY CHARACTER VARYING(50) 50
59 ASSESSED_PATH CHARACTER VARYING(50) 50
60 ASSESSED_PROCESS CHARACTER VARYING(50) 50
61 NET_INCURRED_EX_GST NUMERIC(18,2) 19
62 NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
63 EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
64 TOTAL_PAYMENTS_EX_GST_COST NUMERIC(18,2) 19
65 OUTSTANDING_ESTIMATES_EX_GST NUMERIC(18,2) 19
66 OUTSTANDING_RECOVERY_ESTIMATES_EX_GST NUMERIC(18,2) 19
67 TOTAL_RECOVERIES_EX_GST NUMERIC(18,2) 19
68 RECOVERY_ESTIMATES_EX_GST NUMERIC(18,2) 19
69 CURRENT_NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
70 CURRENT_EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
71 CURRENT_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(18,2) 19
72 PCP_NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
73 PCP_EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
74 PCP_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(18,2) 19
75 FINALISED_COST NUMERIC(18,2) 19
76 TRANSACTION_DAYS_NEW NUMERIC(38,0) 19
77 TRANSACTION_DAYS_AGE_BAND CHARACTER VARYING(256) 256
78 LAST_TOUCHED_DAYS_DURATION NUMERIC(38,1) 19
79 LAST_TOUCHED_DAYS_DURATION_BAND CHARACTER VARYING(256) 256
80 REOPEN_DURATION_DAYS NUMERIC(38,1) 19
81 REOPEN_INTERVAL_DAYS INTEGER 4
82 REOPEN_DURATION_DAYS_BAND CHARACTER VARYING(256) 256
83 ACTIVE_CLAIM_COUNT NUMERIC(38,2) 19
84 NEW_CLAIM_COUNT NUMERIC(38,2) 19
85 REOPENED_CLAIM_COUNT NUMERIC(38,2) 19
86 FINALISED_CLAIM_COUNT NUMERIC(38,0) 19
87 NET_MOVEMENT_COUNT NUMERIC(38,0) 19
88 ESTIMATES_EX_GST_01 NUMERIC(18,2) 19
89 ESTIMATES_EX_GST_10 NUMERIC(18,2) 19
90 ESTIMATES_EX_GST_20 NUMERIC(38,2) 19
91 ESTIMATES_EX_GST_30 NUMERIC(18,2) 19
92 ESTIMATES_EX_GST_40 NUMERIC(18,2) 19
93 ESTIMATES_EX_GST_50 NUMERIC(18,2) 19
94 ESTIMATES_CLM_CNT_01 INTEGER 4
95 ESTIMATES_CLM_CNT_10 NUMERIC(38,0) 19
96 ESTIMATES_CLM_CNT_20 NUMERIC(38,0) 19
97 ESTIMATES_CLM_CNT_30 NUMERIC(38,0) 19
98 ESTIMATES_CLM_CNT_40 NUMERIC(38,0) 19
99 ESTIMATES_CLM_CNT_50 NUMERIC(38,0) 19
100 DAYS_OF_FINALISED_CLAIM INTEGER 4
101 INGOING_ESTIMATE_EX_GST NUMERIC(18,2) 19
102 TOTAL_INGOING_ESTIMATE_EX_GST NUMERIC(18,2) 19
103 GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
104 FIRST_FINALISED_COUNT NUMERIC(18,2) 19
105 MANAGEMENT_NIC NUMERIC(18,2) 19
106 MANAGEMENT_ESTIMATES NUMERIC(18,2) 19
107 MANAGEMENT_PAYMENTS NUMERIC(18,2) 19
108 CURR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
109 PRIOR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
110 PRIOR_1FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
111 PRIOR_2FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
112 CURR_FY_LOSS_NEW_CLAIM_COUNT INTEGER 4
113 PRIOR_FY_LOSS_ACTIVE_END_COUNT INTEGER 4
114 PRIOR_FY_LOSS_NEW_CLAIM_COUNT INTEGER 4
115 PRIOR_MONTH_LODGED_NET_INCURRED_EX_GST NUMERIC(18,2) 19
116 TOTAL_RESERVES_EX_GST NUMERIC(18,2) 19
117 BUILDING_TYPE_COST NUMERIC(18,2) 19
118 CONTENTS_TYPE_COST NUMERIC(18,2) 19
119 CURR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
120 PRIOR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
121 PRIOR_MONTH_LODGED_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
122 TOTAL_VENDOR_PAYMENTS_EX_GST NUMERIC(18,2) 19
123 TOTAL_CASH_PAYMENTS_EX_GST NUMERIC(18,2) 19
124 GROSS_INCURRED_EX_GST_20 NUMERIC(18,2) 19
125 GROSS_INCURRED_EX_GST_40 NUMERIC(18,2) 19
126 GROSS_INCURRED_EX_GST_FINALISED NUMERIC(18,2) 19
127 OUTSTANDING_ESTIMATES_MOVEMENT_EX_GST NUMERIC(18,2) 19
128 OUTSTANDING_RECOVERY_ESTIMATES_MOVEMENT_EX_GST NUMERIC(18,2) 19
129 PRIOR_FY_LOSS_NEW_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
130 PRIOR_FY_LOSS_NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
131 PRIOR_FY_LOSS_EXISTING_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
132 PRIOR_FY_LOSS_EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
133 NON_CUM_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
134 OUTSTANDING_DEMANDED_EX_GST NUMERIC(18,2) 19
135 ACTIVE_RECOVERY_CLAIM_COUNT INTEGER 4
136 FIN_EXPOSURE_ACTIVE_CLAIM_COUNT INTEGER 4
137 EXISTING_NON_LARGE_NIC NUMERIC(18,2) 19
138 EXISTING_LARGE_NIC NUMERIC(18,2) 19