DATABASE SYSTEM AND OBJECT MANIPULATION REPRESENTING PLACEMENT LAYERS AND PARTS

• US 20160307274A1
• Filed: 04/17/2015
• Published: 10/20/2016
• Est. Priority Date: 04/17/2015
• Status: Active Grant

• Current Assignee: OnRisk, Inc.
• Original Assignee: OnRisk, Inc.
• Inventors: Kelley, John Arthur Daves, Sweeney, Francis Joseph, Harvey, William
• Granted Patent: US 10,002,392 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04845 for image manipulation, e.g. dragging, rotation, expansion or change of colour
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

The technology disclosed relates to manipulating and visualizing database objects that represent layers and parts of layers in an insurance or other risk transfer program. In particular, a special purpose database system replaces manual use of spreadsheets and supports data visualization. The technology disclosed provides systems and methods for processing and displaying database objects that build a composite coverage structure capable of representing a complex program of multiple insurance policies or other risk transfer instruments during planning and placement. Reporting from the database of progress against the composite coverage structure and updating objects using a visual interface are described.

Claims

1. A method of processing and displaying database objects to build a composite coverage structure, including:

providing a canvas structure that comprises a tower attachment area and a surplus area, wherein the tower attachment area is bounded by an upper tower boundary specified as a tower exhaustion point, which is a sum of a tower limit and a tower retention, a lower tower boundary specified as a tower attachment point, which is equal to the tower retention, and a tower share boundary specified in a range of 5 to 100 percent;

providing a plurality of coverage frame objects, wherein each of the coverage frame objects;

represents a request for coverage proposal or a coverage proposal available to be bound as an insurance policy or risk transfer instrument;

has an extent defined by an upper frame boundary specified as a coverage exhaustion point, a lower frame boundary specified as a coverage attachment point and a frame share boundary; and

is selectably positioned on the canvas structure in one of a group of positions consisting of within the tower attachment area, straddling the tower share boundary, and in the surplus area outside the tower attachment area;

receiving data representing assignment of a first coverage frame object to the tower attachment area and assigning the first coverage frame object to a first position within the tower attachment area;

receiving data representing assignment of a second coverage frame object to the surplus area and assigning the second coverage frame object to the surplus area; and

transmitting data for display representing at least;

the canvas structure including the tower attachment area;

the first coverage frame object automatically positioned and scaled within the tower attachment area based on a relationship of the upper frame boundary and the lower frame boundary to the upper tower boundary and the lower tower boundary; and

the second coverage frame object positioned outside the tower attachment area.

2. The method of claim 1, further including positioning the first coverage frame object within the tower attachment area relative to the tower share boundary responsive to data representing a user selection of a share position of the first coverage frame object.

3. The method of claim 1, further including at least one coverage frame object adapted to contain a plurality of other coverage frame objects.

4. The method of claim 3, further including differentiating between a lead quote and following quotes that follow the lead quote, with at least one lead quote coverage frame object and a plurality of following quote coverage frame objects contained within a same coverage frame object serving as a container.

5. The method of claim 1, wherein at least one coverage frame object is a quote and further includes a premium for binding the insurance policy or risk transfer instrument.

6. The method of claim 1, further including:

receiving data representing user selection of a displayed coverage frame object; and

transmitting for display information for a selected coverage frame object, the information includes proposal type;

coverage layer limit, layer retention and risk percentage;

market for a corresponding coverage proposal;

carrier credit rating;

coverage premium; and

coverage rate-on-line (C-ROL).

7. The method of claim 1, further including transmitting for display information that aggregates the coverage frame objects assigned to the tower attachment area, the information that aggregates the coverage frame objects includes a count of the coverage frame objects, total premium quoted or bound, aggregate coverage quoted or bound, buyer net retained line (BNRL) and tower rate-on-line (T-ROL).

8. The method of claim 1, further including:

receiving data representing a user moving the second coverage frame object into the tower attachment area;

updating the second coverage frame object to assign it to the tower attachment area; and

updating and transmitting for display the information that aggregates the coverage frame objects assigned to the tower attachment area.

9. The method of claim 1, further including:

providing a palette structure, outside the tower attachment area and distinct from the canvas structure;

wherein each of the coverage frame objects can further be selectably positioned on the palette structure instead of the canvas structure; and

transmitting data for display that further includes data representing the palette structure and a third coverage frame object positioned within the palette structure.

10. The method of claim 1, further including:

receiving data representing assignment of a third coverage frame object to straddle the tower share boundary, including data indicating what share of the third coverage frame object is within the tower attachment area; and

transmitting data for display that further includes data representing the third coverage frame object;

automatically positioned within the tower attachment area based on relationship of the upper frame boundary and the lower frame boundary to the upper tower boundary and the lower tower boundary; and

positioned partially within the tower attachment area and partially outside the tower attachment area, as assigned.

11. The method of claim 10, further including:

transmitting data for display that suggests subdivision of the third coverage frame object at the tower share boundary;

