FCT_PI_HOME_CLAIM_ACS_AFC_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(256) 256
6 REPORT_GROUP4 CHARACTER VARYING(100) 100
7 LOSS_GROUP CHARACTER VARYING(15) 15
8 SUBLOSS_GROUP CHARACTER VARYING(256) 256
9 LARGE_LOSS_IND CHARACTER VARYING(256) 256
10 RISK_REGION CHARACTER VARYING(256) 256
11 RISK_STATE_NAME CHARACTER VARYING(256) 256
12 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
13 BRAND CHARACTER VARYING(256) 256
14 LOSSCAUSE_MGMT CHARACTER VARYING(256) 256
15 LOSSCAUSE_OPR CHARACTER VARYING(256) 256
16 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
17 MEDIA_SENSITIVITY CHARACTER VARYING(256) 256
18 GROSS_INCURRED_BAND CHARACTER VARYING(256) 256
19 EXPOSURE_TYPE CHARACTER VARYING(256) 256
20 TEAM CHARACTER VARYING(256) 256
21 OP_LOB CHARACTER VARYING(256) 256
22 AS_AT_LARGE_LOSS_INDICATOR CHARACTER VARYING(256) 256
23 AS_AT_GROSS_INCURRED_BAND CHARACTER VARYING(256) 256
24 AS_AT_SUBLOSS_GROUP CHARACTER VARYING(100) 100
25 ASSESSED_PATH CHARACTER VARYING(50) 50
26 ASSESSED_PROCESS CHARACTER VARYING(50) 50
27 NEW_CLAIM_COUNT NUMERIC(38,6) 19
28 NEW_CLAIM_COUNT_EXPOSURE NUMERIC(38,0) 19
29 NET_INCURRED_EX_GST NUMERIC(38,6) 19
30 NEW_NET_INCURRED_EX_GST NUMERIC(38,2) 19
31 MANAGEMENT_ESTIMATES NUMERIC(38,2) 19
32 MANAGEMENT_PAYMENTS NUMERIC(38,2) 19
33 RECOVERY_ESTIMATES_EX_GST NUMERIC(38,2) 19
34 AS_AT_GROSS_INCURRED_EX_GST NUMERIC(38,2) 19
35 PCP_NET_INCURRED_EX_GST NUMERIC(38,2) 19
36 PCP_NEW_CLAIM_COUNT NUMERIC(38,0) 19
37 PCP_NEW_CLAIM_COUNT_EXPOSURE NUMERIC(38,0) 19
38 PCP_NEW_NET_INCURRED_EX_GST NUMERIC(38,2) 19
39 PCP_MANAGEMENT_ESTIMATES NUMERIC(38,2) 19
40 PCP_MANAGEMENT_PAYMENTS NUMERIC(38,2) 19
41 PCP_RECOVERY_ESTIMATES_EX_GST NUMERIC(38,2) 19
42 PCP_AS_AT_GROSS_INCURRED_EX_GST NUMERIC(38,2) 19
43 BUILDING_ESTIMATES NUMERIC(38,2) 19
44 BUILDING_PAYMENTS NUMERIC(38,2) 19
45 BUILDING_CLAIM_COST NUMERIC(38,2) 19
46 CONTENTS_ESTIMATES NUMERIC(38,2) 19
47 CONTENTS_PAYEMENTS NUMERIC(38,2) 19
48 CONTENTS_CLAIM_COST NUMERIC(38,2) 19
49 MANAGEMENT_CLAIM_COST NUMERIC(38,2) 19
50 TOTAL_RECOVERIES_EX_GST NUMERIC(38,2) 19
51 TOTAL_PAYMENTS_REVERSAL NUMERIC(38,2) 19
52 RECOVERY_RESERVES NUMERIC(38,2) 19
53 PCP_BUILDING_ESTIMATES NUMERIC(38,2) 19
54 PCP_BUILDING_PAYMENTS NUMERIC(38,2) 19
55 PCP_BUILDING_CLAIM_COST NUMERIC(38,2) 19
56 PCP_CONTENTS_ESTIMATES NUMERIC(38,2) 19
57 PCP_CONTENTS_PAYEMENTS NUMERIC(38,2) 19
58 PCP_CONTENTS_CLAIM_COST NUMERIC(38,2) 19
59 PCP_MANAGEMENT_CLAIM_COST NUMERIC(38,2) 19
60 PCP_TOTAL_RECOVERIES_EX_GST NUMERIC(38,2) 19
61 PCP_TOTAL_PAYMENTS_REVERSAL NUMERIC(38,2) 19
62 PCP_RECOVERY_RESERVES NUMERIC(38,2) 19