Table Detail Report

MLTM_BCB_ALG_MAP2



Column Section Top of Page


Table-level Detail

Description: MLTM_BCB_ALG_MAP V2
Definition: Table used to store relationships between France's BCB identifier and Multum Drug Identifier's for use with allergy checking. Version 2 of table.
Table Type: REFERENCE





Column Detail - MLTM_BCB_ALG_MAP2


Column Name Type Null? Definition
BCB_CODE VARCHAR(100) N Code as provided by BCB
BCB_DESCRIPTION VARCHAR(255) N Description as provided by BCB
DRUG_IDENTIFIER VARCHAR(6) N Multum drug identifier associated to BCB Code
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_BCB_DRC_UNITS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum BCB Dose Range Checking Units
Definition: Storing valid Dose Units for BCB to perform Dose Range Checking
Table Type: REFERENCE





Column Detail - MLTM_BCB_DRC_UNITS


Column Name Type Null? Definition
BCB_UNIT VARCHAR(50) N Identifies the corresponding BCB unit utilized by BCB Dose Range Checking
GLOBAL_TXT VARCHAR(50) N Global drug identifier
GLOBAL_TYPE_ID DOUBLE N Identifies the type of Global Identifier stored in a Global_Txt
UNIT_ID DOUBLE N Identifies the valid unit utilized by BCB Dose Range Checking
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_BCB_DRC_UNITS


Child Column in MLTM_BCB_DRC_UNITS(FK) Parent Table Name Parent Column Name
Parents: GLOBAL_TYPE_ID MLTM_GLOBAL_TYPE GLOBAL_TYPE_ID
UNIT_ID MLTM_UNITS UNIT_ID


MLTM_BCB_DRUG_CATEGORIES



Column Section Top of Page


Table-level Detail

Description: MLTM BCB Drug Categories
Definition: Table for holding BCB drug categories
Table Type: REFERENCE





Column Detail - MLTM_BCB_DRUG_CATEGORIES


Column Name Type Null? Definition
ATC_CODE VARCHAR(25) N This field contains the ATC code as defined by BCB
ATC_DESCRIPTION VARCHAR(100) N This field contains the ATC description as defined by BCB
MULTUM_CATEGORY_ID DOUBLE N Associated Multum category id as defined on MLTM_DRUG_CATEGORIES
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_BCB_FORMULARY_MAP



Column Section Top of Page


Table-level Detail

Description: MLTM_BCB_FORMULARY_MAP
Definition: Table used to store relationships between France's UCD code and Multum's Main Multum Drug_Code
Table Type: REFERENCE





Column Detail - MLTM_BCB_FORMULARY_MAP


Column Name Type Null? Definition
BCB_DESCRIPTION VARCHAR(255) N Description as provided by BCB
BCB_MANUFACTURER VARCHAR(100) N BCB MANUFACTURER NAME
BCB_MANUFACTURER_ID DOUBLE N Manufacturer identifier as defined by BCB. Value is Externally created/managed
BRAND_CODE DOUBLE N Brand Code defined by Multum
CIP_TXT VARCHAR(50) N CIP code as identified by BCB
MAIN_MULTUM_DRUG_CODE DOUBLE N MMDC as created by Multum
UCD_CODE DOUBLE N Code as provided by BCB
UCD_TXT VARCHAR(50) N UCD text
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.
VCIP_TXT VARCHAR(50) N Virtual CIP code as identified by BCB


MLTM_BCB_ORC_MAP



Column Section Top of Page


Table-level Detail

Description: MLTM_BCB_ORC_MAP
Definition: Table used to store relationships between France's UCD code and Multum Drug Identifier's for use with Millennium's order catalog
Table Type: REFERENCE





Column Detail - MLTM_BCB_ORC_MAP


Column Name Type Null? Definition
BCB_DESCRIPTION VARCHAR(255) N Description as provided by BCB
CATALOG_CKI VARCHAR(25) N CKI value as stored on the order_catalog table
CIP_TXT VARCHAR(50) N The CIP code as identified by BCB
SYNONYM_CKI VARCHAR(25) N CKI value as stored on the order_catalog_synonym table
UCD_CODE DOUBLE N Code as provided by BCB
UCD_TXT VARCHAR(50) N UCD Text
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.
VCIP_TXT VARCHAR(50) N Virtual CIP code as identified by BCB