Table Detail Report

OPS2_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job
Definition: The operations job table stores information about a job and its default parameter values.
Table Type: REFERENCE





Column Detail - OPS2_JOB


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.
AUTOSTART_IND DOUBLE N Indicates if the OpsExec server will automatically start processing this job at its scheduled time or wait until a user manually starts the job via the Operations front-end tools.
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.
ENABLED_IND DOUBLE N Indicates if this job 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.
JOB_NAME VARCHAR(50) N The name of the job.
JOB_SEQ DOUBLE N For jobs within a job group, a number that orders the sequence of jobs within the job group.
OPS2_CTRL_GROUP_ID DOUBLE N Foreign key to OPS2_CTRL_GROUP. Indicates to which control group this job or job within a job group belongs.
OPS2_JOB_GROUP_ID DOUBLE N Foreign key to OPS2_JOB_GROUP. Indicates to which job group this job belongs.
OPS2_JOB_ID DOUBLE N Unique, generated number that identifies a single row on the OPS2_JOB table.
OPS2_JOB_TEMPLATE_ID DOUBLE N Foreign key to OPS2_JOB_TEMPLATE. Indicates to which job template this job or job within a job group was originally created from.
ORIG_OPS2_JOB_ID DOUBLE N This field is used to track versions of the jobs. 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.
THRESHOLD_IND DOUBLE N Indicates if the elapsed time for this job should be monitored.
THRESHOLD_PCT DOUBLE N The percentage over the job's average elapsed time at which a threshold alert should be reported.
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_JOB


Child Column in OPS2_JOB(FK) Parent Table Name Parent Column Name
Parents: OPS2_CTRL_GROUP_ID OPS2_CTRL_GROUP OPS2_CTRL_GROUP_ID
ORIG_OPS2_JOB_ID OPS2_JOB OPS2_JOB_ID
OPS2_JOB_GROUP_ID OPS2_JOB_GROUP OPS2_JOB_GROUP_ID
OPS2_JOB_TEMPLATE_ID OPS2_JOB_TEMPLATE OPS2_JOB_TEMPLATE_ID




Parent Column in OPS2_JOB (PK) Child Table Name Child Column Name
Children: OPS2_JOB_ID OPS2_JOB ORIG_OPS2_JOB_ID
OPS2_JOB_SCHED OPS2_JOB_ID
OPS2_SCHED_JOB OPS2_JOB_ID
OPS2_STEP OPS2_JOB_ID


OPS2_JOB_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job Group
Definition: The operations job group table stores information about a job group and its default parameter values.
Table Type: REFERENCE





Column Detail - OPS2_JOB_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.
AUTOSTART_IND DOUBLE N Indicates if the OpsExec server will automatically start processing this job group at its scheduled time or wait until a user manually starts the job group via the Operations front-end tools.
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.
ENABLED_IND DOUBLE N Indicates if this job 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.
JOB_GROUP_NAME VARCHAR(50) N The name of the job group.
OPS2_CTRL_GROUP_ID DOUBLE N Foreign key from the OPS2_CTRL_GROUP table. Identifies the Control Group that this Job Group is a part of.
OPS2_JOB_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_JOB_GROUP table.
ORIG_OPS2_JOB_GROUP_ID DOUBLE N This field is used to track versions of the job 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.
THRESHOLD_IND DOUBLE N Indicates if the elapsed time for this job group that should be monitored.
THRESHOLD_PCT DOUBLE N The percentage over the job group's average elapsed time at which a threshold alert should be reported.
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_JOB_GROUP


Child Column in OPS2_JOB_GROUP(FK) Parent Table Name Parent Column Name
Parents: OPS2_CTRL_GROUP_ID OPS2_CTRL_GROUP OPS2_CTRL_GROUP_ID
ORIG_OPS2_JOB_GROUP_ID OPS2_JOB_GROUP OPS2_JOB_GROUP_ID




Parent Column in OPS2_JOB_GROUP (PK) Child Table Name Child Column Name
Children: OPS2_JOB_GROUP_ID OPS2_JOB OPS2_JOB_GROUP_ID
OPS2_JOB_GROUP ORIG_OPS2_JOB_GROUP_ID
OPS2_JOB_SCHED OPS2_JOB_GROUP_ID
OPS2_SCHED_JOB_GROUP OPS2_JOB_GROUP_ID


OPS2_JOB_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job Schedule
Definition: The operations job schedule table stores information about the schedule of a job group or a job. A schedule relates one to one with a job group or job, never both.
Table Type: REFERENCE





