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 |