Table Detail Report

MLLD_BCB_ALG_MAP



Column Section Top of Page


Table-level Detail

Description: MLLD_BCB_ALG_MAP
Definition: Load 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 - MLLD_BCB_ALG_MAP


Column Name Type Null? Definition
BCB_CODE DOUBLE 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.


MLLD_BCB_ALG_MAP2



Column Section Top of Page


Table-level Detail

Description: MLLD_BCB_ALG_MAP V2
Definition: Load Table used to store relationships between France's UCD code and Multum Drug Identifier's for use with Millennium's order catalog. Version 2 of table.
Table Type: REFERENCE





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


MLLD_BCB_DRC_UNITS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - MLLD_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 - MLLD_BCB_DRC_UNITS


Child Column in MLLD_BCB_DRC_UNITS(FK) Parent Table Name Parent Column Name
Parents: GLOBAL_TYPE_ID MLLD_GLOBAL_TYPE GLOBAL_TYPE_ID
UNIT_ID MLLD_UNITS UNIT_ID


MLLD_BCB_DRUG_CATEGORIES



Column Section Top of Page


Table-level Detail

Description: MLLD BCB DRUG CATEGORIES
Definition: Load table for holding BCB drug categories
Table Type: REFERENCE





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


MLLD_BCB_DRUG_CAT_XREF



Column Section Top of Page


Table-level Detail

Description: MLLD BCB DRUG CAT XREF
Definition: Load table for holding BCB drug categories
Table Type: REFERENCE





Column Detail - MLLD_BCB_DRUG_CAT_XREF


Column Name Type Null? Definition
ATC_CODE VARCHAR(25) N This field contains the ATC code as defined by BCB
DRUG_IDENTIFIER VARCHAR(6) N The Multum drug identifier associated with the given ATC 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.