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 |