Table Detail Report

ESO_FILTER_COND



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO filter cond
Definition: ESO filter cond Table
Table Type: REFERENCE





Column Detail - ESO_FILTER_COND


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 that the record was created in the table.
DESCRIPTION VARCHAR(255) N This string provides a description of the event trigger row.
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_COND_CD DOUBLE N filter cond codeColumn
FILTER_COND_ID DOUBLE N filter condition identifierColumn
FILTER_COND_VALUE VARCHAR(255) Y filter cond valueColumn
ORIGINAL_FILTER_COND_IDENT DOUBLE N original filter cond 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_COND




Parent Column in ESO_FILTER_COND (PK) Child Table Name Child Column Name
Children: FILTER_COND_ID ESO_FILTER_COND_RELTN FILTER_COND_ID


ESO_FILTER_COND_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - ESO_FILTER_COND_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 that the record was created in the table.
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
FILTER_COND_ID DOUBLE N filter condition identifierColumn
FILTER_COND_RELTN_ID DOUBLE N filter cond relation 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_COND_RELTN


Child Column in ESO_FILTER_COND_RELTN(FK) Parent Table Name Parent Column Name
Parents: FIELD_FILTER_RELTN_ID ESO_FIELD_FILTER_RELTN FIELD_FILTER_RELTN_ID
FILTER_COND_ID ESO_FILTER_COND FILTER_COND_ID


ESO_FILTER_PROP



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - ESO_FILTER_PROP


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 that the record was created in the table.
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_ID DOUBLE N filter identifierColumn
FILTER_PROP_CD DOUBLE N filter property codeColumn
FILTER_PROP_ID DOUBLE N filter property identifierColumn
FILTER_PROP_VALUE VARCHAR(255) Y filter property valueColumn
ORIGINAL_FILTER_PROP_IDENT DOUBLE N original filter property 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_PROP


Child Column in ESO_FILTER_PROP(FK) Parent Table Name Parent Column Name
Parents: FILTER_ID ESO_FILTER FILTER_ID




Parent Column in ESO_FILTER_PROP (PK) Child Table Name Child Column Name
Children: FILTER_PROP_ID ESO_FILTER_PROP_ATTRIB FILTER_PROP_ID


ESO_FILTER_PROP_ATTRIB



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - ESO_FILTER_PROP_ATTRIB


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.
ATTRIB_SEQ DOUBLE N attribute sequenceColumn
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 that the record was created in the table.
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_PROP_ATTRIB_CD DOUBLE N filter property attribute codeColumn
FILTER_PROP_ATTRIB_ID DOUBLE N filter property attribute identifierColumn
FILTER_PROP_ATTRIB_VALUE VARCHAR(255) Y filter property attribute valueColumn
FILTER_PROP_ID DOUBLE N filter property 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_PROP_ATTRIB


Child Column in ESO_FILTER_PROP_ATTRIB(FK) Parent Table Name Parent Column Name
Parents: FILTER_PROP_ID ESO_FILTER_PROP FILTER_PROP_ID


ESO_ROUTINE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO Routine Table
Definition: This table defines the scripts or hard coded C routines that are accessible to ESO for event processing.
Table Type: REFERENCE





Column Detail - ESO_ROUTINE


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.
ARGS_DEFAULT VARCHAR(255) Y This string define the default arguments that may be used to populate routine_args element on the ESO_TRIG_ROUTINE_R table.
ARGS_HELP VARCHAR(255) Y This string may define the syntax or options for populating the routine_args element on the ESO_TRIG_ROUTINE_R table.
CREATE_DT_TM DATETIME N This is the date and time that a row is created in the eso_routine table.
DESCRIPTION VARCHAR(255) Y This string provides a description of the routine or script..
ROUTINE VARCHAR(50) N Routine name. Define a hard coded C routine. If this is either GENERIC_SCRIPT_USE_REPLY or GENERIC_SCRIPT_USE_CTX, then the script field should be valued.
ROUTINE_ID DOUBLE N This is the value of the unique primary identifier of the eso_routine table. It is an internal system assigned number.
SCRIPT VARCHAR(50) Y Script Name. If the routine field is either GENERIC_SCRIPT_USE_REPLY or GENERIC_SCRIPT_USE_CTX, then this field should be valued.
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_ROUTINE




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