Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1545. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsDeleted | tinyint | NOT NULL | Specifies whether the record is soft deleted. |
| | | Allowable Values |
| | | 0 - Active |
| | | 1 - Marked as Deleted. |
| | | Note: The presence of this field in tables depends on the configuration at the time of table design. |
IsVersioned | tinyint | NOT NULL | When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. |
| | | This field is linked to HSUser table to get details about the user. For more information see description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
LastCngDtime | datetime | NULL | Last updated time; Universal Time Coordinate or Greenwich Mean Time |
OrderSet_ServiceOid | int | NULL | ObjectID of the OrderSet definition to which the order belongs to. It's the ObjectID of HService record which represents and OrderSet. |
LinkedOrderGroupName | varchar(64) | NULL | OrderSet Name of the Linked Order |
LinkedSetOriginName | varchar(64) | NOT NULL | Original Linked Set that order came from. Maps to LinkedSetOriginName field in HLinkedSetOrigin table |
Foreign_Link_ID | varchar(128) | NULL | Foreign Link ID in which the order originally came from |
LinkTypeName | varchar(64) | NOT NULL | LinkTypeName from HLinkType table |
| | | Allowable Values |
| | | LinkRegular - Orders are linked to each other |
| | | NotLinked - The Order Set was marked as not linked |