Table Detail Report
MLTM_DRUG_ID
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains a listing of all of Multum's unique generic drug identifiers |
Definition: | This table contains a listing of all of Multum's unique generic drug identifiers, as well as specific attributes of each. |
Table Type: | REFERENCE |
Column Detail - MLTM_DRUG_ID
Column Name | Type | Null? | Definition |
---|---|---|---|
DRUG_IDENTIFIER | VARCHAR(6) | N | This field contains Multum's identification codes for generic drugs. These are extremely important codes for developers who are using Multum's database products because they serve as the primary link to all of Multum's advanced clinical services. Multum's drug_id is always of the form "d#####". |
DRUG_SYNONYM_ID | DOUBLE | N | This field contains a unique numeric identifier for a description of a drug. |
EMPIRICALLY | VARCHAR(1) | Y | This field indicates whether drug half-life information is available for the drug. |
HALF_LIFE | DOUBLE | Y | This field contains an estimate of the amount of time necessary for a drug to be eliminated from the body. This estimate may be used to determine the length of time to continue checking for a drug interaction after use of a drug is discontinued. The length of time is reported as a half-life measured in hours. |
IS_SINGLE_INGREDIENT | VARCHAR(1) | Y | This field indicates whether a drug is available as a single product or if it is only available in combination with other drugs. |
MAX_THERAPEUTIC_DUPLICATION | DOUBLE | Y | This field contains a number representing how many orders for a specified drug may be prescribed before therapeutic duplication warnings should be generated. |
PREGNANCY_ABBR | VARCHAR(1) | Y | This is a one-character field that represents the FDA's pregnancy hazard classification scheme. |
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_DRUG_ID
Child Column in MLTM_DRUG_ID(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DRUG_SYNONYM_ID | MLTM_DRUG_NAME | DRUG_SYNONYM_ID |
Parent Column in MLTM_DRUG_ID (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DRUG_IDENTIFIER | MLTM_ADDITIONAL_TEXT | DRUG_IDENTIFIER |
MLTM_ALR_CATEGORY_DRUG_MAP | DRUG_IDENTIFIER | ||
MLTM_CATEGORY_DRUG_XREF | DRUG_IDENTIFIER | ||
MLTM_DRUG_LEAFLET_MAP | DRUG_IDENTIFIER | ||
MLTM_DRUG_MODIFIER_MAP | DRUG_IDENTIFIER | ||
MLTM_DUPLICATION_DRUG_XREF | DRUG_IDENTIFIER | ||
MLTM_FTD_TEXT | DRUG_IDENTIFIER | ||
MLTM_FTD_TEXT_CONDITION | DRUG_IDENTIFIER | ||
MLTM_INT_DRUG_INTERACTIONS | DRUG_IDENTIFIER_1 | ||
MLTM_INT_DRUG_INTERACTIONS | DRUG_IDENTIFIER_2 | ||
MLTM_NDC_MAIN_DRUG_CODE | DRUG_IDENTIFIER | ||
MLTM_REF_DRUG | DRUG_IDENTIFIER | ||
MLTM_XP_CLIN_TEXT_XREF | DRUG_IDENTIFIER | ||
PBS_OCS_MAPPING | DRUG_IDENTIFIER |
MLTM_DRUG_LEAFLET_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum drug leaflet map |
Definition: | This table maps a patient education leaflet to a Multum nomenclature drug_id. |
Table Type: | REFERENCE |
Column Detail - MLTM_DRUG_LEAFLET_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
DRUG_IDENTIFIER | VARCHAR(6) | N | Drug Identifier Multum's identification codes for generic drugs. |
LEAFLET_ID | DOUBLE | N | patient education leaflet row identifier |
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_DRUG_LEAFLET_MAP
Child Column in MLTM_DRUG_LEAFLET_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DRUG_IDENTIFIER | MLTM_DRUG_ID | DRUG_IDENTIFIER |
MLTM_DRUG_MODIFIER
Column Section | Top of Page |
Table-level Detail
Description: | Multum Drug Modifier |
Definition: | This table assigns a textual description to each drug modifier identification number. |
Table Type: | REFERENCE |
Column Detail - MLTM_DRUG_MODIFIER
Column Name | Type | Null? | Definition |
---|---|---|---|
MODIFIER_DESCRIPTION | VARCHAR(60) | N | This field contains a textual description of a drug name modifier. |
MODIFIER_ID | DOUBLE | N | This field contains a unique identifier for each drug name modifier. |
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. |
MLTM_DRUG_MODIFIER_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Drug Modifier Map |
Definition: | This table contains a listing of modifiers for Multum's generic drug names. This table can be used to filter drug lists so that they contain only the desired products. Examples include illicit drugs, herbal products or topical products. |
Table Type: | REFERENCE |
Column Detail - MLTM_DRUG_MODIFIER_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
DRUG_IDENTIFIER | VARCHAR(6) | N | This field contains Multum's identification codes for generic drugs. |
MODIFIER_ID | DOUBLE | N | This field contains a unique identifier for each drug name modifier. |
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_DRUG_MODIFIER_MAP
Child Column in MLTM_DRUG_MODIFIER_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DRUG_IDENTIFIER | MLTM_DRUG_ID | DRUG_IDENTIFIER |
MLTM_DRUG_NAME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM DRUG NAME |
Definition: | This table contains names used to identify a drug or drug product. |
Table Type: | REFERENCE |
Column Detail - MLTM_DRUG_NAME
Column Name | Type | Null? | Definition |
---|---|---|---|
DRUG_NAME | VARCHAR(255) | Y | This field contains Multum's succinct, fixed-length generic drug names. This field also contains brand names, which are the drug names as they appear on labels of drug products. |
DRUG_SYNONYM_ID | DOUBLE | N | This field contains a unique numeric identifier for a description of a drug. |
IS_OBSOLETE | VARCHAR(1) | Y | This field indicates whether a drug is currently available on the market in the United States. |
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_DRUG_NAME
Parent Column in MLTM_DRUG_NAME (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DRUG_SYNONYM_ID | MLTM_DMD_NAME_MAP | DRUG_SYNONYM_ID |
MLTM_DRC_GROUP_RELTN | SYNONYM_ID | ||
MLTM_DRUG_ID | DRUG_SYNONYM_ID | ||
MLTM_DRUG_NAME_GLOBAL_TYPE | DRUG_SYNONYM_ID | ||
MLTM_MANUFACT_DRUG_NAME | DRUG_SYNONYM_ID | ||
MLTM_MMDC_ATTRIBUTE | GENERIC_SYNONYM_ID | ||
MLTM_ORDER_CATALOG | DRUG_SYNONYM_ID | ||
MLTM_RXN_MAP | DRUG_SYNONYM_ID | ||
PBS_OCS_MAPPING | DRUG_SYNONYM_ID |