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 |