Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedEffectivenessH This table stores history details about medication effectiveness
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID for the effectiveness of a medication
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1118). 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
IsVersionedTINYINTNOT 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 HMedEffectivenessH_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
EffectivenessDateTimeSMALLDATETIMENULL The date and time of the assessment for medication effectiveness
CommentVARCHAR(250)NULL Comment related to this particular medication effectiveness
EffectivenessEntbyVARCHAR(188)NULL Name of the person who entered the medication effectiveness
EffectivenessEntbyInitialsVARCHAR(10)NULL Initials for the person who entered the medication effectiveness
EffectivenessEntbyTypeVARCHAR(4)NULL Entered by type of the medication effectiveness. Example, MAK
EffectivenessEntbyOIDINTNULL Object ID of the staff who entered the effectiveness(HStaff)
DisporderOIDINTNOT NULL Object ID of the dispensable medication order(HMedDispOrder)
MedAdminOIDINTNOT NULL Object ID of the medication administration(HMedAdministration)
ReasonVARCHAR(32)NULL Reason for entering effectiveness assessment of a medication

Return to Table-Index

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