This table contains high-level information for medications. It is similar to CLARITY_MEDICATION, but it is used exclusively by web based chart system. When a web based chart system patient enters a medication name in medication section of Your Health Record, this table will be searched for a matching medication.
Primary Key
Column Name
Ordinal Position
MYC_MED_ID
1
Column Information
Name
Type
Discontinued?
1
MYC_MED_ID
VARCHAR
No
The unique ID assigned to the web based chart system medication record
2
MYC_MED_ID_MED_NAME
VARCHAR
No
The name of the web based chart system medication.
3
MED_NAME
VARCHAR
No
The name of the web based chart system medication.