Description: Broad kind of service being ordered
Column Name |
Ordinal Position |
|
|
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
|