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