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