Table Detail Report

EKS_NOTIFY_PERSN_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Entries in this table relate a person to a notification.
Definition: relates a person to a notification message.
Table Type: ACTIVITY





Column Detail - EKS_NOTIFY_PERSN_R


Column Name Type Null? Definition
NOTIFICATION_ID DOUBLE N Relates to the id of the message in the eks_notifications table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
READ_IND DOUBLE Y Indication as to whether the message has been read. 0: new, unread message, 1: message was read/still visible in viewer, 2: message is logically deleted/no longer visible to user.
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_NOTIFY_PERSN_R


Child Column in EKS_NOTIFY_PERSN_R(FK) Parent Table Name Parent Column Name
Parents: NOTIFICATION_ID EKS_NOTIFICATIONS NOTIFICATION_ID
PERSON_ID PRSNL PERSON_ID


EKS_REQUEST



Column Section Top of Page


Table-level Detail

Description: Discern Expert list of incoming requests to event map
Definition: Maps CSA requests to EKS event numbers
Table Type: REFERENCE





Column Detail - EKS_REQUEST


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.
DOMAIN VARCHAR(40) N Should always be set to "CERT" -- will be phased out in the future.
EVENT_NUMBER DOUBLE N The event number of the event being mapped to a request by this record.
FORMAT_SCRIPT CHAR(30) Y Format script used by the process server to format request
REQUEST_NUMBER DOUBLE N The request number of the request being mapped to an event by this record.
REQUEST_TYPE CHAR(1) Y Defines the type of request
SERVER_TYPE CHAR(1) Y The server type(s) that should load this mapping. valid types are: 'A' (ASYNC), 'S' (SYNC), or 'B' (BOTH).
TARGET_REQUEST_NUMBER DOUBLE Y Target request number used by the process server to format incoming request to this request
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_SERVER



Column Section Top of Page


Table-level Detail

Description: server definintions by server class
Definition: Defines attributes of discern expert servers for each class of server in the system
Table Type: REFERENCE





Column Detail - EKS_SERVER


Column Name Type Null? Definition
DB_NAME VARCHAR(40) Y database name to used when generating the SCP entry for this server class.
DB_NODE VARCHAR(40) Y The OPTIONAL node to use when defining this server to SCP.
DB_PW VARCHAR(40) Y Password to use on the SCP command line for the server.
DB_USER VARCHAR(40) Y The user id to use for the definition of the server in SCP
DESCRIPTION VARCHAR(40) Y Description of the server class, normally EKS_ASYNCH_0x or CPM.EKS
DRIVER_PATH VARCHAR(40) Y Path to the driver to use for this server. The driver is the program that calls the code in the expert server's shared image.
EVENT_CACHE_MAX DOUBLE Y maximum size of the event cache
EVOKE_CACHE_MAX DOUBLE Y Max size of the evoke cache.
EXE_PATH VARCHAR(40) Y path to the expert server's shared image.
INSTANCES DOUBLE Y The number of instances of this server class to automatically start when the system is started.
LOG_LEVEL DOUBLE Y The logging level to use for this server class.
MODULE_CACHE_MAX DOUBLE Y max size of the module cache
MODULE_CACHE_PRI_HIGH DOUBLE Y Highest module priority that will be cached in this server class.
MODULE_CACHE_PRI_LOW DOUBLE Y Lowest module priority that will be cached in this server class.
PRIORITY_BEGIN DOUBLE N The lowest event priority that will be serviced by this server class.
PRIORITY_END DOUBLE Y The highest event priority that will be serviced by this server class.
RESTART_IND DOUBLE Y Determines whether the auto-restart indicator will be set in SCP for this server class. If so, then when a server in the class abnormally terminates, CSA will attempt to re-start the server automatically.
SERVER_CLASS VARCHAR(40) N The CSA service name of this server class. Must be unique within the DOMAIN.
SERVER_TYPE CHAR(1) Y Synchronous, or asynchronous.
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_TEMPLATE



Column Section Top of Page


Table-level Detail

Description: EKS template header table
Definition: Records in this table define the overall characteristics of EKS module templates. Templates are the basic component used to build EKS modules.
Table Type: REFERENCE





Column Detail - EKS_TEMPLATE


