Analyzing administrative healthcare claims data and other data sources

• US 8,700,649 B2
• Filed: 03/28/2011
• Issued: 04/15/2014
• Est. Priority Date: 12/06/2005
• Status: Active Grant

• Current Assignee: Optuminsight, Inc. (UnitedHealth Group Incorporated)
• Original Assignee: Optuminsight, Inc. (UnitedHealth Group Incorporated)
• Inventors: Rawlings, Jean, Anderson, David, Kraus, Carl, Paris, Andrew
• Primary Examiner(s): Beausoliel, Jr., Robert
• Assistant Examiner(s): Rayyan, Susan F
• Application Number:
  US13/073,573
• Publication Number:
  US 20110231422A1
• Time in Patent Office: 1,114 Days
• Field of Search: None
• US Class Current: 707/758
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: G16H 10/20 for electronic clinical trials or questionnaires
• CPC Class Codes: G16H 15/00 ICT specially adapted for medical reports, e.g. generation or transmission thereof
• CPC Class Codes: G16H 50/70 for mining of medical data, e.g. analysing previous cases of other patients
• CPC Class Codes: Y02A 90/10 Information and communication technologies [ICT] supporting adaptation to climate change, e.g. for weather forecasting or climate simulation
• CPC Class Codes: Y10S 707/941 Human sciences

Abstract

Techniques suitable for identifying potential subjects for a clinical trial and other applications are disclosed. One or more exclusion or inclusion criteria are defined for the clinical trial. One or more specialized searching tables are pre-generated using administrative healthcare claims data and the one or more exclusion or inclusion criteria. The specialized searching tables are searched. Through the searching step, subjects are identified within the administrative healthcare claims data who match the one or more exclusion or inclusion criteria. Through the searching step, a geographical area is identified corresponding to the subjects who match the one or more exclusion or inclusion criteria. A customized report is generated using the identified subjects and geographical area.

Claims

1. A method for identifying potential subjects for a clinical trial, comprising:

defining one or more exclusion or inclusion criteria for the clinical trial;

accessing a healthcare database containing records for the subjects;

pre-generating two or more specialized searching tables using administrative healthcare claims data from the healthcare database and the one or more exclusion or inclusion criteria, wherein the two or more specialized searching tables are custom, indexed data tables organized according to the predefined exclusion or inclusion criteria and populated with a subset of information from the healthcare database;

searching with a computing device the two or more specialized searching tables in concert with each other;

identifying with the computing device, through the searching step, subjects within the administrative healthcare claims data who match the one or more exclusion or inclusion criteria;

automatically identifying, without user input to set up a geographical search parameter with the computing device, through the searching step, a geographical area corresponding to the subjects who match the one or more exclusion or inclusion criteria; and

generating a customized report using the identified subjects and geographical area, wherein the customized report comprises a map-based report illustrating a geographic propagation over time of the identified subjects.

2. The method of claim 1, where defining one or more exclusion or inclusion criteria comprises selecting criteria using a Venn diagram.

3. The method of claim 1, where defining one or more exclusion or inclusion criteria comprises selecting one or more medical diagnosis codes.

4. The method of claim 1, where automatically identifying the geographical area comprises identifying a zip code.

5. The method of claim 1, where the customized report comprises a map illustrating subjects according to location.

6. The method of claim 1, further comprising identifying potential clinical investigators for the clinical trial through searching of the specialized searching tables and generating a customized report using identified investigators and a corresponding geographical area.

7. The method of claim 6, further comprising using one or more investigator databases to identify the investigators.

8. The method of claim 1, further comprising, prior to the generating of the customized report, defining a minimum subject participation and modifying the one or more exclusion or inclusion criteria if the number of subjects within the administrative healthcare claims data who match the one or more exclusion or inclusion criteria does not meet the minimum subject participation.

9. The method of claim 8, where modifying is done automatically.

10. The method of claim 9, where modifying is done automatically and iteratively until the minimum subject participation is met.

11. A method for recruiting a medical professional, comprising:

defining one or more exclusion or inclusion criteria for the medical professional;

accessing a healthcare database containing records for the medical professional;

pre-generating two or more specialized searching tables using administrative healthcare claims data from the healthcare database and the one or more exclusion or inclusion criteria, wherein the two or more specialized searching tables are custom, indexed data tables organized according to the predefined exclusion or inclusion criteria and populated with a subset of information from the healthcare database;

searching with a computing device the two or more specialized searching tables in concert with each other;

identifying with the computing device, through the searching step, medical professionals within the administrative healthcare claims data who match the one or more exclusion or inclusion criteria;

automatically identifying, without user input to set up a geographical search parameter, with the computing device, through the searching step, a geographical area corresponding to the medical professionals who match the one or more exclusion or inclusion criteria; and

generating a customized report using the identified medical professionals and geographical area, wherein the customized report comprises a map-based report illustrating a geographic propagation over time of the identified medical professionals.

12. The method of claim 11, where defining one or more exclusion or inclusion criteria comprises selecting criteria using a Venn diagram.

13. The method of claim 11, where defining one or more exclusion or inclusion criteria comprises selecting one or more medical diagnosis codes.

14. The method of claim 11, where the medical professionals comprise physicians being recruited as an expert witness for litigation.

15. The method of claim 14, further comprising determining if one or more of the physicians have previous experience as an expert witness, through correlation with one or more expert databases.

16. A non-transitory computer readable medium comprising computer executable instructions that, when executed, carry out the method of claim 11.

17. A method for statistical calculations based on administrative healthcare claims data, comprising:

searching with a computing device administrative healthcare claims data; and

comparing with the computing device one subset of the administrative healthcare claims data against a plurality of other subsets of the administrative healthcare claims data; and

calculating with the computing device a hypergeometric statistical result based on the comparing step using one or more pre-generated factorial tables, the factorial tables comprising logarithmic entries.

18. The method of claim 17, where calculating comprises one or more calculations using the logarithmic entries followed by one or more exponential operations.

19. The method of claim 17, further comprising using the hypergeometric statistical result to detect medical-related fraud.

20. The method of claim 19, where the one subset comprises medical coding data associated with a first physician and the plurality of other subsets comprises medical coding data associated with a plurality of other physicians.

21. The method of claim 20, where the plurality of other physicians are selected to be within the same specialty as the first physician.

22. The method of claim 21, further comprising generating a customized report comparing the first physician versus the plurality of other physicians.

23. The method of claim 22, the customized report comprising a graph of utilization percentage versus medical code for the first physician and the plurality of other physicians.

24. The method of claim 17, further comprising using the hypergeometric statistical result to rate one physician versus other physicians.

25. The method of claim 17, further comprising using the hypergeometric statistical result to identify potential subjects for a clinical trial.

26. The method of claim 17, further comprising using the hypergeometric statistical result to recruit a medical professional for use as an expert witness for litigation.

27. A method, comprising:

pre-generating one or more specialized searching tables using administrative healthcare claims data;

pre-generating one or more factorial tables, the factorial tables comprising logarithmic entries;

searching the specialized searching tables;

identifying with a computing device through the searching step, one or more records within the administrative healthcare claims data that matches one or more search criteria;

comparing with the computing device the one or more records against a plurality of other records of the administrative healthcare claims data;

calculating with the computing device a hypergeometric statistical result based on the comparing step using the one or more factorial tables; and

generating a customized report using the one or more records and the statistical result.

28. The method of claim 27, where the one or more search criteria comprise one or more exclusion or inclusion criteria selected using a Venn diagram.

29. The method of claim 27, where calculating comprises one or more calculations using the logarithmic entries followed by one or more exponential operations.