Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | The object ID of the dispensed medication order |
InstanceHFCID | SMALLINT | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1133). Note: The value specified in the ObjectID field and in this field enables unique identification of an object across the application |
RecordId | INT | NULL | The record ID. Not valued in this table. Column exists as part of the 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 the 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 HMedDispOrderH_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 the 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 when the medication prescribed to the patient became valid |
ValidTo | DATETIME | NULL | The Date/Time when the medication prescribed to the patient is no longer valid |
InternalID | INT | NULL | Object ID of the order(HOrder) |
ExternalID | VARCHAR(6) | NULL | Identifier sent in by a third-party Pharmacy application as part of an inbound transaction |
MedOrderStatus | TINYINT | NOT NULL | The status of the 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 |
Reason | VARCHAR(32) | NULL | Reason for modifying the order |
StartDateTime | DATETIME | NOT NULL | Date and time when the order became valid |
CalculatedStopDateTime | DATETIME | NOT NULL | Date and time when the order component is no longer valid. Calculated based on system preferences |
OrderAsWritten | VARCHAR(650) | NOT NULL | Text describing medication orders that can be dispensed. The medication order details are contained in the text |
MedOrderType | TINYINT | NOT NULL | Type of the medication order |
| | | Allowable Values: |
| | | 0 - medotSimpleMed |
| | | 1 - medotComplexMed |
| | | 2 - medotSlidingDoseMed |
| | | 3 - medotTaperDoseMed |
| | | 4 - medotDifferDoseMed |
| | | 5 - medotExtraDoseMed |
| | | 6 - medotRegularIV |
| | | 7 - medotPCAIV |
| | | 8 - medotFreeText(NA) |
| | | 9 - medotRX(NA) |
IVMethodCode | TINYINT | NULL | Code assigned to the different methods to administer IVs. |
| | | 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) |
TotalVolume | VARCHAR(30) | NULL | Total volume of the bottle from which the IV was administered |
Rate | VARCHAR(8) | NULL | Drip rate of the bottle from which the IV was administered |
RateUnitString | VARCHAR(20) | NULL | Unit of the drip rate of the bottle from which the IV was administered. For example, ml/h |
RunIn | VARCHAR(8) | NULL | Total infusion run-in time of the bottle from which the IV was administered |
PRNIndicator | TINYINT | NOT NULL | When set to 1, indicates that the medication can be administered to the patient as desired. Allowable Values: 0 - Non-PRN order, 1 - PRN order |
PerformedByPatient | TINYINT | NOT NULL | When set to 1, indicates the medication is administered by the patient himself |
| | | Allowable Values: |
| | | 0 - Medication is not administered by patient himself |
| | | 1 - Medication is administered by patient himself |
PriorityCode | TINYINT | NOT NULL | Code assigned to the priority of the medication order. Allowable Values: 0 - medpriStat, 1 - medpriRoutine, 2 - medpriStatRoutine |
PatientVisit_oid | INT | NOT NULL | Object ID for the Patient's Visit(HPatientVisit) |
Patient_oid | INT | NOT NULL | Object ID for the Patient(HPatient) |
AcknowledgedBy_oid | INT | NULL | Object Id for the staff who acknowledged the medication(HStaff) |
TotalVolumeUnitString | VARCHAR(20) | NULL | Unit of the total volume of the bottle from which the IV was administered. ex. ml |
PCAAdditionalDose | VARCHAR(20) | NULL | 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. |
PCAAdditionalDoseUnitString | VARCHAR(20) | NULL | Unit of the additional dose that the patient can give himself with one push |
PCADelayInterval | INT | NULL | Time interval between two pushes to administer dose |
RequestedBy_oid | INT | NULL | Object ID for the staff that requested the medication(HStaff). |
| | | Will be Null when the RequestedBy information on the inbound transaction from the Pharmacy System does not match any entries in HStaff(ex. free text name) |
PCADelayIntervalUnitString | VARCHAR(20) | NULL | Unit of the time interval between two pushes to administer dose |
PCALockoutDose | VARCHAR(20) | NULL | Maximum dose that the patient can administer himself with one push |
PCALockoutDoseUnitString | VARCHAR(20) | NULL | Unit of the maximum dose that the patient can administer himself with one push |
PCALockoutTime | INT | NULL | Maximum time the patient can take to administer himself a dose with one push. The amount of dose(as specified in the PCALockoutDose field) can never exceed the lock out time |
PCALockoutTimeUnitString | VARCHAR(20) | NULL | Unit of the maximum time the patient can take to administer a dose to himself with one push |
VitalsToCollect | VARCHAR(170) | NULL | Abbreviation set for the vitals to be collected to carry out the order. |
| | | Refer to the following abbreviation set for a vital collected and the associated description |
| | | BP - Blood Pressure |
| | | PULSE - Pulse |
| | | TEMP - Temperature |
| | | RS - Respiration |
| | | BS - Blood Sugar |
| | | PS - Pain Scale |
| | | PSL - Pain Scale Location |
RunInUnitString | VARCHAR(20) | NULL | Unit for the total infusion run-in time of the bottle in which the IV was administered |
DisplayDoseString | VARCHAR(47) | NULL | Dose of the medication as displayed to the user |
AcknowledgeRequired | TINYINT | NOT NULL | When set to 1, indicates that the order needs to be acknowledged before any medication is administered. Allowable Values: 0 - Order need not be acknowledged, 1 - Order needs to be acknowledged |
AdminCoSignRequired | TINYINT | NOT NULL | When set to 1, indicates that each administration must be countersigned before it is administered. Allowable Values: 0 - Countersignature not required, 1 - Countersignature required |
Directions | VARCHAR(256) | NULL | Directions(such as shake well before administering) specified to carry out the order |
AcknowledgeDateTime | DATETIME | NULL | Date and time when the order was acknowledged |
RemainingAdm | INT | NULL | Counter to keep track of administrations with an open status. The counter indicates when to change the order status to complete. A value of 0 indicates that the order was created. |
NextOccurenceToGenerate | DATETIME | NULL | Date and time of the next occurrence of the order. |
TotalVolumeUnitCode | VARCHAR(16) | NULL | Code associated with the unit of the total volume of the bottle from which the IV was administered |
RateUnitCode | VARCHAR(16) | NULL | Code associated with the unit of the drip rate of the bottle from which the IV was administered |
RunInUnitCode | VARCHAR(16) | NULL | Code associated with the unit for the total infusion run-in time of the bottle from which the IV wa administered |
PCALockoutTimeUnitCode | VARCHAR(16) | NULL | 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 | Code associated with the maximum dose that the patient can administer himself with one push |
PCADelayIntervalUnitCode | VARCHAR(16) | NULL | Code associated with the time interval between two pushes to administer dose |
PCAAdditionalDoseUnitCode | VARCHAR(20) | NULL | Code associated with the unit of the additional dose that the patient can give himself with one push |
AdminCoSignRequiredReason | VARCHAR(64) | NULL | Reason why it is required to countersign each administration before it is administered |
PCALoadingDose | VARCHAR(20) | NULL | Initial dose for the PCA(Patient Controlled Analgesic) order |
PCALoadingDoseUnitString | VARCHAR(20) | NULL | Unit of the dose for the PCA order |
PCALoadingDoseUnitCode | VARCHAR(20) | NULL | Code associated with the unit of the dose for the PCA order |
MedOrderStatusDateTime | DATETIME | NULL | Date and time when the status of the order was recorded |
MedOrderStatusSignedBy_oid | INT | NULL | Object ID for the staff signing the status update(HStaff) |
MedOrderSet_oid | INT | NOT NULL | Object ID for the order set stored as a result of the one-to-one relationship between HMedDispOrder and HMedOrderSet |
MedOrderStatusReason | VARCHAR(120) | NULL | Reason for the specified order status |
MedFunctionCode | TINYINT | NOT NULL | Code associated with the medication functions that can be carried out on orders to dispense medication to the patient |
| | | 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 |
NumberOfAdditives | INT | NULL | The number of additives |
PRNReason | VARCHAR(64) | NULL | Reason for carrying out a PRN order. A PRN order indicates that the medication is administered only if necessary |
PRNCondition | VARCHAR(32) | NULL | Condition in which the PRN order is carried out. |
VerbalIndicator | SMALLINT | NOT NULL | When set to 1, indicates that the order is a verbal order |
OrderHistoryGroupID | INT | NULL | Object ID of the group that contains the order history(such as modifications made to the order) |
RequestedBy_StaffName | VARCHAR(188) | NULL | Name of the staff who requested the service(derived from Hstaff.Name). For orders originating on the Pharmacy System, the RequestedBy_StaffName may also be free text. Mapped to the ORC.12.02 field in the inbound interface |
MedOrderSetName | VARCHAR(30) | NULL | The MedOrderSet abbreviation when MedOrderType is medotComplexMed. For orders originating on the Pharmacy System, the MedOrderSetName is mapped to the RXE.2 field in the inbound interface. |
ValidatedBy | VARCHAR(188) | NULL | Pharmacist Name who validated the Med Order |
ValidatedDateTime | SMALLDATETIME | NULL | Date Time stamp when the order was validated by pharmacy |
HasVaccine | CHAR(1) | NULL | If this 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 |
Duration | INT | NULL | Duration from Pharmacy to Soarian. Value will be coming ORC-7.3.0 segment |
DurationUnitString | VARCHAR(9) | NULL | DurationUnitString from Pharmacy to Soarian. Value will be coming ORC-7.3.0 segment |
| | | Allowable values: |
| | | NULL - open ended orders |
| | | Days - duration in days |
| | | Doses - duration in doses |
| | | Seconds - duration in seconds |
| | | Minutes - duration in minutes |
| | | Hours - duration in hours |
| | | Bags - duration in bags |
| | | ML - duration in Milliliters |
| | | Weeks - duration in weeks |
| | | Months - duration in months |
| | | Years - duration in years |
DurationUnitCode | INT | NULL | Duration unit code |
| | | Allowable values: |
| | | 0/NULL - open ended orders |
| | | 1 - Days |
| | | 2 - Doses |
| | | 3 - Seconds |
| | | 4 - Minutes |
| | | 5 - Hours |
| | | 6 - Bags |
| | | 7 - Milliliters |
| | | 8 - Weeks |
| | | 9 - Months |
| | | 10 - Years |
LastCngDTime | DATETIME | NULL | The current Universal Time Coordinate or Greenwich Mean Time |
DeliverySource | VARCHAR(3) | NULL | HL7 value indicating where the medication was dispensed from. Default of FL(floorstock) / AN(ancillary dept stock) |
IsUnitDoseDispensed | TINYINT | NULL | If the drug is capable of being unit dose dispensed or not. Allowable values: 0 - no, 1 - yes, 2 - unknown |
HasAdministrationOnStopDateTime | SMALLINT | NULL | Whether there is an occurrence on the stop date time of the order. This feld is coming from Pharmacy inbound transaction, as 4th position of ORC-07.02.01 field. |
| | | Allowable values: |
| | | 0 - No occurrence on stop date time |
| | | 1 - Occurrence on stop date time(Set when pharmacy doesn't send OCCURRENCE_ON_STOP_DATE_TIME flag at all) |
| | | 2 - Order has no occurrences |
SkipAdministrationDTime | DATETIME | NULL | Planned date/time that should not be allowed to be created into an Administration Date/Time |
ChangeNo | SMALLINT | NULL | The number of times the order has changed. Used to properly sequence the history information |
DispenseStatus | VARCHAR(6) | NULL | Indicates dispense status of medication. |
| | | Allowable values: |
| | | OPEN - Open |
| | | DISP - Dispensed |
| | | NODISP - Not dispensed |
| | | INPREP - In preparation |
DispensedByStaff_oid | INT | NULL | Object ID for the Staff who dispensed the medication(HStaff) |
DispensedByStaffName | VARCHAR(188) | NULL | Name of the staff who dispensed the administration |
LastDispenseDTime | DATETIME | NULL | Date/time the drug for the administration was dispensed |
NonFormularyReason | VARCHAR(64) | NULL | Reason for the Non Formulary order(should be null when IsNonFormulary is 0) |