Column Name Type Null? Definition
ACTIVE_FLAG CHAR(1) N The active flag denotes whether the template and its version represented by this record is active or not. If active, this flag will be 'A', and if inactive,the flag will be 'I'.
ALWAYS_TRUE_IND DOUBLE N The indicator of the return value (retval) for template. 0 means this template does not always return true. 1 means this template always return true.
DESCRIPTION VARCHAR(255) Y The description of the template represented by this template header record.
EDITOR_DEF VARCHAR(2000) Y The template's text that is viewable in the EKM editor. This text contains embedded parameter names.
EKM_DEF LONGTEXT Y This is the subroutine text that will be compiled by the module editor using CCL when the template is pulled into a module and saved as part of the module.
KEYWORD VARCHAR(30) Y is used for display purposes on the frontend and will be put in a sortable column of a list box.
NUM_PARAMS DOUBLE Y Number of parameters used by the template. Parameters are variables specified by the module builder when a template is used (instantiated) in a module.
RECOMMEND_FLAG DOUBLE N RECOMMEND_FLAG can have one of 3 values. 0 = Recommend; 1 = Use with Caution; 2 = Not Recommended
TEMPLATE_NAME CHAR(30) N The name of the template represented by this header record.
TEMPLATE_TYPE CHAR(1) Y The type of the template. Templates are defined to be usable in a specified section of the EXPERT module. The type field denotes which portion of the module this template can be used in. Possible values are: 'L' - LOGIC, 'A'- ACTION, 'D'-DATA, and 'E' - EVOKE.
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 Each time a template is saved, it's version number is incremented and the newest version is made active. This field contains the version number.


EKS_TEMPLATEPARAM



Column Section Top of Page


Table-level Detail

Description: Template parameter definition
Definition: This table contains definitions of parameters associated with templates. Each parameter may be set to user specified values when the associated template is placed into an expert module.
Table Type: REFERENCE





Column Detail - EKS_TEMPLATEPARAM


Column Name Type Null? Definition
DATA_TYPE CHAR(1) Y The data type of the parameter. Character, Integer, Help, etc.
DEFAULT_DATA VARCHAR(255) Y The default data that will appear in the parameter when the associated template is placed into a module.
DEPENDENCYLIST VARCHAR(2000) Y Sometimes the list of entries returned by referential help on one parameter depends on the value(s) in other parameter(s). This field is used to store such a list of dependencies.
DEPENDENCYON DOUBLE Y Not currently used..
FORMAT_MASK VARCHAR(255) Y The edit format mask to use for parameters based on edit boxes.
HELP VARCHAR(2000) Y The data stored in this field depends on the HELP_TYPE field. If HELP_TYPE is 0 then this field is not used if HELP_TYPE is 1 then this field contains the referential help select command if HELP_TYPE is 2 then this field contains the list of fixed choices that the user selects from
HELP_TYPE CHAR(1) Y Defines the type of help available to the user when instantiating a template within the module. 0 - no help. 1- Referential help A ccl select statement is executed and the results are available for the user to select from 2- Fixed choices list The user selects from an enumerated list of values
INPUT_TYPE CHAR(1) Y input type indicates the type of control to use in editing the parameter. The current values are : C : combo box M : multiline edit box ( Not yet available ) R : radio buttons ( Not yet available ) X : check boxes ( Not yet available ) S : single line edit box L : list box ( Not yet available ) H : single line edit box & referential help button
MAX_INPUT_LENGTH DOUBLE Y Maximum length of string that can be entered as a value of the parameter
NAME_LENGTH DOUBLE Y Length of parameter name
OPTIMIZABLE_IND DOUBLE N Optimizable indicator. 0 means parameter is not optimizable, 1 means parameter is optimizable.
PAR_NAME CHAR(30) Y Name of parameter
PAR_NUM DOUBLE N Indicates the (0-based) index of parameter in the template.
POS DOUBLE Y Indicates the character index at which this parameter begins in the template's text.
RECONCILE_SCRIPT VARCHAR(255) Y The name of the reconciliation script for the parameter.
REQUIRED_FLAG CHAR(1) Y Not currently used
TEMPLATE_NAME CHAR(30) N The name of the template that this parameter is associated to
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.
VALIDATION VARCHAR(2000) Y Not currently used
VALIDATION_TYPE CHAR(1) Y Not currently used
VERSION CHAR(10) N This value is used along with the TEMPLATE_NAME to associate this parameter with the right template.