System and method for translating insurance-related data

• US 9,330,073 B2
• Filed: 06/04/2013
• Issued: 05/03/2016
• Est. Priority Date: 11/13/2009
• Status: Active Grant

• Current Assignee: Hartford Fire Insurance Company (The Hartford Financial Services Group, Inc.)
• Original Assignee: Hartford Fire Insurance Company (The Hartford Financial Services Group, Inc.)
• Inventors: Rogers, James S., Scott, James Daniel, Letscher, M. Gary, Spranzo, Jill
• Primary Examiner(s): Hong, Stephen
• Assistant Examiner(s): LUDWIG, MATTHEW J
• Application Number:
  US13/909,527
• Publication Number:
  US 20130275863A1
• Time in Patent Office: 1,064 Days
• Field of Search: 715/222, 715/223, 715/224
• US Class Current: 1/1
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/242 Dictionaries
• CPC Class Codes: G06F 40/258 Heading extraction; Automatic titling; Numbering
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: H04L 67/06 specially adapted for file transfer, e.g. file transfer protocol [FTP]

Abstract

A computer system includes a processor; and a memory storage device in communication with the processor. The processor is adapted to: receive via a computer communications network a user identification and an identification of an electronic file having user-generated insurance-related data; provide an output signal for display to the user a prompt for the user to provide mapping data mapping a plurality of insurance-related data fields data identifiers in the user-data electronic file; receive mapping data in response to the prompt; access the user electronic file; employing the received mapping data, map data elements identified in the user-data electronic file, to a document in a predetermined format; verify that the received mapped data constitutes complete data to submit in connection with an insurance transaction; and provide an output signal including data constituting the document in a predetermined format to a system for further processing in accordance with an insurance transaction.

Claims

1. A computer system, comprising:

a processor;

a memory storage device in communication with the processor;

the processor configured to;

receive an identification of an electronic file, stored on a remote storage device and accessible to a user system, the electronic file being in any one of a plurality of formats and having data related to a request for an insurance transaction;

receive mapping data, the mapping data mapping data fields classifying data for requests for insurance transactions to data identifiers in the electronic file;

access the electronic file;

map data elements using the received mapping data to a document in a predetermined format, the elements including at least a name of a proposed insured and an address of a proposed insured, identified in the electronic file;

determine whether the mapped data elements constitute all required data for submission of a request for an insurance transaction; and

if the mapped data elements do not constitute all required data, prompt for further data;

otherwise provide an output signal for communicating the document in the predetermined format to a remote device.

2. The system of claim 1, wherein the plurality of formats comprise text document formats, spreadsheet formats, database formats and XML formats.

3. The system of claim 1, wherein the processor is further configured to prompt a user to provide said mapping data for receipt by said processor.

4. The system of claim 3, wherein the processor is further configured to, prior to prompting the user for mapping data, access the electronic file, and determine a predictive mapping of data, wherein the prompt for the user to provide mapping data comprises prompts for verification of the predictive mapping.

5. The system of claim 4, wherein the determining a predictive mapping of data comprises determining a format of the electronic file and comparing data in the electronic file to a dictionary of identifiers.

6. The system of claim 1, wherein the processor is further configured to store in the memory storage device the mapping data and an association between the mapping data and a user identification, and responsive to a subsequent receipt of user identification and a further user file identification, access the further user file and map the data in the further user file to the predetermined format.

7. The system of claim 1, wherein the processor is further configured to apply rules to the mapped data, and to prompt a user for corrected data if a rule is violated.

8. The system of claim 1, wherein the predetermined format document is an ACORD XML compliant format document.

9. A computer implemented method, comprising:

receiving at a computer an identification of an electronic file, stored on a remote storage device and accessible to a user system, having insurance-related data;

receiving by the computer mapping data mapping data fields classifying data for requests for insurance quotes to data identifiers in the electronic file;

accessing by the computer the user electronic file;

employing, by the computer, the received mapping data to map data elements identified in the electronic file, to a document in a predetermined format;

verifying, by the computer, that the received mapped data constitutes complete data to submit in connection with an insurance transaction; and

providing, by the computer, an output signal including data constituting the document in a predetermined format to a system for further processing in accordance with an insurance transaction.

10. The computer implemented method of claim 9, wherein the receiving of the identification of the electronic file comprises receiving via e-mail.

11. The computer implemented method of claim 10, wherein the receiving of the identification of the electronic file comprises receiving the electronic file via e-mail as an attachment to an e-mail.

12. The computer implemented method of claim 9, wherein the receiving of the identification of the electronic file comprises receiving via http post.

13. The computer implemented method of claim 9, wherein the predetermined format is ACORD XML.

14. The computer implemented method of claim 9, wherein the verifying comprises determining whether the received data includes data in an appropriate format for each of the data fields.

15. A computer system, comprising:

a processor; and

a memory storage device in communication with the processor;

the processor configured to;

receive a user identification and an identification of a user electronic file, stored on a remote storage device and accessible to a user system, having insurance-related data;

access from the memory storage device mapping data associated with the user identification, the mapping data identifying a format of the user electronic file and mapping between a plurality of insurance-related data fields and data identifiers in the user electronic file;

access the user electronic file;

map data elements identified in the user electronic file using the accessed mapping data, to a document in a predetermined format;

verify that the mapped data constitutes complete data to submit in connection with an insurance transaction; and

provide an output signal including data constituting the document in a predetermined format to a system for further processing in accordance with an insurance transaction.

16. The computer system of claim 15, wherein the processor is further configured to, in response to determining that the mapped data does not constitute complete data to submit in connection with an insurance transaction, provide an output signal having data indicative of an identification of an incomplete nature of the mapped data.

17. The computer system of claim 15, wherein the transaction is a request for a quote.

18. The computer system of claim 15, wherein the predetermined format is ACORD XML.