Table Detail Report

MLTM_NDC_OUTER_INNER_MAP



Column Section Top of Page


Table-level Detail

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





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


MLTM_NDC_SOURCE



Column Section Top of Page


Table-level Detail

Description: Contains a listing of all the drug sources which occur in ndc_core_description.
Definition: This table contains a listing of all the drug sources (manufacturers, redistributors, and repackagers) whose products occur in the ndc_core_description table. It also includes addresses for each source.
Table Type: REFERENCE





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


MLTM_ORDER_CATALOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Order Catalog
Definition: Supports loading Multum's Order Catalog
Table Type: REFERENCE





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



Relationship Detail - MLTM_ORDER_CATALOG


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


MLTM_ORDER_CATALOG_LOAD



Column Section Top of Page


Table-level Detail

Description: Multum Order Catalog Load
Definition: Table used for assisting in loading of Multum order catalog content
Table Type: REFERENCE





Column Detail - MLTM_ORDER_CATALOG_LOAD


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.
CATALOG_CKI VARCHAR(50) N CKI value that corresponds to the drug level identifiers.
CATALOG_CONCEPT_CKI VARCHAR(100) N This column corresponds to the CONCEPT_CKI field on the Order_Catalog table.
DCP_CLIN_CAT_MEAN VARCHAR(12) N the clinical category of this orderable. This value will correspond to code set 16389.
DESCRIPTION VARCHAR(255) N the description of the orderable
HIDE_IND DOUBLE N Indicator whether or not to hide this synonym.
MNEMONIC VARCHAR(255) N The display mnemonic for the synonym.
MNEMONIC_KEY_CAP VARCHAR(255) N the key version of the mnemonic for this orderable.
MNEMONIC_TYPE VARCHAR(40) N Display value defining the type of mnemonic.
MNEMONIC_TYPE_MEAN VARCHAR(12) N Used to identify mnemonic_type for internationalization. Expect to have a mnemonic type for each row - based on code set 6011.
ORDER_ENTRY_FORMAT VARCHAR(50) N The order entry format to be used by order entry applications.
PRIMARY_IND DOUBLE N An indicator to determine if the synonym is primary for the drug.
RX_MASK_NBR DOUBLE N Stores the different sub-lists the synonym belongs in, i.e. should it display with diluents, with additives, with medications, or any combination of the above.
SKIP_IND DOUBLE N Indicator whether to skip this row when processing.
SYNONYM_CKI VARCHAR(50) N CKI value that corresponds to the synonym level identifiers.
SYNONYM_CONCEPT_CKI VARCHAR(100) N Concept relating the specific synonym to SNOMED CT.
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_ORDER_SENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_ORDER_SENT
Definition: This table will be used as a load table containing a cumulative list of Multum order sentences. Scripts will be used to compare the data in this table against order sentences currently in Millennium, and will insert valid new order sentences into Millennium.
Table Type: REFERENCE





Column Detail - MLTM_ORDER_SENT


Column Name Type Null? Definition
CATALOG_CKI VARCHAR(100) Y Matches the CKI column on the ORDER_CATALOG table.
CATALOG_CONCEPT_CKI VARCHAR(100) Y Matches the CONCEPT_CKI column on the ORDER_CATALOG table.
CATALOG_DESCRIPTION VARCHAR(255) Y Matches the DESCRIPTION column on the ORDER_CATALOG table.
EXTERNAL_IDENTIFIER VARCHAR(100) N Used here as a unique identifier. Loads the EXTERNAL_IDENTIFIER column on the ORDER_SENTENCE table.
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. This is an extremely important code for developers who are using Multum's database products because it serves as the primary link to all of Multum's tables containing drug product information. An MMDC is assigned to each unique combination of the following fields: active ingredient(s), strength, route of administration, and dosage form. As a result, the MMDC is a very useful field for identifying dru
MNEMONIC_KEY_CAP VARCHAR(255) N Matches the MNEMONIC_KEY_CAP column on the ORDER_CATALOG_SYNONYM table.
MNEMONIC_TYPE VARCHAR(12) Y Used as the MEANING to pull the MNEMONIC_TYPE_CD from the CODE_VALUE table on CODE_SET 6011.
ORDER_SENTENCE_ID DOUBLE N Matches the ORDER_SENTENCE_ID column on the ORDER_SENTENCE table.
RX_TYPE_MEAN VARCHAR(12) Y Loads the RX_TYPE_MEAN column on the ORDER_SENTENCE table.
SENTENCE_SCRIPT VARCHAR(255) Y Used to give a display of the entire order sentence as defined by the source.
SYNONYM_CKI VARCHAR(100) N Matches the CKI column on the ORDER_CATALOG_SYNONYM table.
SYNONYM_CONCEPT_CKI VARCHAR(100) N Matches the CONCEPT_CKI column on the ORDER_CATALOG_SYNONYM 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.
USAGE_FLAG DOUBLE N Loads the USAGE_FLAG column on the ORDER_SENTENCE table.



Relationship Detail - MLTM_ORDER_SENT




Parent Column in MLTM_ORDER_SENT (PK) Child Table Name Child Column Name
Children: EXTERNAL_IDENTIFIER MLTM_ORDER_SENT_DETAIL EXTERNAL_IDENTIFIER