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