Patent Issued for Processing system for automated electronic record creation and transmission (USPTO 11636084): Hartford Fire Insurance Company

2023 MAY 17 (NewsRx) -- By a News Reporter-Staff News Editor at Insurance Daily News -- From Alexandria, Virginia, NewsRx journalists report that a patent by the inventors Abreu, Christopher Blair (Farmington, CT, US), Aloi, Stephen J. (Southington, CT, US), Murdzek, Joseph L (East Hartford, CT, US), filed on July 16, 2021, was published online on April 25, 2023.

The patent’s assignee for patent number 11636084 is Hartford Fire Insurance Company (Hartford, Connecticut, United States).

News editors obtained the following quote from the background information supplied by the inventors: “Electronic records may be used to transfer information between devices. Moreover, in some cases electronic records may need to be created relatively quickly. For example, substantial delays during a creation of an electronic record might make some of the information within the record incomplete or incorrect (e.g., when underlying factors associated with the record change during creation of the record). Also note that some electronic records may need to be created and/or customized in an extremely accurate manner and, in such situations, this may result in delays being introduced during the creation of the electronic record (e.g., so that information in the record can be verified). Further note that consistency between electronic records may be desired. For example, the layout, formatting, structure, terminology, etc. may need to be consistent between various electronic records (and/or between different versions of a single electronic record). In some cases, improving the creation of an electronic record may result in substantial improvements to the operation of a communication network and/or enterprise (e.g., by reducing record revisions that need to be created and transmitted via the network and/or ensuring that the record will serve an intended purpose).

“It would be desirable to provide systems and methods to automatically create electronic records in a way that provides faster, more accurate results and that allows for flexibility and effectiveness when using the records.”

As a supplement to the background information on this patent, NewsRx correspondents also obtained the inventors’ summary information for this patent: “According to some embodiments, systems, methods, apparatus, computer program code and means are provided to automatically create electronic records in a way that provides faster, more accurate results and that allows for flexibility and effectiveness when using the records. According to some embodiments, a relational database management system database and a plurality of database tables linked to the relational database management system database may be accessed. The back-end application computer server may retrieve electronic record layout information and utilize pre-determined mapping logic to automatically insert accessed data into a customized electronic record in accordance with the electronic record layout information. The customized electronic record may then be transmitted to be rendered via an interactive user interface display.

“Some embodiments comprise: means for accessing a relational database management system database; means for accessing a plurality of database tables linked to the relational database management system database; means for retrieving, by the back-end application computer server, electronic record layout information; means for utilizing pre-determined mapping logic to automatically insert accessed data into a customized electronic record in accordance with the electronic record layout information; and means for transmitting the customized electronic record to be rendered via an interactive user interface display.

“In some embodiments, a communication device associated with a back-end application computer server exchanges information with remote devices. The information may be exchanged, for example, via public and/or proprietary communication networks.

“A technical effect of some embodiments of the invention is an improved and computerized way to automatically create electronic records in a way that provides faster, more accurate results and that allows for flexibility and effectiveness when using the records. With these and other advantages and features that will become hereinafter apparent, a more complete understanding of the nature of the invention can be obtained by referring to the following detailed description and to the drawings appended hereto.”

The claims supplied by the inventors are:

“1. A system to customize electronic records associated with a distributed communication network via an automated back-end application computer server, comprising: (a) a relational database management system database; (b) a data dictionary; © a template database containing electronic record layout information; (d) a data format relationship database; (e) a plurality of database tables linked to the relational database management system database; (f) a communication port to facilitate access to the relational database management system database and the plurality of database tables via the distributed communication network; and (g) the back-end application computer server, coupled to the communication port, programmed to: (i) retrieve the electronic record layout information from the template database, (ii) access information from the plurality of linked database tables via the relational database management system database, (iii) retrieve image data to be inserted into a customized electronic record from a third-party source, (iv) execute a data verification process to ensure that the retrieved image data received from the third-party source is all of: (1) complete image data, (2) up-to-date image data, and (3) image data that has not become corrupt, wherein a status of the up-to-date image data is based on an indication of when a parameter value was last updated, (v) utilize pre-determined logic associated with the plurality of linked tables, including logic that requires matching both a first pointer and a second pointer within a single pair of linked tables, to automatically insert accessed data into the customized electronic record in accordance with the electronic record layout information, information in the data dictionary, and information in the data format relationship database, and (vi) transmit the customized electronic record to be rendered via an interactive user interface display; wherein: said inserting is performed upon initiation by an operator, said initiation occurring by the operator executing a document creation tool, and the customized electronic record comprises a human-readable risk management document associated with an asset.

