Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | Indicates the object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table. |
InstanceHFCID | SMALLINT | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1138). Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application |
RecordId | INT | NULL | The record ID. Not valued in this table. Column exists as part of persistence framework implementation |
Description | VARCHAR(1) | NULL | User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not valued |
IsDeleted | TINYINT | NOT NULL | Indicates whether the record was soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted |
IsVersioned | TINYINT | NOT NULL | Indicates whether the record was modified through persistent layer after its initial creation. Once this field is set to True, you cannot reset it to False. If this field is set to True in a table, another table with the name HMedResolutionActionH_Ver is created. Allowable Values: 0 - False, 1 - True |
CreatedUserId | INT | NULL | The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. |
CreationTime | SMALLDATETIME | NULL | The date and time when the object was created |
ValidFrom | DATETIME | NOT NULL | The Date/Time from when the current record became valid |
ValidTo | DATETIME | NOT NULL | The Date/Time the current record became invalid |
ActionExecuted | TINYINT | NOT NULL | Type of suggested action |
| | | Allowable Values: |
| | | 0 - Action Undefined |
| | | 1 - Action Unexecuted |
| | | 2 - Action Executed |
ActionExecutedDateTime | SMALLDATETIME | NULL | The date and time when the suggested action was executed |
ActionType | TINYINT | NOT NULL | Type of suggested action. If the value stored in HMedAlerts.AlertType is 8 or 9, the value stored in this field is 0. If the value stored in HMedAlerts.AlertType is 2, 5, or 6, the value stored in this field is 4. |
| | | Allowable Values: |
| | | 0 - medActionWarning |
| | | 1 - medActionRevokeSource |
| | | 2 - medActionRevokeRelated |
| | | 3 - medActionOverride |
| | | 4 - medActionShowOD |
MedAlert_oid | INT | NOT NULL | Value stored as a result of a many-to-one relationship between HMedResolutionAction and HMedAlerts |
RelatedInternalID | INT | NULL | Affected order identifier. If there is no affected order, this field stores the same value as the value stored in HMedOrder. InternalID or HMedDispOrder.InternalID. This field stores NULL if the value stored in HMedAlerts.AlertType is 9 |
ActionExecutedBy_oid | INT | NULL | Value stored as a result of a many-to-one relationship between HMedResolutionAction and HSUser |
ActionTitle | VARCHAR(316) | NULL | Brief description of the suggested action |
OverrideComments | VARCHAR(255) | NULL | Comments entered by a user when he tries to override existing comments |
ChangeNo | SMALLINT | NULL | The number of times the order has changed. Used to properly sequence the history information |