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. |