Table Detail Report

MLTM_DDM_GROUP_CONDITION_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM DDM Group Condition Map
Definition: Multum DDM_GROUP_CONDITION_MAP table
Table Type: REFERENCE





Column Detail - MLTM_DDM_GROUP_CONDITION_MAP


Column Name Type Null? Definition
CONDITION_ID DOUBLE N Condition ID 2nd column of 2-column PK. FK from table MLTM_DDM_CONDITION_LIST
GROUP_ID DOUBLE N Group ID 1st column of 2-column PK. FK from table MLTM_DDM_GROUP
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_DDM_GROUP_CONDITION_MAP


Child Column in MLTM_DDM_GROUP_CONDITION_MAP(FK) Parent Table Name Parent Column Name
Parents: GROUP_ID MLTM_DDM_GROUP GROUP_ID


MLTM_DDM_GROUP_MMDC_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM DDM Group MMDC Map
Definition: Multum DDM_GROUP_MMDC_MAP table
Table Type: REFERENCE





Column Detail - MLTM_DDM_GROUP_MMDC_MAP


Column Name Type Null? Definition
GROUP_ID DOUBLE N Group ID - 1st column in 2-column PK. FK From MLTM_DDM_GROUP table.
MAIN_MULTUM_DRUG_CODE DOUBLE N Main Multum Drug Code. 2nd column in 2-column PK. FK from MLTM_NDC_MAIN_DRUG_CODE table
MULTUM_CATEGORY_ID DOUBLE N Multum Category ID - FK from MLTM_DRUG_CATEGORIES 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_DDM_GROUP_MMDC_MAP


Child Column in MLTM_DDM_GROUP_MMDC_MAP(FK) Parent Table Name Parent Column Name
Parents: GROUP_ID MLTM_DDM_GROUP GROUP_ID
MULTUM_CATEGORY_ID MLTM_DRUG_CATEGORIES MULTUM_CATEGORY_ID
MAIN_MULTUM_DRUG_CODE MLTM_NDC_MAIN_DRUG_CODE MAIN_MULTUM_DRUG_CODE


MLTM_DDM_MAP



Column Section Top of Page


Table-level Detail

Description: Multum DDM Map
Definition: This table contains a mapping between an icd-9 condition and the main_multum_drug_code or drug category that treats either the ICD-9-CM coded condition in question or treats frequently occurring comorbidities associated with the ICD-9-CM condition.
Table Type: REFERENCE





Column Detail - MLTM_DDM_MAP


Column Name Type Null? Definition
ICD_9 VARCHAR(6) N This field contains the ICD-9-CM code used to classify the disease. ICD-9-CM stands for International Classification of Diseases, Ninth Edition, Clinical Modification.
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
MULTUM_CATEGORY_ID DOUBLE N The Category ID from MLTM_DRUG_CATEGORIES table (FK)
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.


MLTM_DMD_NAME_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum DMD NAME MAP
Definition: This table is used for distribution of Multum to DMD drug name mappings.
Table Type: REFERENCE





Column Detail - MLTM_DMD_NAME_MAP


Column Name Type Null? Definition
APID DOUBLE N Identifies An Actual Medicinal Product (AMP). An AMP is a single dose unit of a finished dose form (unless the product is presented as a continuous dosage form), attributable to an identified supplier that contains a specified amount of an ingredient substance.
APPID DOUBLE N Identifies an Actual Medicinal Product Pack (AMPP). An AMPP is the packaged product that is supplied for direct patient use or from which AMPs are supplied for direct patient use. It may contain multiple components each of which may or may not be an AMPP in their own right.
DMD_NAME VARCHAR(255) N The drug name as provided by the dm+d.
DRUG_SYNONYM_ID DOUBLE N this field contains a unique numeric identifier for a description of a drug.
FUNCTION_ID DOUBLE N This field contains the Multum function_id, which is used for determining the type a drug name is.
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.
VPID DOUBLE N Identifies A Virtual Medicinal Product (VMP). A VMP is an abstract concept representing the properties of one or more clinically equivalent Actual Medicinal Products, where clinical is defined as relating to the course of a disease.
VPPID DOUBLE N Identifies A Virtual Medicinal Product Pack (VMPP). A VMPP is an abstract concept representing the properties of one or more quantitatively equivalent AMPPs. For every Actual Medicinal Product Pack (AMPP) there will exist a corresponding VMPP. A VMPP will have at least one AMPP and may have many AMPPs linked to it.
VTMID DOUBLE N Identifies a Virtual Therapeutic Moiety (VTM). A VTM is the abstract representation of the substance(s), formulated as a medicinal product, intended by an authorising health care professional for use in the treatment of the patient.



Relationship Detail - MLTM_DMD_NAME_MAP


Child Column in MLTM_DMD_NAME_MAP(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID
FUNCTION_ID MLTM_FUNCTION_TYPE FUNCTION_ID


MLTM_DOSE_FORM



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains a listing of dose forms.
Definition: This table contains a listing of dose forms (cream, tablet, suppository, etc.), along with an abbreviation and a unique identifier for each dose form.
Table Type: REFERENCE





Column Detail - MLTM_DOSE_FORM


Column Name Type Null? Definition
DOSE_FORM_ABBR VARCHAR(30) Y This field contains Multum's abbreviations for dosage forms.
DOSE_FORM_CODE DOUBLE N This field contains a numeric designation for a dose form.
DOSE_FORM_DESCRIPTION VARCHAR(255) Y This field contains the full text description of the product's dose form.
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_DOSE_FORM




Parent Column in MLTM_DOSE_FORM (PK) Child Table Name Child Column Name
Children: DOSE_FORM_CODE MLTM_NDC_MAIN_DRUG_CODE DOSE_FORM_CODE