CL_MYC_MED
Description:
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.