Table Detail Report
OPS2_STEP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Operations Step |
Definition: | The operations step table stores information about a step and its default parameter values. A step relates one to one with a request defined in Application Registration. |
Table Type: | REFERENCE |
Column Detail - OPS2_STEP
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. |
BATCH_SELECTION_TXT | VARCHAR(2000) | Y | User input parameters for the request 'batch selection' field. |
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. |
ERROR_IF_EMPTY_IND | DOUBLE | N | Indicates if no data is returned from the request, should the step be reported as a success or error. |
OPERATOR_MSG_TXT | VARCHAR(100) | Y | A message to be communicated to the 'operator'. |
OPS2_JOB_ID | DOUBLE | N | Foreign key to OPS2_JOB. Indicates to which job or job within a job group this step belongs. |
OPS2_STEP_ID | DOUBLE | N | Unique generated number that identifies a single row on the OPS2_STEP table. |
OPS2_STEP_TEMPLATE_ID | DOUBLE | N | Foreign key to OPS2_STEP_TEMPLATE. Indicates to which step template this step was originally created from. |
ORIG_OPS2_STEP_ID | DOUBLE | N | This field is used to track versions of the steps. 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. |
OUTPUT_DISTRIBUTION_TXT | VARCHAR(100) | Y | User input parameters for the request 'output distribution' field. |
REQUEST_NAME | VARCHAR(100) | N | The request name that this step executes. |
REQUEST_NBR | DOUBLE | N | The request number that this step executes. |
STEP_SEQ | DOUBLE | N | Number to order the sequence of steps within a job. |
STOP_JOB_ON_ERROR_IND | DOUBLE | N | Indicates if the entire job should stop further executing if this step fails (STOP_JOB_ON_ERROR_IND = 1) or continue executing (STOP_JOB_ON_ERROR_IND = 0). |
THRESHOLD_IND | DOUBLE | N | Indicates if the elapsed time for this step should be monitored. |
THRESHOLD_PCT | DOUBLE | N | The percentage over the step's average elapsed time at which a threshold alert should be reported. |
TIME_ZONE_TXT | VARCHAR(100) | Y | The time zone context to be provided when executing the request of the step. This is often used by reporting solutions to provide the context in which date and time values should be formated. |
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_STEP
Child Column in OPS2_STEP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OPS2_JOB_ID | OPS2_JOB | OPS2_JOB_ID |
ORIG_OPS2_STEP_ID | OPS2_STEP | OPS2_STEP_ID | |
OPS2_STEP_TEMPLATE_ID | OPS2_STEP_TEMPLATE | OPS2_STEP_TEMPLATE_ID |
Parent Column in OPS2_STEP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OPS2_STEP_ID | OPS2_SCHED_STEP | OPS2_STEP_ID |
OPS2_STEP | ORIG_OPS2_STEP_ID |
OPS2_STEP_TEMPLATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Operations Step Template |
Definition: | Template available to create a step |
Table Type: | REFERENCE |
Column Detail - OPS2_STEP_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. |
BATCH_SELECTION_TXT | VARCHAR(2000) | Y | User input parameters for the request 'batch selection' field. |
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. |
ERROR_IF_EMPTY_IND | DOUBLE | N | Indicates if no data is returned from the request, should the step be reported as a success or error. |
OPERATOR_MSG_TXT | VARCHAR(100) | N | A message to be communicated to the 'operator'. |
OPS2_JOB_TEMPLATE_ID | DOUBLE | N | Foreign key to OPS2_JOB_TEMPLATE. Indicates to which job template this step template belongs. |
OPS2_STEP_TEMPLATE_ID | DOUBLE | N | Unique, generated number that identifies a single row on the OPS2_STEP_TEMPLATE table. |
ORIG_OPS2_STEP_TEMPLATE_ID | DOUBLE | N | This field is used to track versions of the step 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. |
OUTPUT_DISTRIBUTION_TXT | VARCHAR(100) | Y | User input parameters for the request 'output distribution' field. |
REQUEST_NAME | VARCHAR(100) | N | The request name that this step executes. |
REQUEST_NBR | DOUBLE | N | The request number that this step executes. |
STEP_SEQ | DOUBLE | N | Number to order the sequence of steps within a job. |
STOP_JOB_ON_ERROR_IND | DOUBLE | N | Indicates if the entire job should stop further executing if this step fails (STOP_JOB_ON_ERROR_IND = 1) or continue executing (STOP_JOB_ON_ERROR_IND = 0). |
TIME_ZONE_TXT | VARCHAR(100) | Y | The time zone context to be provided when executing the request of the step. This is often used by reporting solutions to provide the context in which date and time values should be formated. |
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_STEP_TEMPLATE
Child Column in OPS2_STEP_TEMPLATE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OPS2_JOB_TEMPLATE_ID | OPS2_JOB_TEMPLATE | OPS2_JOB_TEMPLATE_ID |
ORIG_OPS2_STEP_TEMPLATE_ID | OPS2_STEP_TEMPLATE | OPS2_STEP_TEMPLATE_ID |
Parent Column in OPS2_STEP_TEMPLATE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OPS2_STEP_TEMPLATE_ID | OPS2_STEP | OPS2_STEP_TEMPLATE_ID |
OPS2_STEP_TEMPLATE | ORIG_OPS2_STEP_TEMPLATE_ID |
OPS2_WEEK_OF_MONTH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Operations Week of Month |
Definition: | The operations week of month table stores the week of the month that a job is scheduled to run. |
Table Type: | REFERENCE |
Column Detail - OPS2_WEEK_OF_MONTH
Column Name | Type | Null? | Definition |
---|---|---|---|
OPS2_WEEK_OF_MONTH_ID | DOUBLE | N | Unique generated number that identifies a single row on the OPS2_WEEK_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. |
WEEK_NBR_TXT | VARCHAR(100) | N | Indicates the week of month. Possibilities are 1-4, Last, Repeat |
Relationship Detail - OPS2_WEEK_OF_MONTH
Parent Column in OPS2_WEEK_OF_MONTH (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OPS2_WEEK_OF_MONTH_ID | OPS2_DEPENDENCY_RELTN | OPS2_WEEK_OF_MONTH_ID |
OPS2_JOB_SCHED | OPS2_WEEK_OF_MONTH_ID |
OPS_CONTROL_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 tasks grouped within that control group. |
Table Type: | REFERENCE |
Column Detail - OPS_CONTROL_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
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. |
ENABLE_IND | DOUBLE | Y | Indicates if this control group is available for initialization by the OpsExec Server or not. |
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. |
FAILOVER_HOST | VARCHAR(40) | Y | Name of the node the failover server for this control group will run on if the main server goes down. |
FAILOVER_IND | DOUBLE | Y | Indicates if the failover server is processing the control group at the current time. |
FAILOVER_SERVER_NUMBER | DOUBLE | Y | The SCP server entry id created for the failover server for this control group. |
HOST | VARCHAR(40) | Y | Name of the node the server for this control group runs on. |
NAME | VARCHAR(40) | N | Name of the control group. |
OPS_CONTROL_GRP_ID | DOUBLE | N | Unique identifier for control group records. |
PURGE_DAYS | DOUBLE | Y | Number of days until the scheduled/activity records for this control group will be deleted (compared to the scheduled date and time of the scheduled/activity record) |
SERVER_NUMBER | DOUBLE | Y | The SCP server entry id created for the server for this control group. |
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 - OPS_CONTROL_GROUP
Parent Column in OPS_CONTROL_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OPS_CONTROL_GRP_ID | OPS_SCHEDULE_CONTROL_GROUP | OPS_CONTROL_GRP_ID |
OPS_TASK | OPS_CONTROL_GRP_ID |
OPS_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 task is scheduled to run. |
Table Type: | REFERENCE |
Column Detail - OPS_DAY_OF_MONTH
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
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. |
DAY_OF_MONTH | DOUBLE | Y | Indicates the day of month. |
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. |
OPS_DAY_OF_MONTH_ID | DOUBLE | N | Unique identifier for a day of month record. |
OPS_JOB_VERIFY_ID | DOUBLE | N | Foreign key to ops_job_verify. Indicates to which dependency this day of month belongs. |
OPS_TASK_ID | DOUBLE | N | Foreign key to OPS_TASK. Indicates to which task this day of month belongs. |
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 - OPS_DAY_OF_MONTH
Child Column in OPS_DAY_OF_MONTH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OPS_JOB_VERIFY_ID | OPS_JOB_VERIFY | OPS_JOB_VERIFY_ID |
OPS_TASK_ID | OPS_TASK | OPS_TASK_ID |