Table Detail Report

MLLD_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 - MLLD_MANUFACT_DRUG_NAME


Column Name Type Null? Definition
DRUG_SYNONYM_ID DOUBLE N FK to MLTM_DRUG_NAME.DRUG_SYNONYM_ID
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 - MLLD_MANUFACT_DRUG_NAME


Child Column in MLLD_MANUFACT_DRUG_NAME(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLLD_DRUG_NAME DRUG_SYNONYM_ID


MLLD_MEDICAL_SPECIALTY



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_MED_GUIDE_LINK



Column Section Top of Page


Table-level Detail

Description: Multum Med-Guide Link - LOAD Table
Definition: Table which is loaded with reference data and is used to drive insertions and updates to the MLTM_MED_GUIDE_LINK table
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_MMDC_ATTRIBUTE



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_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.


MLLD_MMDC_NAME_MAP



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_MMDC_NAME_MAP


Column Name Type Null? Definition
DRUG_SYNONYM_ID DOUBLE N This field contains a unique numeric identifier for a description of a drug.
FUNCTION_ID DOUBLE N This field contains a numeric identifier that describes the classification of an entry. For example, a function_id of 16 represents a generic name for a drug; a function_id of 5 represents pregnancy text.
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.