SYSTEM AND METHOD FOR TRANSLATING INSURANCE-RELATED DATA

• US 20110119574A1
• Filed: 11/13/2009
• Published: 05/19/2011
• 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
• Granted Patent: US 8,458,582 B2
• Time in Patent Office: Days
• US Class Current: 715/239
• 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 for translating insurance-related data, comprising:

a processor;

a memory storage device in communication with the processor;

the processor adapted to;

receive via a computer communications network a user identification and an identification of a user electronic file in a remote storage location, the user electronic file being in any one of a plurality of formats, and having data related to a request for an insurance quote;

provide an output signal for display to the user on a display device connected to the processor via the computer communications network a prompt for the user to provide mapping data mapping a plurality of data fields classifying data for requests for insurance quotes to data identifiers in the user electronic file;

receive mapping data in response to the prompt;

access the user electronic file;

employing the received mapping data, map data elements, the elements including at least a name of the proposed insured and an address of the proposed insured, identified in the user electronic file, to an ACORD XML compliant format document;

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

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

otherwise provide an output signal communicating the ACORD XML compliant format document to a quote evaluation system.

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 adapted to, prior to prompting the user for mapping data, access the user electronic file, and determine a predictive mapping of data, and wherein the prompt for the user to provide mapping data comprises prompts for verification of the predictive mapping.

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

5. The system of claim 1, wherein the processor is further adapted to store in the memory storage device the mapping data and an association between the mapping data and the 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 ACORD XML format.

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

13. The computer system of claim 5, wherein the verifying comprises determining whether the received data includes data in an appropriate format for each of the data fields.

7. A computer system for translating insurance-related data, comprising:

a processor; and

a memory storage device in communication with the processor;

the processor 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.

8. The computer system of claim 7, wherein the receiving of the identification of the electronic file comprises receiving via e-mail.

9. The computer system of claim 8, 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.

10. The computer system of claim 7, wherein the receiving of the identification of the electronic file comprises receiving via http post.

11. The computer system of claim 7, wherein the predetermined format is ACORD XML.

12. The computer system of claim 7, further comprising a firewall unit, wherein the processor receives the user identification and the identification of the user electronic file via the firewall unit.

14. A computer system for translating insurance-related data, comprising:

a processor; and

a memory storage device in communication with the processor;

the processor adapted to;

receive via a computer communications network a user identification and an identification of a user electronic file 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;

employing the accessed mapping data, map data elements identified in the user electronic file, 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.

15. The computer system of claim 14, wherein the processor is further adapted 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.

16. The computer system of claim 14, wherein the transaction is a request for a quote.

17. A computer-implemented method for translating insurance-related data, comprising:

receiving by a processor via a computer communications network a user identification and insurance related data;

providing by the processor 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 to data identifiers in the user electronic file;

receiving by the processor mapping data in response to the prompt;

accessing by the processing the user insurance-related data;

employing the received mapping data, mapping by the processor the user insurance-related data, and storing the mapped data in a data storage device in a document in a predetermined format;

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

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

18. The computer-implemented method of claim 17, wherein the receiving the user identification comprises receiving the user identification via a firewall unit.

19. The computer-implemented method of claim 17, wherein the user data is received via fax.

20. The computer-implemented method of claim 17, wherein the user data is received via interactive voice recognition.

21. The computer-implemented method of claim 17, wherein the user data is received via electronic mail.

22. The computer-implemented method of claim 17, wherein the user data is received via web form.

23. The computer-implemented method of claim 17, wherein the user data is received via http post.

24. The computer-implemented method of claim 17, wherein the insurance transaction is a request for a quote.

25. A computer-implemented method for translating insurance-related data, comprising:

receiving by a processor a user identification and user-provided insurance-related data;

accessing by the processor from a 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 fields in the user-provided insurance-related data;

accessing by the processor from the memory storage device a file having the user-provided insurance-related data;

employing the accessed mapping data, mapping by the processor data elements identified in the user electronic file, to a document in a predetermined format, and storing the document in the predetermined format in the memory storage device;

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

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

26. The computer-implemented method of claim 25, wherein the receiving the user identification comprises receiving the user identification via a firewall unit.

27. The computer-implemented method of claim 25, wherein the user data is received via fax.

28. The computer-implemented method of claim 25, wherein the user data is received via interactive voice recognition.

29. The computer-implemented method of claim 25, wherein the user data is received via electronic mail.

30. The computer-implemented method of claim 25, wherein the user data is received via web form.

31. The computer-implemented method of claim 25, wherein the insurance transaction is a request for a quote.

32. A computer-readable medium having a plurality of instructions thereon for translating insurance-related data, which instructions, when executed by a processor, cause the processor to:

receive via a computer communications network a user identification and an identification of a user electronic file, the user electronic file being in any one of a plurality of structured formats, and having 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 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 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.

33. The computer-readable medium of claim 32, wherein the instructions further cause the processor to access a user-generated electronic file.

34. The computer-readable medium of claim 32, wherein the instructions further cause the processor to generate an output signal having data for prompting a user to provide further mapping data.