Database system and object manipulation representing automated structuring of coverage, expected losses and premiums
The technology disclosed relates to manipulating and visualizing database objects that represent layers and parts of layers in insurance or other risk transfer programs. Disclosed is graphically creating placement objects, maintaining a database of objects that can be linked in trees, with policy objects linked to respective proposal objects, and coverage objects linked to the proposal objects and the policy objects. A GUI represents a placement using objects, with metadata that describes objects' statuses, with groups of objects properly nested and linked in the database of objects. User selection of a displayed first object and mode control initiates creation of second objects linked to the first object and, opening of a panel that scales the selected first object to fit the panel and allows the user to add nested second objects, by drawing an added object or entering metadata for the added object, with consistent metadata constrained with the nesting.
1 . A non-transitory computer readable storage medium that stores program instructions that, when executed on hardware, implement a method of graphically creating erosion objects, the implementation including:
representing multiple risk coverages for benefit of an entity to be insured in a multi-tiered coverage data model including layer objects, coverage objects nested within respective layer objects, and claim table entries for generating erosion objects linked to the coverage objects, wherein:
the coverage objects represent bound coverages; and
the claim table entries and erosion objects represent claims reported or paid;
generating layer objects data for display against a scale of coverage amounts, wherein the coverage objects represent stacked layers of intended coverage for the benefit of the entity;
further generating controls for creating erosion objects applied to the coverage objects nested within the layer objects including:
a selection control that selects a risk tower of coverage objects; and
a claim table tool that
accepts details of particular claims as claim table entries and
generates the erosion objects for display from the claim table entries,
including overlaying the erosion objects for display, individually or collectively, on the selected risk tower of coverage object; and
transmitting the layer objects data, the scale of coverage amounts, and the controls for creating the erosion objects for display by a user device.
2 . The non-transitory computer readable storage medium of claim 1 that stores program instructions that, when executed, further implement:
the claim table tool accepting identification of one or more claims as related to a particular occurrence to which an occurrence limit and an occurrence deductible apply.
3 . The non-transitory computer readable storage medium of claim 2 that stores program instructions that, when executed, further implement:
automatically calculating impact of the one or more claims on the occurrence limit and the occurrence deductible for the particular occurrence; and
generating and transmitting for display the erosion objects and remaining coverage objects based on the automatically calculating.
4 . The non-transitory computer readable storage medium of claim 3 that stores program instructions that, when executed, further implement:
the claim table tool further accepting identification of the one or more claims as reported or paid.
5 . The non-transitory computer readable storage medium of claim 3 that stores program instructions that, when executed, further implement:
the one or more claims as related to the particular occurrence are further subject to an aggregate limit and an aggregate deductible for the coverages that apply; and
automatically calculating impact of the one or more claims and any prior claims on the aggregate limit and the aggregate deductible for the particular occurrence;
wherein generating the display erosion and remaining coverage objects for display takes into account the aggregate limit and the aggregate deductible.
6 . The non-transitory computer readable storage medium of claim 2 that stores program instructions that, when executed, further implement:
accounting for prior claims related to the particular occurrence that impact of the occurrence limit and the occurrence deductible applicable to the one or more claims;
wherein generating for display the erosion objects and remaining coverage objects for display takes into account the prior claims .
7 . The non-transitory computer readable storage medium of claim 6 that stores program instructions that, when executed, further implement:
the coverage objects include an occurrence reinstatement with a reinstatement limit applicable to the particular occurrence are further subject to an aggregate limit and an aggregate deductible for the coverages that apply; and
wherein automatically calculating impact of the one or more claims and the prior claims takes into account the occurrence limit, the occurrence deductible, and the reinstatement limit for the particular occurrence.
8 . A computer-implemented method of graphically creating erosion objects, the method including:
representing using a computing device multiple risk coverages for benefit of an entity to be insured in a multi-tiered coverage data model including layer objects, coverage objects nested within respective layer objects, and claim table entries for generating erosion objects linked to the coverage objects, wherein:
the coverage objects represent bound coverages; and
the claim table entries and erosion objects represent claims reported or paid;
generating by the computing device layer objects data for display against a scale of coverage amounts, wherein the coverage objects represent stacked layers of intended coverage for the benefit of the entity;
further generating controls for creating erosion objects applied to the coverage objects nested within the layer objects including:
a selection control that selects a risk tower of coverage objects; and
a claim table tool that
accepts details of particular claims as claim table entries and
generates the erosion objects for display from the claim table entries,
including overlaying the erosion objects for display, individually or collectively, on the selected risk tower of coverage object; and
transmitting from the computing device the layer objects data, the scale of coverage amounts, and the controls for creating the erosion objects for display by a user device.
9 . The computer-implemented method of claim 8 , further including:
the claim table tool accepting identification of one or more claims as related to a particular occurrence to which an occurrence limit and an occurrence deductible apply.
10 . The computer-implemented method of claim 9 , further including:
automatically calculating impact of the one or more claims on the occurrence limit and the occurrence deductible for the particular occurrence;
and generating and transmitting for display erosion and remaining coverage objects for display based on the automatically calculating.
11 . The computer-implemented method of claim 10 , further including:
the claim table tool further accepting identification of the one or more claims as reported or paid.
12 . The computer-implemented method of claim 10 , further including:
the one or more claims as related to the particular occurrence are further subject to an aggregate limit and an aggregate deductible for the coverages that apply; and
automatically calculating impact of the one or more claims and any prior claims on the aggregate limit and the aggregate deductible for the particular occurrence;
wherein generating the display erosion and remaining coverage objects for display takes into account the aggregate limit and the aggregate deductible.
13 . The computer-implemented method of claim 9 , further including:
accounting for prior claims related to the particular occurrence that impact of the occurrence limit and the occurrence deductible applicable to the one or more claims;
wherein generating for display the erosion objects and remaining coverage objects for display takes into account the prior claims .
14 . The computer-implemented method of claim 13 , further including:
the coverage objects include an occurrence reinstatement with a reinstatement limit applicable to the particular occurrence are further subject to an aggregate limit and an aggregate deductible for the coverages that apply; and
wherein automatically calculating impact of the one or more claims and the prior claims takes into account the occurrence limit, the occurrence deductible, and the reinstatement limit for the particular occurrence.