Table Detail Report

MLLD_NDC_OUTER_INNER_MAP



Column Section Top of Page


Table-level Detail

Description: MLLD_NDC_OUTER_INNER_MAP
Definition: This table provides mappings for outer and inner NDC packaging.
Table Type: REFERENCE





Column Detail - MLLD_NDC_OUTER_INNER_MAP


Column Name Type Null? Definition
INNER_NDC_CODE VARCHAR(25) N NDC Code for the inner packaging
INNER_SIZE DOUBLE N Date the row was generated by Multum
OBSOLETE_DATE DATETIME Y The obsolete date for the relationship
OUTER_NDC_CODE VARCHAR(25) N NDC Code for the outer packaging
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_NDC_SOURCE



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_NDC_SOURCE


Column Name Type Null? Definition
ADDRESS1 VARCHAR(100) Y This field contains line 1 of the street addresses for the manufacturers/redistributors of drug products.
ADDRESS2 VARCHAR(100) Y This field contains line 2 of the street address for the manufacturers/redistributors of drug products.
CITY VARCHAR(50) Y This field contains the names of the cities where manufacturers/redistributors are located.
COUNTRY VARCHAR(50) Y This field contains the names of the countries where manufacturers/repackagers are located.
PROVINCE VARCHAR(30) Y This field identifies the provinces of the countries in which manufacturers/redistributors are located, if applicable.
SOURCE_DESC VARCHAR(120) Y This field contains the names of manufacturers, redistributor, and repackagers of drug products.
SOURCE_ID DOUBLE N This field contains a unique code for each drug source (manufacturer/redistributor).
STATE VARCHAR(30) Y This field contains a unique code for each drug source (manufacturer/redistributor).
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.
ZIP VARCHAR(10) Y This field contains the 10-character zip codes of manufacturers/redistributors.


MLLD_ORDER_CATALOG



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_ORDER_CATALOG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CREATE_DT_TM DATETIME N Indicates date orderable was approved by Multum
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs. These are extremely important codes for developers who are using Multum's database products because they serve as the primary link to all of Multum's advanced clinical services. Multum's drug_id is always of the form "d#####".
DRUG_SYNONYM_ID DOUBLE N This field contains a (unique ?) numeric identifier for a description of a drug. This value comes from an outside source and is not generated in Millennium.
HIDE_IND DOUBLE Y Indicates whether the orderable should be viewable during ordering.
MNEMONIC_TYPE VARCHAR(40) N Defines the default type of synonym for the order catalog
ORDER_ENTRY_FORMAT VARCHAR(50) Y Default order entry format for orderable.
OVERRIDE_MNEMONIC_TYPE VARCHAR(40) Y Indicates mnemonic_type to be used if different for dose range checking
RX_MASK DOUBLE Y Default rx_mask for orderable.
SKIP_IND DOUBLE N indicates whether synonym should be ignored with future updates. 0 - do not skip (default); 1 - skip
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_PBS_NDC_MAP



Column Section Top of Page


Table-level Detail

Description: MLLD PBS NDC MAP
Definition: Table used to help facilitate loading of MLTM_PBS_NDC_MAP (used to store mappings between PBS codes and NDC codes)
Table Type: REFERENCE





Column Detail - MLLD_PBS_NDC_MAP


Column Name Type Null? Definition
BRAND_NAME VARCHAR(45) N Brand Name associated to record
DRUG_IDENTIFIER VARCHAR(6) N Multum Drug Identifier
DRUG_NAME VARCHAR(255) N Drug Name associated to record
MAIN_MULTUM_DRUG_CODE DOUBLE N Multum defined code.
MANUFACTURER_CODE VARCHAR(20) N MANUFACTURER CODE FROM TABLE PBS_MANUFACTURER
MULTUM_MEDICAL_SUPPLY_CODE DOUBLE N Medical Supply code defined by Multum
NDC_CODE VARCHAR(25) N NDC Code as defined by Multum
PACK_SIZE DOUBLE N QUANTITY CONTAINED IN MANUFACTURER'S PACKAGE
PBS_ITEM_CODE VARCHAR(5) N PBS_CODE defined by external source.
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_PRODUCT_ROUTE



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_PRODUCT_ROUTE


Column Name Type Null? Definition
ROUTE_ABBR VARCHAR(30) Y This field contains abbreviations for the various routes of administration.
ROUTE_CD DOUBLE N ROUTE CODE
ROUTE_CODE DOUBLE N This field contains a unique code for each route of administration.
ROUTE_DESCRIPTION VARCHAR(30) Y This field contains textual descriptions of the various routes of administration or product routes.
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.