Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1143. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsDeleted | tinyint | NOT NULL | Specifies whether the record is soft deleted. |
| | | Allowable Values |
| | | 0 - Active |
| | | 1 - Marked as Deleted. |
| | | Note: The presence of this field in tables depends on the configuration at the time of table design. |
IsVersioned | bit | NOT NULL | Whether the table data is Versioned or not. |
| | | Allowable Values: |
| | | 0 - No version data captured. |
| | | 1 - Version changes available in _Ver table. |
| | | Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HMedDrugService_Ver. |
| | | Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. |
| | | This field is linked to HSUser table to get details about the user. For more information see description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
StartDateTime | datetime | NOT NULL | Date and time when the drug service is active from Soarian's Service Catalog. |
GenericName | varchar(95) | NOT NULL | Generic name of the medication. The generic name is populated from Drug Database(NDDF - National Drug Data File for US Clients , ID-Berlin for EU Clients). All drug services have generic names. |
StopDateTime | datetime | NULL | Date and time when the drug service is no longer valid. |
BrandName | varchar(65) | NULL | Brand name of the medication. |
| | | All medications have a generic name and a brand name. The brand name is populated from Drug Database(NDDF - National Drug Data File for US Clients , ID-Berlin for EU Clients) . All packaged medications have brand names. |
OfficialDrugCode | varchar(32) | NULL | Nationally(or regionally) recognized drug identifier for a dispensable packaged drug. |
IsClinicallyEquivalent | bit | NULL | When set to 1, indicates that the drug code has a suffix and it can be removed without changing its meaning. |
| | | Allowable Value |
| | | 0 - False |
| | | 1 - True |
DrugCode | varchar(32) | NOT NULL | Unique code associated with the medication. |
DrugLevel | tinyint | NOT NULL | Level of description for the medication. |
| | | Allowable Values: |
| | | 0 - medDrugBrand |
| | | 1 - medDrugRoute |
| | | 2 - medDrugForm |
| | | 3 - medDrugStrength |
| | | 4 - medDrugPackage |
| | | 5 - medDrugNDC |
ObsoleteDateTime | datetime | NULL | Date and time when the drug service is no longer available for selection or processing. |
DrugServiceStatus | tinyint | NOT NULL | Status of the drug service. |
| | | Allowable Values: |
| | | 0 - Active |
| | | 1 - Inactive |
| | | 2 - Obsolete |
DrugType | tinyint | NOT NULL | Type of medication. |
| | | Allowable Values: |
| | | 0 - meddtMed |
| | | 1 - meddtSolution |
| | | 2 - meddtAdditive |
| | | 3 - meddtMedAdditive |
| | | 4 - MeddtPremix |
VitalsToCollect | varchar(170) | NULL | Abbreviation set for the vitals required to be collected prior to administering the medication. These vitals must be collected before the nurse administers the medication. Refer to the following abbreviation set for a vital collected and the associated description. |
| | | Allowable Values: |
| | | BP - Blood Pressure |
| | | PULSE - Pulse |
| | | TEMP - Temperature |
| | | RS - Respiration |
| | | BS - Blood Sugar |
| | | PS - Pain Scale |
| | | PSL - Pain Scale Location |
PackageName | varchar(128) | NULL | Packaged name of the medication. |
PackageSize | varchar(32) | NULL | Package size of the medication. |
PackageUnitString | varchar(20) | NULL | Package unit of the medication.This field will contain internationalized string. |
PackageUnitCode | varchar(16) | NULL | Code associated with the package unit of the medication. Value won't be internationalized and business logic can be written on the coded values. |
Supplier | varchar(32) | NULL | Supplier of the medication.The supplier is populated from Drug Database |
Strength | varchar(15) | NULL | Strength of the medication. If the strength of a medication is high, it indicates that the medication 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. |
|
StrengthUnitString | varchar(20) | NULL | Unit of the strength of the medication.This field will contain internationalized string. |
StrengthUnitCode | varchar(16) | NULL | Code associated with the unit of the strength of the medication. Value won't be internationalized and business logic can be written on the coded values. |
RouteCode | varchar(15) | NULL | Code associated with the route. The route indicates the manner in which the medication should be taken. This route is populated from Drug Database. |
DoseForm | varchar(32) | NULL | Form of dosage of the medication. eg Tablet, Capsule etc |
EnteredBy_oid | int | NULL | ObjectID of the user who entered this record in Soarian Catalog. Usually this field is valued when Catalog is being updated using Med Formulary transactions from Pharmacy system. |
HealthCareUnit_oid | int | NULL | ObjectID of HealthCareUnit where the Detail of the Service is configured. Usually all medications are configured only at Enterprise level. |
Service_oid | int | NOT NULL | Value stored as a result of a one-to-one relationship between HMedDrugService and HService. |
CatalogID | int | NOT NULL | Catalog Identifier of the record in HMedDrugCatalogues that contains information about the drug database vendor. |
Parent_oid | int | NULL | ObjectID stored as a result of a self relationship in HMedDrugService. Routed Med will have this field valued as null , where as Package Med created out of the Routed Med will have the ObjectID of Routed Med in this field. One routed drug can have many packaged drugs. |
FormularyStatus | varchar(64) | NULL | Formulary status of the medication. The formulary status indicates if the medication is under investigation or is in use in the hospital. |
| | | Allowable Values: |
| | | Formulary |
| | | Non-formulary |
| | | Investigation |
| | | Therap Eval. |
InappropriateRoutes | varchar(MAX) | NULL | List of delimited routes that are inappropriate for administering the medication. The delimiter used is "\". |
DrugServiceName | varchar(128) | NOT NULL | Unique name of the drug service in Soarian Catalog. |
DrugServiceAbbreviation | varchar(16) | NOT NULL | Abbreviation of the unique name of the drug service in Soarian Catalog. |
DrugClass | varchar(2) | NULL | Indicates the classification that determines how narcotic the medication is. |
GenericOrBrandName | tinyint | NOT NULL | When set to 1, indicates that the drug service is a brand level(packaged) service. |
| | | Allowable Values: |
| | | 0 - Generic |
| | | 1 - Packaged(Brand) |
AdminCoSignRequired | tinyint | NOT NULL | When set to 1, indicates that cosignatory's signature is required to carry out the drug service. |
| | | Allowable Values: |
| | | 0 - Cosignatory's signature not required |
| | | 1 - Cosignatory's signature required |
AdminCoSignRequiredReason | varchar(64) | NULL | Reason why the cosignatory's signature is required to carry out the drug service. |
RouteString | varchar(64) | NULL | Manner in which the medication should be taken. This route is populated from Drug Database. |
TheraputicCode | varchar(8) | NULL | Classification system of how the medication is used. |
OAWOverride | tinyint | NULL DEFAULT(0 | Indicates the name that would be used for the Order as written concatenation on the picklist. |
| | | Allowable Values: |
| | | 0 - Generic name or brand name |
| | | 1 - Service name |
ServiceTypeOID | int | NOT NULL | One to one relationship with the service type(HServiceType) associated with this entry |
ServiceSubTypeoid | int | NULL | One to one relationship with the service sub type associated with this entry |
RoundingRule | char(6) | NOT NULL | Rule on how rounding will be applied for the calculated volume. |
| | | Allowable Values: |
| | | None |
| | | Up |
| | | Down |
NoOfDigitsAfterDecimal | smallint | NOT NULL | Specifies how many numbers appear on the right side of the decimal. |
Volume | Varchar(6) | NULL | Total volume of medication required to carry out the service. |
VolumeUnit | Varchar(12) | NULL | Unit of the total volume of medication required to carry out the service. For example, ml(milliliters) |
VolumeUnitCode | Varchar(16) | NULL | Unit code of the volume. |
DefaultUnit | char(1) | NULL | Specifies whether the default unit for this medication is Strength or Volume |
| | | Allowable Values: |
| | | D - Strength |
| | | V - Volume |
LimitSearchToNameOnly | smallint | NOT NULL | Specifies how this medication record is searched in Clinical work flow |
| | | Allowable Values: |
| | | 0 - Full Search |
| | | 1 - Limited to servicename |
|
IsAutoProfiled | tinyint | NOT NULL | The drug product is enabled for auto-profiling. |
| | | Allowable values |
| | | 0 - No |
| | | 1 - Yes |
IsUnitDoseDispensed | tinyint | NOT NULL | The drug product is available in the automatic dispensing system. |
| | | Allowable values |
| | | 0 - No |
| | | 1 - Yes |
| | | 2 - Undetermined |
DeliverySource | varchar(3) | Not Null | Specifies how drug is stocked. |
| | | Allowable values |
| | | AN:filled from ancillary dept stock |
| | | FL:filled from floor stock. |
RetrospectiveReviewReqd | tinyint | NULL | Indicates if the drug product is enabled for Retrospective Review. |
| | | Allowable values |
| | | NULL or 0 - No |
| | | 1 - Yes |
FormularyStatusCode | smallint | NULL | To store the ItemCode from HDataDictionaryItem table, of the formulary status. |
| | | Allowable values |
| | | 0 - Formulary |
| | | 1 - Non-formulary |
| | | 2 - Investigation |
| | | 3 - Therap Eval. |
IndicationRequiredCode | tinyint | NULL | Mandatory-ness setting for Indication. |
| | | Allowable value |
| | | 2 - Mandatory |
| | | 1 - Optional |
| | | 0 or NULL - Not Available |
ATCCodeUS | varchar(8) | NULL | Drug's Anatomical Therapeutic Chemical(ATC) Classification code, as developed by the World Health Organization(WHO). |
| | | Note: This column is only used in a US environment because the TheraputicCode column(which contains the ATC code in a European environment) may contain FDB's Hierarchical Specific Therapeutic Class Code(HIC3). |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|