Table Detail Report

CQM_LISTENER_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: CQM Listener Configuration
Definition: The CQM listener configuration table identifies the verifiable alias of listener applications that are permitted to retrieve CQM transaction. Each alias is associated in this table with a CQM application and a trigger table.
Table Type: REFERENCE





Column Detail - CQM_LISTENER_CONFIG


Column Name Type Null? Definition
APPLICATION_NAME VARCHAR(12) N The application name denotes a specific usage of CQM. This string is limited to twelve characters as it concatenated into DB table names to isolate the physical storage space of transaction by applicatio.
COMM_PARAMS VARCHAR(200) Y Identifies communications method and parameters that used by the trigger explosion process to notify the listener presented in this row.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
CURRENT_NODE VARCHAR(100) Y Node on which the comserver is currently set to run
LISTENER_ALIAS VARCHAR(48) N The verifiable alias, by application name, which denotes a listener application that processes trigger exploded transactions.
LISTENER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener configuration table. It is an internal system assigned number.
LISTENER_IMAGE_NAME VARCHAR(132) Y Future
LISTENER_IMAGE_OPTIONS VARCHAR(132) Y Future
LISTENER_TRIGGER_TABLE_EXT VARCHAR(9) N Denotes the extension string concatenated onto the listener trigger table name that denotes the physical storage space which the listener application identified in this row will receive its trigger events. This string is limited to nine characters.
PRIMARY_NODE VARCHAR(100) Y Node on which the listener should run under normal conditions.
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 - CQM_LISTENER_CONFIG




Parent Column in CQM_LISTENER_CONFIG (PK) Child Table Name Child Column Name
Children: LISTENER_ID CQM_LISTENER_REGISTRY LISTENER_ID
CQM_MDRESULTS_TR_1 LISTENER_ID
CQM_MICRESULTS_TR_1 LISTENER_ID


CQM_LISTENER_REGISTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CQM Listener Registry
Definition: The CQM listener registry table identifies the trigger explosion (or transaction routing) dynamics. This table associated the CQM routing parameters to listener applications that are presented in the CQM listener configuration table.
Table Type: REFERENCE





Column Detail - CQM_LISTENER_REGISTRY


Column Name Type Null? Definition
CLASS VARCHAR(15) Y Identifies the trigger explosion class of the transaction.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
DEBUG_IND DOUBLE Y Defines whether debugging is active or inactive for the trigger explosion routing identified by this row
LISTENER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener configuration table. It is an internal system assigned number.
REGISTRY_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener registry table. It is an internal system assigned number.
SUBTYPE VARCHAR(15) Y Identifies the trigger explosion subtype of the transaction.
SUBTYPE_DETAIL VARCHAR(15) Y Identifies the trigger explosion subtype detail of the transaction.
TARGET_PRIORITY DOUBLE Y Identifies the priority of a target transaction row in the listener trigger table for the trigger explosion routing identified in this row. The value range for priority is 1 throug 99, highest to lowest, respectively.
TYPE VARCHAR(15) Y Identifies the trigger explosion type of the transaction.
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 Defines the verbosity level during debugging for the trigger explosion routing identified in this row.



Relationship Detail - CQM_LISTENER_REGISTRY


Child Column in CQM_LISTENER_REGISTRY(FK) Parent Table Name Parent Column Name
Parents: LISTENER_ID CQM_LISTENER_CONFIG LISTENER_ID


ESO_FIELD_FILTER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: eso field filter relation
Definition: eso field filter relation Table
Table Type: REFERENCE





Column Detail - ESO_FIELD_FILTER_RELTN


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATE_DT_TM DATETIME N The date and time the record was created
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXCLUDE_IND DOUBLE N Indicates whether this result is included or excluded from the calculation of the Mean and Standard Deviation. A value of 0 indicates the result should be included in the calculation. A value of 1 indicates the result should be excluded from the calculation.
FIELD_FILTER_RELTN_ID DOUBLE N field filter relation identifierColumn
FIELD_TRANS_ID DOUBLE N field filter identifierColumn
FILTER_ID DOUBLE N filter identifierColumn
RELTN_SEQ DOUBLE N relation sequenceColumn
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.



Relationship Detail - ESO_FIELD_FILTER_RELTN


Child Column in ESO_FIELD_FILTER_RELTN(FK) Parent Table Name Parent Column Name
Parents: FIELD_TRANS_ID ESO_FIELD_TRANS FIELD_TRANS_ID
FILTER_ID ESO_FILTER FILTER_ID




Parent Column in ESO_FIELD_FILTER_RELTN (PK) Child Table Name Child Column Name
Children: FIELD_FILTER_RELTN_ID ESO_FILTER_COND_RELTN FIELD_FILTER_RELTN_ID


ESO_FIELD_TRANS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO Field Trans
Definition: ESO field trans
Table Type: REFERENCE





Column Detail - ESO_FIELD_TRANS


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME N create date and timeColumn
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FIELD_CD DOUBLE N field codeColumn
FIELD_TRANS_ID DOUBLE N field trans identifierColumn
FIELD_TYPE_CD DOUBLE N field type codeColumn
GROUP_CD DOUBLE N group codeColumn
MESSAGE_FORMAT_CD DOUBLE N message format codeColumn
MESSAGE_TRIGGER_CD DOUBLE N message trigger codeColumn
MESSAGE_TYPE_CD DOUBLE N message type codeColumn
MESSAGE_VERSION_CD DOUBLE N message version codeColumn
ORIGINAL_FIELD_TRANS_IDENT DOUBLE N original field trans identifierColumn
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.



Relationship Detail - ESO_FIELD_TRANS




Parent Column in ESO_FIELD_TRANS (PK) Child Table Name Child Column Name
Children: FIELD_TRANS_ID ESO_FIELD_FILTER_RELTN FIELD_TRANS_ID


ESO_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: eso filter
Definition: eso filter Table
Table Type: REFERENCE





Column Detail - ESO_FILTER


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME N The date and time the record was created
DESCRIPTION VARCHAR(255) N descriptionColumn
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FILTER_CD DOUBLE N filter codeColumn
FILTER_ID DOUBLE N filter identifierColumn
ORIGINAL_FILTER_IDENT DOUBLE N original filter identifierColumn
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.



Relationship Detail - ESO_FILTER




Parent Column in ESO_FILTER (PK) Child Table Name Child Column Name
Children: FILTER_ID ESO_FIELD_FILTER_RELTN FILTER_ID
ESO_FILTER_PROP FILTER_ID