Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | The object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table. |
InstanceHFCID | SMALLINT | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1134). 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 | TINYINT | NOT 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 HMedOrderComponentDosage_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. For more information on HSUser table |
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 |
DosageDateTime | DATETIME | NULL | The date and time of administering the medication to the patient. |
DosageType | TINYINT | NOT NULL | The type of dosage. Different order types have different kinds and numbers of dosages for every administration |
| | | Allowable Values: |
| | | 0 - medodtSliding |
| | | 1 - medodtDiffer |
| | | 2 - medodtExtra |
| | | 3 - medodtSimple |
Dose | VARCHAR(47) | NULL | The dose of medication. For example 250 mg of erythromycin. |
DoseUnitString | VARCHAR(30) | NULL | The unit of the dose of medication. An example is "mg" in 250 mg of erythromycin. |
MedOrderComponent_oid | INT | NOT NULL | Object ID of the medication order component(HMedOrderComponent) |
Patient_oid | INT | NOT NULL | Object ID for the Patient(HPatient) |
RangeFrom | VARCHAR(9) | NULL | Minimum value in the sliding scale |
RangeTo | VARCHAR(9) | NULL | Maximum value in the sliding scale |
DispensingDose | VARCHAR(20) | NULL | The dose of medication to be dispensed. |
DispensingDoseUnitString | VARCHAR(30) | NULL | The unit of the dose of medication to be dispensed |
DoseUnitCode | VARCHAR(20) | NULL | The code associated with the unit of the dose |
DispensingDoseUnitCode | VARCHAR(20) | NULL | The code associated with the unit of the dose of medication to be dispensed |
SequenceNo | INT | NOT NULL | Unique sequence number assigned to the complex medical dosage |
DoseConcentration | VARCHAR(60) | NULL | The dose concentration. |
ChangeNo | SMALLINT | NULL | The number of times the order has changed. Used to properly sequence the history information |
OriginalDose | VARCHAR(47) | NULL | The original dose |
OriginalDoseUnitCode | VARCHAR(20) | NULL | The original dose unit code |
OriginalDoseUnitString | VARCHAR(30) | NULL | The original dose unit string |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|