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 |