Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | The object ID of the dispensable component |
InstanceHFCID | SMALLINT | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(1116). 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 | TINYINT | 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 HMedDispOrderComponentH_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 which the medication prescribed to the patient is valid |
ValidTo | DATETIME | NULL | The Date/Time when the medication prescribed to the patient is no longer valid |
ExternalID | VARCHAR(6) | NULL | Identifier sent in by the third-party Pharmacy application as a part of inbound transaction |
PrimaryComponent | TINYINT | NOT NULL | When set to 1, indicates that the medication is a primary component. A single primary component is allowed per medication. Allowable Values: 0/1 |
ResultToCollect | VARCHAR(64) | NULL | Result that should be measured. It indicates a name that describes the vital sign on which the medication strength should be based. For example, BloodSugar |
BrandDrugName | VARCHAR(95) | NULL | Brand name of the medication as displayed to the user. For example, Aspirin Oral Tab 325 mg |
DrugLevel | TINYINT | NOT NULL | Level of description for the medication. Allowable Values: 0 - Brand, 1 - Route, 2 - Form, 3 - Strength, 4 - Package, 5 - NDC |
NotifyPhysician | VARCHAR(75) | NULL | Actions required to be taken by the physician if a measured value of medication exceeds the specified value. For example: Contact MD if BloodSugar <70 or >350 |
OfficialDrugCode | VARCHAR(32) | NULL | Indicates the nationally(or regionally) recognized drug identifier for a dispensable packaged drug |
DrugCode | VARCHAR(32) | NOT NULL | Code assigned to the medication. |
RouteCode | VARCHAR(15) | NOT NULL | Code associated with the route, the method of taking or administering the medication |
SequenceNo | INT | NOT NULL | Unique sequence number assigned to the drug component used to prescribe medication |
FrequencyString | VARCHAR(40) | NOT NULL | Frequency of taking or administering the medication. This is populated from the Name field in HRecurrenceTemplate |
MedDispOrder_oid | INT | NOT NULL | Object ID of HMedDispOrder stored as a result of a one-to-many relationship between HMedDispOrderComponent and HMedDispOrder |
Patient_oid | INT | NOT NULL | Object ID for the Patient(HPatient) |
Frequency_oid | INT | NOT NULL | Object ID of HRecurrenceInstance stored as a result of a one-to-one relationship between HMedDispOrderComponent and HRecurrenceInstance |
DrugStrength | VARCHAR(15) | NULL | Strength of the drug. If the strength of a drug is high, it indicates that the drug has higher capability. As an example, Bob takes 250 mg erythromycin four times a day to cure his throat infection. If Bob's doctor increases the drug strength to 500 mg, he will then take it only twice a day |
DrugStrengthUnitString | VARCHAR(20) | NULL | Unit associated with the strength of the drug. For example, mg(milligrams) |
DoseForm | VARCHAR(32) | NULL | Administration form of the drug. For example, Tabl(tablet, powder, bag) |
DrugType | TINYINT | NOT NULL | Type of medication. Allowable values: 0 - MED, 1 - SOLUTION, 2 - ADDITIVE, 3 - MED_ADDITIVE, 4 - PREMIX, 5 - UNDEF |
GenericDrugName | VARCHAR(95) | NULL | Indicates the alternate name assigned to the drug |
DrugStrengthUnitCode | VARCHAR(20) | NULL | Code associated with the unit of the strength of the drug |
RouteString | VARCHAR(32) | NULL | The manner in which the medication should be taken. For example, oral. This string can be a user-defined value if the user has different names than first databank. |
CatalogID | INT | NOT NULL | Object ID of the catalog that contains information about the drug service associated with the prescribed medication |
DrugService_oid | INT | NOT NULL | Identifier value stored as a result of a one-to-one relationship between HMedDrugService and HMedDispOrderComponent. This values is the object ID of the drug service(HMedDrugService) that contains information about the drug service associated with the prescribed medication |
DrugClass | VARCHAR(2) | NULL | Classification that determines how narcotic the medication is |
TheraputicCode | VARCHAR(8) | NULL | Classification system of how the medication is used. ATC codes used in a European environment. May contain FDB's Hierarchical Specific Therapeutic Class Code(HIC3) defined in HATCMaster |
ChangeNo | SMALLINT | NULL | Indicates the number of times the order has changed. Used to properly sequence the history information |
GenericOrBrandName | TINYINT | NULL | Primary drug name indicator, 1 or null for generic, 0 for brand |
Duration | INT | NULL | Duration for which the drug component is valid |
DurationUnitCode | INT | NULL | Code associated with the unit of the duration for which the component is valid |
DurationUnitString | VARCHAR(20) | NULL | Unit of the duration for which the component is valid. For example, days, doses |
SubRouteString | VARCHAR(32) | NULL | Sub route string |
SubRouteCode | VARCHAR(15) | NULL | Sub route code |
DrugVolume | VARCHAR(6) | NULL | Drug volume |
DrugVolumeUnit | VARCHAR(12) | NULL | Unit of the drug volume |
DrugVolumeUnitCode | VARCHAR(16) | NULL | Code of the drug volume unit |
DefaultUnit | CHAR(1) | NULL | Default unit for medication |
IndicationRequiredCode | TINYINT | NULL | Mandatory-ness setting for Indication. Allowable values: 0/NULL - Not Available, 1 - Optional, 2 - Mandatory |
ATCCodeUS | VARCHAR(8) | NULL | Indicate drug's Anatomical Therapeutic Chemical(ATC) Classification code, as developed by the World Health Organization(WHO). This column is only used in a US environment |