“2. The system of claim 1, wherein at least one of the relational database management system database and the plurality of database tables are associated with at least one of: (i) the template, (ii) visual basic for applications code, (iii) structured query language data, (iv) the data dictionary, and (v) financial parameters.

“3. The system of claim 1, wherein the automated back-end application computer server is associated with an open source platform accessed by a plurality of third party entities to create customized electronic records.

“4. The system of claim 1, wherein the human-readable risk management document is further associated with sections including at least one of: (i) a valuation, (ii) a yield curve/spread, (iii) a day count description, and (iv) a credit description.

“5. The system of claim 1, wherein the asset is associated with insurance industry assets.

“6. The system of claim 1, wherein the asset is associated with asset backed securities-available for sale.

“7. A computerized method to customize electronic records associated with a distributed communication network via an automated back-end application computer server, comprising: accessing a relational database management system database; access a template database containing electronic record layout information; accessing a plurality of database tables linked to the relational database management system database; retrieving, by the back-end application computer server, the electronic record layout information from the template database; retrieving image data to be inserted into a customized electronic record from a third-party source; executing a data verification process to ensure that the retrieved image data received from the third-party source is all of: (1) complete image data, (2) up-to-date image data, and (3) image data that has not become corrupted, wherein a status of the up-to-date image data is based on an indication of when a parameter value was last updated; utilizing pre-determined logic associated with the plurality of linked tables, including logic that requires matching both a first pointer and a second pointer within a single pair of linked tables, to automatically insert accessed data into the customized electronic record in accordance with the electronic record layout information, information in a data dictionary, and information in a data format relationship database; and transmitting the customized electronic record to be rendered via an interactive user interface display; wherein: said inserting is performed upon initiation by an operator, said initiation occurring by the operator executing a document creation tool, and the customized electronic record comprises a human-readable risk management document associated with an asset.

“8. The method of claim 7, wherein at least one of the relational database management system database and the plurality of database tables are associated with at least one of: (i) the template, (ii) visual basic for applications code, (iii) structured query language data, (iv) the data dictionary, and (v) financial parameters.

“9. The method of claim 7, wherein the automated back-end application computer server is associated with an open source platform accessed by a plurality of third party entities to create customized electronic records.

“10. The method of claim 7, wherein the human-readable risk management document is further associated with sections including at least one of: (i) a valuation, (ii) a yield curve/spread, (iii) a day count description, and (iv) a credit description.

“11. A non-transitory, computer-readable medium storing instructions, that, when executed by a processor, cause the processor to perform a method to customize electronic records associated with a distributed communication network via an automated back-end application computer server, the method comprising: accessing a relational database management system database; accessing a template database containing electronic record layout information; accessing a plurality of database tables linked to the relational database management system database; retrieving, by the back-end application computer server, the electronic record layout information from the template database; retrieving image data to be inserted into a customized electronic record from a third-party source; executing a data verification process to ensure that the retrieved image data received from the third-party source is all of: (1) complete image data, (2) up-to-date image data, and (3) image data that has not become corrupted, wherein a status of the up-to-date image data is based on an indication of when a parameter value was last updated; utilizing pre-determined logic associated with the plurality of linked tables, including logic that that requires matching both a first pointer and a second pointer within a single pair of linked tables, to automatically insert accessed data into the customized electronic record in accordance with the electronic record layout information, information in a data dictionary, and information in a data format relationship database; and transmitting the customized electronic record to be rendered via an interactive user interface display; wherein: said inserting is performed upon initiation by an operator, said initiation occurring by the operator executing a document creation tool, and the customized electronic record comprises a human-readable risk management document associated with an asset.

“12. The medium of claim 11, wherein at least one of the relational database management system database and the plurality of database tables are associated with at least one of: (i) the template, (ii) visual basic for applications code, (iii) structured query language data, (iv) the data dictionary, and (v) financial parameters.

“13. The medium of claim 11, wherein the automated back-end application computer server is associated with an open source platform accessed by a plurality of third party entities to create customized electronic records.

“14. The medium of claim 11, wherein the human-readable risk management document is further associated with sections including at least one of: (i) a valuation, (ii) a yield curve/spread, (iii) a day count description, and (iv) a credit description.”

For additional information on this patent, see: Abreu, Christopher Blair. Processing system for automated electronic record creation and transmission. U.S. Patent Number 11636084, filed July 16, 2021, and published online on April 25, 2023. Patent URL (for desktop use only): https://ppubs.uspto.gov/pubwebapp/external.html?q=(11636084)&db=USPAT&type=ids

(Our reports deliver fact-based news of research and discoveries from around the world.)