Table Detail Report
MLTM_CATEGORY_DRUG_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM CATEGORY DRUG XREF |
Definition: | This table assigns a drug to one or more therapeutic/chemical categories. |
Table Type: | REFERENCE |
Column Detail - MLTM_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. |
Relationship Detail - MLTM_CATEGORY_DRUG_XREF
Child Column in MLTM_CATEGORY_DRUG_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MULTUM_CATEGORY_ID | MLTM_DRUG_CATEGORIES | MULTUM_CATEGORY_ID |
DRUG_IDENTIFIER | MLTM_DRUG_ID | DRUG_IDENTIFIER |
MLTM_CATEGORY_SUB_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table permits "nesting" of therapeutic/chemical categories. |
Definition: | This table permits "nesting" of therapeutic/chemical categories. It allows assignment of one or more (sub)categories to a more general category. |
Table Type: | REFERENCE |
Column Detail - MLTM_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. |
Relationship Detail - MLTM_CATEGORY_SUB_XREF
Child Column in MLTM_CATEGORY_SUB_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MULTUM_CATEGORY_ID | MLTM_DRUG_CATEGORIES | MULTUM_CATEGORY_ID |
SUB_CATEGORY_ID | MLTM_DRUG_CATEGORIES | MULTUM_CATEGORY_ID |
MLTM_CERN_RXB_DICT_MAP
Column Section | Top of Page |
Table-level Detail
Description: | RxBuilder Dictionary Map |
Definition: | Mapping of Dictionary ID's to Code CKI's |
Table Type: | REFERENCE |
Column Detail - MLTM_CERN_RXB_DICT_MAP
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_CKI | VARCHAR(255) | N | Code CKI - Cerner CKI |
CODE_SET | DOUBLE | N | The values for CODE_SET will come from the CSV file that will load the table. These correspond to the code_set values on the code_value table. |
DESCRIPTION | VARCHAR(255) | N | Short description |
DICTIONARY_ID | DOUBLE | N | Multum Dictionary ID from mltm_rxb_dictionary table |
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_CLINICAL_ROUTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Clinical Route |
Definition: | This table contains a listing of routes of administration (orally, topically, rectally, etc.) and a unique identifier for each route. These routes are presented as phrases and abbreviations that are clinically appropriate for describing a route of administration. |
Table Type: | REFERENCE |
Column Detail - MLTM_CLINICAL_ROUTE
Column Name | Type | Null? | Definition |
---|---|---|---|
ROUTE_CODE | DOUBLE | N | Clinical route code. This field contains a unique code for each route of administration. |
ROUTE_DESCRIPTION | VARCHAR(255) | Y | This field contains textual descriptions of the various routes of administration or product routes. |
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_CLINICAL_ROUTE
Parent Column in MLTM_CLINICAL_ROUTE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ROUTE_CODE | MLTM_SCRIPT_COMMON | ROUTE_CODE |
MLTM_COLOR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM COLOR |
Definition: | Multum Colors for Drug Products |
Table Type: | REFERENCE |
Column Detail - MLTM_COLOR
Column Name | Type | Null? | Definition |
---|---|---|---|
COLOR_DESCRIPTION | VARCHAR(255) | N | MULTUM Color Description |
COLOR_ID | DOUBLE | N | Primary Key. This value comes from an outside source. No Sequence is required. |
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_COLOR
Parent Column in MLTM_COLOR (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | COLOR_ID | MLTM_NDC_IMAGE | COLOR_ID |