ORDERABLECATEGORY
Description: Broad kind of service being ordered

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
PARENTIDENTIFIERID 2 IDENTIFIER
DEFAULTPRIORITYLKORDERPRIORITYID 11 LKORDERPRIORITY
LKPUBLICATIONSTATUSID 12 LKPUBLICATIONSTATUS
LKORDERABLECATEGORYTYPEID 14 LKORDERABLECATEGORYTYPE
LKCPOEFORMID 15 LKCPOEFORM

Column Information
Name Type
1 ORDERABLECATEGORYID INT
Description: The unique Id for the OrderableCategory table
Name Type
2 PARENTIDENTIFIERID INT
Description: ParentIdentifierId is a foreign key to the Identifier table
Name Type
3 VERSION INT
Description: The orderable category version
Name Type
4 CATEGORY NVARCHAR
Description: The category of the orderableCategory
Name Type
5 SYSTEM NVARCHAR
Description: The code system use
Name Type
6 DESCRIPTION NVARCHAR
Description: Detailed Description
Name Type
7 VENDORLOCKED BIT
Description: A flag to determine if the orderable category can be changed
Name Type
8 INACTIVATEDDATETIME DATETIME2
Description: The date when the orderable Category date is inactivated
Name Type
9 CREATED DATETIME2
Description: Record created time
Name Type
10 LASTMODIFIED DATETIME2
Description: Record Last Modified time
Name Type
11 DEFAULTPRIORITYLKORDERPRIORITYID INT
Description: DefaultPriorityLkOrderPriorityId is a foreign key to the LkOrderPriority table
Name Type
12 LKPUBLICATIONSTATUSID INT
Description: LkPublicationStatusId is a foreign key to the LkPublicationStatus table
Name Type
13 INSTRUCTIONS NVARCHAR
Description: The orderable category instruction
Name Type
14 LKORDERABLECATEGORYTYPEID INT
Description: LkOrderableCategoryTypeId is a foreign key to the LkOrderableCategoryType table
Name Type
15 LKCPOEFORMID INT
Description: LkCpoeFormId is a foreign key to the LkCpoeForm table