Table Detail Report

MLTM_ADDITIONAL_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Additional Text
Definition: This table provides additional information about dosing parameters for patients who may need dosage adjustments based on kidney function, liver function, or other patient attributes.
Table Type: REFERENCE





Column Detail - MLTM_ADDITIONAL_TEXT


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs.
TEXT_ID DOUBLE N Number assigned for additional text
TEXT_TYPE_ID DOUBLE N FK from table FTD_TEXT_TYPE
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_ADDITIONAL_TEXT


Child Column in MLTM_ADDITIONAL_TEXT(FK) Parent Table Name Parent Column Name
Parents: DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER


MLTM_ALR_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Allergy Category
Definition: This table assigns a code to each allergy category. It also provides textual descriptions of the category in singular and plural forms.
Table Type: REFERENCE





Column Detail - MLTM_ALR_CATEGORY


Column Name Type Null? Definition
ALR_CATEGORY_ID DOUBLE N The ALR category Identifier
CATEGORY_DESCRIPTION VARCHAR(60) Y Textual Description of the alr category
CATEGORY_DESCRIPTION_PLURAL VARCHAR(60) Y Textual descriptions of the category
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_ALR_CATEGORY




Parent Column in MLTM_ALR_CATEGORY (PK) Child Table Name Child Column Name
Children: ALR_CATEGORY_ID MLTM_ALR_CATEGORY_CLASS_MAP ALR_CATEGORY_ID
MLTM_ALR_CATEGORY_DRUG_MAP ALR_CATEGORY_ID
MLTM_ALR_TEXT_MAP ALR_CATEGORY_ID


MLTM_ALR_CATEGORY_CLASS_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum allergy category class map
Definition: This table is used to assign allergy categories to an allergy drug class. For example, the category cephalosporins is assigned to the class penicillins and related drugs in this table. (For purposes of working with Multum's allergy tables, allergy classes can be defined as a group of allergy categories that share allergic cross-reactivity potential.)
Table Type: REFERENCE





Column Detail - MLTM_ALR_CATEGORY_CLASS_MAP


Column Name Type Null? Definition
ALR_CATEGORY_ID DOUBLE N FK from MLTM ALR CATEGORY table
CLASS_ID DOUBLE N The allergy drug class Identifier. Classes can be defined as a group of allergy categories that share allergic cross-reactivity potential.)
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_ALR_CATEGORY_CLASS_MAP


Child Column in MLTM_ALR_CATEGORY_CLASS_MAP(FK) Parent Table Name Parent Column Name
Parents: ALR_CATEGORY_ID MLTM_ALR_CATEGORY ALR_CATEGORY_ID
CLASS_ID MLTM_ALR_CLASS CLASS_ID


MLTM_ALR_CATEGORY_DRUG_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum allergy category drug map
Definition: This table is used to assign drugs to an allergy category. For example, the drug cephalexin is assigned to the category cephalosporins in this table.
Table Type: REFERENCE





Column Detail - MLTM_ALR_CATEGORY_DRUG_MAP


Column Name Type Null? Definition
ALR_CATEGORY_ID DOUBLE N FK from the MLTM_ALR_CATEGORY table
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#####". Together, the drug_id and the ndc_main_Multum_drug_code (MMDC), described elsewhere in this guide, provide a mechanism for relating high-level clinical drug information (like drug dosing algorithms,
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_ALR_CATEGORY_DRUG_MAP


Child Column in MLTM_ALR_CATEGORY_DRUG_MAP(FK) Parent Table Name Parent Column Name
Parents: ALR_CATEGORY_ID MLTM_ALR_CATEGORY ALR_CATEGORY_ID
DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER


MLTM_ALR_CLASS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum allergy class
Definition: This table assigns an identification number to an allergy class. For example, the allergy class penicillins and related drugs has an identification number of 1.
Table Type: REFERENCE





Column Detail - MLTM_ALR_CLASS


Column Name Type Null? Definition
CLASS_DESCRIPTION VARCHAR(60) Y The drug class description. Relates the class description to a class number.
CLASS_ID DOUBLE N The alr class 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_ALR_CLASS




Parent Column in MLTM_ALR_CLASS (PK) Child Table Name Child Column Name
Children: CLASS_ID MLTM_ALR_CATEGORY_CLASS_MAP CLASS_ID