Table Detail Report

DRC_DOSE_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DRC Dose Range
Definition: This table stores the dose ranges for each type of dose range checks (ie Daily, Single dose, Weekly, Therapy, etc.) These Dose Ranges are related to Premise Groups on the DRC_PREMISE table.
Table Type: REFERENCE





Column Detail - DRC_DOSE_RANGE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CUSTOM_IND DOUBLE Y Custom Indicator for Dose range. 0 indicates Multum built and 1 indicates Client built.
DOSE_DAYS DOUBLE Y The number of days to use in the checking of N Days Dose.
DRC_DOSE_RANGE_ID DOUBLE N The unique identifier
DRC_PREMISE_ID DOUBLE N The premise group this range is being built for
LONG_TEXT_ID DOUBLE N A pointer to text to display to the user if an order was placed with a dose outside of this particular dose.
MAX_DOSE DOUBLE Y For dose range checking, the maximum safe dose for a given medication.
MAX_DOSE_UNIT_CD DOUBLE N The unit of measure for maximum dose.
MAX_VALUE DOUBLE Y The maximum value for the range
MAX_VARIANCE_PCT DOUBLE N Stores a percentage to apply to the MAX VALUE when performing dose range checking
MIN_VALUE DOUBLE Y The minimum value for the range
MIN_VARIANCE_PCT DOUBLE N Stores a percentage to apply to the MIN VALUE when performing dose range checking.
TYPE_FLAG DOUBLE Y The type of dose range
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.
VALUE_UNIT_CD DOUBLE N The units of measure for the range



Relationship Detail - DRC_DOSE_RANGE


Child Column in DRC_DOSE_RANGE(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in DRC_DOSE_RANGE (PK) Child Table Name Child Column Name
Children: DRC_DOSE_RANGE_ID DRC_DOSE_RANGE_VER DRC_DOSE_RANGE_ID


DRC_DOSE_RANGE_VER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DRC Dose range Version
Definition: History of the DRC_DOSE_RANGE table.
Table Type: REFERENCE





Column Detail - DRC_DOSE_RANGE_VER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DOSE_DAYS DOUBLE Y The number of days to use in the checking of N Days Dose
DRC_DOSE_RANGE_ID DOUBLE N Unique Identifier with ver_seq
DRC_PREMISE_ID DOUBLE N The premise group this range is being built for
LONG_TEXT_ID DOUBLE N A pointer to text to display to the user if an order was placed with a dose outside of this particular dose.
MAX_DOSE DOUBLE Y For dose range checking, the maximum safe dose for a given medication.
MAX_DOSE_UNIT_CD DOUBLE N The unit of measure for maximum dose.
MAX_VALUE DOUBLE Y The maximum value for the range
MAX_VARIANCE_PCT DOUBLE N Stores a percentage to apply to the MAX_VALUE when performing dose range checking.
MIN_VALUE DOUBLE Y The minimum value for the range
MIN_VARIANCE_PCT DOUBLE N Stores a percentage to apply to the MIN_VALUE when performing dose range checking.
TYPE_FLAG DOUBLE Y The type of dose range
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.
VALUE_UNIT_CD DOUBLE N The units of measure for the range
VER_SEQ DOUBLE N version of the drc_dose_range row.



Relationship Detail - DRC_DOSE_RANGE_VER


Child Column in DRC_DOSE_RANGE_VER(FK) Parent Table Name Parent Column Name
Parents: DRC_DOSE_RANGE_ID DRC_DOSE_RANGE DRC_DOSE_RANGE_ID
DRC_PREMISE_ID DRC_PREMISE DRC_PREMISE_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


DRC_FACILITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dose Range Check Facility Relation
Definition: Allow for flexing dose range content by facility. User configurable Reference Table.
Table Type: REFERENCE





Column Detail - DRC_FACILITY_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DOSE_RANGE_CHECK_ID DOUBLE N FK FROM DOSE_RANGE_CHECK. Part of alternate key.
DRC_FACILITY_R_ID DOUBLE N PRIMARY KEY
DRC_GROUP_ID DOUBLE N This value comes from MLTM_DRC_GROUP_RELTN. Part of alternate key.
FACILITY_CD DOUBLE N Facility Code from code set 220. Part of Alternate Key.
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 - DRC_FACILITY_R


Child Column in DRC_FACILITY_R(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD CODE_VALUE CODE_VALUE
DOSE_RANGE_CHECK_ID DOSE_RANGE_CHECK DOSE_RANGE_CHECK_ID


DRC_FACILITY_R_VER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dose Range Check to Facility Relation table - Versioning Table
Definition: Allow for versioning of DRC_FACILITY_R
Table Type: REFERENCE





Column Detail - DRC_FACILITY_R_VER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DOSE_RANGE_CHECK_ID DOUBLE N FK from DOSE_RANGE_CHECK table.
DRC_FACILITY_R_ID DOUBLE N Primary key
DRC_GROUP_ID DOUBLE N This value comes from MLTM_DRC_GROUP_RELTN.GROUPER_ID
FACILITY_CD DOUBLE N FACILITY CODE. Part of Alternate Key.
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.
VER_SEQ DOUBLE N VERSION SEQUENCE Column



Relationship Detail - DRC_FACILITY_R_VER


Child Column in DRC_FACILITY_R_VER(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD CODE_VALUE CODE_VALUE
DOSE_RANGE_CHECK_ID DOSE_RANGE_CHECK DOSE_RANGE_CHECK_ID


DRC_FORM_RELTN



Column Section Top of Page


Table-level Detail

Description: It stores current relationships between a DRC grouping to a DOSE_RANGE_CHECK_ID.
Definition: Table stores current relationships between a Formulation to a DOSE_RANGE_CHECK_ID. The table is initially populated with Multum content but a client has the ability to modify the Multum content and build their own.
Table Type: REFERENCE





Column Detail - DRC_FORM_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BUILD_FLAG DOUBLE Y A flag showing the how the relationship between MMDC's and Premise groups was built:
DOSE_RANGE_CHECK_ID DOUBLE N The id of the premise group/ dose ranges to be used in to DRC the order.
DRC_FORM_RELTN_ID DOUBLE N Unique identifier
DRC_GROUP_ID DOUBLE N The DRC grouping number that this set of dose range rules relates to.
FORMULATION_CODE DOUBLE Y In the Multum world the MMDC id of the drug to be checked.
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.