Table Detail Report

MLTM_ORDER_SENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_ORDER_SENT_DETAIL
Definition: This table will be used as a load table containing the ORDER_SENTENCE_DETAIL data for the cumulative list of Multum order sentences in the load table MLTM_ORDER_SENT.
Table Type: REFERENCE





Column Detail - MLTM_ORDER_SENT_DETAIL


Column Name Type Null? Definition
EXTERNAL_IDENTIFIER VARCHAR(100) N Used as an FK to MLTM_ORDER_SENT on column EXTERNAL_IDENTIFIER
OE_FIELD_MEANING VARCHAR(25) N Used to pull the OE_FIELD_MEANING_ID from the OE_FIELD_MEANING table, matching on the OE_FIELD_MEANING column. This is then loaded to the OE_FIELD_MEANING_ID column on the ORDER_SENTENCE_DETAIL table.
OE_FIELD_VALUE VARCHAR(255) Y In certain cases, this will be directly converted to a numeric value to load the OE_FIELD_VALUE column on the ORDER_SENTENCE_DETAIL table. Otherwise, it will be used as the DISPLAY to pull the code for the OE_FIELD_VALUE from the CODE_VALUE table on CODE_SET > 0.
OE_FIELD_VALUE_CKI VARCHAR(100) Y In certain cases, this will be used as the CKI to pull a code from the CODE_VALUE table on CODE_SET > 0. Loads this value to the OE_FIELD_VALUE column on the ORDER_SENTENCE_DETAIL table.
SEQUENCE DOUBLE N Loads the SEQUENCE column on the ORDER_SENTENCE_DETAIL 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.



Relationship Detail - MLTM_ORDER_SENT_DETAIL


Child Column in MLTM_ORDER_SENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: EXTERNAL_IDENTIFIER MLTM_ORDER_SENT EXTERNAL_IDENTIFIER


MLTM_PBS_NDC_MAP



Column Section Top of Page


Table-level Detail

Description: MLTM PBS NDC MAP
Definition: Table used to store mappings between PBS codes and NDC Codes
Table Type: REFERENCE





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


MLTM_PRODUCT_ROUTE



Column Section Top of Page


Table-level Detail

Description: Contains a listing of routes and an abbrev and unique identifiers for each route
Definition: Contains a listing of routes as well as an abbreviation and a unique identifier for each route. These routes are presented as phrases and abbreviations that are appropriate for description of a particular drug pproduct's principal route of administration.
Table Type: REFERENCE





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


MLTM_PRODUCT_STRENGTH



Column Section Relationship Section Top of Page


Table-level Detail

Description: List of product strengths for display and unique id for each product strength.
Definition: Contains a textual list of product strengths designed for end user display and a unique identifier for each product strength.
Table Type: REFERENCE





Column Detail - MLTM_PRODUCT_STRENGTH


Column Name Type Null? Definition
PRODUCT_STRENGTH_CODE DOUBLE N This field contains a unique code for each product strength description.
PRODUCT_STRENGTH_DESCRIPTION VARCHAR(255) Y This field contains full textual descriptions of drug product strengths.
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_PRODUCT_STRENGTH




Parent Column in MLTM_PRODUCT_STRENGTH (PK) Child Table Name Child Column Name
Children: PRODUCT_STRENGTH_CODE MLTM_NDC_MAIN_DRUG_CODE PRODUCT_STRENGTH_CODE


MLTM_REF_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum Reference Detail
Definition: This table contains the textual description of source information referenced by ref_id.
Table Type: REFERENCE





Column Detail - MLTM_REF_DETAIL


Column Name Type Null? Definition
AUTHORS VARCHAR(255) Y source informatin author
JOURNAL_ABBREV VARCHAR(100) Y Journal AbbreviationColumn
PAGES VARCHAR(64) Y Number of Pages in text format
REF_ID DOUBLE N textual description of source information referenced by ref_id.
TITLE VARCHAR(255) Y The reference title
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.
VOLUMN_ISSUE VARCHAR(20) Y The issue volume indentifer
YEAR_COMPLETE VARCHAR(15) Y Year Complete - text format



Relationship Detail - MLTM_REF_DETAIL




Parent Column in MLTM_REF_DETAIL (PK) Child Table Name Child Column Name
Children: REF_ID MLTM_REF_DRUG REF_ID