Table Detail Report

DRC_FORM_RELTN_VER



Column Section Top of Page


Table-level Detail

Description: DRC FORM RELTN VER
Definition: Provides History of the DRC_FORM_RELTN table.
Table Type: REFERENCE





Column Detail - DRC_FORM_RELTN_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.
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 with ver_seq
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.
VER_SEQ DOUBLE N History of the DRC_FORM_RELTN table


DRC_GROUP_RELTN



Column Section Top of Page


Table-level Detail

Description: Stores the relationship between a DRC Group number and a list of similar MMDC
Definition: Stores the relationship between a DRC Group and a list of similar MMDC and CNUM numbers. This table is built by Multum and is not currently modified by the client.
Table Type: REFERENCE





Column Detail - DRC_GROUP_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.
DRC_GROUP_ID DOUBLE N The DRC grouping number for the list of similar MMDC and CNUM numbers
DRC_GROUP_RELTN_ID DOUBLE N Unique Identifier
DRUG_SYNONYM_ID DOUBLE N The CNUM ID of the drug to be checked
FORMULATION_ID DOUBLE N 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.


DRC_GROUP_RELTN_VER



Column Section Top of Page


Table-level Detail

Description: Stores the historical relationships between DRC Groups and MMDC/CNUM numbers
Definition: Stores past versions relationships between DRC Group number and the list of similar MMDC(products) and CNUM numbers.
Table Type: REFERENCE





Column Detail - DRC_GROUP_RELTN_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.
DRC_GROUP_ID DOUBLE N The DRC grouping number for the list of similar MMDC and CNUM numbers
DRC_GROUP_RELTN_ID DOUBLE N Unique Identifier
DRUG_SYNONYM_ID DOUBLE N The CNUM ID of the drug to be checked
FORMULATION_ID DOUBLE N 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.
VER_SEQ DOUBLE N Sequence number to keep versions in synch


DRC_PREMISE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dose Range Checking Premise
Definition: Table stores the premises to be used to see if a patient qualifies to be checked for dose ranges. These premises could range from age, route, patient condition, etc? The table is initially populated with Multum content but a user has the ability to modify the content.
Table Type: REFERENCE





Column Detail - DRC_PREMISE


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.
CONCEPT_CKI VARCHAR(255) Y Parent CKI to CMT_CONCEPT table. CKI stands for Cerner Knowledge Index.
DOSE_RANGE_CHECK_ID DOUBLE N The high level grouping id of all the premise groups/dose ranges that should be applied to this order.
DRC_IDENTIFIER VARCHAR(50) Y Unique identifier for dose range from Multum. Combination of !. Both fields are from external database.
DRC_PREMISE_ID DOUBLE N Unique Identifier
MULTUM_CASE_ID DOUBLE N The actual identifier for a premise from Multum.
PARENT_IND DOUBLE Y Notes whether this premise is a parent or not.
PARENT_PREMISE_ID DOUBLE N If the premise is part of a premise group this will be the id of the premise group level.
PREMISE_TYPE_FLAG DOUBLE Y Identifies what type of premise this is
RELATIONAL_OPERATOR_FLAG DOUBLE Y Controls the comparison against the premise value .
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VALUE1 DOUBLE Y Holds any numeric or code value premise values.
VALUE1_STRING VARCHAR(255) Y Holds any textual premise values
VALUE2 DOUBLE Y Holds any numeric or code value premise values.
VALUE2_STRING VARCHAR(255) Y Holds any textual premise values
VALUE_TYPE_FLAG DOUBLE Y Controls the type of data that is stored for the premise
VALUE_UNIT_CD DOUBLE N Contains the codified units of measure for the premise



Relationship Detail - DRC_PREMISE




Parent Column in DRC_PREMISE (PK) Child Table Name Child Column Name
Children: DRC_PREMISE_ID DRC_DOSE_RANGE_VER DRC_PREMISE_ID


DRC_PREMISE_LIST



Column Section Top of Page


Table-level Detail

Description: It is used to store a list of values for a premise.
Definition: Table is used to store a list of values for a premise if more than one value is valid in a premise. This could include route groups where multiple routes are applicable. The table is initially populated with Multum content but a user has the ability to m
Table Type: REFERENCE





Column Detail - DRC_PREMISE_LIST


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.
DRC_PREMISE_ID DOUBLE N The premise this list is getting built for.
DRC_PREMISE_LIST_ID DOUBLE N Unique Identifier.
PARENT_ENTITY_ID DOUBLE N Represents the value of the date you are building the list for. (i.e. NOMENCLATURE ID)
PARENT_ENTITY_NAME VARCHAR(50) Y Represents the data you are building the list for. (i.e. NOMENCLATURE)
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.