Table Detail Report

MLTM_DRC_GROUPS_OBSOLETE



Column Section Top of Page


Table-level Detail

Description: MLTM_DRC_GROUPS_OBSOLETE
Definition: Table used to store Multum dose range checking obsolete groupers
Table Type: REFERENCE





Column Detail - MLTM_DRC_GROUPS_OBSOLETE


Column Name Type Null? Definition
GROUPER_ID DOUBLE N Externally assigned identifier for dose range check group.
GROUPER_NAME VARCHAR(255) N Name assigned to Multum Dose Range check grouper
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


MLTM_DRC_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM DRC GROUP RELTN
Definition: Multum Dose Range Checking Grouper Relationships
Table Type: REFERENCE





Column Detail - MLTM_DRC_GROUP_RELTN


Column Name Type Null? Definition
GROUPER_ID DOUBLE N Externally assigned identifier for dose range check group
GROUPER_NAME VARCHAR(250) Y Name assigned to Multum Dose Range check grouper
MAIN_MULTUM_DRUG_CODE DOUBLE N Multum's designator for groups of similar drug products.
SYNONYM_ID DOUBLE N Multum's identifier for a unique drug name.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VERSION VARCHAR(25) Y VersionColumn



Relationship Detail - MLTM_DRC_GROUP_RELTN


Child Column in MLTM_DRC_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID
MAIN_MULTUM_DRUG_CODE MLTM_NDC_MAIN_DRUG_CODE MAIN_MULTUM_DRUG_CODE


MLTM_DRC_PREMISE



Column Section Top of Page


Table-level Detail

Description: Multum Dose Range Checking Standard Premise Content
Definition: This table is used to store the standard Dose Range Checking contest as provided by Multum
Table Type: REFERENCE





Column Detail - MLTM_DRC_PREMISE


Column Name Type Null? Definition
AGE_HIGH_NBR DOUBLE N The high age value for a given premise
AGE_LOW_NBR DOUBLE N The low age value for a given premise
AGE_OPERATOR_TXT VARCHAR(25) N Textual string representing the operand to be used for age ranges.
AGE_UNIT_CKI VARCHAR(50) N The corresponding CKI value for a given age unit.
AGE_UNIT_DISP VARCHAR(40) N The display value for a given age unit
COMMENT_TXT VARCHAR(255) Y text to display to the user if an order was placed with a dose outside of this particular dose.
CONDITION1_DESC VARCHAR(50) Y The Multum description for the condition. First of possibly 2 conditions.
CONDITION1_ID DOUBLE N The internal Multum identifier for the given condition. First of possible 2.
CONDITION2_DESC VARCHAR(50) Y The Multum description for the condition. Second of possibly 2 conditions.
CONDITION2_ID DOUBLE N The internal Multum identifier for the given condition. Second of possible 2.
CONDITION_CONCEPT_CKI VARCHAR(255) N Stores a reference to a concept_cki which will be loaded to the DRC_PREMISE table.
CORRECTED_GEST_AGE_CKI VARCHAR(50) N The corresponding CKI value for a given gestational age unit
CORRECTED_GEST_AGE_HIGH_NBR DOUBLE N The high gestational age value for a given premise
CORRECTED_GEST_AGE_LOW_NBR DOUBLE N The low gestational age value for a given premise
CORRECTED_GEST_AGE_OPER_TXT VARCHAR(25) N Textual string representing the operand to be used for gestational age ranges.
CORRECTED_GEST_AGE_UNIT_DISP VARCHAR(40) N The display value for a given gestational age unit
CORRECTED_GEST_AGE_UNIT_ID DOUBLE N The internal Multum identifier for a given gestational age unit
DOSE_RANGE_CHECK_ID DOUBLE N The dose_range_check_id from the dose_range_check table, if one exists for the given grouper_id.
DOSE_RANGE_TYPE VARCHAR(100) N Textual string representing the dose range type flag for dose ranges
DOSE_RANGE_TYPE_ID DOUBLE N The internal Multum identifier for a given dose range type
DOSE_UNIT_CD DOUBLE N Code value corresponding to dose_unit_cki on code set 54
DOSE_UNIT_CKI VARCHAR(50) N The corresponding CKI value for a given dose unit
DOSE_UNIT_DISP VARCHAR(40) N The display value for a given dose unit
DOSE_UNIT_ID DOUBLE N The internal Multum identifier for a given dose unit
DRC_CKI VARCHAR(100) N Multum created unique identifier for table.
DRC_DOSE_RANGE_ID DOUBLE N The lowest level - dose units
DRC_IDENTIFIER VARCHAR(45) N unique identifier for a given dose range from Multum. combination of !. both fields are from external database.
DRC_PREMISE_ID DOUBLE N The drc_premise_id from the drc_premise table for a given Multum case id, if one exists.
GENDER_FLAG DOUBLE N 0 - no value 1 - Male 2 - Female
GROUPER_ID DOUBLE N the drc grouping number for the list of similar mmdc and cnum numbers
GROUPER_NAME VARCHAR(100) N a textual description of the rule to allow easier viewing and building of drc functionality.
HIGH_DOSE_VALUE DOUBLE N The high dose value for a given dose range
LIVER_DESC VARCHAR(50) N The Multum description for the liver condition
LOW_DOSE_VALUE DOUBLE N The low dose value for a given dose range
MAX_DOSE_AMT DOUBLE N Foor dose range checking. The maximum safe dose for a given medication.
MAX_DOSE_UNIT_CKI VARCHAR(99) N The CKI for the unit of measure for maximum dose.
MAX_DOSE_UNIT_DISP VARCHAR(40) Y The display value for the unit of measure for maximum dose.
MULTUM_CASE_ID DOUBLE N the actual identifier for a premise from Multum.
PARENT_PREMISE_ID DOUBLE N The parent_premise_id from the DRC_PREMISE table
PEDS_IND DOUBLE N Flag to determine if row is specific to Pediatric content.
RENAL_CONDITION_TXT VARCHAR(40) N Multum textual description for a given renal condition
RENAL_HIGH_VALUE DOUBLE N The high renal value for a given premise
RENAL_LOW_VALUE DOUBLE N The low renal value for a given premise
RENAL_OPERATOR_TXT VARCHAR(25) N Textual string representing the operand to be used for renal ranges.
RENAL_UNIT_CKI VARCHAR(50) N The corresponding CKI value for a given renal unit
RENAL_UNIT_DISP VARCHAR(40) N The display value for a given renal unit
RENAL_UNIT_ID DOUBLE N The internal Multum identifier for a given renal unit
ROUTE_DISP VARCHAR(40) N The display value for a given route
ROUTE_ID DOUBLE N The internal Multum identifier for a given route.
SMOKER_FLAG DOUBLE N 0 - no value 1 - yes 2 - no
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WEIGHT_HIGH_VALUE DOUBLE N The high weight value for a given premise
WEIGHT_LOW_VALUE DOUBLE N The low weight value for a given premise
WEIGHT_OPERATOR_TXT VARCHAR(25) N Textual string representing the operand to be used for weight ranges.
WEIGHT_UNIT_CKI VARCHAR(50) N The corresponding CKI value for a given weight unit
WEIGHT_UNIT_DISP VARCHAR(40) N The display value for a given weight unit
WEIGHT_UNIT_ID DOUBLE N The internal Multum identifier for a given weight unit


