Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKMEDICATIONADMINISTRATIONSTATUSID	6	LKMEDICATIONADMINISTRATIONSTATUS
LKMEDICATIONADMINISTRATIONCATEGORYID	7	LKMEDICATIONADMINISTRATIONCATEGORY
MEDICATIONID	8	MEDICATION
ENCOUNTERLOCATIONID	9	ENCOUNTERLOCATION
ORDERID	15	ORDER
DOSAGEID	16	DOSAGE

	Name	Type
1	MEDICATIONADMINISTRATIONID	BIGINT
	Description: The unique Id for the MedicationAdministration table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: The universally unique Id for the MedicationAdministration record

	Name	Type
3	FHIRLASTUPDATEDDATETIME	DATETIME2
	Description: The Date / Time the record was updated, required for the FHIR resource

	Name	Type
4	ISHISTORICAL	BIT
	Description: Determines if the medication administration record is historical

	Name	Type
5	ISOVERDUE	BIT
	Description: Determines if the medication administration was overdue when completed

	Name	Type
6	LKMEDICATIONADMINISTRATIONSTATUSID	INT
	Description: LkMedicationAdministrationStatusId is a foreign key to the LkMedicationAdministrationStatus table

	Name	Type
7	LKMEDICATIONADMINISTRATIONCATEGORYID	INT
	Description: LkMedicationAdministrationCategoryId is a foreign key to the LkMedicationAdministrationCategory table

	Name	Type
8	MEDICATIONID	INT
	Description: MedicationId is a foreign key to the Medication table

	Name	Type
9	ENCOUNTERLOCATIONID	INT
	Description: EncounterLocationId is a foreign key to the EncounterLocation table

	Name	Type
10	DISPLAYDATETIME	DATETIME2
	Description: The Date / Time the administration was scheduled for

	Name	Type
11	EFFECTIVEDATETIME	DATETIME2
	Description: The Date / Time the administration was initiated / performed

	Name	Type
12	EFFECTIVEDATETIMEOFFSET	INT
	Description: The DateTimeOffset when the administration was initiated / performed

	Name	Type
13	EFFECTIVEENDDATETIME	DATETIME2
	Description: The Date / Time the administration event was discontinued

	Name	Type
14	EFFECTIVEENDDATETIMEOFFSET	INT
	Description: The DateTimeOffset when the administration was discontinued

	Name	Type
15	ORDERID	INT
	Description: OrderId is a foreign key to the Order table

	Name	Type
16	DOSAGEID	INT
	Description: DosageId is a foreign key to the Dosage table

	Name	Type
17	PERFORMEDHXYEAR	INT
	Description: The year the administration was performed for historical medication administrations

	Name	Type
18	PERFORMEDHXMONTH	INT
	Description: The month the administration was performed for historical medication administrations

	Name	Type
19	PERFORMEDHXDAY	INT
	Description: The day the administration was performed for historical medication administrations

	Name	Type
20	CREATED	DATETIME2
	Description: Record created time

	Name	Type
22	LASTMODIFIED	DATETIME2
	Description: Record Last Modified time