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