Table Detail Report
MLTM_RXN_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM RXN MAP |
Definition: | Table used to store mappings between Multum identifiers and RxNorm identifiers |
Table Type: | REFERENCE |
Column Detail - MLTM_RXN_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
DRUG_SYNONYM_ID | DOUBLE | N | The Multum drug synonym id |
MAIN_MULTUM_DRUG_CODE | DOUBLE | N | The Multum main drug code |
RXCUI | VARCHAR(60) | N | Identifier from RxNorm terminology. |
RXN_DESCRIPTION | VARCHAR(3000) | Y | The descriptor for the RxNorm translation |
TERM_TYPE_MEANING | VARCHAR(20) | N | Defines the type of term |
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_RXN_MAP
Child Column in MLTM_RXN_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DRUG_SYNONYM_ID | MLTM_DRUG_NAME | DRUG_SYNONYM_ID |
MLTM_SCRIPT_CATEGORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Script Category |
Definition: | This table assigns a category to a prescription. |
Table Type: | REFERENCE |
Column Detail - MLTM_SCRIPT_CATEGORY
Column Name | Type | Null? | Definition |
---|---|---|---|
CATEGORY_CODE | DOUBLE | N | Assigns a category code to a prescription |
SCRIPT_CATEGORY | VARCHAR(255) | Y | assigns a category to a prescription. |
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_SCRIPT_CATEGORY
Parent Column in MLTM_SCRIPT_CATEGORY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CATEGORY_CODE | MLTM_SCRIPT_COMMON | CATEGORY_CODE |
MLTM_SCRIPT_COMMON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Script Common |
Definition: | This table contains a listing of information about Common Scripts for specific drugs and drug products. |
Table Type: | REFERENCE |
Column Detail - MLTM_SCRIPT_COMMON
Column Name | Type | Null? | Definition |
---|---|---|---|
CATEGORY_CODE | DOUBLE | Y | This field contains a unique identifier for each common script category. |
DOSE_AMOUNT | DOUBLE | Y | Dose Amount in specified units |
DOSE_TO_AMOUNT | DOUBLE | Y | Dose to Amount in specified quantity |
DOSE_TO_UNIT | DOUBLE | N | This field contains a unique code for each unit of measurement used in Multum's databases. |
DOSE_UNIT | DOUBLE | N | This field contains a unique code for each unit of measurement used in Multum's databases. |
DURATION_AMOUNT | DOUBLE | Y | Duration Amount - in specified units |
DURATION_UNIT | DOUBLE | Y | This field contains a unique code for each unit of measurement used in Multum's databases. |
FREQUENCY_CODE | DOUBLE | N | This field contains a numeric identifier assigned to a frequency of administration. |
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 |
QUANTITY_AMOUNT | DOUBLE | Y | Quantity Amount - in specified units |
QUANTITY_TO_AMOUNT | DOUBLE | Y | Quantity to Amount in specified units |
QUANTITY_TO_UNIT | DOUBLE | Y | This field contains a unique code for each unit of measurement used in Multum's databases. |
QUANTITY_UNIT | DOUBLE | Y | This field contains a unique code for each unit of measurement used in Multum's databases. |
RATE_AMOUNT | DOUBLE | Y | Rate Amount - in specified units |
RATE_AMOUNT_UNIT | DOUBLE | Y | This field contains a unique code for each unit of measurement used in Multum's databases. |
RATE_TIME | DOUBLE | Y | Rate Time -in specified units |
RATE_TIME_UNIT | DOUBLE | Y | This field contains a unique code for each unit of measurement used in Multum's databases. |
ROUTE_CODE | DOUBLE | N | This field contains a unique code for each route of administration. |
SCRIPT_ID | DOUBLE | N | Prescription Category Identifier. This field contains a unique identifier for each prescription. |
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_SCRIPT_COMMON
Child Column in MLTM_SCRIPT_COMMON(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ROUTE_CODE | MLTM_CLINICAL_ROUTE | ROUTE_CODE |
FREQUENCY_CODE | MLTM_FREQUENCY | FREQUENCY_CODE | |
CATEGORY_CODE | MLTM_SCRIPT_CATEGORY | CATEGORY_CODE |
MLTM_SEVERITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Severity |
Definition: | This table defines severity level for clinical text, such as a drug interaction. |
Table Type: | REFERENCE |
Column Detail - MLTM_SEVERITY
Column Name | Type | Null? | Definition |
---|---|---|---|
SEVERITY_DESCRIPTION | VARCHAR(50) | Y | This field contains a textual description of the potential severity of a drug interaction, pregnancy alert, or lactation alert, as well as an indication that general warning or contraindication text is not applicable to a particular drug. |
SEVERITY_ID | DOUBLE | N | The PK column for this 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_SEVERITY
Parent Column in MLTM_SEVERITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SEVERITY_ID | MLTM_INT_HEADER_SEVERITY_MAP | SEVERITY_ID |
MLTM_XP_CLIN_TEXT_XREF | SEVERITY_ID |
MLTM_SHAPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM SHAPE |
Definition: | Multum Shapes for Drug Products |
Table Type: | REFERENCE |
Column Detail - MLTM_SHAPE
Column Name | Type | Null? | Definition |
---|---|---|---|
SHAPE_DESCRIPTION | VARCHAR(255) | N | Shape Description for Multum Drugs |
SHAPE_ID | DOUBLE | N | Primar Key. This value comes from an outside source. No Sequence is required or used. |
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_SHAPE
Parent Column in MLTM_SHAPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SHAPE_ID | MLTM_NDC_IMAGE | SHAPE_ID |