FCT_PI_HOME_CLAIM_OPERATIONS_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIM_NUMBER CHARACTER VARYING(40) 40
3 ACTIVATION_DATE TIMESTAMP 8
4 ADJUSTER CHARACTER VARYING(181) 181
5 ADJUSTER_TEAM CHARACTER VARYING(100) 100
6 ADJUSTER_TEAM_GROUP CHARACTER VARYING(100) 100
7 ADJUSTER_TEAM_GROUP_REGION CHARACTER VARYING(100) 100
8 BRAND CHARACTER VARYING(256) 256
9 CATASTROPHE_NAME CHARACTER VARYING(60) 60
10 CATASTROPHE_NUMBER CHARACTER VARYING(60) 60
11 CLAIM_LOSS_DATE TIMESTAMP 8
12 CLAIM_TYPE CHARACTER VARYING(256) 256
13 CLOSED_DATE TIMESTAMP 8
14 EXPOSURE_TYPE CHARACTER VARYING(19) 19
15 LARGE_LOSS_INDICATOR CHARACTER(3) 3
16 LODGEMENT_DATE DATE 4
17 LODGEMENT_USER BIGINT 8
18 LOSS_CAUSE CHARACTER VARYING(256) 256
19 LOSS_CAUSE_REPORTED CHARACTER VARYING(256) 256
20 LOSS_GROUP CHARACTER VARYING(15) 15
21 LOSS_LIMIT_BANDING CHARACTER VARYING(40) 40
22 OPERATIONAL_LOB CHARACTER VARYING(16) 16
23 POLICY_ID BIGINT 8
24 REPORT_ONLY CHARACTER VARYING(256) 256
25 REPORTED_DATE TIMESTAMP 8
26 RISK_REGION CHARACTER VARYING(8) 8
27 RISK_STATE CHARACTER VARYING(256) 256
28 SUBLOSS_GROUP CHARACTER VARYING(18) 18
29 STORM_CAUSE CHARACTER VARYING(1541) 1541
30 GROSS_INCURRED NUMERIC(18,2) 19
31 GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
32 FIRST_DAY_NET_INCURRED NUMERIC(18,2) 19
33 PAYMENT_GST NUMERIC(18,2) 19
34 RECOVERY_GST NUMERIC(18,2) 19
35 OPEN_RESERVES_EX_GST NUMERIC(18,2) 19
36 OPEN_RECOVERY_RESERVES_EX_GST NUMERIC(18,2) 19
37 NET_INCURRED_EX_GST NUMERIC(18,2) 19
38 NET_INCURRED_EX_GST_PROPERTY_DAMAGE NUMERIC(38,2) 19
39 OPEN_RECOVERY_RESERVES NUMERIC(18,2) 19
40 OPEN_RESERVES NUMERIC(18,2) 19
41 TOTAL_PAYMENTS NUMERIC(18,2) 19
42 TOTAL_RECOVERIES_EX_GST NUMERIC(18,2) 19
43 EVENT_NAME CHARACTER VARYING(256) 256
44 RISK_POSTCODE CHARACTER VARYING(60) 60
45 LOSS_STATE CHARACTER VARYING(256) 256
46 CLAIM_STATE CHARACTER VARYING(256) 256
47 ESTIMATE_UPDATE_FLAG CHARACTER VARYING(3) 3