Table Detail Report

MLLD_DDM_GROUP_CONDITION_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_DDM_GROUP_MMDC_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_DDM_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.
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.


MLLD_DMD_NAME_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MULTUM LOAD DMD NAME MAP
Definition: Load table - used for distribution of Multum to DMD drug name mappings
Table Type: REFERENCE





Column Detail - MLLD_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 - MLLD_DMD_NAME_MAP


Child Column in MLLD_DMD_NAME_MAP(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLLD_DRUG_NAME DRUG_SYNONYM_ID
FUNCTION_ID MLLD_FUNCTION_TYPE FUNCTION_ID


MLLD_DOSE_FORM



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.