Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedResolutionAction This table stores resolution actions related to medical alerts
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL Indicates the object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table.
InstanceHFCIDSMALLINTNOT 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
RecordIdINTNULL The record ID. Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient.
DescriptionVARCHAR(1)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not used.
IsDeletedTINYINTNOT NULL Indicates whether the record was soft deleted. Allowable Values: 0 - Active , 1 - Marked as Deleted
IsVersionedTINYINTNOT NULL Indicates whether the record was modified through persistent layer after it's 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 HMedResolutionAction_Ver is created. Allowable Values: 0 - False, 1 - True
CreatedUserIdINTNULL The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user.
CreationTimeSMALLDATETIMENULL The date and time when the object was created
ValidFromDATETIMENOT NULL The Date/Time from which the medication prescribed to the patient became valid
ValidToDATETIMENOT NULL The Date/Time when the medication prescribed to the patient became invalid
ActionExecutedTINYINTNOT 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, 1, 2, 3, 4 Key of allowable values: 0 - medActionWarning 1 - medActionRevokeSource 2 - medActionRevokeRelated 3 - medActionOverride 4 - medActionShowOD
ActionExecutedDateTimeSMALLDATETIMENULL The date and time when the suggested action was executed
ActionTypeTINYINTNOT 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_oidINTNOT NULL Value stored as a result of a many-to-one relationship between HMedResolutionAction and HMedAlerts
RelatedInternalIDINTNULL 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_oidINTNULL Value stored as a result of a many-to-one relationship between HMedResolutionAction and HSUser
ActionTitleVARCHAR(316)NULL Brief description of the suggested action
OverrideCommentsVARCHAR(255)NULL Comments entered by a user when he tries to override existing comments
ChangeNoSMALLINTNULL The number of times the order has changed. Used to properly sequence the history information
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates