OPS2_AVG_RUNTIME



Column Section Top of Page


Table-level Detail

Description: Operations Average Runtime
Definition: The operations average runtime table stores information about a job group's, job's, or step's average execution times.
Table Type: ACTIVITY





Column Detail - OPS2_AVG_RUNTIME


Column Name Type Null? Definition
BEG_AVG_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.
END_AVG_DT_TM DATETIME N The date and time after which this table row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INITIAL_RUNTIME_SECS DOUBLE N The total runtime of the parent object's execution that resulted in the creation of this table row.
OPS2_AVG_RUNTIME_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_AVG_RUNTIME table.
PARENT_ENTITY_ID DOUBLE N Identifies the parent object for this row.
PARENT_ENTITY_NAME VARCHAR(32) N The name of the table that contains the parent object.
RUNTIME_AVG_SECS DOUBLE N The average runtime (in seconds) of the parent object.
RUNTIME_OCCURRENCE_NBR DOUBLE N Number signifying how many times this average has been computed. Not necessarily the number of occurrences used in computing the average, but rather the total number of times the average has been computed.
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.


OPS2_CTRL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Control Group
Definition: The operations control group table stores information about a control group. A control group relates one to one with an operations server that processes scheduled jobs grouped within that control group.
Table Type: REFERENCE





Column Detail - OPS2_CTRL_GROUP


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.
CTRL_GROUP_NAME VARCHAR(40) N The name of the control group.
ENABLED_IND DOUBLE N Indicates if this control group is eligible to run.
END_EFFECTIVE_DT_TM DATETIME N 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.
EXTERNAL_USERNAME VARCHAR(100) Y The name of the non-Millennium (e.g. Olympus) user that modified the record.
HOST_NAME VARCHAR(40) N The host/node for which this control group's server will run on.
OPS2_CTRL_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_CTRL_GROUP table.
ORIG_OPS2_CTRL_GROUP_ID DOUBLE N This field is used to track versions of the Control Groups. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PROCESS_START_DT_TM DATETIME N The day the control group begins processing the schedule.
PURGE_DAYS_NBR DOUBLE N Number of days until the scheduled activity records for this control group will be deleted. This field is compared to the scheduled date and time of the scheduled activity record.
SERVER_ENTRY_NBR DOUBLE N The SCP entry ID backing this control group's server.
TIME_ZONE_TXT VARCHAR(100) Y The time zone context of the entire control group's schedule. Represents the time zone context for which scheduled items are assumed to have been configured under. This is strictly the context for which a scheduled item's configuration will be interpreted, but not necessarily the time zone in which the scheduled item will be executed from.
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 - OPS2_CTRL_GROUP


Child Column in OPS2_CTRL_GROUP(FK) Parent Table Name Parent Column Name
Parents: ORIG_OPS2_CTRL_GROUP_ID OPS2_CTRL_GROUP OPS2_CTRL_GROUP_ID




Parent Column in OPS2_CTRL_GROUP (PK) Child Table Name Child Column Name
Children: OPS2_CTRL_GROUP_ID OPS2_CTRL_GROUP ORIG_OPS2_CTRL_GROUP_ID
OPS2_JOB OPS2_CTRL_GROUP_ID
OPS2_JOB_GROUP OPS2_CTRL_GROUP_ID
OPS2_SCHED_CTRL_GROUP OPS2_CTRL_GROUP_ID


OPS2_DAY_OF_MONTH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Day of Month
Definition: The operations day of month table stores the days of the month that a job is scheduled to run.
Table Type: REFERENCE





Column Detail - OPS2_DAY_OF_MONTH


Column Name Type Null? Definition
DAY_NBR_TXT VARCHAR(100) N Indicates the day of the month. Possibilities are the number 1- 31, Last, Repeat.
OPS2_DAY_OF_MONTH_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_DAY_OF_MONTH table.
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 - OPS2_DAY_OF_MONTH




Parent Column in OPS2_DAY_OF_MONTH (PK) Child Table Name Child Column Name
Children: OPS2_DAY_OF_MONTH_ID OPS2_DEPENDENCY_RELTN OPS2_DAY_OF_MONTH_ID
OPS2_JOB_SCHED OPS2_DAY_OF_MONTH_ID


OPS2_DAY_OF_WEEK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Day of Week
Definition: The operations day of week table stores the days of the week that a job is scheduled to run. Possibilities are: 1-7, MWF,Etc.,
Table Type: REFERENCE





Column Detail - OPS2_DAY_OF_WEEK


Column Name Type Null? Definition
DAY_NBR_TXT VARCHAR(100) N Indicates the day of week. Possibilities are 1-7, MWF, etc.
OPS2_DAY_OF_WEEK_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_DAY_OF_WEEK table.
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 - OPS2_DAY_OF_WEEK




Parent Column in OPS2_DAY_OF_WEEK (PK) Child Table Name Child Column Name
Children: OPS2_DAY_OF_WEEK_ID OPS2_DEPENDENCY_RELTN OPS2_DAY_OF_WEEK_ID
OPS2_JOB_SCHED OPS2_DAY_OF_WEEK_ID


