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