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 |