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 |