SYSTEMS AND METHODS FOR ELECTRONIC HEALTH RECORDS
An electronic health record system includes a query translation engine in communication with a user interaction module to transform query phrases from the user interaction module into formalized database queries of the extracted data from a data organization module.
1 . A method of query phrase formulation, comprising:
receiving a query phrase for data from electronic health records, the query phrase including a numerator and a denominator;
translating the query phrase into a first database query with predefined query generation syntax associated with the numerator and a second database query with predefined query generation syntax associated with the denominator; and
determining a relationship between the numerator and the denominator.
2 . The method as recited in claim 1 , wherein the translating the query phrase into a database query with predefined query generation syntax includes parsing the query phrase into predefined fields.
3 . The method as recited in claim 2 , wherein the predefined fields includes aggregation, value set, value identifies, taxonomy, data table ID, comparison, time delay, date, and limit.
4 . The method as recited in claim 3 , wherein the relationship includes a ratio.
5 . The method as recited in claim 3 , the first database query is a subset of the second database query.
6 . The method as recited in claim 3 , wherein the first database query includes a first multiple of database queries, and the second database query includes a multiple of second database queries.
7 . The method as recited in claim 1 , wherein the query phrase is received in plain language.
8 . The method as recited in claim 1 , further comprising generating a table of results for the ratio of the results of the numerator divided by the denominator.
9 . The method as recited in claim 8 , further comprising generating a table of results for the ratio of the results of the numerator divided by the denominator.
10 . The method as recited in claim 9 , further comprising providing detailed traceability of each result accessible through the table of results.
11 . The method as recited in claim 10 , wherein the traceability of each result is provided in near real time.
12 . The method as recited in claim 8 , further comprising generating a graphical user interface for the ratio of the results of the numerator divided by the denominator.
13 . The method as recited in claim 12 , wherein the traceability of each result is provided in near real time.
14 . The method as recited in claim 12 , wherein determining the relationship between the numerator and the denominator includes exclusions.
15 . The method as recited in claim 12 , wherein the exclusion includes a factor non-applicable the numerator and the denominator.
16 . The method as recited in claim 1 , wherein a ratio of the numerator and the denominator is a performance rate associated with the first database query and the second database query.
17 . The method as recited in claim 1 , wherein the denominator is 1 and the relationship is an absolute count.
18 . A method of query phrase formulation, comprising:
receiving a query phrase for electronic health records in plain language text;
translating the query phrase into a first database query with predefined query generation syntax and a second database query with predefined query generation syntax, the first database query is a subset of the second database query; and
determining a relationship between the first database query and the second database query.
19 . The method as recited in claim 18 , wherein the first database query includes a first multiple of database queries, and the second database query includes a multiple of second database queries.
20 . The method as recited in claim 18 , further comprising providing detailed traceability of the relationship.
21 . The method as recited in claim 20 , wherein the traceability of each result is provided in near real time.
22 . The method as recited in claim 21 , wherein the traceability includes indication of a numerator and a denominator.
23 . The method as recited in claim 22 , wherein the denominator is positive if a predefined test was performed within a predetermined time period.
24 . The method as recited in claim 23 , wherein the numerator is positive if the predefined test meets a predetermined outcome.
25 . A method of interpreting data from electronic health records, comprising:
receiving data from a multiple of different electronic health records implementations; and
assigning a status to the data to generate a common format status variable for the data.
26 . An electronic health record data mining system comprising:
a data manipulation module operable to receive data from a multiple of electronic health records and assign a status to the data to generate a common format status variable in a data warehouse;
a mapping library operable to receive unassigned data from the data manipulation module and pattern match the unassigned data with an entry in a set of mapping data to generate updated data that is returned to the data manipulation module for assignment.
27 . A method of generating a risk score, comprising:
collecting data from electronic health records;
mapping the data to at least one condition category to generate at least one mapped conditioned category;
refining the at least one mapped conditioned category into a hierarchy to generate a hierarchal mapped conditioned category; and
determining a risk score for a person in response to the hierarchal mapped conditioned category.
28 . A method of generating a risk score, comprising:
collecting data from electronic health records;
mapping the data to at least one condition category to generate at least one mapped conditioned category;
refining the at least one mapped conditioned category into a hierarchy to generate a hierarchal mapped conditioned category; and
determining a risk score for a person in response to the hierarchal mapped conditioned category on a regular basis for each person based on the available clinical data for each person.
29 . A method of health care provider assessment, comprising:
processing audit log data to create standardized format audit log data;
categorizing the standardized format audit log data to define a plurality of events;
associating each of the plurality of events with a visit with a patient; and
processing data from each visit with the patient; and
conveying a visual representation of each visit from the data.
30 . A method of health care provider assessment, comprising:
processing audit log data to create standardized format audit log data;
categorizing the standardized format audit log data to define a plurality of events;
associating each of the plurality of events with a visit with a patient; and
processing the data to determine approximate real time tracking of each health care resource from each visit.
31 . A method of health care provider assessment, comprising:
processing audit log data to create standardized format audit log data;
categorizing the standardized format audit log data to define a plurality of events;
associating each of the plurality of events with a visit with a patient; and
processing the data to determine approximate real time tracking of each patient from the visits.
32 . A graphical user interface for a health care provider assessment, comprising:
displaying an appointment from check-in to check-out as a span
displaying a scheduled appointment time along the span
displaying a period of dense charting activity by support staff along the span
displaying a period of dense charting activity by provider along the span.