Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedSign This table stores data associated with a co-signature action of Medication order
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID for the medication sign action
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1102). 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. Not valued in this table. Column exists as part of persistence framework implementation
DescriptionVARCHAR(1)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not valued
IsDeletedTINYINTNOT NULL Indicates whether the record is 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 HMedSign_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. For more information on HSUser table
CreationTimeSMALLDATETIMENULL The date and time when the object is created
SignDateDATETIMENOT NULL The Date/Time when the sign ocurred
Target_HFCIDINTNOT NULL Not valued
Target_OIDINTNOT NULL Not valued
Patient_oidINTNOT NULL Object ID for the Patient(HPatient)
SignedUser_OIDINTNOT NULL Object ID for the staff who did the sign action(HStaff)
SignedUserNameVARCHAR(188)NOT NULL User Name for the staff who signed
IsToCoSignTINYINTNOT NULL Flag(0/1) indicating if order needs to be cosigned
IsToActivateTINYINTNOT NULL Flag(0/1) indicating if order needs to be activated
PatientVisit_oidINTNULL Object ID for the Patient's Visit(HPatientVisit)
MedOrder_oidINTNOT NULLObject ID of the signed medication order(HMedOrder)
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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