Table Detail Report

MLTM_RXN_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM RXN MAP
Definition: Table used to store mappings between Multum identifiers and RxNorm identifiers
Table Type: REFERENCE





Column Detail - MLTM_RXN_MAP


Column Name Type Null? Definition
DRUG_SYNONYM_ID DOUBLE N The Multum drug synonym id
MAIN_MULTUM_DRUG_CODE DOUBLE N The Multum main drug code
RXCUI VARCHAR(60) N Identifier from RxNorm terminology.
RXN_DESCRIPTION VARCHAR(3000) Y The descriptor for the RxNorm translation
TERM_TYPE_MEANING VARCHAR(20) N Defines the type of term
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - MLTM_RXN_MAP


Child Column in MLTM_RXN_MAP(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID


MLTM_SCRIPT_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Script Category
Definition: This table assigns a category to a prescription.
Table Type: REFERENCE





Column Detail - MLTM_SCRIPT_CATEGORY


Column Name Type Null? Definition
CATEGORY_CODE DOUBLE N Assigns a category code to a prescription
SCRIPT_CATEGORY VARCHAR(255) Y assigns a category to a prescription.
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_SCRIPT_CATEGORY




Parent Column in MLTM_SCRIPT_CATEGORY (PK) Child Table Name Child Column Name
Children: CATEGORY_CODE MLTM_SCRIPT_COMMON CATEGORY_CODE


MLTM_SCRIPT_COMMON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Script Common
Definition: This table contains a listing of information about Common Scripts for specific drugs and drug products.
Table Type: REFERENCE





Column Detail - MLTM_SCRIPT_COMMON


Column Name Type Null? Definition
CATEGORY_CODE DOUBLE Y This field contains a unique identifier for each common script category.
DOSE_AMOUNT DOUBLE Y Dose Amount in specified units
DOSE_TO_AMOUNT DOUBLE Y Dose to Amount in specified quantity
DOSE_TO_UNIT DOUBLE N This field contains a unique code for each unit of measurement used in Multum's databases.
DOSE_UNIT DOUBLE N This field contains a unique code for each unit of measurement used in Multum's databases.
DURATION_AMOUNT DOUBLE Y Duration Amount - in specified units
DURATION_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
FREQUENCY_CODE DOUBLE N This field contains a numeric identifier assigned to a frequency of administration.
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. This is an extremely important code for developers who are using Multum's database products because it serves as the primary link to all of Multum's tables containing drug product information. An MMDC is assigned to each unique combination of the following fields: active ingredient(s), strength, route of administration, and dosage form. As a result, the MMDC is a very useful field for identifying dru
QUANTITY_AMOUNT DOUBLE Y Quantity Amount - in specified units
QUANTITY_TO_AMOUNT DOUBLE Y Quantity to Amount in specified units
QUANTITY_TO_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
QUANTITY_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
RATE_AMOUNT DOUBLE Y Rate Amount - in specified units
RATE_AMOUNT_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
RATE_TIME DOUBLE Y Rate Time -in specified units
RATE_TIME_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
ROUTE_CODE DOUBLE N This field contains a unique code for each route of administration.
SCRIPT_ID DOUBLE N Prescription Category Identifier. This field contains a unique identifier for each prescription.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - MLTM_SCRIPT_COMMON


Child Column in MLTM_SCRIPT_COMMON(FK) Parent Table Name Parent Column Name
Parents: ROUTE_CODE MLTM_CLINICAL_ROUTE ROUTE_CODE
FREQUENCY_CODE MLTM_FREQUENCY FREQUENCY_CODE
CATEGORY_CODE MLTM_SCRIPT_CATEGORY CATEGORY_CODE


MLTM_SEVERITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Severity
Definition: This table defines severity level for clinical text, such as a drug interaction.
Table Type: REFERENCE





Column Detail - MLTM_SEVERITY


Column Name Type Null? Definition
SEVERITY_DESCRIPTION VARCHAR(50) Y This field contains a textual description of the potential severity of a drug interaction, pregnancy alert, or lactation alert, as well as an indication that general warning or contraindication text is not applicable to a particular drug.
SEVERITY_ID DOUBLE N The PK column for this table.
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_SEVERITY




Parent Column in MLTM_SEVERITY (PK) Child Table Name Child Column Name
Children: SEVERITY_ID MLTM_INT_HEADER_SEVERITY_MAP SEVERITY_ID
MLTM_XP_CLIN_TEXT_XREF SEVERITY_ID


MLTM_SHAPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM SHAPE
Definition: Multum Shapes for Drug Products
Table Type: REFERENCE





Column Detail - MLTM_SHAPE


Column Name Type Null? Definition
SHAPE_DESCRIPTION VARCHAR(255) N Shape Description for Multum Drugs
SHAPE_ID DOUBLE N Primar Key. This value comes from an outside source. No Sequence is required or used.
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_SHAPE




Parent Column in MLTM_SHAPE (PK) Child Table Name Child Column Name
Children: SHAPE_ID MLTM_NDC_IMAGE SHAPE_ID