Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | The object ID for the effectiveness of a medication |
InstanceHFCID | SMALLINT | NOT 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 |
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 |
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 HMedEffectiveness_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 |
EffectivenessDateTime | SMALLDATETIME | NULL | The date and time of the assessment for medication effectiveness |
Comment | VARCHAR(250) | NULL | Comment related to this particular medication effectiveness |
EffectivenessEntby | VARCHAR(188) | NULL | Name of the person who entered the medication effectiveness |
EffectivenessEntbyInitials | VARCHAR(10) | NULL | Initials for the person who entered the medication effectiveness |
EffectivenessEntbyType | VARCHAR(4) | NULL | Entered by type of the medication effectiveness. Example, MAK |
EffectivenessEntbyOID | INT | NULL | Object ID of the staff that entered the effectiveness(HStaff) |
DisporderOID | INT | NOT NULL | Object ID of the dispensable medication order(HMedDispOrder) |
MedAdminOID | INT | NOT NULL | Object ID of the medication administration(HMedAdministration) |
Reason | VARCHAR(32) | NULL | Reason for entering effectiveness assessment of a medication |