Table Detail Report
MLTM_DRC_GROUPS_OBSOLETE
Column Section | Top of Page |
Table-level Detail
Description: | MLTM_DRC_GROUPS_OBSOLETE |
Definition: | Table used to store Multum dose range checking obsolete groupers |
Table Type: | REFERENCE |
Column Detail - MLTM_DRC_GROUPS_OBSOLETE
Column Name | Type | Null? | Definition |
---|---|---|---|
GROUPER_ID | DOUBLE | N | Externally assigned identifier for dose range check group. |
GROUPER_NAME | VARCHAR(255) | N | Name assigned to Multum Dose Range check grouper |
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_DRC_GROUP_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM DRC GROUP RELTN |
Definition: | Multum Dose Range Checking Grouper Relationships |
Table Type: | REFERENCE |
Column Detail - MLTM_DRC_GROUP_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
GROUPER_ID | DOUBLE | N | Externally assigned identifier for dose range check group |
GROUPER_NAME | VARCHAR(250) | Y | Name assigned to Multum Dose Range check grouper |
MAIN_MULTUM_DRUG_CODE | DOUBLE | N | Multum's designator for groups of similar drug products. |
SYNONYM_ID | DOUBLE | N | Multum's identifier for a unique drug name. |
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. |
VERSION | VARCHAR(25) | Y | VersionColumn |
Relationship Detail - MLTM_DRC_GROUP_RELTN
Child Column in MLTM_DRC_GROUP_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | MLTM_DRUG_NAME | DRUG_SYNONYM_ID |
MAIN_MULTUM_DRUG_CODE | MLTM_NDC_MAIN_DRUG_CODE | MAIN_MULTUM_DRUG_CODE |
MLTM_DRC_PREMISE
Column Section | Top of Page |
Table-level Detail
Description: | Multum Dose Range Checking Standard Premise Content |
Definition: | This table is used to store the standard Dose Range Checking contest as provided by Multum |
Table Type: | REFERENCE |
Column Detail - MLTM_DRC_PREMISE
Column Name | Type | Null? | Definition |
---|---|---|---|
AGE_HIGH_NBR | DOUBLE | N | The high age value for a given premise |
AGE_LOW_NBR | DOUBLE | N | The low age value for a given premise |
AGE_OPERATOR_TXT | VARCHAR(25) | N | Textual string representing the operand to be used for age ranges. |
AGE_UNIT_CKI | VARCHAR(50) | N | The corresponding CKI value for a given age unit. |
AGE_UNIT_DISP | VARCHAR(40) | N | The display value for a given age unit |
COMMENT_TXT | VARCHAR(255) | Y | text to display to the user if an order was placed with a dose outside of this particular dose. |
CONDITION1_DESC | VARCHAR(50) | Y | The Multum description for the condition. First of possibly 2 conditions. |
CONDITION1_ID | DOUBLE | N | The internal Multum identifier for the given condition. First of possible 2. |
CONDITION2_DESC | VARCHAR(50) | Y | The Multum description for the condition. Second of possibly 2 conditions. |
CONDITION2_ID | DOUBLE | N | The internal Multum identifier for the given condition. Second of possible 2. |
CONDITION_CONCEPT_CKI | VARCHAR(255) | N | Stores a reference to a concept_cki which will be loaded to the DRC_PREMISE table. |
CORRECTED_GEST_AGE_CKI | VARCHAR(50) | N | The corresponding CKI value for a given gestational age unit |
CORRECTED_GEST_AGE_HIGH_NBR | DOUBLE | N | The high gestational age value for a given premise |
CORRECTED_GEST_AGE_LOW_NBR | DOUBLE | N | The low gestational age value for a given premise |
CORRECTED_GEST_AGE_OPER_TXT | VARCHAR(25) | N | Textual string representing the operand to be used for gestational age ranges. |
CORRECTED_GEST_AGE_UNIT_DISP | VARCHAR(40) | N | The display value for a given gestational age unit |
CORRECTED_GEST_AGE_UNIT_ID | DOUBLE | N | The internal Multum identifier for a given gestational age unit |
DOSE_RANGE_CHECK_ID | DOUBLE | N | The dose_range_check_id from the dose_range_check table, if one exists for the given grouper_id. |
DOSE_RANGE_TYPE | VARCHAR(100) | N | Textual string representing the dose range type flag for dose ranges |
DOSE_RANGE_TYPE_ID | DOUBLE | N | The internal Multum identifier for a given dose range type |
DOSE_UNIT_CD | DOUBLE | N | Code value corresponding to dose_unit_cki on code set 54 |
DOSE_UNIT_CKI | VARCHAR(50) | N | The corresponding CKI value for a given dose unit |
DOSE_UNIT_DISP | VARCHAR(40) | N | The display value for a given dose unit |
DOSE_UNIT_ID | DOUBLE | N | The internal Multum identifier for a given dose unit |
DRC_CKI | VARCHAR(100) | N | Multum created unique identifier for table. |
DRC_DOSE_RANGE_ID | DOUBLE | N | The lowest level - dose units |
DRC_IDENTIFIER | VARCHAR(45) | N | unique identifier for a given dose range from Multum. combination of |
DRC_PREMISE_ID | DOUBLE | N | The drc_premise_id from the drc_premise table for a given Multum case id, if one exists. |
GENDER_FLAG | DOUBLE | N | 0 - no value 1 - Male 2 - Female |
GROUPER_ID | DOUBLE | N | the drc grouping number for the list of similar mmdc and cnum numbers |
GROUPER_NAME | VARCHAR(100) | N | a textual description of the rule to allow easier viewing and building of drc functionality. |
HIGH_DOSE_VALUE | DOUBLE | N | The high dose value for a given dose range |
LIVER_DESC | VARCHAR(50) | N | The Multum description for the liver condition |
LOW_DOSE_VALUE | DOUBLE | N | The low dose value for a given dose range |
MAX_DOSE_AMT | DOUBLE | N | Foor dose range checking. The maximum safe dose for a given medication. |
MAX_DOSE_UNIT_CKI | VARCHAR(99) | N | The CKI for the unit of measure for maximum dose. |
MAX_DOSE_UNIT_DISP | VARCHAR(40) | Y | The display value for the unit of measure for maximum dose. |
MULTUM_CASE_ID | DOUBLE | N | the actual identifier for a premise from Multum. |
PARENT_PREMISE_ID | DOUBLE | N | The parent_premise_id from the DRC_PREMISE table |
PEDS_IND | DOUBLE | N | Flag to determine if row is specific to Pediatric content. |
RENAL_CONDITION_TXT | VARCHAR(40) | N | Multum textual description for a given renal condition |
RENAL_HIGH_VALUE | DOUBLE | N | The high renal value for a given premise |
RENAL_LOW_VALUE | DOUBLE | N | The low renal value for a given premise |
RENAL_OPERATOR_TXT | VARCHAR(25) | N | Textual string representing the operand to be used for renal ranges. |
RENAL_UNIT_CKI | VARCHAR(50) | N | The corresponding CKI value for a given renal unit |
RENAL_UNIT_DISP | VARCHAR(40) | N | The display value for a given renal unit |
RENAL_UNIT_ID | DOUBLE | N | The internal Multum identifier for a given renal unit |
ROUTE_DISP | VARCHAR(40) | N | The display value for a given route |
ROUTE_ID | DOUBLE | N | The internal Multum identifier for a given route. |
SMOKER_FLAG | DOUBLE | N | 0 - no value 1 - yes 2 - no |
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. |
WEIGHT_HIGH_VALUE | DOUBLE | N | The high weight value for a given premise |
WEIGHT_LOW_VALUE | DOUBLE | N | The low weight value for a given premise |
WEIGHT_OPERATOR_TXT | VARCHAR(25) | N | Textual string representing the operand to be used for weight ranges. |
WEIGHT_UNIT_CKI | VARCHAR(50) | N | The corresponding CKI value for a given weight unit |
WEIGHT_UNIT_DISP | VARCHAR(40) | N | The display value for a given weight unit |
WEIGHT_UNIT_ID | DOUBLE | N | The internal Multum identifier for a given weight unit |
MLTM_DRC_ROUTE
Column Section | Top of Page |
Table-level Detail
Description: | MLTM_DRC_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_DRC_ROUTE
Column Name | Type | Null? | Definition |
---|---|---|---|
ROUTE_ABBR | VARCHAR(30) | Y | This field contains abbreviations for the various routes of administration. |
ROUTE_CODE | DOUBLE | N | 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. |
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_DRUG_CATEGORIES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table assigns a textual description to each therapeutic/chemical drug cat. |
Definition: | This table assigns a textual description to each therapeutic/chemical drug category identification number. |
Table Type: | REFERENCE |
Column Detail - MLTM_DRUG_CATEGORIES
Column Name | Type | Null? | Definition |
---|---|---|---|
CATEGORY_ATC_CODE | VARCHAR(20) | N | The code which denotes the appropriate alternative therapeutic class. |
CATEGORY_NAME | VARCHAR(255) | Y | This field contains a textual description of the therapeutic/chemical category referenced by Multum_category_id. |
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_DRUG_CATEGORIES
Parent Column in MLTM_DRUG_CATEGORIES (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MULTUM_CATEGORY_ID | CMS_CRITICAL_CATEGORY | MULTUM_CATEGORY_ID |
MLTM_ALT_DRUG_CAT_NAME | CATEGORY_ID | ||
MLTM_CATEGORY_DRUG_XREF | MULTUM_CATEGORY_ID | ||
MLTM_CATEGORY_SUB_XREF | MULTUM_CATEGORY_ID | ||
MLTM_CATEGORY_SUB_XREF | SUB_CATEGORY_ID | ||
MLTM_DDM_GROUP_MMDC_MAP | MULTUM_CATEGORY_ID |