Error and load summary reporting in a health care solution environment

• US 7,403,901 B1
• Filed: 04/13/2000
• Issued: 07/22/2008
• Est. Priority Date: 04/13/2000
• Status: Expired due to Term

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture LLP (Accenture PLC)
• Inventors: Gregory, Mary Michelle, Carley, Kevin W., Moody, Megan Davies, Dikeman, Jennifer Scot, Harrington, Lisa Marie
• Primary Examiner(s): MORGAN, ROBERT W
• Application Number:
  US09/549,236
• Time in Patent Office: 3,022 Days
• Field of Search: 707/500, 707/522, 707/7, 707/3, 707/100, 714/730, 379/111, 705/2, 705/3
• US Class Current: 705/2
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: G16H 15/00 ICT specially adapted for medical reports, e.g. generation or transmission thereof
• CPC Class Codes: G16Z 99/00 Subject matter not provided for in other main groups of this subclass
• CPC Class Codes: Y10S 707/99937 Sorting

Abstract

A system, method and computer program are provided for generating error and summary reports for a data load. A plurality of records to be loaded in a database are received. The records may include medical records. A data management template corresponding to the records is chosen. It is verified that all records to be loaded match the data management template. The records are sent to a database for loading in the database upon validation that the records match the data management template. A report of records that match the data management template and records that do not match the data management template is compiled.

Claims

1. A method for generating error and summary reports for a data load, while storing user input data files in a multi-tier client/server architecture such that the data files are organized around tiers of keywords, comprising the steps of:

(a) maintaining a connection between multiple user stations and a server having a database;

(b) selecting a plurality of user-selected keywords from a user interface, wherein each keyword is associated to a data file name and a data type, also wherein the plurality of keywords are arranged in the user interface in a tier structure such that keywords in a first tier are associated to data files that must be loaded into the database before data files associated to a second tier are loaded into the database;

(c) receiving from one of the user stations a plurality of user input data files that are associated to the selected plurality of keywords;

(d) selecting a data management template corresponding to the keywords, wherein the data management template organizes the data files to be loaded into the database;

(e) validating that all data to be loaded into the database match the data management template by enforcing business rules and requirements and ensuring that referential integrity, codependency, primary key, required field, default field, sequence number, and hard-coded field checks are met;

(f) loading the validated data into the database;

(g) compiling a report identifying data that match the data management template and data that do not match the data management template; and

(h) providing said compiled report to said user for review.

2. A method as recited in claim 1, wherein no data are loaded into the database if any of the data does not match the data management template.

3. A method as recited in claim 1, wherein the user input data files are medical files.

4. A method as recited in claim 1, further comprising the steps of separating data that match the data management template from data that do not match the data management template, and sending the data that do not match the data management template to the user station.

5. A method as recited in claim 1, further comprising the step of sending a notification upon detecting a concurrently executing load process.

6. A computer program embodied on a computer readable medium for generating error and summary reports for a data load, while storing user input data files in a multi-tier client/server architecture such that the data files are organized around tiers of keywords, comprising:

(a) a code segment that maintains a connection between multiple user stations and a server having a database;

(b) a code segment that selects a plurality of user-selected keywords from a user interface, wherein each keyword is associated to a data file name and a data type, also wherein the plurality of keywords are arranged in the user interface in a tier structure such that keywords in a first tier are associated to data files that must be loaded into the database before data files associated to a second tier are loaded into the database;

(c) a code segment that receives from one of the user stations a plurality of user input data files that are associated to the selected plurality of keywords;

(d) a code segment that selects a data management template corresponding to the keywords, wherein the data management template organizes the data files to be loaded into the database;

(e) a code segment that validates that all data to be loaded into the database matches the data management template by enforcing business rules and requirements and ensuring that referential integrity, codependency, primary key, required field, default field, sequence number, and hard-coded field checks are met;

(f) a code segment that loads the validated data into the database;

(g) a code segment that compiles a report identifying data that match the data management template and data that do not match the data management template; and

h) a code segment that provides said compiled report to said user for review.

7. A computer program embodied on a computer readable medium as recited in claim 6, wherein no data are loaded into the database if any of the data does not match the data management template.

8. A computer program embodied on a computer readable medium as recited in claim 6, wherein the user input data files are medical files.

9. A computer program embodied on a computer readable medium as recited in claim 6, further comprising a code segment that separates data that match the data management template from data that do not match the data management template, and sends the data that do not match the data management template to the user station.

10. A computer program embodied on a computer readable medium as recited in claim 6, further comprising a code segment that sends a notification upon detecting a concurrently executing load process.