Description: This table is used for 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.
| Column Name |
Ordinal Position |
|
|
Name |
Type |
|
| 1 |
MEDICATIONID |
INT |
|
|
Description: This is a unique Id used to identity a Medication.
|
|
Name |
Type |
|
| 2 |
FHIRLASTUPDATEDDATETIME |
DATETIME2 |
|
|
Description: This the Fhir Last Updated Date Time for this medication.
|
|
Name |
Type |
|
| 3 |
GENERICNAME |
NVARCHAR |
|
|
Description: This is Medication Generic Name.
|
|
Name |
Type |
|
| 4 |
LKMEDICATIONDRUGCLASSID |
INT |
|
|
Description: This is a foreign key to LkMedicationDrugClass. It helps identify the drug class in the LkMedicationDrugClass table.
|
|
Name |
Type |
|
| 5 |
EFFECTIVEDATE |
DATE |
|
|
Description: This is the Medication Effective Date.
|
|
Name |
Type |
|
| 6 |
INACTIVEDATE |
DATE |
|
|
Description: This is the Medication Inactive Date.
|
|
Name |
Type |
|
| 7 |
SPECIALHANDLING |
NVARCHAR |
|
|
Description: This flag is used to identity medication that needs special handling.
|
|
Name |
Type |
|
| 8 |
LABMONITORING |
BIT |
|
|
Description: This flag is used to identify medications that require lab monitoring.
|
|
Name |
Type |
|
| 9 |
MAXDISPENSEQUANTITYID |
INT |
|
|
Description: It identifies the maximum quantity that should be dispensed within a given period.
|
|
Name |
Type |
|
| 10 |
MAXDISPENSEPERIODQUANTITYID |
INT |
|
|
Description: This is a foreign key to the MaxDispenseQuantity table. It helps identify the period for the maximum dispense quanity.
|
|
Name |
Type |
|
| 11 |
TALLMAN |
NVARCHAR |
|
|
Description: The tallman name is used to help differentiate medication that have look-alike names.
|
|
Name |
Type |
|
| 12 |
DISPLAYNAME |
NVARCHAR |
|
|
Description: The Medication DisplayName allow users to provide a custom display name.
|
|
Name |
Type |
|
| 13 |
ISVACCINE |
BIT |
|
|
Description: This flag is used to identify a vaccine.
|