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. |