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 |