System and method for use in providing a healthcare information database

• US 20030069758A1
• Filed: 09/16/2002
• Published: 04/10/2003
• Est. Priority Date: 10/10/2001
• Status: Abandoned Application

• Current Assignee: Siemens Medical Solutions Health Services Corporation (Siemens AG)
• Original Assignee: Siemens Medical Solutions Health Services Corporation (Siemens AG)
• Inventors: Anderson, Laura M., Denny, Robert C. Jr.
• Application Number:
  US10/244,443
• Publication Number:
  US 20030069758A1
• Time in Patent Office: Days
• US Class Current: 705/3
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: G16H 40/20 for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
• CPC Class Codes: G16H 40/63 for local operation
• CPC Class Codes: G16H 50/20 for computer-aided diagnosis, e.g. based on medical expert systems
• CPC Class Codes: G16H 70/00 ICT specially adapted for the handling or processing of medical references

Abstract

A method for providing accessibility to an information database by users of application software is presented, comprising the steps of retrieving desired data from a first source; processing the data to be suitable for incorporation in a transitional database by using industry specific starter data to aid in merging the desired data; applying a predetermined rule to the processed data to ensure compatibility of the processed data with the transitional database; incorporating the processed data into the transitional database in response to the determination; and communicating transitional database data to a targeted information database. It is emphasized that this abstract is provided to comply with the rules requiring an abstract which will allow a searcher or other reader to quickly ascertain the subject matter of the technical disclosure. It is submitted with the understanding that it will not be used to interpret or limit the scope of meaning of the claims.

Claims

1. A method for providing accessibility to a healthcare information database by healthcare personnel for use in clinical care delivery, comprising the steps of:

a. retrieving patient related data;

b. processing the retrieved patient related data to be suitable for incorporation in a transitional database, the traditional database further comprising;

i. a predetermined initial structure; and

ii. predetermined data;

c. applying a predetermined rule to the processed patient related data to ensure compatibility of the processed patient related data with the transitional database;

d. incorporating the processed patient related data into the transitional database in response to the determination; and

e. communicating transitional database data to a user healthcare information database.

2. The method of claim 1 wherein:

a. the transitional database further comprises at least one transitional table, the at least one transitional table further comprising at least one object class.

3. The method of claim 2, wherein:

a. the step of processing the received patient related data further comprises re-formatting the received patient related data to include particular data required by an object associated with the at least one object class.

4. The method of claim 1, wherein:

a. the step of processing the received patient related data comprises at least one of (i) parsing the received patient related data to identify data elements for inclusion in predetermined data fields in the particular record structure of the transitional database, (ii) deriving data elements from the received patient related data for inclusion in predetermined data fields in the particular record structure of the transitional database, or (iii) omitting data elements of the received patient related data from the particular record structure of the transitional database.

5. A method according to claim 1, wherein:

a. the step of processing the received patient related data includes the further step of including data from a template database together with the received patient related data.

6. A method according to claim 1, further including the step of:

a. examining the processed patient related data to determine whether the processed patient related data is at least one of (i) textually valid or (ii) numerically valid.

7. A method according to claim 1, wherein:

a. the predetermined rule is at least one of (i) validation that sufficient information exists to satisfy a record'"'"'s fields, (ii) validation that field data is properly formatted, or (iii) validation that field data is within a predetermined range of permissible values.

8. A method according to claim 1, wherein:

a. the step of communicating data content of the transitional database to a user healthcare information database includes the further step of sequentially ordering data elements of the content for communication by ordering the data content to be compatible with a desired hierarchical record structure.

9. A method according to claim 1, wherein:

a. the step of communicating transitional database data to a user healthcare information database further comprises communicating transitional database data to an object oriented user healthcare information database.

10. A method according to claim 1, wherein:

a. the step of communicating data content of the transitional database to a user healthcare information database includes the step of creating linked object elements for inclusion in a desired record structure of the user healthcare database wherein the linked objects reflect the desired record structure.

11. The method of claim 1, wherein step (a) further comprises:

a. receiving patient related data by migrating data from at least one of (i) a relational database, (ii) a flat file, (iii) a spreadsheet, (iv) a hypertext file, (v) an extensible markup language (XML) formatted file, or (vi) an health level seven (HL7-A28) formatted file.

