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 |