Table Detail Report

EKS_MICRO_MED_R



Column Section Top of Page


Table-level Detail

Description: Discern microbiology cross reference table.
Definition: Discern microbiology cross reference table. Connects antibiotic codes from code set 1011 to pharmacy catalog codes in Order_Catalog table.
Table Type: ACTIVITY





Column Detail - EKS_MICRO_MED_R


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.
ANTIBIOTIC_CD DOUBLE N Code values of antibiotics from code set 1011
CATALOG_CD DOUBLE N Code values of pharmacy items from Order_Catalog table
EKS_MICRO_MED_ID DOUBLE N Sequence number which uniquely identifies the row in the table.
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_MODULE



Column Section Top of Page


Table-level Detail

Description: EKS Module
Definition: The module header record. Defines base expert module attributes.
Table Type: REFERENCE





Column Detail - EKS_MODULE


Column Name Type Null? Definition
ACTIVE_FLAG CHAR(1) N When eks modules are saved, their active flag is set to 'A' (Active) and all other versions of the same module are made 'I' (inactive).
EKS_RELEASE CHAR(10) Y This field indicates the release of the EKS system that created the module. If the release is less than the current release being used, this module's format will change to the new format when re-saved. If loaded with a prior version of the EKM editor, then the load MAY succeed, or it may fail, in any case, the module will NEVER allowed to be changed with a prior version of the EKM Editor.
KNOW_PRIORITY DOUBLE Y The module's priority when executing in the expert server.
KNOW_TYPE CHAR(20) Y The type of the module. DATA_DRIVEN, GOAL_DRIVEN, TIME_DRIVEN
KNOW_URGENCY DOUBLE Y The priority of the action section of the module.
LAST_REV_DT_TM DATETIME Y The date the module had a significant change, as determined by the module editor. May differ from if the compile was not deemed significant. User defined field.
MAINT_AUTHOR VARCHAR(255) Y The author of the module.
MAINT_DATE DATETIME Y date the module was created.
MAINT_DUR_BEGIN_DT_TM DATETIME Y The beginning of the time frame when the module should be active.
MAINT_DUR_END_DT_TM DATETIME Y the end of the module active time frame.
MAINT_FILENAME VARCHAR(30) Y The file name used to contain the source text of the eks module.
MAINT_INSTITUTION VARCHAR(255) Y The institution using the expert module.
MAINT_SPECIALIST VARCHAR(255) Y The person responsible for encoding the knowledge represented by this ekm.
MAINT_TITLE VARCHAR(255) Y The title of the module as free text.
MAINT_VALIDATION CHAR(12) Y The level of validation this module has been through.
MAINT_VERSION CHAR(10) Y Version of the module. The version is incremented every time the module is saved.
MODULE_NAME CHAR(30) N The name of the module.
NUM_STORAGE DOUBLE Y The number of eks_modulestorage records required to store the module definition.
OPTIMIZED_IND DOUBLE N Optimized Indicator for current module version. 0 = No values were optimized, 1 = At least one parameter value was optimized.
OPTIMIZE_FLAG DOUBLE N Module Optimization Flag. 0 - System default value. 1 - Optimizes the module.2 - Don¿t optimizes the module.
RECONCILE_DT_TM DATETIME Y The date of the module reconciled.
RECONCILE_FLAG DOUBLE N Module Reconciliation Status Flag. 0 = Reconciliation not attempted on current module version , 1 = Module was fully reconcilable with no exceptions found, 2 = Reconciliation exceptions were found, 3 = Module was only partially reconcilable, but no exceptions were found3 - Attempt made. Patial was Ok
RELEASE_DT_TM DATETIME Y The date that action(s) are seen on the front end by users. May differ from if testing was done before releasing the module to end users. User defined field.
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.
VERSION CHAR(10) N version assigned to module to keep track of latest module saved since previous modules are retained.


EKS_MODULESTORAGE



Column Section Top of Page


Table-level Detail

Description: module definition storage table
Definition: The module storage table contains the encoded defintion of the module including the templates used, and their conjunctive and disjunctive relationships.
Table Type: REFERENCE





Column Detail - EKS_MODULESTORAGE


