MED_THERAPY_PROBLEM
Description:
Table for medication therapy recommendation information stored in Tasks Database (LTK) records.

Primary Key
Column Name Ordinal Position
ACTIVITY_ID 1

Column Information
Name Type Discontinued?
1 ACTIVITY_ID VARCHAR No
The unique identifier for the task record.
2 MTP_DX_ID NUMERIC No
This column displays the diagnosis problem identifier which corresponds to a Medication Therapy Problem.
3 MTP_MED_ID NUMERIC No
This column displays the medication order identifier which corresponds to a Medication Therapy Problem.
4 MTP_RATIONALE_C_NAME VARCHAR No
This column displays the rationale associated with a Medication Therapy Problem.
May contain organization-specific values: Yes
Category Entries:
Duplicate Therapy
No medical indication at this time
Nonmedication therapy more appropriate
Addiction/recreational medication use
Treating avoidable adverse medication reaction
Preventive therapy
Untreated condition
Synergistic therapy
More effective medication available
Condition refractory to medication
Dosage form inappropriate
Contraindications present
Drug not effective for condition
Dose too low
Frequency inappropriate
Incorrect administration
Medication interaction
Incorrect storage
Order duration inappropriate
Medication requires monitoring
Undesirable effect
Unsafe medication for the patient
Allergic reaction
Dosage increase/decrease too fast
Dose too high
Does not understand instructions
More cost-effective medication available
Cannot afford medication product
Patient prefers not to take
Patient forgets to take
Medication product not available
Cannot swallow/administer medication
5 MTP_PROBLEM_C_NAME VARCHAR No
This column displays the problem category of a Medication Therapy Problem.
May contain organization-specific values: Yes
Category Entries:
Unnecessary medication therapy
Needs additional medication therapy
Ineffective medication
Dosage too low
Needs additional monitoring
Adverse medication event
Dosage too high
Adherence
Cost
6 MTP_TOPIC_C_NAME VARCHAR No
This column displays the topic of a Medication Therapy Problem.
May contain organization-specific values: Yes
Category Entries:
Indication
Effectiveness
Safety
Adherence
7 MTP_RECOMMEND_C_NAME VARCHAR No
This column displays the recommended action which corresponds to a 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
8 MTP_RECOMMEND_MED_ID NUMERIC No
This column displays the identifier of the recommended medication associated with a Medication Therapy Problem.
9 MTP_RECOMMEND_ORDER VARCHAR No
This column displays the recommended order associated with a Medication Therapy Problem.
10 MTP_ACTION_TAKEN_C_NAME VARCHAR No
This column displays the action taken for a Medication Therapy Problem.
May contain organization-specific values: Yes
Category Entries:
Contacted Provider
Initiated Medication
Discontinued Medication
Changed Medication
11 MTP_OUTCOME_C_NAME VARCHAR No
This column displays the outcome of a 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
12 MTP_START_DATE DATETIME No
This column displays the start date of a Medication Therapy Problem.
13 MTP_END_DATE DATETIME No
This column displays the end date of a Medication Therapy Problem.