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 |