Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
PARENTIDENTIFIERID	2	IDENTIFIER
ORDERABLECATEGORYIDENTIFIERID	5	IDENTIFIER
LKPUBLICATIONSTATUSID	6	LKPUBLICATIONSTATUS
PUBLISHERCONTACTDETAILID	14	CONTACTDETAIL
LKORDERABLEUSAGECONTEXTID	16	LKORDERABLEUSAGECONTEXT
AOEQUESTIONNAIREID	25	QUESTIONNAIRE
RESTRICTEDBYPRACTITIONERID	30	PRACTITIONER
RESTRICTEDBYDEPARTMENTORGANIZATIONID	31	ORGANIZATION
RESTRICTEDBYFACILITYLOCATIONID	32	LOCATION
DEFAULTPRIORITYLKORDERPRIORITYID	34	LKORDERPRIORITY

	Name	Type
1	ORDERABLEID	INT
	Description: The unique Id for the Orderable table

	Name	Type
2	PARENTIDENTIFIERID	INT
	Description: ParentIdentifierId is a foreign key to the Identifier table

	Name	Type
3	UUID	UNIQUEIDENTIFIER
	Description: The unique identifier

	Name	Type
4	ISORDERSET	BIT
	Description: A flag to determine if an order is an orderset

	Name	Type
5	ORDERABLECATEGORYIDENTIFIERID	INT
	Description: OrderableCategoryIdentifierId is a foreign key to the Identifier table

	Name	Type
6	LKPUBLICATIONSTATUSID	INT
	Description: LkPublicationStatusId is a foreign key to the LkPublicationStatus table

	Name	Type
7	VALIDITYPERIODSTARTDATETIME	DATETIME2
	Description: The period of time when the orderable is valid

	Name	Type
8	VALIDITYPERIODENDDATETIME	DATETIME2
	Description: The period of time when the orderable is no long valid

	Name	Type
9	VERSION	INT
	Description: The orderable version

	Name	Type
10	NAME	NVARCHAR
	Description: The orderable name

	Name	Type
11	DISPLAYNAME	NVARCHAR
	Description: The orderable display name

	Name	Type
12	SUBTITLE	NVARCHAR
	Description: The orderable sub title

	Name	Type
13	ISEXPERIMENTAL	BIT
	Description: A flag to determine if the orderable is experimental

	Name	Type
14	PUBLISHERCONTACTDETAILID	INT
	Description: PublisherContactDetailId is a foreign key to the ContactDetail table

	Name	Type
15	DESCRIPTION	NVARCHAR
	Description: Detailed Description

	Name	Type
16	LKORDERABLEUSAGECONTEXTID	INT
	Description: LkOrderableUsageContextId is a foreign key to the LkOrderableUsageContext table

	Name	Type
17	PURPOSE	NVARCHAR
	Description: The purpose of the orderable

	Name	Type
18	USAGE	NVARCHAR
	Description: The orderable usage

	Name	Type
19	COPYRIGHT	NVARCHAR
	Description: The orderable copyright

	Name	Type
20	APPROVALDATE	DATE
	Description: The orderable approval date

	Name	Type
21	LASTREVIEWDATE	DATE
	Description: The date the orderable was last approved

	Name	Type
22	EFFECTIVEPERIODSTARTDATE	DATE
	Description: The orderable start date time

	Name	Type
23	EFFECTIVEPERIODENDDATE	DATE
	Description: The orderable end date time

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

	Name	Type
25	AOEQUESTIONNAIREID	INT
	Description: AoeQuestionnaireId is a foreign key to the Questionnaire table

	Name	Type
26	INSTRUCTIONS	NVARCHAR
	Description: The orderable instruction

	Name	Type
27	PROVIDERCOMMENTS	NVARCHAR
	Description: The orderable provider comment

	Name	Type
28	INACTIVATEDDATETIME	DATETIME2
	Description: The date when the orderable was inactivated

	Name	Type
29	VENDORLOCKED	BIT
	Description: A flag to determine if the orderable cannot be changed

	Name	Type
30	RESTRICTEDBYPRACTITIONERID	INT
	Description: RestrictedByPractitionerId is a foreign key to the Practitioner table

	Name	Type
31	RESTRICTEDBYDEPARTMENTORGANIZATIONID	INT
	Description: RestrictedByDepartmentOrganizationId is a foreign key to the Organization table

	Name	Type
32	RESTRICTEDBYFACILITYLOCATIONID	INT
	Description: RestrictedByFacilityLocationId is a foreign key to the Location table

	Name	Type
33	STARTTOMORROW	BIT
	Description: A flag to determine if the orderable will start the next day

	Name	Type
34	DEFAULTPRIORITYLKORDERPRIORITYID	INT
	Description: DefaultPriorityLkOrderPriorityId is a foreign key to the LkOrderPriority table

	Name	Type
35	DONOTDISPLAYPRIORITY	BIT
	Description: A flag to determine if the orderable priority should be displayed

	Name	Type
36	LASTMODIFIED	DATETIME2
	Description: Record Last Modified time

	Name	Type
37	CREATED	DATETIME2
	Description: Record created time