Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
ORDERABLEID	3	ORDERABLE
LKORDERFUNCTIONALSTATUSID	4	LKORDERFUNCTIONALSTATUS
LKORDERINTENTID	5	LKORDERINTENT
LKORDERPRIORITYID	6	LKORDERPRIORITY
PATIENTID	8	PATIENT
ENCOUNTERLOCATIONID	9	ENCOUNTERLOCATION
REQUESTERPRACTITIONERID	10	PRACTITIONER
PERFORMERPRACTITIONERID	11	PRACTITIONER
LKPROCEDUREPERFORMERROLEID	12	LKPROCEDUREPERFORMERROLE
OCCURRENCETIMINGID	17	TIMING
ORDERGROUPID	18	ORDERGROUP
ORDERSETID	19	ORDERABLE
ORDERABLECATEGORYID	20	ORDERABLECATEGORY
LKORDERMETHODID	21	LKORDERMETHOD
PARENTORDERID	22	ORDER

	Name	Type
1	ORDERID	INT
	Description: The unique Id for the Order table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: A unique identifier

	Name	Type
3	ORDERABLEID	INT
	Description: OrderableId is a foreign key to the Orderable table

	Name	Type
4	LKORDERFUNCTIONALSTATUSID	INT
	Description: LkOrderFunctionalStatusId is a foreign key to the LkOrderFunctionalStatus table

	Name	Type
5	LKORDERINTENTID	INT
	Description: LkOrderIntentId is a foreign key to the LkOrderIntent table

	Name	Type
6	LKORDERPRIORITYID	INT
	Description: LkOrderPriorityId is a foreign key to the LkOrderPriority table

	Name	Type
7	DONOTPERFORM	BIT
	Description: Flag to indicate do not perform

	Name	Type
8	PATIENTID	INT
	Description: PatientId is a foreign key to the Patient table

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

	Name	Type
10	REQUESTERPRACTITIONERID	INT
	Description: RequesterPractitionerId is a foreign key to the Practitioner table

	Name	Type
11	PERFORMERPRACTITIONERID	INT
	Description: PerformerPractitionerId is a foreign key to the Practitioner table

	Name	Type
12	LKPROCEDUREPERFORMERROLEID	INT
	Description: LkProcedurePerformerRoleId is a foreign key to the LkProcedurePerformerRole table

	Name	Type
13	OCCURRENCEPERIODSTARTDATETIME	DATETIME2
	Description: The date when the order starts

	Name	Type
14	OCCURRENCEPERIODSTARTDATETIMEZONEOFFSET	INT
	Description: The order start date time zone offset

	Name	Type
15	OCCURRENCEPERIODENDDATETIME	DATETIME2
	Description: The date when the order ends

	Name	Type
16	OCCURRENCEPERIODENDDATETIMEZONEOFFSET	INT
	Description: The order end date time zone offset

	Name	Type
17	OCCURRENCETIMINGID	INT
	Description: OccurrenceTimingId is a foreign key to the Timing table

	Name	Type
18	ORDERGROUPID	INT
	Description: OrderGroupId is a foreign key to the OrderGroup table

	Name	Type
19	ORDERSETID	INT
	Description: OrderSetId is a foreign key to the Orderable table

	Name	Type
20	ORDERABLECATEGORYID	INT
	Description: OrderableCategoryId is a foreign key to the OrderableCategory table

	Name	Type
21	LKORDERMETHODID	INT
	Description: LkOrderMethodId is a foreign key to the LkOrderMethod table

	Name	Type
22	PARENTORDERID	INT
	Description: ParentOrderId is a foreign key to the Order table

	Name	Type
23	NOSHOW	BIT
	Description: A flag to determine if the order should be shown

	Name	Type
24	NEEDSCOSIGN	BIT
	Description: Needs Co-Signature Flag

	Name	Type
25	NEEDSRELEASE	BIT
	Description: Needs Release Flag