MLTM_DRC_ROUTE



Column Section Top of Page


Table-level Detail

Description: MLTM_DRC_ROUTE
Definition: This table contains a listing of routes of administration (orally, topically, rectally, etc.) and a unique identifier for each route. These routes are presented as phrases and abbreviations that are clinically appropriate for describing a route of administration.
Table Type: REFERENCE





Column Detail - MLTM_DRC_ROUTE


Column Name Type Null? Definition
ROUTE_ABBR VARCHAR(30) Y This field contains abbreviations for the various routes of administration.
ROUTE_CODE DOUBLE N This field contains a unique code for each route of administration.
ROUTE_DESCRIPTION VARCHAR(255) Y This field contains textual descriptions of the various routes of administration.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


MLTM_DRUG_CATEGORIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table assigns a textual description to each therapeutic/chemical drug cat.
Definition: This table assigns a textual description to each therapeutic/chemical drug category identification number.
Table Type: REFERENCE





Column Detail - MLTM_DRUG_CATEGORIES


Column Name Type Null? Definition
CATEGORY_ATC_CODE VARCHAR(20) N The code which denotes the appropriate alternative therapeutic class.
CATEGORY_NAME VARCHAR(255) Y This field contains a textual description of the therapeutic/chemical category referenced by Multum_category_id.
MULTUM_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical category to a specific drug.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MLTM_DRUG_CATEGORIES




Parent Column in MLTM_DRUG_CATEGORIES (PK) Child Table Name Child Column Name
Children: MULTUM_CATEGORY_ID CMS_CRITICAL_CATEGORY MULTUM_CATEGORY_ID
MLTM_ALT_DRUG_CAT_NAME CATEGORY_ID
MLTM_CATEGORY_DRUG_XREF MULTUM_CATEGORY_ID
MLTM_CATEGORY_SUB_XREF MULTUM_CATEGORY_ID
MLTM_CATEGORY_SUB_XREF SUB_CATEGORY_ID
MLTM_DDM_GROUP_MMDC_MAP MULTUM_CATEGORY_ID