Table Detail Report
MLTM_SYST_IDENTIFIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum SYST Identifier |
Definition: | This table defines a body system (i.e., hematologic, hepatic, respiratory, etc.). |
Table Type: | REFERENCE |
Column Detail - MLTM_SYST_IDENTIFIER
Column Name | Type | Null? | Definition |
---|---|---|---|
SYST_ID | DOUBLE | N | This field contains a numeric identifier for a side effect system. |
SYST_NAME | VARCHAR(30) | Y | This field contains a textual description of a body system represented by syst_id. For example, syst_id 1 has a syst_name of hematologic. |
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_SYST_IDENTIFIER
Parent Column in MLTM_SYST_IDENTIFIER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SYST_ID | MLTM_XP_CLIN_TEXT_XREF | SYST_ID |
MLTM_UNITS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Units of measurement related to drugs with an abbreviation and unique ID units. |
Definition: | Contains a listing of units of measurement related to drugs (milligram, milliliter, milliequivalent, gram, etc.), along with an abbreviation and a unique identifier for each unit. |
Table Type: | REFERENCE |
Column Detail - MLTM_UNITS
Column Name | Type | Null? | Definition |
---|---|---|---|
UNIT_ABBR | VARCHAR(30) | Y | This field contains an abbreviation for each unit of measurement in Multum's databases. (For example: ml, mg, gm) |
UNIT_CD | DOUBLE | N | Multum Unit Code - Unit of Measure |
UNIT_DESCRIPTION | VARCHAR(255) | Y | This field contains a textual description of each unit of measurement used in Multum's databases. For example: (milliliter, milligram, gram) |
UNIT_ID | DOUBLE | N | This field contains a unique code for each unit of measurement used in Multum's databases. |
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_UNITS
Parent Column in MLTM_UNITS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | UNIT_ID | MLTM_BCB_DRC_UNITS | UNIT_ID |
MLTM_XP_CLIN_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum XP Clinical Text |
Definition: | This table provides a textual description of each clinical text section and includes a unique code for each description. |
Table Type: | REFERENCE |
Column Detail - MLTM_XP_CLIN_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
CLINICAL_TEXT | VARCHAR(2000) | Y | ** OBSOLETE** textual description of each clinical text section. No longer used due to size limitation. Has been replaced by the LONG_TEXT_ID FK column. |
CLIN_TEXT | LONGTEXT | Y | Textual description of each clinical text section. This column replaces and negates use of long_text_id column. |
LONG_TEXT_ID | DOUBLE | N | ** OBSOLETE ** ID from the LONG_TEXT_REFERENCE table for the Clinical Text related to this row. Replaces the clinical_text column. ** THIS COLUMN IS REPLACED BY THE NEW CLIN_TEXT COLUMN (which will have a LONG data type). |
TEXT_ID | DOUBLE | N | PK column. A unique code for each description. |
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_XP_CLIN_TEXT
Child Column in MLTM_XP_CLIN_TEXT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
Parent Column in MLTM_XP_CLIN_TEXT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TEXT_ID | MLTM_XP_CLIN_TEXT_XREF | TEXT_ID |
MLTM_XP_CLIN_TEXT_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum XP Clin Text Xref |
Definition: | This table contains essential information about drug lactation hazards, pharmacology, pregnancy hazards, side effects, and warnings and contraindications, including codes for each of the drugs, identifiers for a particular type of clinical information, text level, body system identification, display order, and a code representing specific text describing the clinical information. |
Table Type: | REFERENCE |
Column Detail - MLTM_XP_CLIN_TEXT_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
DISPLAY_ORDER | DOUBLE | Y | The display order |
DRUG_IDENTIFIER | VARCHAR(6) | N | This field contains Multum's identification codes for generic drugs. |
FUNCTION_ID | DOUBLE | N | The function ID from MLTM FUNCTION TYPE table |
LEVEL_ID | DOUBLE | N | Part of the unique identifier for this table. |
SEVERITY_ID | DOUBLE | N | FK from the Multum severity table |
SYST_ID | DOUBLE | N | FK from the MLTM SYST IDENTIFIER TABLE |
TEXT_ID | DOUBLE | N | PK from the Multum XP Clin Text 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_XP_CLIN_TEXT_XREF
Child Column in MLTM_XP_CLIN_TEXT_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DRUG_IDENTIFIER | MLTM_DRUG_ID | DRUG_IDENTIFIER |
FUNCTION_ID | MLTM_FUNCTION_TYPE | FUNCTION_ID | |
SEVERITY_ID | MLTM_SEVERITY | SEVERITY_ID | |
SYST_ID | MLTM_SYST_IDENTIFIER | SYST_ID | |
TEXT_ID | MLTM_XP_CLIN_TEXT | TEXT_ID |