Mapping clinical data with a health data dictionary

• US 20020128861A1
• Filed: 01/05/2001
• Published: 09/12/2002
• Est. Priority Date: 01/05/2001
• Status: Abandoned Application

• Current Assignee: 3M Innovative Properties Company (3M Company)
• Original Assignee: 3M Innovative Properties Company (3M Company)
• Inventors: Willis, Michelle, Gerard, Martha, Karren, Steve, Harada, Susan, Cassin, Edward M., Beeney, Shane, Larsen, Brian J., Lau, Lee Min, Endo, Joni D.
• Application Number:
  US09/755,966
• Publication Number:
  US 20020128861A1
• Time in Patent Office: Days
• US Class Current: 705/2
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G16H 70/20 relating to practices or guidelines

Abstract

Systems, methods, and computer program products for mapping clinical data including insurance data and pharmaceutical data with a health data dictionary. The health data dictionary provides a vocabulary that identifies insurance companies and pharmaceutical compounds including drugs in a normalized and standard form. The clinical data generated at a legacy system is compared with standard clinical data stored in the health data dictionary. Based on this comparison a partial or exact match is identified for the clinical data. After a match is selected, the normalized clinical data can be stored in a data repository. For unmatched clinical data, new concepts can be created and added to the health data dictionary for future use.

Claims

1. In a system including a legacy system having clinical information, wherein the clinical information is stored in a data repository, wherein the clinical information is not normalized and not in a standard format, a method for mapping the clinical information to a health data dictionary such that the clinical information is normalized and in a standard format, the method comprising:

an act of receiving insurance information from the legacy system;

an act of searching content of the health data dictionary for a match to the received insurance information; and

an act of identifying a match for the insurance information.

2. A method as defined in claim 1, further comprising an act of identifying a best match for the insurance information when the match is a partial match.

3. A method as defined in claim 1, further comprising an act of displaying insurance concepts to a user.

4. A method as defined in claim 1, further comprising an act of creating a new insurance concept when the match is not found.

5. A method as defined in claim 1, further comprising an act of creating a new representation for an existing insurance concept stored in the health data dictionary.

6. A method as defined in claim 1, wherein the act of searching content of the health data dictionary further comprises as act of comparing the insurance information with insurance tables in the health data dictionary.

7. A method as defined in claim 6, wherein the insurance tables include synonym tables, the synonym tables including at least one of misspellings of insurance data, abbreviations of insurance data, spellings of insurance data, and formats of insurance data.

8. In a system including a legacy system storing insurance information in a data repository, wherein the insurance information is not normalized and is not in a standard form, a method for mapping the insurance information to a normalized and standard form, the method comprising:

a step for receiving the insurance information from the legacy system;

a step for changing the insurance information using existing content of a health data dictionary, wherein the content of the health data dictionary includes standard insurance information associated with concept identifiers; and

a step for storing the changed insurance information in the data repository with the concept identifiers that correspond to the changed insurance information.

9. A method as defined in claim 8, wherein the step for changing the insurance information further comprises a step for searching the standard insurance information, wherein the standard insurance information is stored in insurance tables of the health data dictionary.

10. A method as defined in claim 8, wherein the step for changing the insurance information further comprises a step for identifying a match for the insurance information.

11. A method as defined in claim 10, wherein the match is an exact match.

12. A method as defined in claim 10, wherein the match is a partial match, wherein the partial match is identified according to a probability.

13. A method as defined in claim 10, further comprising a step for selecting a best match for the insurance information.

14. A method as defined in claim 8, wherein the step for changing the insurance information further comprises:

a step for comparing the insurance information with synonym tables included in the insurance tables of the health data dictionaries, the synonym tables including misspellings of the insurance data, abbreviations of the insurance data and different formats of the insurance data; and

a step for correcting the insurance information to the standard insurance information identified by the match.

16. A method as defined in claim 15, wherein the act of receiving the pharmaceutical data further comprises an act of receiving national drug codes for the ingredients.

17. A method as defined in claim 15, wherein the act of receiving the pharmaceutical data further comprises an act of receiving generic sequence numbers for the compound.

