Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
TIMINGID	5	TIMING
LKPRNREASONID	7	LKPRNREASON
MAXDOSEPERPERIODNUMERATORQUANTITYID	8	QUANTITY
MAXDOSEPERPERIODDENIMONATORQUANTITYID	9	QUANTITY
MAXDOSEPERADMINISTRATIONQUANTITYID	10	QUANTITY
MAXDOSEPERLIFETIMEQUANTITYID	11	QUANTITY
LKBODYSITEID	12	LKBODYSITE
ROUTEID	13	ROUTE
LKADMINISTRATIONMETHODID	14	LKADMINISTRATIONMETHOD

	Name	Type
1	DOSAGEID	INT
	Description: The unique Id for the Dosage table

	Name	Type
2	SEQUENCE	INT
	Description: Not used

	Name	Type
3	SIGTEXT	NVARCHAR
	Description: Signature text of Medication Order

	Name	Type
4	PATIENTINSTRUCTION	NVARCHAR
	Description: Patient Instruction of Medication Order

	Name	Type
5	TIMINGID	INT
	Description: TimingId is a foreign key to the Timing table

	Name	Type
6	PRN	BIT
	Description: Flag for pro re nata - as needed

	Name	Type
7	LKPRNREASONID	INT
	Description: LkPrnReasonId is a foreign key to the LkPrnReason table

	Name	Type
8	MAXDOSEPERPERIODNUMERATORQUANTITYID	INT
	Description: MaxDosePerPeriodNumeratorQuantityId is a foreign key to the Quantity table

	Name	Type
9	MAXDOSEPERPERIODDENIMONATORQUANTITYID	INT
	Description: MaxDosePerPeriodDenimonatorQuantityId is a foreign key to the Quantity table

	Name	Type
10	MAXDOSEPERADMINISTRATIONQUANTITYID	INT
	Description: MaxDosePerAdministrationQuantityId is a foreign key to the Quantity table

	Name	Type
11	MAXDOSEPERLIFETIMEQUANTITYID	INT
	Description: MaxDosePerLifetimeQuantityId is a foreign key to the Quantity table

	Name	Type
12	LKBODYSITEID	INT
	Description: LkBodySiteId is a foreign key to the LkBodySite table

	Name	Type
13	ROUTEID	INT
	Description: RouteId is a foreign key to the Route table

	Name	Type
14	LKADMINISTRATIONMETHODID	INT
	Description: LkAdministrationMethodId is a foreign key to the LkAdministrationMethod table

	Name	Type
15	PRNREASON	NVARCHAR
	Description: Pro re nata - as needed reason