Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The object ID of the medication order object. This field is always a primary key for the associated table |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1131). 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 | When set to 1, the object was deleted. Note: The presence of this field in tables depends on the configuration at the time of table design |
IsVersioned | tinyint | NOT NULL | When set to True, the object was modified. 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 HMedOrder _Ver is created. Allowable Values: 0 - False, 1 - True Note: The presence of this field in tables depends on the configuration at the time of table design |
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 |
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 invalid |
InternalID | int | NULL | The object ID of the order as specified in HOrder table |
ExternalID | varchar(6) | NULL | The ID of the order sent by the pharmacy system |
MedOrderStatus | tinyint | NOT NULL | The status of the medical order |
| | | Allowable Values: |
| | | 0 - medosDraft |
| | | 1 - medosInactive |
| | | 2 - medosActive |
| | | 3 - medosSuspendedFromInactive |
| | | 4 - medosSuspendedFromActive |
| | | 5 - medosSuspendedFromInProgress |
| | | 6 - medosInProgress |
| | | 7 - medosInvalid |
| | | 8 - medosCancelled |
| | | 9 - medosDiscontinued |
| | | 10 - medosComplete |
| | | 11 - MedosPendingActivation |
OrderAsWritten | varchar(650) | NOT NULL | The vital information pertaining to an order and as written by the physician |
MedOrderType | tinyint | NOT NULL | The type of medical order |
| | | Allowable Values: |
| | | 0 - medotSimpleMed |
| | | 1 - medotComplexMed |
| | | 2 - medotSlidingDoseMed |
| | | 3 - medotTaperDoseMed |
| | | 4 - medotDifferDoseMed |
| | | 5 - medotExtraDoseMed |
| | | 6 - medotRegularIV |
| | | 7 - medotPCAIV |
| | | 8 - medotFreeText |
| | | 9 - medotRX |
StartDateTime | datetime | NOT NULL | The date and time from when the order is valid |
StopDateTime | datetime | NULL | The date and time when the order is no longer valid |
MedOrderStatusModifier | varchar(30) | NULL | The modifier associated with the medical order status. A modifier the medical order status has been altered by specific circumstances, but unchanged in its definition or code |
Duration | int | NULL | The duration for which the order is valid |
DischargeIndicator | tinyint | NOT NULL | When set to 1, this order is placed under DischargeContext. Such orders are not automatically discontinued on close of the visit |
IVMethodCode | tinyint | NULL | The code associated with the method by which IV is administered to the patient |
| | | Allowable Values: |
| | | 0 - PUSH |
| | | 1 - ALTLVP(Alternating LVP) |
| | | 2 - ALTTPN |
| | | 3 - KVO |
| | | 4 - PLAIN |
| | | 5 - LVP |
| | | 6 - TPN |
| | | 7 - PIGBCK(Piggyback) |
| | | 8 - ENTRL |
| | | 9 - PLIRR(Plain Irrigation) |
| | | 10 - IRR(Irrigation) |
PRNIndicator | tinyint | NOT NULL | When set to 1, the medication can be administered to the patient, if needed. Allowable Values: 0 - Non-PRN order, 1 - PRN order(PRN means medication can be administered as needed) |
PriorityCode | tinyint | NOT NULL | The code associated with the priority of the order. Allowable Values: 0 - medpriStat, 1 - medpriRoutine, 2 - medpriStatRoutine |
TotalVolume | varchar(30) | NULL | The volume of an IV bottle |
TotalVolumeUnitString | varchar(20) | NULL | The unit of the total volume of the bottle from which IV is administered. For example, ml |
Rate | varchar(8) | NULL | The drip rate of the IV to be administered |
RateUnitString | varchar(20) | NULL | The unit of the drip rate of the IV to be administered |
RunIn | varchar(8) | NULL | The period for which the IV should be administered |
Refills | varchar(4) | NULL | The number of refills that the pharmacist can use to expedite the order |
Directions | varchar(256) | NULL | The directions(such as shake well before administering) specified by the physician to process the order |
CoSignLevelRequired | int | NOT NULL | A signature is required from an authority, of a certain level, other than the one specified to activate the order |
PerformedByPatient | tinyint | NOT NULL | When set to 1, the order is carried out by the patient himself. Allowable Values: 0 - Order is not carried out by patient, 1 - Order is carried out by patient |
RequestedBy_oid | int | NULL | Object ID of the user who requested the medication order(HStaff) |
SignedBy_oid | int | NULL | Object ID of the user who signed the medication order(HStaff) |
EnteredBy_oid | int | NOT NULL | Object ID of the user who entered details about the medication order(HStaff) |
Patient_oid | int | NOT NULL | Object ID for the Patient(HPatient) |
PatientVisit_oid | int | NULL | Object ID for the Patient's Visit(HPatientVisit) |
MedOrderSet_oid | int | NOT NULL | Object ID for the medication order set containing the current order(HMedOrderSet) |
DurationUnitString | varchar(9) | NULL | The unit of the duration of the medication order |
CalculatedStopDateTime | datetime | NOT NULL | The calculated end date and time of the order |
PRNReason | varchar(64) | NULL | The reason for carrying out a PRN order. A PRN order that the medication is administered only if necessary |
PCAAdditionalDose | varchar(20) | NULL | The additional dose that the patient can give themselves with one push. PCA(Patient Controlled Analgesic) is a type of IV medication order where the patient controls the amount of analgesic or painkiller that is dispensed. A special pump regulates the given amount |
Reason | varchar(120) | NULL | The reason for carrying out the order |
PrintPrescription | tinyint | NOT NULL | When set to 1, the prescription will be printed when the order associated with it is signed. Allowable Values: 0 - Prescription will not be printed, 1 - Prescription will be printed |
Substitution | tinyint | NOT NULL | When set to 1, the component, associated with the order, can be substituted. The components may be substituted for clinical reasons, as a hospital policy, or because of preference for certain brands. Allowable Values: 0, 1 Key of allowable values: 0 - Substitution allowed, 1 - Substitution not allowed |
SubstitutionReason | varchar(64) | NULL | The reason for substituting the component associated with the order |
RunInUnitString | varchar(20) | NULL | The unit for the total infusion run-in time of the bottle in which IV was administered |
TitrateInstruction | varchar(32) | NULL | The instructions that should be followed when administering an IV that is titrated. For example, Run in till patient condition stabilizes |
ChemoIndicator | tinyint | NOT NULL | That the order is a Chemo order. Allowable Values: 0 - Not an Chemo order, 1 - Chemo order |
PCAAdditionalDoseUnitString | varchar(20) | NULL | The unit of the additional dose that the patient can give himself with one push |
PCADelayInterval | varchar(12) | NULL | The time interval between two pushes to administer dose |
PCADelayIntervalUnitString | varchar(20) | NULL | The unit of the time interval between two pushes to administer dose |
PCALockoutDose | varchar(20) | NULL | The maximum dose that the patient can administer himself with one push |
PCALockoutDoseUnitString | varchar(20) | NULL | The unit of the maximum dose that the patient can administer himself with one push |
PCALockoutTime | varchar(12) | NULL | The maximum time the patient can take to administer himself a dose with one push. The amount of dose(as specified in PCALockoutDose field) can never exceed the lock out time |
PCALockoutTimeUnitString | varchar(20) | NULL | The unit of the maximum time the patient can take to administer a dose to himself with one push |
RequestorUnit_oid | int | NULL | The object ID of the unit that requested the medication order |
ProviderUnit_oid | int | NULL | The object ID of the unit that the provider was assigned to |
NbrOfSignatures | int | NOT NULL | The number of signatures required to activate the order |
PRNCondition | varchar(32) | NULL | The conditions for carrying out a PRN order |
LinkType | tinyint | NULL | The type of relation to the original order. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - medoltRevise, 1 - medoltRenew |
TotalVolumeUnitCode | varchar(16) | NULL | The code associated with the unit of the total volume of the bottle from which IV was administered |
RateUnitCode | varchar(16) | NULL | The code associated with the unit of the drip rate of the bottle from which IV was administered |
RunInUnitCode | varchar(16) | NULL | The code associated with the unit for the total infusion run-in time of the bottle in which IV was administered |
PCALockoutTimeUnitCode | varchar(16) | NULL | The code associated with the unit of the maximum time the patient can take to administer himself a dose with one push |
PCALockoutDoseUnitCode | varchar(20) | NULL | The code associated with the maximum dose that the patient can administer himself with one push |
PCADelayIntervalUnitCode | varchar(16) | NULL | The code associated with the time interval between two pushes to administer dose |
PCAAdditionalDoseUnitCode | varchar(20) | NULL | The code associated with the unit of the additional dose that the patient can give himself with one push |
DurationUnitCode | int | NULL | The code associated with the unit of the duration of the medication service |
OrderTypeFormID | int | NULL | The form ID of the order type level form |
OrderTypeFormInstDT | datetime | NULL | The date and time when the order type level form was instantiated |
DepTypeFormId | int | NULL | The form ID of the department level form |
DepTypeFormInstDT | datetime | NULL | The date and time when the department level form was instantiated |
MustReview | tinyint | NOT NULL | When set to 1, the medication order must be reviewed. Allowable Values: 0 - Need not be reviewed, 1 - Must be reviewed |
ActSignedNumber | int | NOT NULL | The number of signatures that are counted to activate the order |
CoSignedNumber | int | NOT NULL | The number of countersignatures that are counted to activate the order |
IsCoSigned | tinyint | NOT NULL | When set to 1, the order is countersigned by an authorized signatory other than the specified signatory. Allowable Values: 0 - Not countersigned, 1 - Countersigned |
ActivateLevelRequired | int | NOT NULL | The level of signature required to activate the order |
CoSignRequired | tinyint | NOT NULL | When set to 1, the order needs to be countersigned to be activated. Allowable Values: 0 - Need not be countersigned, 1 - Needs to be countersigned |
IsDripIV | tinyint | NULL | When set to 1, the order is a drip IV order. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - Not a drip IV order, 1 - Drip IV order |
DripIVStartingDose | varchar(30) | NULL | The dose required to start a medication service |
DripIVStartingDoseUnitString | varchar(20) | NULL | The unit of the dose required to start a medication service |
DripIVStartingDoseUnitCode | varchar(20) | NULL | The code associated with the unit of the dose required to start a medication service |
PriorityString | varchar(20) | NULL | The priority of the medication service. Allowable Values: STAT, Routine, STATRoutine, or NULL |
PCALoadingDose | varchar(30) | NULL | The initial dose for the PCA(Patient Controlled Analgesic) order |
PCALoadingDoseUnitString | varchar(20) | NULL | The unit of the dose for the PCA order |
PCALoadingDoseUnitCode | varchar(20) | NULL | The code associated with the unit of the dose for the PCA order |
IVMethodString | varchar(32) | NULL | An explanatory text of the IV method used for UI presentation |
IsCreatedFromOrderSet | tinyint | NOT NULL | When set to 1, the order is created for an order set. Allowable Values: 0 - Not created from order set, 1 - Created from order set |
OriginalOrderID | int | NULL | The order ID before the order was modified |
IsRenewed | tinyint | NOT NULL | When set to 1, the order is renewed. Allowable Values: 0 - Not renewed, 1 - Renewed |
OrderHistoryGroupID | int | NULL | The object ID of the group that contains the order history(such as modifications made to the order) |
MedFunctionCode | tinyint | NOT NULL | The code associated with the medication functions that can be carried out on orders. |
| | | Allowable values: |
| | | 0 - Undefined |
| | | 1 - Acknowledged |
| | | 2 - Discontinue |
| | | 3 - Suspend |
| | | 5 - Resume |
| | | 6 - Renew |
| | | 7 - Revise |
| | | 8 - Complete |
| | | 10 - InProgress |
| | | 12 - Cosign |
| | | 14 - Cancel |
| | | 19 - NewOrder |
| | | 20 - CosignAdministration |
| | | 21 - ChartAdministration |
| | | 22 - MoveVisit |
| | | 23 - MergePatient |
| | | 24 - Invalid |
| | | 25 - Active |
| | | 30 - Validate |
| | | 42 - RejectCosign |
| | | 43 - FutureDiscontinue |
| | | 44 - TrueRevise |
| | | 45 - DoNotRenew |
| | | 46 - Continue |
| | | 52 - Review |
| | | 53 - ShiftIV |
| | | 54 - Shift |
| | | 55 - ReviewEUHomeMeds |
MedOrderStatusDateTime | datetime | NULL | The date and time when the status of the order was recorded |
RuleInvokeCounter | int | NOT NULL | The counter on how many times the rule was invoked for the order |
RequestString | varchar(64) | NULL | The reason for requesting the order |
RequestCode | int | NULL | The code associated with the reason for requesting the order |
VerbalIndicator | tinyint | NULL | When set to 1, the order is a verbal order. Allowable Values: 0 - Not a verbal order, 1 - Verbal order |
ServiceRequestedBy_StaffName | varchar(188) | NULL | The name of the staff who requested the service |
ServiceRequestorHCU_HCUAbbrev | varchar(75) | NULL | The healthcare unit that was the requestor of the service |
ProblemString | varchar(64) | NULL | The name of the problem(patient's ailment) associated with the order |
ProblemCode | int | NULL | The code associated with the problem |
DispensedAmount | varchar(32) | NULL | The dosage of medication that should be dispensed to the patient |
WorkstationID | varchar(30) | NULL | The ID of the workstation from where the user placed, managed, or revised the order |
AdministeredOver | varchar(30) | NULL | The rate at which the IV order was administered. This field is used to calculate the rate by the following formula. Rate = AdministeredVolume(ml) / AdministeredOver(hr) |
AdministeredOverUnit | varchar(20) | NULL | The unit of the administered-over time for the IV order |
AdministeredOverUnitCode | varchar(16) | NULL | The code associated with the unit of the administered-over time for the IV order |
AdministeredVolume | varchar(30) | NULL | The volume of the administered IV order |
AdministeredVolumeUnit | varchar(20) | NULL | The unit of the volume of the administered IV order |
AdministeredVolumeUnitCode | varchar(16) | NULL | The code associated with the unit of the volume of the administered IV order |
EndType | tinyint | NOT NULL | The manner in which the order ends. |
| | | Allowable Values: 0 - Open-ended order |
| | | 1 - On(ended by stop date/time) |
| | | 2 - For Days(ended by duration) |
| | | 3 - For Doses(ended by doses) |
StartOnEvent | varchar(64) | NULL | Name of the event |
RevisedByOID | int | NULL | The object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table |
RevisedBy | Varchar(30) | NULL | Name of the user who revised the medication order |
PatientActualWeight | varchar(6) | NULL | Actual weight of the patient |
PatientActualWeightUnitCode | varchar(16) | NULL | Actual weight of the patient, always stored in kg(kilograms) |
PatientActualWeightDateTime | smalldatetime | NULL | Date/Time that the patient's actual weight was collected |
DosingWeight | varchar(6) | NULL | Weight that was used in weight-based dosing calculations |
DosingWeightUnitCode | varchar(16) | NULL | Unit code of the weight value used in weight-based dosing calculation(lbs,oz,kg,g,etc...) |
DosingWeightDateTime | smalldatetime | NULL | Date/Time that the patient's dosing weight was collected |
PrevDosingWeight | varchar(6) | NULL | The patient's previous dosing weight |
PrevDosingWeightUnitCode | varchar(16) | NULL | The patient's previous dosing weight unit code |
PatientActualHeightDateTime | smalldatetime | NULL | The Date/Time that the patient's actual height was collected |
DosingHeightDateTime | smalldatetime | NULL | The Date/Time that the patient's dosing height was collected |
MaxDose | varchar(30) | NULL | Maximum dose allowed for this drug as defined by First Data Bank |
MaxDoseUnitCode | varchar(20) | NULL | Unit code of the maximum dose allowed for this drug |
BSA | varchar(10) | NULL | Body surface area of the patient |
BSAUnitCode | varchar(16) | NULL | Unit Code for the patient's body surface area |
CalculatedDose | varchar(30) | NULL | Dose as calculated using dosing weight/height |
CalculatedDoseUnitCode | varchar(16) | NULL | Unit code of dose as calculated using dosing weight/height |
PatientActualHeight | varchar(6) | NULL | The actual height of the patient |
PatientActualHeightUnitCode | varchar(16) | NULL | The unit code for the actual height of the patient |
PrevDosingWeightDateTime | Smalldatetime | NULL | The Date/Time the previous dosing weight was collected |
DosingHeight | varchar(6) | NULL | Height of the patient used in height based dosing calculations |
DosingHeightUnitCode | varchar(16) | NULL | Unit Code of the patient's height used in height based dosing calculations |
PrevDosingHeight | varchar(6) | NULL | The patient's previous dosing height |
PrevDosingHeightUnitCode | varchar(16) | NULL | The unit code for the patient's previous dosing height |
PrevDosingHeightDateTime | Smalldatetime | NULL | The Date/Time the previous dosing height was collected |
OrderSubTypeAbbr | varchar(30) | NULL | Abbreviation for the Order Sub type |
ModifiedCalculatedDose | Varchar(30) | NULL | The calculated dose that was manually modified by the user |
ModifiedRate | Varchar(15) | NULL | The rate of administration that was modified by the user |
ModifiedCalcDoseUnitCode | Varchar(20) | NULL | The unit code for the modified dose |
PendingStatusDateTime | smalldatetime | NULL | The Date/Time the order was pending |
MedOrderSetName | Varchar(30) | NULL | Name of the orderset associated with the order |
IsRevisable | tinyint | Not Null | Flag indicating whether or not the order is revisable. Allowable values: |
| | | 0 - The order cannot be revised because the drug code is not defined in service catalog, but is defined in the Drug Vendor Content |
| | | 1 - The order can be revised |
| | | 2 - The order cannot be revised because either Pharmacy has not sent acknoweldgement for True Revise order function(function code 44) or has sent negative acknowledgement |
IsOwnMed | tinyint | Not Null | Flag indicating whether or not the order is its own med or not |
CalculatedVolume | Varchar(30) | NULL | This field stores the calculated volume for Bolus IV orders when doing weight-based calculation for the IV |
CalculatedVolumeUnitCode | Varchar(20) | NULL | This field stores the unit code for the calculated volume, such as mL or L |
IVCategory | smallint | NULL | This field stores the category/type of regular IV. IV categories are Regular, Maintenance and Bolus. Allowable Values: 1 - Regular, 2 - Bolus , 3 - Maintenance |
IVMaintenanceFactor | smallint | NULL | This field stores the multiplication factor for the maintenance fluid IV. Allowable Values: 0 = None, 1 = Full maintenance, 3 = One-third maintenance, 5 = One-half maintenance, 7 = Two-thirds Maintenance, 9 = One and half Maintenance, 11 = 2 Maintenance |
IVCategoryString | varchar(32) | NULL | This field stores the string description of the category/type of regular IV. IV categories are Regular, Maintenance and Bolus |
IVMaintenanceFactorString | varchar(32) | NULL | This field stores the string description of the multiplication factor for the maintenance fluid IV. IV Maintenance factors are: None, Full maintenance, One-third maintenance, One-half maintenance, Two-thirds Maintenance, One and half Maintenance, 2 Maintenance |
AutoProfileIndicator | varchar(16) | NULL | The auto-profiling status of an order. |
| | | Allowable values: |
| | | NOTEVAL - Order has not been evaluated by Rx to determine if it can be auto-profiled or not |
| | | NOTQUAL - Order dose does not qualify to be auto-profiled as determined on Soarian |
| | | QUALRXEVALPEND - Transient setting used when Rx has been called to evaluate order but Soarian DB hasn't been updated yet |
| | | QUALRXEVALFAIL - Order was evaluated by Rx and has failed validation |
| | | QUALRXEVALSUCC - Transient setting used when Rx has passed validation of the order but Soarian DB hasn't been updated yet |
| | | QUALRXPOSTFAIL - Order was sent to Rx to be saved as an auto-profiled order and the save has failed |
| | | AUTOPROFILED - Order has been qualified and successfully auto-profiled by Rx |
SessionId | INT | NULL | This field stores the sessionid and will be used to create the link between hmedorderh and hordertransitionrecord table |
| | | SessionId and SessionStartDateTime need to be used as a composite key |
| | | In order to guarantee uniqueness, when using SessionId for look up, include SessionStartDateTime as well |
IsNonFormulary | tinyint | NULL | Allowable Values(0=Drug is in formulary, 1=Drug is in service catalog, but marked as not formulary, 2 - Drug is external drug base). Valued only for International clients, otherwise NULL |
IsControlledSubstance | tinyint | NULL | Allowable Values(0 - Drug is not a controlled substance, 1 - Drug is a controlled substance). Valued only for International clients, othewrise NULL |
ChangeNo | smallint | NULL | The number of times the order was changed. Used to properly sequence the history information |
DosingWeightSrcAbbr | varchar(16) | NULL | The Finding Abbreviation for the finding that was used to value the dosing weight |
DosingWeightSrcDispName | varchar(64) | NULL | The Finding Display name for the finding that was used to value the dosing weight |
RetrospectiveReviewIndicator | varchar(16) | NULL | The possible states for an order regarding Retrospective Review |
| | | Allowable values: |
| | | NULL or 'NOTNEEDED' - The order does NOT qualify for Retrospective Review |
| | | 'NEEDED' - The order qualifies for Retrospective Review |
| | | 'DONE' - The order was Retrospective Reviewed |
NonFormularyReason | varchar(64) | NULL | The reason for Non Formulary orders(should be null when IsNonFormulary is 0) |
NonWtAdministeredVolume | varchar(30) | NULL | The non-weight based admin volume(admin volume per day) |
NonWtAdminVolumeUnitCode | varchar(16) | NULL | The unit code for the non-weight based admin volume |
NonWtAdminVolumeUnitString | varchar(20) | NULL | The presentation value for units for non-weight based admin volume |
SessionStartDateTime | datetime | NULL | The start date time of the session. This is the date time used when the order goes into session. |
| | | SessionId and SessionStartDateTime need to be used as a composite key. |
| | | In order to guarantee uniqueness, always look up SessionStartDateTime in conjunction with SessionId. |
OriginalCalculatedDose | varchar(30) | NULL | Original calculated dose |
OriginalCalculatedDoseUnitCode | varchar(16) | NULL | Original calculated dose unit |
DoseAdjustmentPercentage | smallint | NULL | Percentage differential between the calculated and modified dose |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
MTPID | varchar(36) | NULL | MTPID(IHE IT Medication Treatment Plan Identifier) used to uniquely identify a prescription within the Swiss Portal |