Table Detail Report

MLTM_DUPLICATION_SUB_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Duplication Sub Cross-Reference
Definition: Therapeutic duplication categories. It allows assignment of one or more (sub) categories to a more general category.
Table Type: REFERENCE





Column Detail - MLTM_DUPLICATION_SUB_XREF


Column Name Type Null? Definition
MULTUM_CATEGORY_ID DOUBLE N 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_DUPLICATION_SUB_XREF


Child Column in MLTM_DUPLICATION_SUB_XREF(FK) Parent Table Name Parent Column Name
Parents: MULTUM_CATEGORY_ID MLTM_DUPLICATION_CATEGORIES MULTUM_CATEGORY_ID
SUB_CATEGORY_ID MLTM_DUPLICATION_CATEGORIES MULTUM_CATEGORY_ID


MLTM_FLAVOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM FLAVOR
Definition: Multum Flavors for drug products
Table Type: REFERENCE





Column Detail - MLTM_FLAVOR


Column Name Type Null? Definition
FLAVOR_DESCRIPTION VARCHAR(255) N Flavor Description for MULTUM drug product
FLAVOR_ID DOUBLE N Primary Key. This value comes from an outside source. No Sequence is used.
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_FLAVOR




Parent Column in MLTM_FLAVOR (PK) Child Table Name Child Column Name
Children: FLAVOR_ID MLTM_NDC_IMAGE FLAVOR_ID


MLTM_FREQUENCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum frequency
Definition: This table contains a listing of Multum's frequency of administration terms, along with an abbreviation and a unique identifier for each term.
Table Type: REFERENCE





Column Detail - MLTM_FREQUENCY


Column Name Type Null? Definition
FREQUENCY_ABBR VARCHAR(10) Y This field contains an abbreviation for the frequency of administration. For example, the frequency abbreviation for the frequency description every 4 hours is Q4H. This field is most appropriate for applications where such terms are commonly used by healthcare professionals.
FREQUENCY_CODE DOUBLE N This field contains a numeric identifier assigned to a frequency of administration. A unique identifier for rows in this table.
FREQUENCY_DESCRIPTION VARCHAR(255) Y This field contains a full text description of the frequency of administration for a drug and includes specific terms such as every 4 hours or 4 times daily. This field is most appropriate for applications that use full text descriptions for clarity or for presentation to non-professional personnel.
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_FREQUENCY




Parent Column in MLTM_FREQUENCY (PK) Child Table Name Child Column Name
Children: FREQUENCY_CODE MLTM_SCRIPT_COMMON FREQUENCY_CODE


MLTM_FREQUENCY_MULTIPLIER



Column Section Top of Page


Table-level Detail

Description: Multum Frequency Multiplier
Definition: This table assigns a multiplier defining the number of doses per day to a frequency.
Table Type: REFERENCE





Column Detail - MLTM_FREQUENCY_MULTIPLIER


Column Name Type Null? Definition
FREQUENCY_ID DOUBLE N The PK column for this table.
MULTIPLIER DOUBLE Y multiplier defining the number of doses per day to a frequency.
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_FTD_HEADING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum FTD Heading
Definition: This table provides an identifier and a text description for the dosing text.
Table Type: REFERENCE





Column Detail - MLTM_FTD_HEADING


Column Name Type Null? Definition
HEADING_DESCRIPTION VARCHAR(255) Y a text description for the dosing text.
HEADING_ID DOUBLE N The PK identifier for rows in this 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_FTD_HEADING




Parent Column in MLTM_FTD_HEADING (PK) Child Table Name Child Column Name
Children: HEADING_ID MLTM_FTD_TEXT HEADING_ID
MLTM_FTD_TEXT_CONDITION HEADING_ID