receiving data representing user input designating subdivision of the third coverage frame object; and

creating a plurality of new coverage frame objects contained within the third coverage frame object, wherein the new coverage frame objects subdivide the third coverage frame object and assigning one or more of the new coverage frame objects that are within the tower attachment area to the tower attachment area.

12. The method of claim 1, further including:

receiving data representing user input positioning a fourth coverage frame object in a fourth position, wherein the fourth position

is in the tower attachment area or straddling the tower share boundary and

the fourth coverage frame object overlaps the position of the first coverage frame object;

generating data for display that suggests subdivision of the first and/or fourth coverage frame object at lines defining the overlap in positions;

receiving data representing user input designating subdivision of the first or fourth coverage frame object, retention of one or more designated parts of the subdivided coverage frame object in the tower attachment area, and transfer of one or more overlapped and undesignated parts out of the tower attachment area;

creating a plurality of new coverage frame objects contained within the designated coverage frame object, wherein the new coverage frame objects subdivide the designated coverage frame object and assigning one or more of the new coverage frame objects as designated to the tower attachment area; and

transmitting data for display representing the subdivision of the designated coverage frame object.

13. The method of claim 12, further including, in the transmitted data for display, data representing one or more unused parts of the designated coverage frame object in a ghosted frame that represents a whole coverage proposal.

14. The method of claim 12, further including generating a new request for coverage proposal from at least some of the new coverage frame objects within the subdivided designated coverage frame and transmitting the new request for coverage proposal to at least a party that offered the coverage proposal in the fourth coverage frame object or another party.

15. The method of claim 1, further including:

receiving data representing a coverage proposal responsive to a request for coverage proposal;

linking a fifth coverage frame object that represents the coverage proposal to a fourth coverage frame object that represents the request for coverage proposal; and

transmitting data for display that visually represents the fifth coverage frame object as coincident in position with and responsive to the fourth coverage frame object.

16. A computer implemented system of processing and displaying database objects to build a composite coverage structure, the computer implemented system including:

a processor, memory coupled to the processor, and program instructions stored in the memory that implement a method comprising;

providing a canvas structure that comprises a tower attachment area and a surplus area, wherein the tower attachment area is bounded by an upper tower boundary specified as a tower exhaustion point, which is a sum of a tower limit and a tower retention, a lower tower boundary specified as a tower attachment point, which is equal to the tower retention, and a tower share boundary specified in a range of 5 to 100 percent;

providing a plurality of coverage frame objects, wherein each of the coverage frame objects;

represents a request for coverage proposal or a coverage proposal available to be bound as an insurance policy or risk transfer instrument;

has an extent defined by an upper frame boundary specified as a coverage exhaustion point, a lower frame boundary specified as a coverage attachment point and a frame share boundary; and

is selectably positioned on the canvas structure in one of a group of positions consisting of within the tower attachment area, straddling the tower share boundary, and in the surplus area outside the tower attachment area;

receiving data representing assignment of a first coverage frame object to the tower attachment area and assigning the first coverage frame object to a first position within the tower attachment area;

receiving data representing assignment of a second coverage frame object to the surplus area and assigning the second coverage frame object to the surplus area; and

transmitting data for display representing at least;

the canvas structure including the tower attachment area;

the first coverage frame object automatically positioned and scaled within the tower attachment area based on a relationship of the upper frame boundary and the lower frame boundary to the upper tower boundary and the lower tower boundary; and

the second coverage frame object positioned outside the tower attachment area.

17. A tangible computer readable storage medium that stores program instructions that implement a method of processing and displaying database objects to build a composite coverage structure, the implementation including:

providing a canvas structure that comprises a tower attachment area and a surplus area, wherein the tower attachment area is bounded by an upper tower boundary specified as a tower exhaustion point, which is a sum of a tower limit and a tower retention, a lower tower boundary specified as a tower attachment point, which is equal to the tower retention, and a tower share boundary specified in a range of 5 to 100 percent;

providing a plurality of coverage frame objects, wherein each of the coverage frame objects;

represents a request for coverage proposal or a coverage proposal available to be bound as an insurance policy or risk transfer instrument;

has an extent defined by an upper frame boundary specified as a coverage exhaustion point, a lower frame boundary specified as a coverage attachment point and a frame share boundary; and

is selectably positioned on the canvas structure in one of a group of positions consisting of within the tower attachment area, straddling the tower share boundary, and in the surplus area outside the tower attachment area;

receiving data representing assignment of a first coverage frame object to the tower attachment area and assigning the first coverage frame object to a first position within the tower attachment area;

receiving data representing assignment of a second coverage frame object to the surplus area and assigning the second coverage frame object to the surplus area; and

transmitting data for display representing at least;

the canvas structure including the tower attachment area;

the first coverage frame object automatically positioned and scaled within the tower attachment area based on a relationship of the upper frame boundary and the lower frame boundary to the upper tower boundary and the lower tower boundary; and

the second coverage frame object positioned outside the tower attachment area.