|
Name |
Type |
Discontinued? |
|
1 |
PROBLEM_ID |
NUMERIC |
No |
|
|
|
The unique identifier (.1 item) for the medication therapy problem record. |
|
|
2 |
PAT_ID |
VARCHAR |
No |
|
|
|
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table. |
|
|
3 |
PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
The unique contact serial number for the patient encounter where this medication therapy problem was created. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI). |
|
|
4 |
CREATION_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID associated with the user who created this medication therapy problem. This column is frequently used to link to the CLARITY_EMP table. |
|
|
5 |
CREATION_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
6 |
DEPARTMENT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
7 |
EPISODE_ID |
NUMERIC |
No |
|
|
|
The unique ID associated with the episode that this medication therapy problem is linked to. |
|
|
8 |
MTP_CONTEXT_C_NAME |
VARCHAR |
No |
|
|
|
The context category ID for the medication therapy problem. |
May contain organization-specific values: Yes |
Category Entries: |
Medication Management Services |
Regulated MTM |
Specialty Pharmacy |
|
|
9 |
RESPONSIBLE_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID associated with the user responsible for the resolution of this medication therapy problem. |
|
|
10 |
RESPONSIBLE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
11 |
COMMENTS_NOTE_ID |
VARCHAR |
No |
|
|
|
The unique ID of the note that contains additional information documented for this medication therapy problem. |
|
|
12 |
SOURCE_TASK_ID |
VARCHAR |
No |
|
|
|
The unique ID of the task record that this medication therapy problem was created from. |
|
|
13 |
CURRENT_MTP_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
The current status of the medication therapy problem. |
May contain organization-specific values: No |
Category Entries: |
Unverified |
In Progress |
Completed |
Deleted |
|
|
14 |
CURRENT_MTP_RATIONALE_C_NAME |
VARCHAR |
No |
|
|
|
The rationale behind why this is 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 |
|
|