Column Detail - OPS2_JOB_SCHED


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 scheduled item. 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 jobs.
END_DATE_DT_TM DATETIME Y The last day the scheduled item will occur.
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.
END_TIME_DT_TM DATETIME Y For scheduled items that occur more than once in a single day, the last time of the day that the scheduled item will occur.
OPS2_DAY_OF_MONTH_ID DOUBLE N Foreign key to OPS2_DAY_OF_MONTH. Indicates which days of the month this schedule applies.
OPS2_DAY_OF_WEEK_ID DOUBLE N Foreign key to OPS2_DAY_OF_WEEK. Indicates which days of the week this schedule applies.
OPS2_JOB_GROUP_ID DOUBLE N Foreign key to OPS2_JOB_GROUP. Indicates to which job group this schedule applies.
OPS2_JOB_ID DOUBLE N Foreign key to OPS2_JOB. Indicates to which job or job within a job group this schedule applies.
OPS2_JOB_SCHED_ID DOUBLE N Unique, generated number that identifies a single row on the OPS2_JOB_SCHED table.
OPS2_MONTH_OF_YEAR_ID DOUBLE N Foreign key to OPS2_MONTH_OF_YEAR. Indicates which months of the year this schedule applies.
OPS2_WEEK_OF_MONTH_ID DOUBLE N Foreign key to OPS2_WEEK_OF_MONTH. Indicates which weeks of the month this schedule applies.
ORIG_OPS2_JOB_SCHED_ID DOUBLE N This field is used to track versions of the job schedules. 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.
START_DATE_DT_TM DATETIME Y The first day the scheduled item will occur.
START_TIME_DT_TM DATETIME N The first time of the day that the scheduled item will occur.
TIME_RECUR_INTERVAL_NBR DOUBLE N For scheduled items that occur more than once in a single day, the interval between each occurrence in a day of the scheduled item. The unit of measurement for how this value is interpreted, is defined by TIME_RECUR_INTERVAL_UOM_TXT.
TIME_RECUR_INTERVAL_UOM_TXT VARCHAR(10) N Indicates if a scheduled item occurs more than once in a single day, and if so, what unit of measurement is being used to signify the interval between occurrences. The schedule item may recur by the hour (TIME_RECUR_INTERVAL_UOM_TXT = 'H'), by the minute (TIME_RECUR_INTERVAL_UOM_TXT = 'M'), or not at all (TIME_RECUR_INTERVAL_UOM_TXT = '').
TIME_RECUR_SKIP_OVERDUE_IND DOUBLE N For scheduled items that occur more than once in a single day, indicates if redundant occurrences of the item should be automatically skipped if multiple occurrences are found to be overdue (TIME_RECUR_SKIP_OVERDUE_IND = 1) or be redundantly executed (TIME_RECUR_SKIP_OVERDUE_IND = 0).
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_JOB_SCHED


Child Column in OPS2_JOB_SCHED(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
OPS2_JOB_ID OPS2_JOB OPS2_JOB_ID
OPS2_JOB_GROUP_ID OPS2_JOB_GROUP OPS2_JOB_GROUP_ID
ORIG_OPS2_JOB_SCHED_ID OPS2_JOB_SCHED OPS2_JOB_SCHED_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_JOB_SCHED (PK) Child Table Name Child Column Name
Children: OPS2_JOB_SCHED_ID OPS2_JOB_SCHED ORIG_OPS2_JOB_SCHED_ID


OPS2_JOB_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job Template
Definition: The operations job template table stores information about the available templates for creating a job and its default parameter values.
Table Type: REFERENCE





Column Detail - OPS2_JOB_TEMPLATE


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.
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_JOB_TEMPLATE_ID DOUBLE N Unique, generated number that identifies a single row on the OPS2_JOB_TEMPLATE table.
ORIG_OPS2_JOB_TEMPLATE_ID DOUBLE N This field is used to track versions of the job templates. 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.
TEMPLATE_NAME VARCHAR(40) N The name of the template to create a job.
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_JOB_TEMPLATE


Child Column in OPS2_JOB_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: ORIG_OPS2_JOB_TEMPLATE_ID OPS2_JOB_TEMPLATE OPS2_JOB_TEMPLATE_ID




Parent Column in OPS2_JOB_TEMPLATE (PK) Child Table Name Child Column Name
Children: OPS2_JOB_TEMPLATE_ID OPS2_JOB OPS2_JOB_TEMPLATE_ID
OPS2_JOB_TEMPLATE ORIG_OPS2_JOB_TEMPLATE_ID
OPS2_STEP_TEMPLATE OPS2_JOB_TEMPLATE_ID


OPS2_MONTH_OF_YEAR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Month of Year
Definition: The operations month of year table stores the months of the year that a job is scheduled to run.
Table Type: REFERENCE





Column Detail - OPS2_MONTH_OF_YEAR


Column Name Type Null? Definition
MONTH_NBR_TXT VARCHAR(100) N Indicates the month of year. Possibilities are 1-12 and All Months.
OPS2_MONTH_OF_YEAR_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_MONTH_OF_YEAR 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_MONTH_OF_YEAR




Parent Column in OPS2_MONTH_OF_YEAR (PK) Child Table Name Child Column Name
Children: OPS2_MONTH_OF_YEAR_ID OPS2_DEPENDENCY_RELTN OPS2_MONTH_OF_YEAR_ID
OPS2_JOB_SCHED OPS2_MONTH_OF_YEAR_ID