MED_THERAPY_PROB_INFO

Description: |
This table contains basic information about a medication therapy problem.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PROBLEM_ID | 1 |

Column Information

| 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