Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | Object ID for the medication order supplimentary information |
InstanceHFCID | SMALLINT | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1140). 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. Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient |
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 | SMALLINT | NOT NULL | Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted |
IsVersioned | BIT | 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 HMedOrderSuppInfoH_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 | DATETIME | NULL | The date and time when the object is created |
TitrateInstruction1 | VARCHAR(64) | NULL | First instruction of the five titrate instructions |
TitrateInstruction2 | VARCHAR(64) | NULL | Second instruction of the five titrate instructions |
TitrateInstruction3 | VARCHAR(64) | NULL | Third instruction of the five titrate instructions |
TitrateInstruction4 | VARCHAR(64) | NULL | Fourth instruction of the five titrate instructions |
TitrateInstruction5 | VARCHAR(64) | NULL | Last(fifth) instruction of the five instructions |
IncreaseDose | VARCHAR(20) | NULL | Part of Increase by titrate instructions that stores the dose part |
IncreaseDoseUnit | VARCHAR(20) | NULL | Part of Increase by titrate instructions that stores the dose unit part |
IncreaseEvery | VARCHAR(10) | NULL | Indicates the "Every" duration part(repeat pattern) |
IncreaseEveryUnitCode | VARCHAR(10) | NULL | Indicates the "Every" duration unit part |
IncreaseFor | VARCHAR(10) | NULL | Part of Increase by titrate instructions, stores the 'For' part |
IncreaseForUnit | VARCHAR(10) | NULL | Part of Increase by titrate instructions, stores the 'For Unit' part |
OtherTitrateInstructions | VARCHAR(64) | NULL | Free text titrate instructions representing 'Other' |
MaxDose | VARCHAR(10) | NULL | Maximum dose of the titrate |
MaxDoseUnit | VARCHAR(20) | NULL | Part of Increase by titrate instructions, stores the 'For Unit' part |
MaxDosePerDuration | VARCHAR(10) | NULL | Maximum dose per duration |
MedOrderOID | INT | NOT NULL | Object ID of the medication order(HMedOrder) |
TargetCosigner1StaffName | VARCHAR(188) | NULL | Primary target cosigner for an order. The field will store the staffname with the title. Hence the length is 188 |
TargetCosigner2StaffName | VARCHAR(188) | NULL | Secondary target cosigner for an order. The field will store the staffname with title.Hence the length is 188 |
TargetCosigner3StaffName | VARCHAR(188) | NULL | Tertiary target cosigner for an order. The field will store the staffname with title.Hence the length is 188 |
TargetCosigner1StaffOID | INT | NULL | Object ID of the primary target cosigner staff(HStaff) |
TargetCosigner2StaffOID | INT | NULL | Object ID of the secondary primary target cosigner staff(HStaff) |
TargetCosigner3StaffOID | INT | NULL | Object ID of the tertiary target cosigner staff(HStaff) |
OrderSourceModifierName | VARCHAR(64) | NULL | Name of the order source modifier |
OrderSourceModifierOID | INT | NULL | Object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table |
OrderSourceAbbr | CHAR(4), | | System defined order source abbreviation to which the selected order source modifier is mapped to |
| | | Allowable values: |
| | | NULL - not valued |
| | | VERB - verbal |
| | | WRTN - written |
| | | PRTL - per-protocol |
ValidFrom | DATETIME | NULL | Date and time from when current record is valid |
ValidTo | DATETIME | NULL | Date and time till when current record is valid |
PharmacyInstr | VARCHAR(256) | NULL | Instructions given to pharmacy |
OAWType | CHAR(1) | NOT NULL | OAW(Order as Written) type. Allowable values: 'S' - Standard, 'A' - Advanced, 'C' - Complex. Default - 'S' |
HasVaccine | CHAR(1) | NULL | Indicates if Order has a vaccine component. Allowable Values: Y - Order has a Vaccine component, N - Order does NOT have a vaccine component, NULL or empty string - NOT Known |
ChangeNo | SMALLINT | NULL | Number of times the order has changed. Used to properly sequence the history information |
IndicationCode | VARCHAR(18) | NULL | Medication indication code |
IndicationDescription | VARCHAR(80) | NULL | Medication Indication description |
CodeSystem | VARCHAR(8) | NULL | Code system that defines the indication |
IndicationRequiredCode | TINYINT | NULL | Mandatory-ness setting for Indication. Allowable value: 0/NULL - NOT Available, 1 - Optional, 2 - Mandatory |