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.