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 1508. 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. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | 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. |
ToOrderStatusModifier | varchar(30) | NULL | Modifier associated with the order status after it is transitioned. |
ChangedDateTime | smalldatetime | NULL | Date and time when the order is transitioned. |
OrderFunction | varchar(32) | NULL | Order function, such as Activate Order, Cosign, associated during this transition. |
OrderFunctionCode | tinyint | NULL | Code associated with the order function. |
FunctionBy | varchar(30) | NULL | User who performs the order function. |
Order_oid | int | NOT NULL | ObjectID of the order(HOrder table) of which this transition belongs to. |
ReasonForRevision | varchar(120) | NULL | Reason why the order is transitioned. |
SessionID | int | NULL | Identifier of the order session during this transition. |
SessionStartDateTime | datetime | NULL | Start date and time of the order session during this transition. |
SessionEndDateTime | datetime | NULL | End date and time of the order session during this transition. |
OrderStatusCode | tinyint | NULL | Code associated with the order status. Please see the documentation of HOrder table for allowable values. |
OrderStatusModifierAbbr | varchar(4) | NULL | Abbreviation set for order Status modifier. An order status modifier is the user-defined name given to a predefined order status. |
FunctionByStaff | varchar(188) | NULL | Name of the logged in Staff(HStaff table) during this transition. |
FunctionByUSerOID | int | NULL | Object ID of logged in user during this transition. |
FunctionByStaffOID | int | NULL | Object ID of the logged in staff(HStaff) during this transition. |
FunctionSourceModName | Varchar(64) | NULL | Order source modifier name during this transition. |
CausedInFunctionCode | smallint | NULL | Code of the Order Function which caused this transition. Used to capture specific functions like Future Suspend/Future Discontine , where OrderFuction is still Suspend/Discontinue , but this field is to determine more specifics of the function |
RequestedBy | Varchar(188) | NULL | Name of the Staff(HStaff table) who requested this transition. Can be different from the logged in staff for the order function which supports on-behalf of transitions. |
Requestedby_oid | INT | NULL | Object ID of the Staff(HStaff table) who requested this transition |
FutureDCDTimeMins | smalldatetime | NULL | Date and time when the future dc will occur. |
AgeWeightClassification | CHAR(3) | NULL | Age/weight classification of the patient during this transition. |
| | | Allowable Values |
| | | 'Unk' - Undetermined/unknown |
| | | 'Ped' - Pediatric |
| | | 'Adu' - Adult |
| | | 'Ger' - Geriatric |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|