Table Detail Report

MLTM_LEAFLET_MMDC_MAP



Column Section Top of Page


Table-level Detail

Description: Multum Leaflet MMDC map
Definition: This table maps a patient education leaflet to a Multum nomenclature main_multum_drug_code.
Table Type: REFERENCE





Column Detail - MLTM_LEAFLET_MMDC_MAP


Column Name Type Null? Definition
LEAFLETID DOUBLE N Value from the Multum Leaflet Table
MAIN_MULTUM_DRUG_CODE DOUBLE N Value from the NDC main Multum drup code 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.


MLTM_MANUFACT_DRUG_NAME



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_MANUFACT_DRUG_NAME
Definition: Table used to store the manufacture ordered drug name for combination drugs.
Table Type: REFERENCE





Column Detail - MLTM_MANUFACT_DRUG_NAME


Column Name Type Null? Definition
DRUG_SYNONYM_ID DOUBLE N Table used to store the manufacture ordered drug name for combination drugs.
IS_OBSOLETE VARCHAR(1) N Determines whether the drug name has been made obsolete
MANUFACTURER_ORDERED_DRUG_NAME VARCHAR(255) N Stores the manufacture ordered drug name for combination drugs
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_MANUFACT_DRUG_NAME


Child Column in MLTM_MANUFACT_DRUG_NAME(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID


MLTM_MEDICAL_SPECIALTY



Column Section Top of Page


Table-level Detail

Description: MLTM Medical Specialty
Definition: Multum DDM Medical Specialty
Table Type: REFERENCE





Column Detail - MLTM_MEDICAL_SPECIALTY


Column Name Type Null? Definition
MEDICAL_SPECIALTY_DESCRIPTION VARCHAR(50) Y Medical Specialty Description text
MEDICAL_SPECIALTY_ID DOUBLE N PK column for 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.


MLTM_MED_GUIDE_LINK



Column Section Top of Page


Table-level Detail

Description: Multum Med-Guide Link
Definition: Table which links the various levels of the multum drug hierarchy to an NDC, and ultimately to the med-guide at the fda website
Table Type: REFERENCE





Column Detail - MLTM_MED_GUIDE_LINK


Column Name Type Null? Definition
BRAND_DESCRIPTION VARCHAR(255) N The Brand Level Description of the NDC specified
BRAND_DESCRIPTION_IDENT VARCHAR(25) N The Drug Synonym ID for the Brand Level entry for the NDC specified
BRAND_FUNCTION_ID DOUBLE N The Multum assigned function id for the ndc specified
DRUG_IDENTIFIER VARCHAR(6) N Multum's identifier for generic drugs
GENERIC_DESCRIPTION VARCHAR(255) N The description of the generic form of the NDC specified.
GENERIC_DESCRIPTION_IDENT VARCHAR(25) N The Drug Synonym ID for the Generic form of the NDC specified.
MAIN_MULTUM_DRUG_CODE DOUBLE N High-Level identifier used by Multum to denote similar drugs
MEDGUIDE_LINK VARCHAR(255) N URL which points to the medical guide for the given NDC.
NDC_CODE VARCHAR(25) N The FDA assigned National Drug Code for a drug
PRIMARY_DESCRIPTION VARCHAR(255) N The Primary level description of the NDC specified
PRIMARY_DESCRIPTION_IDENT VARCHAR(25) N The Drug Synonym ID for the Primary Level entry for the NDC specified
TRADE_DESCRIPTION VARCHAR(255) Y The description of the trade form of the NDC specified
TRADE_DESCRIPTION_IDENT VARCHAR(25) Y The Drug Synonym ID for the Trade form of the NDC specified
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_MMDC_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum MMDC Attribute
Definition: This table contains attributes about a Multum Formulation (MMDC - main multum drug code) which are derived from other Multum tables.
Table Type: REFERENCE





Column Detail - MLTM_MMDC_ATTRIBUTE


Column Name Type Null? Definition
AVAILABLE_IND DOUBLE Y Indicates the drug is currently being marketed
GENERIC_FORM_IND DOUBLE Y Indicates if drug has a generic form.
GENERIC_SYNONYM_ID DOUBLE N Contains synonym ID for generic name
MAIN_MULTUM_DRUG_CODE DOUBLE N Unique ID - from the Main Multum Drug Code Table
OTC_STATUS DOUBLE Y Status of drug availability Over The Counter
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_MMDC_ATTRIBUTE


Child Column in MLTM_MMDC_ATTRIBUTE(FK) Parent Table Name Parent Column Name
Parents: GENERIC_SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID
MAIN_MULTUM_DRUG_CODE MLTM_NDC_MAIN_DRUG_CODE MAIN_MULTUM_DRUG_CODE