MEDICATION
Description: Identification and definition of a medication for the purposes of prescribing, dispensing, and administering a medication as well as for making statements about medication use

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKMEDICATIONDRUGCLASSID 4 LKMEDICATIONDRUGCLASS
MAXDISPENSEQUANTITYID 9 QUANTITY
MAXDISPENSEPERIODQUANTITYID 10 QUANTITY

Column Information
Name Type
1 MEDICATIONID INT
Description: The unique Id for the Medication table
Name Type
2 FHIRLASTUPDATEDDATETIME DATETIME2
Description: Fhir Last Updated Date Time
Name Type
3 GENERICNAME NVARCHAR
Description: Medication Generic Name
Name Type
4 LKMEDICATIONDRUGCLASSID INT
Description: LkMedicationDrugClassId is a foreign key to the LkMedicationDrugClass table
Name Type
5 EFFECTIVEDATE DATE
Description: Medication Effective Date
Name Type
6 INACTIVEDATE DATE
Description: Medication Inactive Date
Name Type
7 SPECIALHANDLING NVARCHAR
Description: Medication Special Handling
Name Type
8 LABMONITORING BIT
Description: Medication Lab Monitoring
Name Type
9 MAXDISPENSEQUANTITYID INT
Description: MaxDispenseQuantityId is a foreign key to the Quantity table
Name Type
10 MAXDISPENSEPERIODQUANTITYID INT
Description: MaxDispensePeriodQuantityId is a foreign key to the Quantity table
Name Type
11 TALLMAN NVARCHAR
Description: Medication Tallman
Name Type
12 DISPLAYNAME NVARCHAR
Description: Medication DisplayName