Table Detail Report

MLLD_BCB_FORMULARY_MAP



Column Section Top of Page


Table-level Detail

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





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


MLLD_BCB_ORC_MAP



Column Section Top of Page


Table-level Detail

Description: MLLD_BCB_ORC_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_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 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


MLLD_BCB_SUB_CAT_XREF



Column Section Top of Page


Table-level Detail

Description: MLLD_BCB_SUB_CAT_XREF
Definition: Load table for holding BCB drug categories hierarchy
Table Type: REFERENCE





Column Detail - MLLD_BCB_SUB_CAT_XREF


Column Name Type Null? Definition
BCB_CATEGORY VARCHAR(25) N This field contains the ATC code as defined by BCB for the parent category
CATEGORY_DESC VARCHAR(200) Y This field contains the ATC description as defined by BCB for the parent category
CATEGORY_ID DOUBLE N This field is used for the building of the category in a Millennium domain.
SUB_CATEGORY VARCHAR(25) N This field contains the ATC code as defined by BCB for the child category
SUB_CATEGORY_DESC VARCHAR(200) Y This field contains the ATC description as defined by BCB for the child category
SUB_CATEGORY_ID DOUBLE N This field is used for the building of the category in a Millennium domain.
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_CATEGORY_DRUG_XREF



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_CATEGORY_DRUG_XREF


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs. These are extremely important codes for developers who are using Multum's database products because they serve as the primary link to all of Multum's advanced clinical services. Multum's drug_id is always of the form "d#####".
DRUG_SYNONYM_ID DOUBLE N This field contains a unique numeric identifier for a description of a drug.
FUNCTION_ID DOUBLE N This field contains a numeric identifier that describes the classification of an entry. For example, a function_id of 16 represents a generic name for a drug; a function_id of 5 represents pregnancy text.
MULTUM_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical category to a specific drug.
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_CATEGORY_SUB_XREF



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_CATEGORY_SUB_XREF


Column Name Type Null? Definition
MULTUM_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical category to a specific drug.
SUB_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical sub-category to a specific drug.
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.