MDL_MD_PRBLM_LIST

Description:

The MDL_MD_PRBLM_LIST table enables you to report on Medication Problem List information.

Primary Key

Column Name	Ordinal Position
MED_PRBLM_LIST_ID	1

Column Information

	Name	Type	Discontinued?
1	MED_PRBLM_LIST_ID	NUMERIC	No
	The unique identifier (.1 item) for the med problem list record.
2	RECORD_STATUS_C_NAME	VARCHAR	No
	Status of record: 1-inactive, 2-deleted, 4-hidden, 5-inactive and hidden, or 6-deleted and hidden. May contain organization-specific values: No Category Entries: Active Inactive Deleted Inactive and Deleted Hidden Inactive and Hidden Deleted and Hidden Inactive Deleted and Hidden
3	PATIENT_ID	VARCHAR	No
	The Patient ID (EPT) with which this medication problem list (MDL) record is associated.
4	CRRNT_LONG_TERM_YN	VARCHAR	No
	The current long-term status of this medication problem list (MDL) record. May contain organization-specific values: No Category Entries: Yes No
5	MEDICATION_NOTE_ID	VARCHAR	No
	ID of the note (HNO). This note applies to all patient medications that share the same simple generic medication name.
6	SOURCE_PAT_CID	NUMERIC	No
	Source patient CID during patient merge in IntraConnect environments
7	MED_ADHER_SCORE	INTEGER	No
	This item stores the most recently calculated medication adherence score for this simple generic. The adherence score is not updated in real time. If you need to ensure a current score for reporting on a population of patients and certain simple generics, you can use a registry with metric HFP 82099-Medication Adherence Score Data.
8	MED_ADHER_CONF_C_NAME	VARCHAR	No
	Our confidence that the dispense data used to calculate the medication adherence score is a comprehensive list of dispenses. May contain organization-specific values: No Category Entries: Low Moderate High
9	MED_ADHER_ACC_DTTM	DATETIME (UTC)	No
	This item stores the instant that the current score is considered accurate. This is equivalent to the end of the period that we run medication adherence calculation.
10	MED_ADHER_DAYSOWNED	INTEGER	No
	This item stores the number of days a patient is supposed to take medications related to this simple generic. This item is accurate to the current medication adherence score.
11	MED_ADHER_COVERED	INTEGER	No
	This item stores the number of days that are covered by a patient's supply. Equivalently, it means the patient is being adherent on these days. This item is accurate with the current adherence score.
12	MED_ADHER_HIDDEN_C_NAME	VARCHAR	No
	This item stores the reason that the score is hidden. May contain organization-specific values: No Category Entries: PRN OTC No Days Supplied
13	MED_ADHER_INST_DTTM	DATETIME (UTC)	No
	This item stores the calculation instant of the current adherence score.
14	MED_ADHER_STRT_DATE	DATETIME	No
	This item sets the start date of the Medication adherence score measurement period
15	MED_ADHER_ORD_INST_DTTM	DATETIME (UTC)	No
	This item stores the earliest order instant used when calculating the adherence score.