Table Detail Report

MLTM_INT_HEADER_SEVERITY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM INT Header Severity Map
Definition: Multum INT_HEADER_SEVERITY_MAP table
Table Type: REFERENCE





Column Detail - MLTM_INT_HEADER_SEVERITY_MAP


Column Name Type Null? Definition
HEADER_ID DOUBLE N Header ID - 1st column in 2-column PK. FK from table MLTM_INT_HEADER
SEQUENCE_NUMBER DOUBLE N Sequence Number
SEVERITY_ID DOUBLE N Severity ID - 2nd column of 2-column PK. FK from MLTM_SEVERITY
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_INT_HEADER_SEVERITY_MAP


Child Column in MLTM_INT_HEADER_SEVERITY_MAP(FK) Parent Table Name Parent Column Name
Parents: HEADER_ID MLTM_INT_HEADER HEADER_ID
SEVERITY_ID MLTM_SEVERITY SEVERITY_ID




Parent Column in MLTM_INT_HEADER_SEVERITY_MAP (PK) Child Table Name Child Column Name
Children: HEADER_ID MLTM_INT_INTERACT_SEVERITY_MAP HEADER_ID
SEVERITY_ID MLTM_INT_INTERACT_SEVERITY_MAP SEVERITY_ID


MLTM_INT_INTERACT_SEVERITY_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM Interaction Severity Map
Definition: Multum INT_INTERACTION_HEADER_SEVERITY_MAP table
Table Type: REFERENCE





Column Detail - MLTM_INT_INTERACT_SEVERITY_MAP


Column Name Type Null? Definition
HEADER_ID DOUBLE N Header ID - 2nd column of 3-column PK. FK from MLTM_INT_HEADER_SEVERITY_MAP
INT_ID DOUBLE N Interaction ID - 1st column of 3-column PK. FK from MLTM_INTERACTION_DESCRIPTION
SEVERITY_ID DOUBLE N Severity ID - 3rd column of 3-column PK. 2nd column in FK from MLTM_INT_HEADER_SEVERITY_MAP
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_INT_INTERACT_SEVERITY_MAP


Child Column in MLTM_INT_INTERACT_SEVERITY_MAP(FK) Parent Table Name Parent Column Name
Parents: INT_ID MLTM_INTERACTION_DESCRIPTION INT_ID
HEADER_ID MLTM_INT_HEADER_SEVERITY_MAP HEADER_ID
SEVERITY_ID MLTM_INT_HEADER_SEVERITY_MAP SEVERITY_ID


MLTM_LABEL



Column Section Top of Page


Table-level Detail

Description: Contains the text for warnings that might be placed on a prescription bottle.
Definition: This table contains the text for warnings that might be placed on a prescription bottle as information for the patient.
Table Type: REFERENCE





Column Detail - MLTM_LABEL


Column Name Type Null? Definition
LABEL VARCHAR(50) Y This field contains an abbreviated text description for patient advice associated with a drug.
LABEL_FULL VARCHAR(150) Y This field contains a text description for patient advice associated with a drug.
LABEL_FULL_SPANISH VARCHAR(200) Y This field contains a Spanish text description for patient advice associated with a drug.
LABEL_ID DOUBLE N This field contains an identifier for warning text that may be used to provide patient advice about a drug.
LABEL_SPANISH VARCHAR(70) Y This field contains an abbreviated Spanish text description for patient advice associated with a 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.


MLTM_LABEL_DRUG_XREF



Column Section Top of Page


Table-level Detail

Description: MLTM LABEL DRUG XREF
Definition: This table assigns a warning label to a main_multum_drug_code.
Table Type: REFERENCE





Column Detail - MLTM_LABEL_DRUG_XREF


Column Name Type Null? Definition
LABEL_ID DOUBLE N This field contains an identifier for warning text that may be used to provide patient advice about a drug.
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. An MMDC is assigned to each unique combination of the following fields: active ingredient(s), strength, route of administration, and dosage form.
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_LEAFLET



Column Section Top of Page


Table-level Detail

Description: Multum Leaflet
Definition: This table assigns a unique identifier, title, and file name to a patient education leaflet.
Table Type: REFERENCE





Column Detail - MLTM_LEAFLET


Column Name Type Null? Definition
DATE_REVISED DATETIME Y Last Revision date for the leaflet
FILENAME VARCHAR(255) Y Filename for the leafelet
FUNCTION_ID DOUBLE N Value from the Multum Function Type table (FK)
LEAFLETID DOUBLE N Leaflet ID. Part of the key for this table.
LEAFLET_VERSION DOUBLE Y The version number of this leafelet
TITLE VARCHAR(110) Y The leafelet Title
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.