Table Detail Report

MLTM_CATEGORY_DRUG_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM CATEGORY DRUG XREF
Definition: This table assigns a drug to one or more therapeutic/chemical categories.
Table Type: REFERENCE





Column Detail - MLTM_CATEGORY_DRUG_XREF


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.
FUNCTION_ID DOUBLE N This field contains a numeric identifier that describes the classification of an entry. For example, a function_id of 16 represents a generic name for a drug; a function_id of 5 represents pregnancy text.
MULTUM_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical category to a specific drug.
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_CATEGORY_DRUG_XREF


Child Column in MLTM_CATEGORY_DRUG_XREF(FK) Parent Table Name Parent Column Name
Parents: MULTUM_CATEGORY_ID MLTM_DRUG_CATEGORIES MULTUM_CATEGORY_ID
DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER


MLTM_CATEGORY_SUB_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table permits "nesting" of therapeutic/chemical categories.
Definition: This table permits "nesting" of therapeutic/chemical categories. It allows assignment of one or more (sub)categories to a more general category.
Table Type: REFERENCE





Column Detail - MLTM_CATEGORY_SUB_XREF


Column Name Type Null? Definition
MULTUM_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical category to a specific drug.
SUB_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical sub-category to a specific drug.
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_CATEGORY_SUB_XREF


Child Column in MLTM_CATEGORY_SUB_XREF(FK) Parent Table Name Parent Column Name
Parents: MULTUM_CATEGORY_ID MLTM_DRUG_CATEGORIES MULTUM_CATEGORY_ID
SUB_CATEGORY_ID MLTM_DRUG_CATEGORIES MULTUM_CATEGORY_ID


MLTM_CERN_RXB_DICT_MAP



Column Section Top of Page


Table-level Detail

Description: RxBuilder Dictionary Map
Definition: Mapping of Dictionary ID's to Code CKI's
Table Type: REFERENCE





Column Detail - MLTM_CERN_RXB_DICT_MAP


Column Name Type Null? Definition
CODE_CKI VARCHAR(255) N Code CKI - Cerner CKI
CODE_SET DOUBLE N The values for CODE_SET will come from the CSV file that will load the table. These correspond to the code_set values on the code_value table.
DESCRIPTION VARCHAR(255) N Short description
DICTIONARY_ID DOUBLE N Multum Dictionary ID from mltm_rxb_dictionary 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.


MLTM_CLINICAL_ROUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Clinical Route
Definition: This table contains a listing of routes of administration (orally, topically, rectally, etc.) and a unique identifier for each route. These routes are presented as phrases and abbreviations that are clinically appropriate for describing a route of administration.
Table Type: REFERENCE





Column Detail - MLTM_CLINICAL_ROUTE


Column Name Type Null? Definition
ROUTE_CODE DOUBLE N Clinical route code. This field contains a unique code for each route of administration.
ROUTE_DESCRIPTION VARCHAR(255) Y This field contains textual descriptions of the various routes of administration or product routes.
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_CLINICAL_ROUTE




Parent Column in MLTM_CLINICAL_ROUTE (PK) Child Table Name Child Column Name
Children: ROUTE_CODE MLTM_SCRIPT_COMMON ROUTE_CODE


MLTM_COLOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM COLOR
Definition: Multum Colors for Drug Products
Table Type: REFERENCE





Column Detail - MLTM_COLOR


Column Name Type Null? Definition
COLOR_DESCRIPTION VARCHAR(255) N MULTUM Color Description
COLOR_ID DOUBLE N Primary Key. This value comes from an outside source. No Sequence is required.
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_COLOR




Parent Column in MLTM_COLOR (PK) Child Table Name Child Column Name
Children: COLOR_ID MLTM_NDC_IMAGE COLOR_ID