Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The object ID for the Medication Prescription |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1130). 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 is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted |
IsVersioned | bit | NOT NULL | Not used |
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 is created |
ValidFrom | datetime | NOT NULL | The Date/Time from when the current record became valid |
ValidTo | datetime | NULL | The Date/Time until the current record is valid |
PrescriptionFormID | int | NULL | Form ID used for entering the Prescription |
PrescriptionFormInstDt | datetime | NULL | The Date/Time when Prescription was added |
Printed | datetime | NULL | The Date/Time when prescription was printed |
Responsible_oid | int | NOT NULL | Object ID for the staff who added the Prescription(HStaff) |
Patient_oid | int | NOT NULL | Object ID for the Patient(HPatient) |
PatientVisit_oid | int | NOT NULL | Object ID for the Patient's Visit(HPatientVisit) |
MedOrder_oid | int | NOT NULL | Object ID of the stored medication order(HMedOrder) |
ChangeNo | smallint | NULL | The number of times the order has changed. Used to properly sequence the history information |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|