Methods and systems for database management based on code-marker discrepancies
View Patent ↗Methods and systems for risk assessment and adjustment are described. In one embodiment, a patient-level risk score associated with a patient is calculated. A plan-level average risk score associated with a benefit plan is calculated. The patient is a member of the benefit plan. A missing diagnosis code associated with the patient is identified based on medical claims history of the patient, historical prescription drug claims of the patient, and a drug marker. A revised patient-score associated with the patient is calculated based on identification of the missing diagnosis code. Additional methods and systems are disclosed.
1. A database management system comprising:
a prescriber device;
a database configured to store, for each user of a plurality of users, a set of codes indicating prior diagnoses for the user and a set of drug identifiers indicating prior drug prescriptions for the user; and
a review device comprising a memory and a processor that executes instructions from the memory, wherein the review device is remote from the prescriber device, and wherein the review device is configured to:
obtain a mapping between medical codes and corresponding drug markers;
select a subset of users from the plurality of users, wherein for each user of the subset of users, at least one of the set of drug identifiers in the database for the user is present in the mapping;
for each user of the subset of users, select a subset of the set of drug identifiers for the user by, for each drug identifier of the set of drug identifiers for the user in the database:
determining a corresponding medical code from the drug identifier according to the mapping,
searching the set of codes in the database for the user for the corresponding medical code
in response to identifying that the corresponding medical code is not present in the set of codes in the database for the user, including the drug identifier in the subset of drug identifiers; and
transmit the subset of drug identifiers for the subset of users to the prescriber device over a communications network,
wherein the prescriber device is configured to, in response to receiving drug identifiers, including a first drug identifier, from the review device:
generate a graphical display for an operator of the prescriber device, wherein the graphical display depicts (i) the first drug identifier and (ii) health information regarding a first user associated with the first drug identifier,
solicit a first diagnosis code corresponding to the first drug identifier, and
in response to receiving the first diagnosis code from the operator, transmit the first diagnosis code over the communications network to the review device, and
wherein the review device is configured to, in response to receiving the first diagnosis code from the prescriber device:
update the database to reflect the first diagnosis code in the set of codes corresponding to the first user,
calculate a first user-specific metric for the first user based on the updated database, and
selectively generate a display based on a plan-level metric, wherein the plan-level metric is based on a first weight and the first user-specific metric, and wherein the first weight is determined based on at least one of a demographic value, a Hierarchical Condition Category (HCC) value, and a severity value.
2. The system of claim 1 wherein the review device is configured to, in response to updating the database:
identify a plan-specific set of users of the plurality of users, wherein each user of the plan-specific set of users is associated with a first plan;
for each user of the plan-specific set of users other than the first user, calculate a user-specific metric; and
calculate the plan-level metric based on the user-specific metrics, including the first user-specific metric, of the plan-specific set of users.
3. The system of claim 2 wherein the review device is configured to transmit a request for reimbursement based on the plan-level metric.
4. The system of claim 3 wherein the review device is configured to transmit the request for reimbursement based on a difference between the plan-level metric and an average metric across a plurality of plans.
5. The system of claim 4 wherein the average metric is calculated across a population of a state in which the first plan is offered.
6. The system of claim 2 wherein the plan-level metric is calculated based on a weighted combination of the user-specific metrics of the plan-specific set of users, wherein the weight for each of the user-specific metrics in the weighted combination is determined based on at least one of a demographic value, a Hierarchical Condition Category (HCC) value, and a severity value.
7. The system of claim 1 wherein calculating the first user-specific metric for the first user includes:
accessing, from the updated database, the set of codes for the first user and the set of drug identifiers for the first user;
calculating a demographic metric;
calculating a user diagnostic metric; and
calculating the first user-specific metric based on the demographic metric and the user diagnostic metric.
8. The system of claim 7 wherein calculating the demographic metric includes:
assigning a demographic value to the first user based on age and gender of the first user; and
calculating the demographic metric based on the demographic value.
9. The system of claim 1 wherein the review device is configured to:
document a plurality of conditions that support mapping between codes and corresponding drug markers; and
analyze a user population associated with a plan to identify the first user as having a condition among the plurality of conditions that support mapping between codes and corresponding drug markers.
10. The system of claim 1 wherein the review device is configured to:
generate a user-specific details report that includes, for a plan population associated with a plan, at least one of (i) the first user-specific metric, (ii) the subset of drug identifiers for the first user, and (iii) a condition associated with a particular drug identifier of the subset of drug identifiers.
11. The system of claim 1 wherein the set of codes are selected from revision nine or greater of the International Classification of Diseases.
12. The system of claim 1 wherein the operator of the prescriber device is a medical care professional legally permitted to write a prescription for a medication.
13. The system of claim 1 wherein the first drug identifier of the first user corresponds to a therapy for a condition that supports mapping between medical codes and corresponding drug markers.
14. The system of claim 1 wherein the first drug identifier is a drug marker for a prescription drug that is usable to identify the first user as having a first medical condition.
15. A method comprising:
storing, in a database, for each user of a plurality of users, a set of codes indicating prior diagnoses for the user and a set of drug identifiers indicating prior drug prescriptions for the user;
at a review device, obtaining a mapping between medical codes and corresponding drug markers;
at the review device, selecting a subset of users from the plurality of users, wherein for each user of the subset of users, at least one of the set of drug identifiers in the database for the user is present in the mapping;
at the review device, for each user of the subset of users, selecting a subset of the set of drug identifiers for the user by, for each drug identifier of the set of drug identifiers for the user in the database:
determining a corresponding medical code from the drug identifier according to the mapping;
searching the set of codes in the database for the user for the corresponding medical code; and
in response to identifying that the corresponding medical code is not present in the set of codes in the database for the user, including the drug identifier in the subset of drug identifiers;
at a prescriber device, for a first drug identifier of the subset of drug identifiers:
generating a graphical display for an operator, wherein the graphical display depicts (i) the first drug identifier and (ii) health information regarding a first user associated with the first drug identifier; and
soliciting a first diagnosis code corresponding to the first drug identifier from the operator; and
in response to receiving the first diagnosis code from the operator prescriber device:
at the review device, updating the database to reflect the first diagnosis code in the set of codes corresponding to the first user;
at the review device, calculating a first user-specific metric for the first user based on the updated database; and
at the review device, selectively generating a display based on the updated database a plan-level metric, wherein the plan-level metric is based on a first weight and the first user-specific metric, and wherein the first weight is determined based on at least one of a demographic value, a Hierarchical Condition Category (HCC) value, and a severity value.
16. A non-transitory computer-readable medium comprising instructions that, when executed by one or more processors, cause the one or more processors to perform operations including:
storing, in a database, for each user of a plurality of users, a set of codes indicating prior diagnoses for the user and a set of drug identifiers indicating prior drug prescriptions for the user;
at a review device, obtaining a mapping between medical codes and corresponding drug markers;
at the review device, selecting a subset of users from the plurality of users, wherein for each user of the subset of users, at least one of the set of drug identifiers in the database for the user is present in the mapping;
at the review device, for each user of the subset of users, selecting a subset of the set of drug identifiers for the user by, for each drug identifier of the set of drug identifiers for the user in the database:
determining a corresponding medical code from the drug identifier according to the mapping;
searching the set of codes in the database for the user for the corresponding medical code; and
in response to identifying that the corresponding medical code is not present in the set of codes in the database for the user, including the drug identifier in the subset of drug identifiers;
at a prescriber device, for a first drug identifier of the subset of drug identifiers:
generating a graphical display for an operator, wherein the graphical display depicts (i) the first drug identifier and (ii) health information regarding a first user associated with the first drug identifier; and
soliciting a first diagnosis code corresponding to the first drug identifier from the operator; and
in response to receiving the first diagnosis code from the operator prescriber device:
at the review device, updating the database to reflect the first diagnosis code in the set of codes corresponding to the first user;
at the review device, calculating a first user-specific metric for the first user based on the updated database; and
at the review device, selectively generating a display based on the updated database a plan-level metric, wherein the plan-level metric is based on a first weight and the first user-specific metric, and wherein the first weight is determined based on at least one of a demographic value, a Hierarchical Condition Category (HCC) value, and a severity value.