Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedMPWDispSelection This table stores temporary administration selection made for the purpose of sign/dispensed or print. When used in an EDR workflow, print service pulls selection data based on the TransactionId, generates the report and prints it.
Column Name Column Datatype Column Null Option Column Comment
TransactionIdINTNOT NULL Unique transaction id, common for entire selection. This is used to group all med administrations. Also processing takes place per transaction ID.
DispSelectionDtimeDATETIMENOT NULL The Date/Time when the selection was made
LabelTypeVARCHAR(10)NOT NULL Type of label to be printed or signed for the current row
Allowable Values:
SIGN - sign administration selection
MB - medication box specific print selection
IV - IV specific print selection
DispUser_oidINTNOT NULL Object ID of the user who made the administration selection(HSUser)
WorkstationIdVARCHAR(30)NULL Identifier of the workstation from which the selection was triggered
Entity_oidINTNOT NULL Entity identifier corresponding to current patient(HHealthCareUnit)
PatientVisit_oidINTNOT NULL Object ID for the Patient's Visit(HPatientVisit)
MedDispOrder_oidINTNOT NULL Object ID for the dispensable medication order(HMedDispOrder)
MedAdministration_oidINTNULL Object ID for the administration object(HMedAdministration)
MPWSequenceNoINTNOT NULLOrdinal value of current row. Unique value representing the position within selection

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates