MED_THERAPY_PROB_RECOMMND

Description: |
This table contains the recommendation to resolve a problem.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PROBLEM_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PROBLEM_ID | NUMERIC | No |
The unique identifier (.1 item) for the med therapy problem record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | MTP_RECOMMEND_C_NAME | VARCHAR | No |
The recommended action category ID for the medication therapy problem.
May contain organization-specific values: Yes
Category Entries:
Start Medication
Discontinue Medication
Change Medication
Increase Dose
Decrease Dose
Increase Frequency
Decrease Frequency
Change PRN to Schedule
Increase Ordered Duration of Medication
Decrease Ordered Duration of Medication
Change Medication Formulation
Change Administration Time
Provide Education
Referral to Service
Make Appt with PCP
Order Lab
Order Vaccine
Provide Adherence Intervention
Continue to Monitor
Self-Monitoring
Reorder Medication
5 | RECOMMENDED_MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
6 | RECOMMENDED_MED_COMMENTS | VARCHAR | No |
The recommended medication comments include additional information entered by the user who documented the medication therapy problem.
7 | MTP_OUTCOME_C_NAME | VARCHAR | No |
The outcome category ID for the medication therapy problem.
May contain organization-specific values: Yes
Category Entries:
Contact Provider - Awaiting Response
Accepted per Provider
Accepted with Changes per Provider
Accepted per CPA
Accepted - no CPA Needed
Patient Agreed - Adherence/Education
Declined per Provider
Declined per Patient
Resolved Med Access Issue
No Longer Relevant
Accepted through Bulk Process
Provider Response Not Received
Accepted through Order Sign
Completed through Order Decline
8 | MED_TO_ACT_ON_ORDER_ID | NUMERIC | No |
The unique ID of the existing medication order that the recommended action applies to.
9 | MED_TO_ACT_ON_MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
10 | RECOMMENDED_MED_ORDER_ID | NUMERIC | No |
The unique ID of the medication order that should be signed to complete the recommendation.