Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedAdministrationH This table stores the historical data of medication order administrations
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULL The object ID of the Administration object. This field is always a primary key and matches the one from the HMedAdministration
InstanceHFCIDSMALLINTNOT NULL The HFC(Healthcare Foundation Class) ID of the object(1110 - matches the main table HMedAdministration). Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdINTNULL The record ID. Not valued in this table. Column exists as part of persistence framework implementation
DescriptionVARCHAR(1)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not valued
IsDeletedTINYINTNOT NULL Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted
IsVersionedBITNOT 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 HMedAdministrationH_Ver is created. Allowable Values: 0 - False, 1 - True
CreatedUserIdINTNULL 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.
CreationTimeSMALLDATETIMENULL The date and time when the object is created
ValidFromDATETIMENOT NULL The Date/Time from when the current record became valid
ValidToDATETIMENULL The Date/Time until the current record is valid
AdministrationStatusTINYINTNOT NULL The status of administering the medication to the patient. Allowable values: 0 - Open, 1 - Administered, 2 - Not Administered, 3 - Cancelled, 4 - Patient Performed, 5 - Suspended
AdministrationTypeTINYINTNOT NULL Flag indicating whether drug administered was med or IV. Allowable values: 0 - Med, 1 - IV
PlannedDateTimeDATETIMENULL The Date/Time that the administration was originally planned for
PlannedDoseVARCHAR(50)NULL Dose of the drug that was originally planned for
PlannedDoseUnitStringVARCHAR(30)NULL The unit String of the Dose that was originally planned for
PlannedRunInVARCHAR(20)NULL The originally planned Run-In. Populated for specific medication types as IVs
PlannedRateVARCHAR(8)NULL The originally planned Rate. Populated for specific medication types as IVs
PlannedRateUnitStringVARCHAR(20)NULL Unit String of the planned Rate
ActualDateTimeDATETIMENULL The Date/Time that the medication was actually given to the patient
ActualDoseVARCHAR(50)NULL Indicates actual Dose that was given
ActualDoseUnitStringVARCHAR(30)NULL Dose Unit for the actual dose that was given
CommentVARCHAR(64)NULL Comment related to this particular medication administration
VitalStatusTINYINTNOT NULL Indicates whether or not vitals are required. Allowable values: 1 - Yes, 0 - No
SignedBy_oidINTNULL Object ID for the staff who signed the administration(HStaff)
Patient_oidINTNOT NULL Object ID for the Patient(HPatient)
CoSignedBy_oidINTNULL Object ID for the staff who cosigned the administration(HStaff)
MedDispOrder_oidINTNOT NULL Object ID for the Dispensed Order(HMedDispOrder)
PlannedRunInUnitStringVARCHAR(20)NULL The planned RunIn unit as string
ActualRunInFLOAT(53)NULL The actual RunIn value documented
ActualRunInUnitStringVARCHAR(20)NULL Actual unit for the RunIn value
ActualRateFLOAT(53)NULL Actual rate at which the drug is being dispensed to the patient
ActualRateUnitStringVARCHAR(20)NULL Unit string for the rate of the drug that is being dispensed
SignedDateTimeDATETIMENULL Date/time when the administration was signed off on by the user
CoSignDateTimeDATETIMENULL Date/time when the administration was cosigned by the 2nd user
CoSignRequiredTINYINTNOT NULL Flag inidicating whether or not a 2nd user must cosign the administration. Allowable values: 1 - Yes, 0 - No
VitalsToCollectVARCHAR(170)NULL Stores the comma separated list of vital signs to be collected
ReasonVARCHAR(64)NULL The reason for the drug being administered
Visit_oidINTNOT NULL Object ID for the Patient's Visit(HPatientVisit)
DoseIsNormalizedTINYINTNOT NULL Flag indicating whether or not the dose is normalized. Allowable values: 1 - Yes, 0 - No
PlannedDoseUnitCodeVARCHAR(20)NULL Unit code for the planned Dose
PlannedRateUnitCodeVARCHAR(16)NULL Unit code for the planned Rate
PlannedRunInUnitCodeVARCHAR(16)NULL Unit code for the planned Runin
ActualDoseUnitCodeVARCHAR(20)NULL Unit Code of the Actual Dose given to patient
ActualRateUnitCodeVARCHAR(16)NULL The actual Rate Unit Code
ActualRunInUnitCodeVARCHAR(16)NULL The actual RunIn Unit Code
SignedByStaffNameVARCHAR(188)NULL Name of the staff who signed off on the administration
CoSignedByStaffNameVARCHAR(188)NULL Name of the cosigner(if collected) who signed off on the administration
HasHistoryTINYINTNOT NULL Indicates if there exists entries in HMedAdministrationH for this particular administration. Allowable values: 1 - Yes, 0 - No
AdmStatusOriginTINYINTNULL Status of the administration.
Allowable values:
0 - Open
1 - Administered
2 - NotAdministered
3 - Cancelled
4 - PatientPerformed
5 - Suspended
MedFunctionCodeTINYINTNOT NULL Status of the medication being administered.
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
IsInterfaceTINYINTNOT NULL Indicates if the data was entered via the Interface or not. Allowable values: 1 - Yes, 0 - No
SignedbyTypeVARCHAR(4)NULL Type of signature on administration. Allowable values: 0 - Sign, 1 - CoSign, 2 - EnteredBy, 3 - Responsible, 4 - RequestedBy
CoSignedbyTypeVARCHAR(4)NULL Type of co-signature on administration.
Allowable values:
0 - Sign
1 - CoSign
2 - EnteredBy
3 - Responsible
4 - RequestedBy
LotNumberVARCHAR(30)NULL Lot number of the drug being administered
ManufacturerNameVARCHAR(30)NULL Manufacturer name of the drug being administered
ExpirationDateVARCHAR(8)NULL Expiration date of the drug being administered
AdministrationEndDTimeDATETIMENULL The date/time the drug stopped being administered
AdminSiteVARCHAR(24)NULL Site on the patient's body where the drug was admininstered
VolumeInfusedFLOAT(53)NULL Actual amount that has been infused into the patient
DispenseStatusVARCHAR(6)NULL Dispense status of medication
Allowable values:
OPEN - Open
DISP - Dispensed
NODISP - Not dispensed(Not used)
INPREP - In preparation(Not used)
DispensedByStaff_oidINTNULL Reference to the HStaff object ID for the staff who dispensed the administration(HStaff)
DispensedByStaffNameVARCHAR(188)NULL The name of the staff who dispensed the administration
DispensedDateTimeDATETIMENULL Date/time the drug for the administration was dispensed
ChangeNoSMALLINTNULL The number of times the administration has changed. Used to properly sequence the history information
MedDispOrderComponent_oidINTNULL Object ID for the Dispensable Order Component(HMedDispOrderComponent)
IsContinuedOnVisitChangeBITNULL Flag to indicate an IV continued running on admission/transfer. Allowable Values: 0 - False, 1 - True
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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