MED_THERAPY_PROB_PROBLEM
Description:
This table contains information about the medication therapy problem identified for this patient.

Primary Key
Column Name Ordinal Position
PROBLEM_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 PROBLEM_ID NUMERIC No
The unique identifier (.1 item) for the medication 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 MED_THERAPY_PROBLEM_CSN_ID NUMERIC No
The unique contact serial number (CSN) of the medication therapy problem contact. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
4 CONTACT_PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for the patient encounter where this edit happened. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5 DOCUMENTING_USER_ID VARCHAR No
The unique ID of the user who documented changes made on this contact.
6 DOCUMENTING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 INSTANT_OF_UPDATE_UTC_DTTM DATETIME (UTC) No
The instant this contact was saved. This is stored in UTC time.
8 MTP_STATUS_C_NAME VARCHAR No
The status category ID of the medication therapy problem.
May contain organization-specific values: No
Category Entries:
Unverified
In Progress
Completed
Deleted
9 CONTACT_RESPONSIBLE_USER_ID VARCHAR No
The unique ID of the responsible user at the time of the contact for this medication therapy problem.
10 CONTACT_RESPONSIBLE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 MTP_PRIORITY_LEVEL_C_NAME VARCHAR No
The relative priority category ID of the medication therapy problem.
May contain organization-specific values: No
Category Entries:
Low
Normal
High
12 START_DATE DATETIME No
The date the medication therapy problem was identified.
13 END_DATE DATETIME No
The date the medication therapy problem was resolved or changed to an inactive status.
14 DUE_DATE DATETIME No
The date that the next action is due for a medication therapy problem.
15 MTP_RATIONALE_C_NAME VARCHAR No
The rationale category ID for this 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
16 MTP_PROBLEM_C_NAME VARCHAR No
The problem type category ID for this 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
17 MED_RELATED_NEED_MTP_TOPIC_C_NAME VARCHAR No
The medication related need category ID for this medication therapy problem.
May contain organization-specific values: Yes
Category Entries:
Indication
Effectiveness
Safety
Adherence