Description: Definition of a group of items commonly ordered together for certain situations, such as pre-admission, pre-operative, etc.
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| PARENTIDENTIFIERID |
2 |
IDENTIFIER
|
|
|
Name |
Type |
|
| 1 |
ORDERGROUPID |
INT |
|
|
Description: The unique Id for the OrderGroup table
|
|
Name |
Type |
|
| 2 |
PARENTIDENTIFIERID |
INT |
|
|
Description: ParentIdentifierId is a foreign key to the Identifier table
|
|
Name |
Type |
|
| 3 |
VERSION |
INT |
|
|
Description: The version number of an order group
|
|
Name |
Type |
|
| 4 |
NAME |
NVARCHAR |
|
|
Description: The order group name
|
|
Name |
Type |
|
| 5 |
DESCRIPTION |
NVARCHAR |
|
|
Description: Detailed Description
|
|
Name |
Type |
|
| 6 |
INSTRUCTIONS |
NVARCHAR |
|
|
Description: The instructions for an order group
|
|
Name |
Type |
|
| 7 |
VENDORLOCKED |
BIT |
|
|
Description: Indicates whether or not an order group is locked by the vendor
|
|
Name |
Type |
|
| 8 |
ISACTIVE |
BIT |
|
|
Description: Indicates whether or not an order group is active
|
|
Name |
Type |
|
| 9 |
LKPUBLICATIONSTATUSID |
INT |
|
|
Description: The publication status of an order group
|
|
Name |
Type |
|
| 10 |
CREATED |
DATETIME2 |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 12 |
LASTMODIFIED |
DATETIME2 |
|
|
Description: Record Last Modified time
|