Table Detail Report

ESO_TRIGHOLD_INPUT_QUE



Column Section Top of Page


Table-level Detail

Description: ESO Trigger Hold Input Que
Definition: Acts as an input queue for the trigger hold server. Populated by HNAUSER. Logs information about each trigger that is enqueued on the eso_trighold_que table.
Table Type: ACTIVITY





Column Detail - ESO_TRIGHOLD_INPUT_QUE


Column Name Type Null? Definition
ERROR_TEXT VARCHAR(500) Y Error text reported by the script if a trigger combine failed
ESO_TRIGHOLD_INPUT_QUE_ID DOUBLE N Defines a unique ID for each trigger's input que info
ESO_TRIGHOLD_QUE_ID DOUBLE N Defines a unique ID for each trigger enqueued on the eso_trighold_que table.
MESSAGE LONGBLOB Y Compressed message
MESSAGE_LEN DOUBLE Y Message lengthColumn
PRIMARY_ENTITY_ID DOUBLE N Value of the first identifier used for matching triggers of this class
TRIGGER_HELD_IND DOUBLE N Trigger held indicatorColumn
TRIGGER_PROC_FLAG DOUBLE Y Trigger process status flag 1 = Trigger Received 2 = Trigger on hold 3 = Trigger sent to CQM
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.


ESO_TRIGHOLD_PARM



Column Section Top of Page


Table-level Detail

Description: ESO Trigger Hold Parameter
Definition: Stores trigger hold parameters for different class/type/subtype combinations. If a row exists for a particular combination, then that trigger can be held.
Table Type: REFERENCE





Column Detail - ESO_TRIGHOLD_PARM


Column Name Type Null? Definition
CLASS VARCHAR(15) N The trigger's CQM class
ESO_TRIGHOLD_PARM_ID DOUBLE N Defines a unique ID for each trigger hold parameter
SUBTYPE VARCHAR(15) N The trigger's CQM subtype
TRIG_ROLLUP_SCRIPT_NAME VARCHAR(40) Y Defines which script will be used to combine multiple triggers
TYPE VARCHAR(15) N The trigger's CQM type
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.


ESO_TRIGHOLD_QUE



Column Section Top of Page


Table-level Detail

Description: ESO Trigger Hold Queue
Definition: Stores outbound triggers before they reach the CQM server. Will combine selected triggers to reduce outbound volume.
Table Type: ACTIVITY





Column Detail - ESO_TRIGHOLD_QUE


Column Name Type Null? Definition
CLASS VARCHAR(15) N The trigger's CQM class
ESO_TRIGHOLD_QUE_ID DOUBLE N Defines a unique ID for each trigger on the queue
MESSAGE LONGBLOB Y Compressed messageColumn
MESSAGE_LEN DOUBLE Y Message lengthColumn
QUE_INSERT_DT_TM DATETIME N Date/time trigger was inserted into queue
TRIG_IDENTIFIER_COMP VARCHAR(100) N Trigger identifier composite string
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.


ESO_TRIGHOLD_RULE



Column Section Top of Page


Table-level Detail

Description: ESO Trigger Hold Rule
Definition: Stores rules for combining currently held triggers with incoming triggers.
Table Type: REFERENCE





Column Detail - ESO_TRIGHOLD_RULE


Column Name Type Null? Definition
CLASS VARCHAR(15) N The trigger's CQM class
DOUBLE_LIST_NAME VARCHAR(40) N Defines the rule for combining triggers
ESO_TRIGHOLD_RULE_ID DOUBLE N Defines a unique ID for each trigger hold rule
SEQ_NBR DOUBLE N Sequence number of double list entry
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.


ESO_TRIG_ROUTINE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO Trigger Routine Relation Table
Definition: This table define the relationships between ESO Triggers and ESO routines. For each outbound trigger event, this table define the list of processing units (scripts or routines) that are needed to format an outbound message according to UI specifications.
Table Type: REFERENCE





Column Detail - ESO_TRIG_ROUTINE_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
CREATE_DT_TM DATETIME N This is the date and time that a row is created in the eso_trig_routine_r table.
DEBUG_IND DOUBLE Y This indicator may be used by the ESO Server to debug ESO routines or scripts while in a run-time mode.
ROUTINE_ARGS VARCHAR(255) Y This string defines the arguments that are passed into the ESO script or routine when the event trigger is processed.
ROUTINE_CONTROL DOUBLE Y This integer number is passed into the ESO script or routine when the event trigger is processed to control routine specific processing elements..
ROUTINE_ID DOUBLE N Part of the Unique Identifier fro this table. Identifies the routine from the ESO_ROUTINE table.
SEQUENCE_NBR DOUBLE N Identifies the sequence that the routine should be performed in by trigger (TRIGGER_ID).
TRIGGER_ID DOUBLE N Part of the unique identifier for the table. Identifies the Trigger from the ESO_TRIGGER 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.
VERBOSITY_FLAG DOUBLE Y This flag may be used by the ESO Server to control the verbosity when debugging an ESO routine or script while in a run-time mode.



Relationship Detail - ESO_TRIG_ROUTINE_R


Child Column in ESO_TRIG_ROUTINE_R(FK) Parent Table Name Parent Column Name
Parents: ROUTINE_ID ESO_ROUTINE ROUTINE_ID
TRIGGER_ID ESO_TRIGGER TRIGGER_ID




Parent Column in ESO_TRIG_ROUTINE_R (PK) Child Table Name Child Column Name
Children: ROUTINE_ID SI_ESO_TRIG_ROUT_R_HIST ROUTINE_ID
TRIGGER_ID SI_ESO_TRIG_ROUT_R_HIST TRIGGER_ID