Table Detail Report

EKS_DLG_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: EKS DLG EVENT
Definition: Event tracking table, contains a row for each time an event has occurred
Table Type: ACTIVITY





Column Detail - EKS_DLG_EVENT


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y This flag indicates that an action may need to be taken on the incoming order.0 = Non-specified action.1 = Alert message display only. 2 = Cancel the triggering action. 3 = Continue the triggering action. 4 = Modify the triggering action.5 = Message from EKS_LOG_ACTION_A template.
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALERT_LONG_TEXT_ID DOUBLE N Identifies an entry in the long text table which contains the free text associated with alert history.
DLG_DT_TM DATETIME Y The date and time when the triggered event occurred
DLG_EVENT_ID DOUBLE N Sequence number which uniquely identifies the event
DLG_NAME VARCHAR(255) Y Name of the Insight which executed.
DLG_PRSNL_ID DOUBLE N Identifies the user who was logged in when the event or Insight executed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
LONG_TEXT_ID DOUBLE N Identifies entry in the long text table which contains the free text associated with override reasons.
MODIFY_DLG_NAME VARCHAR(255) Y Name of the trigger module or user defined name.
OVERRIDE_DEFAULT_IND DOUBLE Y Boolean to indicate whether the default Insights recommendation was overridden. True indicates default override
OVERRIDE_REASON_CD DOUBLE N Code value which indicates the user's reason for overriding the default action of an Insight
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TRIGGER_ENTITY_ID DOUBLE N Identifier for the entity which triggered the event. Relates to the TRIGGER_ENTITY_NAME field
TRIGGER_ENTITY_NAME CHAR(32) Y Parent entity for the item which triggered this event. Relates to the TRIGGER_ENTITY_ID table.
TRIGGER_ORDER_ID DOUBLE N ID of trigger order drug. Not all rows on this table will have a value in column TRIGGER_ORDER_ID that exists in the PK column on the Orders table. Some times TRIGGER_ORDER_ID is getting populated with a generated order_id in cases where Orders invokes Discern alerts but a user then cancels the order based on the alert. When this happens there will be no matching PK in the Orders table.
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.



Relationship Detail - EKS_DLG_EVENT


Child Column in EKS_DLG_EVENT(FK) Parent Table Name Parent Column Name
Parents: DLG_NAME EKS_DLG DLG_NAME
ENCNTR_ID ENCOUNTER ENCNTR_ID
ALERT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
DLG_PRSNL_ID PRSNL PERSON_ID




Parent Column in EKS_DLG_EVENT (PK) Child Table Name Child Column Name
Children: DLG_EVENT_ID EKS_DLG_EVENT_ATTR DLG_EVENT_ID


EKS_DLG_EVENT_ATTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: EKS DLG EVENT ATTR
Definition: Contains attributes of an event in the EKS_DLG_EVENT table
Table Type: ACTIVITY





Column Detail - EKS_DLG_EVENT_ATTR


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ATTR_ID DOUBLE N ID of attribute
ATTR_NAME CHAR(32) Y The name of the table which contains the identifiers for the event attribute
ATTR_VALUE VARCHAR(255) Y The value of the attribute identifier. Relates to the ATTR_NAME table
DLG_EVENT_ATTR_ID DOUBLE N Unique identifier for an event attribute.
DLG_EVENT_ID DOUBLE N The identifier of the event for which these attributes were generated
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.



Relationship Detail - EKS_DLG_EVENT_ATTR


Child Column in EKS_DLG_EVENT_ATTR(FK) Parent Table Name Parent Column Name
Parents: DLG_EVENT_ID EKS_DLG_EVENT DLG_EVENT_ID


EKS_EVENT



Column Section Top of Page


Table-level Detail

Description: Event Definition
Definition: Defines expert events. Each event may be mapped to one or more system requests that are originally destined for other servers in the system.
Table Type: REFERENCE





Column Detail - EKS_EVENT


Column Name Type Null? Definition
DOMAIN VARCHAR(40) N Should always be "CERT". This field will be phased out.
EVENT_NAME VARCHAR(40) N The event name to be used when this event occurs. EKS Modules are coded to be evoked on the event NAME.
EVENT_NUMBER DOUBLE N The event number is used as an internal key within the EKS server to map from incoming requests to lists of modules to run.
EVENT_PREFETCH_SCRIPT VARCHAR(31) Y If defined, the prefetch script is executed AFTER all evokes are evaluated in the server, but before any modules are executed.
EVENT_PRIORITY DOUBLE Y Priority of the event relative to other events within the eks servers. Evoke's where-clauses are evaluated as events arrive, but the modules to be evoked are placed in lists that enqueued and processed by event priority.
SINGLE_THREAD CHAR(1) Y Causes the server to obtain locks once for all modules being processed for the event rather than obtaining and releasing it for each module. This effectively causes the server to single thread the event and saves CPU/IO because other resources may be held also.
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.


EKS_EVENT_TEMPLATE_R



Column Section Top of Page


Table-level Detail

Description: event template mapping
Definition: Used to indicate which templates may be used when building modules to service specific events.
Table Type: REFERENCE





Column Detail - EKS_EVENT_TEMPLATE_R


Column Name Type Null? Definition
EVENT_NUMBER DOUBLE N event number that this template is being mapped to
TEMPLATE_NAME CHAR(30) N Template being mapped to an event defined by this relationship record.
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.


EKS_MICRO



Column Section Top of Page


Table-level Detail

Description: Discern microbiology cross reference table.
Definition: Discern microbiology cross reference table. Contains a list of antibiotics from code set 1011 and relative cost.
Table Type: ACTIVITY





Column Detail - EKS_MICRO


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N Code values of antibiotics from code set 1011
RELATIVE_COST CHAR(30) Y Relative cost
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.