Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | The object ID of the Administration object. This field is always a primary key and matches the one from the HMedAdministration |
InstanceHFCID | SMALLINT | NOT 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. |
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 | Indicates whether the record is soft deleted. Allowable Values: 0 - Active, 1 - Marked as Deleted |
IsVersioned | BIT | NOT 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 |
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. For more information on HSUser table. |
CreationTime | SMALLDATETIME | NULL | The date and time when the object is 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 valid |
AdministrationStatus | TINYINT | NOT 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 |
AdministrationType | TINYINT | NOT NULL | Flag indicating whether drug administered was med or IV. Allowable values: 0 - Med, 1 - IV |
PlannedDateTime | DATETIME | NULL | The Date/Time that the administration was originally planned for |
PlannedDose | VARCHAR(50) | NULL | Dose of the drug that was originally planned for |
PlannedDoseUnitString | VARCHAR(30) | NULL | The unit String of the Dose that was originally planned for |
PlannedRunIn | VARCHAR(20) | NULL | The originally planned Run-In. Populated for specific medication types as IVs |
PlannedRate | VARCHAR(8) | NULL | The originally planned Rate. Populated for specific medication types as IVs |
PlannedRateUnitString | VARCHAR(20) | NULL | Unit String of the planned Rate |
ActualDateTime | DATETIME | NULL | The Date/Time that the medication was actually given to the patient |
ActualDose | VARCHAR(50) | NULL | Indicates actual Dose that was given |
ActualDoseUnitString | VARCHAR(30) | NULL | Dose Unit for the actual dose that was given |
Comment | VARCHAR(64) | NULL | Comment related to this particular medication administration |
VitalStatus | TINYINT | NOT NULL | Indicates whether or not vitals are required. Allowable values: 1 - Yes, 0 - No |
SignedBy_oid | INT | NULL | Object ID for the staff who signed the administration(HStaff) |
Patient_oid | INT | NOT NULL | Object ID for the Patient(HPatient) |
CoSignedBy_oid | INT | NULL | Object ID for the staff who cosigned the administration(HStaff) |
MedDispOrder_oid | INT | NOT NULL | Object ID for the Dispensed Order(HMedDispOrder) |
PlannedRunInUnitString | VARCHAR(20) | NULL | The planned RunIn unit as string |
ActualRunIn | FLOAT(53) | NULL | The actual RunIn value documented |
ActualRunInUnitString | VARCHAR(20) | NULL | Actual unit for the RunIn value |
ActualRate | FLOAT(53) | NULL | Actual rate at which the drug is being dispensed to the patient |
ActualRateUnitString | VARCHAR(20) | NULL | Unit string for the rate of the drug that is being dispensed |
SignedDateTime | DATETIME | NULL | Date/time when the administration was signed off on by the user |
CoSignDateTime | DATETIME | NULL | Date/time when the administration was cosigned by the 2nd user |
CoSignRequired | TINYINT | NOT NULL | Flag inidicating whether or not a 2nd user must cosign the administration. Allowable values: 1 - Yes, 0 - No |
VitalsToCollect | VARCHAR(170) | NULL | Stores the comma separated list of vital signs to be collected |
Reason | VARCHAR(64) | NULL | The reason for the drug being administered |
Visit_oid | INT | NOT NULL | Object ID for the Patient's Visit(HPatientVisit) |
DoseIsNormalized | TINYINT | NOT NULL | Flag indicating whether or not the dose is normalized. Allowable values: 1 - Yes, 0 - No |
PlannedDoseUnitCode | VARCHAR(20) | NULL | Unit code for the planned Dose |
PlannedRateUnitCode | VARCHAR(16) | NULL | Unit code for the planned Rate |
PlannedRunInUnitCode | VARCHAR(16) | NULL | Unit code for the planned Runin |
ActualDoseUnitCode | VARCHAR(20) | NULL | Unit Code of the Actual Dose given to patient |
ActualRateUnitCode | VARCHAR(16) | NULL | The actual Rate Unit Code |
ActualRunInUnitCode | VARCHAR(16) | NULL | The actual RunIn Unit Code |
SignedByStaffName | VARCHAR(188) | NULL | Name of the staff who signed off on the administration |
CoSignedByStaffName | VARCHAR(188) | NULL | Name of the cosigner(if collected) who signed off on the administration |
HasHistory | TINYINT | NOT NULL | Indicates if there exists entries in HMedAdministrationH for this particular administration. Allowable values: 1 - Yes, 0 - No |
AdmStatusOrigin | TINYINT | NULL | Status of the administration. |
| | | Allowable values: |
| | | 0 - Open |
| | | 1 - Administered |
| | | 2 - NotAdministered |
| | | 3 - Cancelled |
| | | 4 - PatientPerformed |
| | | 5 - Suspended |
MedFunctionCode | TINYINT | NOT 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 |
IsInterface | TINYINT | NOT NULL | Indicates if the data was entered via the Interface or not. Allowable values: 1 - Yes, 0 - No |
SignedbyType | VARCHAR(4) | NULL | Type of signature on administration. Allowable values: 0 - Sign, 1 - CoSign, 2 - EnteredBy, 3 - Responsible, 4 - RequestedBy |
CoSignedbyType | VARCHAR(4) | NULL | Type of co-signature on administration. |
| | | Allowable values: |
| | | 0 - Sign |
| | | 1 - CoSign |
| | | 2 - EnteredBy |
| | | 3 - Responsible |
| | | 4 - RequestedBy |
LotNumber | VARCHAR(30) | NULL | Lot number of the drug being administered |
ManufacturerName | VARCHAR(30) | NULL | Manufacturer name of the drug being administered |
ExpirationDate | VARCHAR(8) | NULL | Expiration date of the drug being administered |
AdministrationEndDTime | DATETIME | NULL | The date/time the drug stopped being administered |
AdminSite | VARCHAR(24) | NULL | Site on the patient's body where the drug was admininstered |
VolumeInfused | FLOAT(53) | NULL | Actual amount that has been infused into the patient |
DispenseStatus | VARCHAR(6) | NULL | Dispense status of medication |
| | | Allowable values: |
| | | OPEN - Open |
| | | DISP - Dispensed |
| | | NODISP - Not dispensed(Not used) |
| | | INPREP - In preparation(Not used) |
DispensedByStaff_oid | INT | NULL | Reference to the HStaff object ID for the staff who dispensed the administration(HStaff) |
DispensedByStaffName | VARCHAR(188) | NULL | The name of the staff who dispensed the administration |
DispensedDateTime | DATETIME | NULL | Date/time the drug for the administration was dispensed |
ChangeNo | SMALLINT | NULL | The number of times the administration has changed. Used to properly sequence the history information |
MedDispOrderComponent_oid | INT | NULL | Object ID for the Dispensable Order Component(HMedDispOrderComponent) |
IsContinuedOnVisitChange | BIT | NULL | Flag to indicate an IV continued running on admission/transfer. Allowable Values: 0 - False, 1 - True |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|