Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
TransactionId | INT | NOT NULL | Unique transaction id, common for entire selection. This is used to group all med administrations. Also processing takes place per transaction ID. |
DispSelectionDtime | DATETIME | NOT NULL | The Date/Time when the selection was made |
LabelType | VARCHAR(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_oid | INT | NOT NULL | Object ID of the user who made the administration selection(HSUser) |
WorkstationId | VARCHAR(30) | NULL | Identifier of the workstation from which the selection was triggered |
Entity_oid | INT | NOT NULL | Entity identifier corresponding to current patient(HHealthCareUnit) |
PatientVisit_oid | INT | NOT NULL | Object ID for the Patient's Visit(HPatientVisit) |
MedDispOrder_oid | INT | NOT NULL | Object ID for the dispensable medication order(HMedDispOrder) |
MedAdministration_oid | INT | NULL | Object ID for the administration object(HMedAdministration) |
MPWSequenceNo | INT | NOT NULL | Ordinal value of current row. Unique value representing the position within selection |