18. A method as defined in claim 15, wherein the act of searching the health data dictionary further comprises an act of comparing the characteristics of the compound to standard characteristics of a standard compound stored in pharmacy tables of the health data dictionary.

19. A method as defined in claim 18, wherein the match is an exact match with a standard compound.

20. A method as defined in claim 18, wherein the match is a partial match with a standard compound.

21. A method as defined in claim 20, further comprising an act of creating a new pharmacy entry in the pharmacy tables of the health data dictionary for an unmatched compound.

22. A method as defined in claim 15, further comprising an act of providing a list of ingredients to select from when the national drug codes are not provided.

24. A method as defined in claim 23, wherein the step for identifying characteristics further comprises a step for identifying a route for the pharmaceutical data.

25. A method as defined in claim 23, wherein the step for selecting a match further comprises a step for selecting an exact match.

26. A method as defined in claim 23, wherein the step for selecting a match further comprises a step for identifying a partial match for the pharmaceutical data.

27. A method as defined in claim 23, wherein the step for identifying characteristics further comprises a step for identifying national drug codes for the ingredients.

28. A method as defined in claim 23, wherein the step for identifying characteristics further comprises a step for identifying generic sequence numbers for the pharmaceutical data.

29. A method as defined in claim 23, further comprising a step for inserting a representation for the pharmaceutical data in the health data dictionary.

30. A method as defined in claim 23, further comprising a step for enforcing rules and constraints of the health data dictionary.

31. A method as defined in claim 23, further comprising a step for modifying a pharmaceutical concept without the national drug code.

15. In a system including a legacy system having clinical data including pharmaceutical data, wherein the pharmaceutical data is not normalized and is not in a standard format, a method for mapping the pharmaceutical data to a health data dictionary, wherein the health data dictionary has content including pharmaceutical content in a standard form, the method comprising:

an act of receiving the pharmaceutical data from the legacy system, wherein the pharmaceutical data has characteristics including a name, a strength, a form, a route, an interface code, and ingredient information, wherein the characteristics identify a compound;

and act of searching the health data dictionary according to the characteristics of the compound; and

an act of selecting a match for the compound such that the compound is in the standard form.

23. In a system including a legacy system sending clinical data including pharmaceutical data to a data repository for storage, wherein the clinical data is not in a standard format and is not normalized, a method for mapping the clinical data such that the clinical data is normalized with a health data dictionary, the method comprising:

a step for identifying characteristics of the pharmaceutical data at the legacy system, wherein the characteristics include a drug name, a strength, a form, an interface code, and one or more ingredient identifiers.

a step for comparing the characteristics of the pharmaceutical data with standard characteristics standard characteristics of the pharmaceutical data, the standard characteristics stored in pharmacy tables of the health data dictionary; and

a step for selecting a match for the pharmaceutical data provided by the legacy system such that the pharmaceutical data is normalized.

32. In a computerized system that includes a legacy system, a health data dictionary, and a data repository, wherein the legacy system provides clinical data for storage in the data repository and wherein the clinical data is not normalized, a computer program product for implementing a method of mapping the clinical data with the health data dictionary to normalize the clinical data before storing the clinical data in the data repository, the computer program product comprising:

a computer readable medium for carrying machine-executable instructions for implementing the method, wherein the method is comprised of machine-executable instructions for performing;

an act of receiving insurance information from the legacy system;

an act of searching content of the health data dictionary for a match to the received insurance information; and

an act of identifying a match for the insurance information.

33. In a computerized system that includes a legacy system, a health data dictionary, and a data repository, wherein the legacy system provides clinical data for storage in the data repository and wherein the clinical data is not normalized, a computer program product for implementing a method of mapping the clinical data with the health data dictionary to normalize the clinical data before storing the clinical data in the data repository, the computer program product comprising:

a computer readable medium for carrying machine-executable instructions for implementing the method, wherein the method is comprised of machine-executable instructions for performing;

an act of receiving the pharmaceutical data from the legacy system, wherein the pharmaceutical data has characteristics including a name, a strength, a form, a route, an interface code, and ingredient information, wherein the characteristics identify a compound;

and act of searching the health data dictionary according to the characteristics of the compound; and

an act of selecting a match for the compound such that the compound is in the standard form.