OPS2_DEPENDENCY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Dependency Relation
Definition: The operations dependency table stores the information about a dependency that exists between:- Jobs and other jobs not in the same Job Group- Job Groups and other Job Groups- Job Groups and Jobs that are not in the same Job Group- Job Groups and Steps that are not in the same Job Group- Jobs and Steps that are not in the same Job- Steps and other Steps that are not in the same Job
Table Type: REFERENCE





Column Detail - OPS2_DEPENDENCY_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.
DATE_RECUR_INTERVAL_NBR DOUBLE N The interval between each occurrence of the dependency. The unit of measurement for how this value is interpreted, flexes based on the schedule type. For example, this value will be an interval of days for daily dependencies.
DEP_CRITERIA_FLAG DOUBLE N The criteria that must be satisfied by the 'trigger item' of the dependency, in order for the 'dependent item' to be automatically executed. The dependency may be configured to execute on errors only (DEP_CRITERIA_FLAG = 0), on success only (DEP_CRITERIA_FLAG = 1), or both (DEP_CRITERIA_FLAG = 2).
DEP_JOB_GROUP_START_DT_TM DATETIME Y The start time for the specific occurrence of the job group representing the 'dependent item' for which this dependency applies.
DEP_JOB_START_DT_TM DATETIME Y The start time for the specific occurrence of the job or job within a job group representing the 'dependent item' for which this dependency applies.
DEP_PARENT_ENTITY_ID DOUBLE N Identifies the dependent object for the triggering object on this row.
DEP_PARENT_ENTITY_NAME VARCHAR(32) N The name of the dependent table that contains the object that is the dependent object.
END_EFFECTIVE_DT_TM DATETIME N 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.
EXTERNAL_USERNAME VARCHAR(100) Y The name of the non-Millennium (e.g. Olympus) user that modified the record.
OPS2_DAY_OF_MONTH_ID DOUBLE N Foreign key to OPS2_DAY_OF_MONTH. Indicates which days of the month this dependency applies.
OPS2_DAY_OF_WEEK_ID DOUBLE N Foreign key to OPS2_DAY_OF_WEEK. Indicates which days of the week this dependency applies.
OPS2_DEPENDENCY_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the OPS2_DEPENDENCY_RELTN table.
OPS2_MONTH_OF_YEAR_ID DOUBLE N Foreign key to OPS2_MONTH_OF_YEAR. Indicates which months of the year this dependency applies.
OPS2_WEEK_OF_MONTH_ID DOUBLE N Foreign key to OPS2_WEEK_OF_MONTH. Indicates which weeks of the month this dependency applies.
ORIG_OPS2_DEPENDENCY_RELTN_ID DOUBLE N This field is used to track versions of the Dependency relationships. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
SAME_DAY_IND DOUBLE N Indicates if the 'dependent item' of the dependency will execute on the same day as the 'trigger item' (SAME_DAY_IND = 1) or the next day (SAME_DAY_IND = 0).
SKIP_IF_FAILED_IND DOUBLE N Indicates if the 'dependent item' of the dependency should be automatically skipped if the dependency criteria (i.e. DEP_CRITERIA_FLAG) is not satisfied (SKIP_IF_FAILED_IND = 1), or wait for a user to resolve the situation (SKIP_IF_FAILED_IND = 0).
TRIGGER_JOB_GROUP_START_DT_TM DATETIME Y The start time for the specific occurrence of the job group representing the 'trigger item' for which this dependency applies.
TRIGGER_JOB_START_DT_TM DATETIME Y The start time for the specific occurrence of the job or job within a job group representing the 'trigger item' for which this dependency applies.
TRIGGER_PARENT_ENTITY_ID DOUBLE N Identifies the trigger item for the dependent object on this row.
TRIGGER_PARENT_ENTITY_NAME VARCHAR(32) N The name of the table that contains the object that is the trigger item.
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 - OPS2_DEPENDENCY_RELTN


Child Column in OPS2_DEPENDENCY_RELTN(FK) Parent Table Name Parent Column Name
Parents: OPS2_DAY_OF_MONTH_ID OPS2_DAY_OF_MONTH OPS2_DAY_OF_MONTH_ID
OPS2_DAY_OF_WEEK_ID OPS2_DAY_OF_WEEK OPS2_DAY_OF_WEEK_ID
ORIG_OPS2_DEPENDENCY_RELTN_ID OPS2_DEPENDENCY_RELTN OPS2_DEPENDENCY_RELTN_ID
OPS2_MONTH_OF_YEAR_ID OPS2_MONTH_OF_YEAR OPS2_MONTH_OF_YEAR_ID
OPS2_WEEK_OF_MONTH_ID OPS2_WEEK_OF_MONTH OPS2_WEEK_OF_MONTH_ID




Parent Column in OPS2_DEPENDENCY_RELTN (PK) Child Table Name Child Column Name
Children: OPS2_DEPENDENCY_RELTN_ID OPS2_DEPENDENCY_RELTN ORIG_OPS2_DEPENDENCY_RELTN_ID
OPS2_SCHED_DEPENDENCY_R OPS2_DEPENDENCY_RELTN_ID