12. The method of claim 1 wherein:

a. the predetermined data comprise data specific to healthcare.

13. The method of claim 1 wherein step (b) further comprises:

a. reviewing data in the traditional database by the healthcare personnel; and

b. modifying data in the traditional database by the healthcare personnel.

14. A method for providing a user interface supporting merger of patient related data elements derived from a first repository and record data elements derived from a second repository, comprising the steps of:

a. initiating generation of at least one display window supporting merging a data element held in the first repository and a data element held in the second repository into a composite repository, the at least one display window including;

i. an element derived from the first repository being presented horizontally adjacent to an element derived from the second repository permitting side by side comparison; and

ii. a selection icon permitting user selection of an individual element derived from the first repository and an individual element derived from the second repository for inclusion in the composite repository; and

b. initiating merger of the selected individual data element into a composite repository in response to user command.

15. A method according to claim 14, wherein:

a. the element derived from the first repository and the element derived from the second repository are at least one of (i) data elements held in either of the first or second repositories, (ii) identifiers indicating a category of data elements in the first and second repositories, or (iii) identifiers indicating a data field of a record in either of the first or second repositories.

16. A system for use in providing a healthcare information database accessible by healthcare personnel for use in clinical care delivery, comprising:

a. a starter model, further comprising a transitional database with a particular record structure, the transitional database to be used to incorporate processed patient related data in response to a determination of validity and to store the incorporated processed patient related data for subsequent transfer to a user healthcare information database;

b. a data processor having operative access to the starter model, the data processor being capable of receiving patient related data and processing the received patient related data to be suitable for incorporation in the transitional database; and

c. a validation processor operatively in communication with the data processor and the starter model, the validation processor being useful for applying a predetermined rule to determine whether the processed patient related data is compatible with the particular record structure of the transitional database.

17. The system of claim 16 wherein:

a. the starter model further comprises at least one of (i) starter data, (ii) hospital specific data, or (iii) tool setup data, and

b. the transitional database further comprises user specific data and starter database elements.

18. The system of claim 16, wherein:

a. the starter data further comprise a predetermined set of data required for all required classes in a new database to be derived at least in part from the starter model.

19. The system of claim 18 wherein:

a. the input format definer is capable of defining an import format comprising at least one of (i) a relational database format, (ii) a flat file format, (iii) a spreadsheet format, (iv) a comma delimited format, or (v) a hypertext format.

20. A method of converting a database for health care, comprising the steps of:

a. initiating a conversion system at a workstation;

b. querying the database for a list of tasks assigned to a specific user;

c. presenting the list of tasks and their associated status in a worklist;

d. selecting a specific task of the tasks listed in the worklist;

e. displaying a step required to complete the selected task;

f. determining if data is involved to complete the selected task; and

g. if data is involved;

i. running an internal data integrity check to verify that a predetermined electronic database system can use the data;

ii. if the data pass the internal data integrity check, marking the task as completed; and

iii. if the data is found to have errors, leaving the task status as incomplete.

21. A method according to claim 20, further comprising the step of:

a. displaying an error warning at the workstation if the data is found to have an error.

22. A method of processing healthcare and patient related information to create a database supporting a healthcare information system for use by hospitals, comprising the steps of:

a. populating a predetermined transitional table in a transitional database with a dataset comprising predetermined starter data representative of a healthcare data processing requirement;

b. accessing a dataset from a current healthcare data processing database;

c. processing the dataset from the current healthcare data processing database according to at least one predefined rule; and

d. merging the processed dataset with the dataset from the predetermined transitional table by;

i. displaying an element from both datasets for a user; and

ii. allowing a user to choose an element from either dataset to be used to further populate the transitional table.

23. A method according to claim 22, wherein:

a. the transitional database further comprises a plurality of object classes.

24. A method according to claim 22, further comprising the step of:

a. running a predetermined rule against a chosen element to validate data integrity of the chosen element against a predetermined transitional table.

25. A method according to claim 24, further comprising the step of:

a. committing the validated element to the predetermined transitional table of the transitional database in a desired record format for that predetermined transitional table.