FCT_PI_HOME_CLAIM_LIFE_INSIGHT_TWB

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_DATE TIMESTAMP 8
2 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
3 LOSS_GROUP CHARACTER VARYING(15) 15
4 SUBLOSS_GROUP CHARACTER VARYING(18) 18
5 GROUPED_LOSS_CAUSE CHARACTER VARYING(256) 256
6 LOSS_CAUSE CHARACTER VARYING(256) 256
7 LOB CHARACTER VARYING(256) 256
8 BRAND CHARACTER VARYING(256) 256
9 RISK_STATE CHARACTER VARYING(256) 256
10 GROSS_INCURRED_BAND CHARACTER VARYING(12) 12
11 TEAM CHARACTER VARYING(256) 256
12 FINALISED_CLAIM_COUNT BIGINT 8
13 FINALISED_CLAIM_WITHIN_30D_COUNT BIGINT 8
14 FINALISED_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
15 FINALISED_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
16 FINALISED_CLAIM_LARGE_LOSS_COUNT BIGINT 8
17 FULFILLED_CLAIM_COUNT BIGINT 8
18 FULFILLED_CLAIM_WITHIN_20D_COUNT BIGINT 8
19 FULFILLED_REPAIR_CLAIM_COUNT BIGINT 8
20 FULFILLED_REPAIR_CLAIM_WITHIN_20D_COUNT BIGINT 8
21 FULFILLED_SUPPLY_CLAIM_COUNT BIGINT 8
22 FULFILLED_SUPPLY_CLAIM_WITHIN_20D_COUNT BIGINT 8
23 FULFILLED_CASH_CLAIM_COUNT BIGINT 8
24 FULFILLED_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
25 FULFILLED_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
26 FULFILLED_CLAIM_LARGE_LOSS_COUNT BIGINT 8
27 FULFILLED_REPAIR_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
28 FULFILLED_REPAIR_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
29 FULFILLED_REPAIR_CLAIM_LARGE_LOSS_COUNT BIGINT 8
30 FULFILLED_SUPPLY_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
31 FULFILLED_SUPPLY_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
32 FULFILLED_SUPPLY_CLAIM_LARGE_LOSS_COUNT BIGINT 8
33 REOPEN_CLAIM_COUNT BIGINT 8
34 ACTIVE_CLAIM_COUNT NUMERIC(38,0) 19
35 ACTIVE_CLAIM_OVER_90D_COUNT NUMERIC(38,0) 19
36 FINALISED_CLAIM_LIFE NUMERIC(38,0) 19
37 FINALISED_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
38 FINALISED_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
39 FINALISED_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
40 FULFILLED_CLAIM_LIFE NUMERIC(38,0) 19
41 FULFILLED_REPAIR_CLAIM_LIFE NUMERIC(38,0) 19
42 FULFILLED_SUPPLY_CLAIM_LIFE NUMERIC(38,0) 19
43 FULFILLED_CASH_CLAIM_LIFE NUMERIC(38,0) 19
44 FULFILLED_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
45 FULFILLED_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
46 FULFILLED_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
47 FULFILLED_REPAIR_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
48 FULFILLED_REPAIR_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
49 FULFILLED_REPAIR_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
50 FULFILLED_SUPPLY_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
51 FULFILLED_SUPPLY_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
52 FULFILLED_SUPPLY_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
53 REOPEN_CLAIM_LIFE NUMERIC(38,0) 19
54 PCP_FINALISED_CLAIM_COUNT BIGINT 8
55 PCP_FINALISED_CLAIM_WITHIN_30D_COUNT BIGINT 8
56 PCP_FINALISED_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
57 PCP_FINALISED_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
58 PCP_FINALISED_CLAIM_LARGE_LOSS_COUNT BIGINT 8
59 PCP_FULFILLED_CLAIM_COUNT BIGINT 8
60 PCP_FULFILLED_CLAIM_WITHIN_20D_COUNT BIGINT 8
61 PCP_FULFILLED_REPAIR_CLAIM_COUNT BIGINT 8
62 PCP_FULFILLED_REPAIR_CLAIM_WITHIN_20D_COUNT BIGINT 8
63 PCP_FULFILLED_SUPPLY_CLAIM_COUNT BIGINT 8
64 PCP_FULFILLED_SUPPLY_CLAIM_WITHIN_20D_COUNT BIGINT 8
65 PCP_FULFILLED_CASH_CLAIM_COUNT BIGINT 8
66 PCP_FULFILLED_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
67 PCP_FULFILLED_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
68 PCP_FULFILLED_CLAIM_LARGE_LOSS_COUNT BIGINT 8
69 PCP_FULFILLED_REPAIR_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
70 PCP_FULFILLED_REPAIR_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
71 PCP_FULFILLED_REPAIR_CLAIM_LARGE_LOSS_COUNT BIGINT 8
72 PCP_FULFILLED_SUPPLY_CLAIM_NON_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
73 PCP_FULFILLED_SUPPLY_CLAIM_ASSESSED_LESS_THAN_50K_COUNT BIGINT 8
74 PCP_FULFILLED_SUPPLY_CLAIM_LARGE_LOSS_COUNT BIGINT 8
75 PCP_REOPEN_CLAIM_COUNT BIGINT 8
76 PCP_ACTIVE_CLAIM_COUNT NUMERIC(38,0) 19
77 PCP_ACTIVE_CLAIM_OVER_90D_COUNT NUMERIC(38,0) 19
78 PCP_FINALISED_CLAIM_LIFE NUMERIC(38,0) 19
79 PCP_FINALISED_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
80 PCP_FINALISED_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
81 PCP_FINALISED_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
82 PCP_FULFILLED_CLAIM_LIFE NUMERIC(38,0) 19
83 PCP_FULFILLED_REPAIR_CLAIM_LIFE NUMERIC(38,0) 19
84 PCP_FULFILLED_SUPPLY_CLAIM_LIFE NUMERIC(38,0) 19
85 PCP_FULFILLED_CASH_CLAIM_LIFE NUMERIC(38,0) 19
86 PCP_FULFILLED_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
87 PCP_FULFILLED_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
88 PCP_FULFILLED_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
89 PCP_FULFILLED_REPAIR_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
90 PCP_FULFILLED_REPAIR_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
91 PCP_FULFILLED_REPAIR_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
92 PCP_FULFILLED_SUPPLY_CLAIM_NON_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
93 PCP_FULFILLED_SUPPLY_CLAIM_ASSESSED_LESS_THAN_50K_LIFE NUMERIC(38,0) 19
94 PCP_FULFILLED_SUPPLY_CLAIM_LARGE_LOSS_LIFE NUMERIC(38,0) 19
95 PCP_REOPEN_CLAIM_LIFE NUMERIC(38,0) 19
96 ASSESSED_PATH CHARACTER VARYING(50) 50
97 ASSESSED_PROCESS CHARACTER VARYING(50) 50
98 MTD INTEGER 4
99 YTD INTEGER 4