Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMedSubRouteMap This table stores the details of system-defined Routes for taking a medication and the relationship with its sub-routes.
Column Name Column Datatype Column Null Option Column Comment
RouteCodevarchar(15)NOT NULL Route Code for taking the medication. ex. Inj(Injection), IV(Intravenous)
SubRouteCodevarchar(15)NOT NULL Subroute codes associated with the given routes. ex. Epid(Epidural), IDrm(Intradermal), IM(Intramuscular)
RouteStringvarchar(32)NOT NULL Internationalized string for the route which displays in the UI.
RouteItemTypeCodevarchar(64)NOT NULL Links to the the Data Dictionary ItemType Code in HDictionaryItemType table. ex. Med.MedDrugRoutes.Injection, Med.MedDrugRoutes.Intravenous
SubRouteStringvarchar(32)NOT NULL Internationalized string for the sub route which displays in the UI.
SubRouteItemTypeCodevarchar(64)NOT NULL Links to the the Data Dictionary ItemType Code in the HDictionaryItemType table. ex. Med.MedDrugRoutes.Epidural, Med.MedDrugRoutes.Intradermal, Med.MedDrugRoutes.Intramuscular
StatussmallintNULL Whether the record is active or obsolete.
Allowable Values:
0 - Active
1 - Obsolete
ProcessingMethodsmallintNULL The process to be taken to inject the medication for the specified route.
Allowable Values:
0 - Push
7 - Piggyback

Return to Table-Index

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