Column Name Type Null? Definition
DATA_SEQ DOUBLE N The eks_module table's num_storage field describes the count of module storage records required to describe the module details. The DATA_SEQ field is the offset of a module storage record within the set used to describe the module.
DATA_TYPE DOUBLE N Type of the data held within this record. The types basically denote which section of the module is being stored in this record (EVOKE, DATA,LOGIC,ACTION).
EKM_INFO LONGTEXT Y The text of the module containing the templates and parameters and their conjunctive/disjunctive relationships.
MODULE_NAME CHAR(30) N The name of the module this record is associated with.
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.
VERSION CHAR(10) N The version of the module that this record is associated with.


EKS_MODULE_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: eks server module audit table
Definition: Used by eks servers to log the results of having run a module.
Table Type: ACTIVITY





Column Detail - EKS_MODULE_AUDIT


Column Name Type Null? Definition
ACTION_COUNT DOUBLE Y Count of action template results.
ACTION_EXEC_SECS DOUBLE Y Will contain how long in seconds, the action section of the rule execution took to complete.
ACTION_RETURN CHAR(100) Y Action return values as an array of 3 digit numbers.
BEGIN_DT_TM DATETIME Y The date/time the module began.
CONCLUDE DOUBLE Y Module's overall conclusion result. 0 - logic false, 1-logic true, 2-action(s) performed.
END_DT_TM DATETIME Y The date/time the module ended.
EVENT_NUMBER DOUBLE Y EKS Internal event number that triggered this module.
LOGIC_COUNT DOUBLE Y Count of templates returning a value in the logic section.
LOGIC_EXEC_SECS DOUBLE Y Will contain how long in seconds, the logic section of the rule execution took to complete.
LOGIC_RETURN CHAR(100) Y Array of 3 digit values denoting the return values for templates in the logic section.
MODULE_NAME CHAR(30) Y Name of the module that ran in the server.
MODULE_VERSION VARCHAR(10) Y Current Module Version executed for the rule instance.
PERSONNEL_ID DOUBLE N Personnel ID of the person that initiated module firing by performing system request. ***Obsolete column. Column never populated. Always 0.***
REC_ID DOUBLE N Contains the record sequence obtained from eks_module_audit_seq when inserting into table. Contains a unique key from a sequence.
REQUEST_NUMBER DOUBLE Y System request number that triggered EKS internal event.
SERVER_CLASS CHAR(40) Y The class of the server that ran the module.
SERVER_INSTANCE DOUBLE Y The CSA instance number of the server that ran the module.
SERVER_NODE VARCHAR(30) Y Linux/AIX application node name the server instance is running on.
SERVER_NUMBER DOUBLE Y The number of the server that ran the module (domain + directory entry number).
SERVER_RTLLOG VARCHAR(30) Y The server rtl log name written in $CCLUSERDIR.
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_MODULE_AUDIT




Parent Column in EKS_MODULE_AUDIT (PK) Child Table Name Child Column Name
Children: REC_ID EKS_MODULE_AUDIT_DET MODULE_AUDIT_ID


EKS_MODULE_AUDIT_DET



Column Section Relationship Section Top of Page


Table-level Detail

Description: module audit template details
Definition: As modules are logged to the audit table (eks_module_audit), this table is updated with information pertaining to each template used in the logic and actions sections. And one row is created for each in the table.
Table Type: ACTIVITY





Column Detail - EKS_MODULE_AUDIT_DET


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N Accession id associated with the template at runtime
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
LOGGING VARCHAR(2000) Y Text logging information field used by the template to log messages.
MODULE_AUDIT_ID DOUBLE N Relates to the module audit header record. This record is a detail record created to relate a specific template's detail info when a module runs.
ORDER_ID DOUBLE N If an order is associated with the template at runtime, it's order Id will be contained in this field.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TASK_ASSAY_CD DOUBLE N Task assay code (if applicable) associated with the current Expert template
TEMPLATE_ALIAS VARCHAR(50) Y The template alias name defined for a Discern rule/template instance.
TEMPLATE_NAME CHAR(30) Y Template executed for the current audit record
TEMPLATE_NUMBER DOUBLE N ordinal number of the template within the module that fired.
TEMPLATE_RETURN DOUBLE Y return value from the template ( 0 - 100 )
TEMPLATE_TYPE CHAR(1) Y Template type E)voke, L)ogic, A)ction.
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_MODULE_AUDIT_DET


Child Column in EKS_MODULE_AUDIT_DET(FK) Parent Table Name Parent Column Name
Parents: MODULE_AUDIT_ID EKS_MODULE_AUDIT REC_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID