Table Detail Report

DRC_PREMISE_LIST_VER



Column Section Top of Page


Table-level Detail

Description: DRC PREMISE LIST VER
Definition: History of the DRC_PREMISE_LIST table.
Table Type: REFERENCE





Column Detail - DRC_PREMISE_LIST_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_PREMISE_ID DOUBLE N The premise this list is getting built for.
DRC_PREMISE_LIST_ID DOUBLE N Unique Identifier with ver_seq
PARENT_ENTITY_ID DOUBLE N Represents the value of the date you are building the list
PARENT_ENTITY_NAME VARCHAR(50) Y Represents the data you are building the list for.
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 of the drc_premise_list row.


DRC_PREMISE_VER



Column Section Top of Page


Table-level Detail

Description: DRC PREMISE VER
Definition: Provides History to the DRC_PREMISE table.
Table Type: REFERENCE





Column Detail - DRC_PREMISE_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.
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_PREMISE_ID DOUBLE N Unique Identifier with ver_seq
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. 0
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.
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.
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
VER_SEQ DOUBLE N Version of the Rule


DRC_UNIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dose Range Checking Unit
Definition: Reference data that defines the simple units of measure for dose range checking.
Table Type: REFERENCE





Column Detail - DRC_UNIT


Column Name Type Null? Definition
ADDITION_ADDEND_AMT DOUBLE N This is the addend used to convert units within the same base class.
BASE_NBR DOUBLE N This identifies the base class for the unit.
BRANCH_NBR DOUBLE N This identifies the branch unit within a base class. The base unit will have a branch number of 1.
DRC_UNIT_CKI VARCHAR(255) N This is the CKI defined for the unit as assigned in code set 54 with the cs_54_utility tool.
DRC_UNIT_DESC VARCHAR(100) Y Description of the drc unit.
DRC_UNIT_ID DOUBLE N Unique identifier for unit.
MULTIPLY_FACTOR_AMT DOUBLE N This is the factor used to convert units within the same base class.
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_UNIT




Parent Column in DRC_UNIT (PK) Child Table Name Child Column Name
Children: DRC_UNIT_ID DRC_UNIT_EXPRSN_RELTN DRC_UNIT_ID


DRC_UNIT_EXPRSN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dose Range Checking Unit Expression
Definition: Reference data that defines the unit of measure expressions for dose range checking
Table Type: REFERENCE





Column Detail - DRC_UNIT_EXPRSN


Column Name Type Null? Definition
DRC_UNIT_EXPRSN_ID DOUBLE N Unique system generated identifier
UNIT_EXPRESSION VARCHAR(100) Y Textual description of the unit expression.
UNIT_EXPRSN_CKI VARCHAR(255) N This is the CKI defined for the unit as assigned in code set 54 with the cs_54_utility tool.
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_UNIT_EXPRSN




Parent Column in DRC_UNIT_EXPRSN (PK) Child Table Name Child Column Name
Children: DRC_UNIT_EXPRSN_ID DRC_UNIT_EXPRSN_RELTN DRC_UNIT_EXPRSN_ID


DRC_UNIT_EXPRSN_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dose Range Checking Unit Expression Relation
Definition: Reference data that defines the unit of measure expressions for dose range checking
Table Type: REFERENCE





Column Detail - DRC_UNIT_EXPRSN_RELTN


Column Name Type Null? Definition
DRC_UNIT_EXPRSN_ID DOUBLE N Foreign key to drc_unit_expression table.
DRC_UNIT_ID DOUBLE N Foreign key to drc_unit table.
RELATION_NUMERATOR_IND DOUBLE N A value of 1 indicates the unit is in the numerator of the expression and a value of 0 indicates the unit is in the denominator of the expression.
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_UNIT_EXPRSN_RELTN


Child Column in DRC_UNIT_EXPRSN_RELTN(FK) Parent Table Name Parent Column Name
Parents: DRC_UNIT_ID DRC_UNIT DRC_UNIT_ID
DRC_UNIT_EXPRSN_ID DRC_UNIT_EXPRSN DRC_UNIT_EXPRSN_ID