Table Detail Report

OPS_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 task is scheduled to run.
Table Type: REFERENCE





Column Detail - OPS_DAY_OF_WEEK


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_WEEK DOUBLE Y Indicates the day of week.
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_WEEK_ID DOUBLE N Unique identifier for a day of week record.
OPS_JOB_VERIFY_ID DOUBLE N Foreign key to ops_job_verify. Indicates to which dependency this day of week belongs.
OPS_TASK_ID DOUBLE N Foreign key to OPS_TASK. Indicates to which task this day of week 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_WEEK


Child Column in OPS_DAY_OF_WEEK(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


OPS_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job
Definition: The operations job table stores information about a job. A job is a grouping of steps.
Table Type: REFERENCE





Column Detail - OPS_JOB


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.
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.
NAME VARCHAR(40) N Name of the job.
OPS_JOB_ID DOUBLE N Unique identifier of a job record.
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_JOB




Parent Column in OPS_JOB (PK) Child Table Name Child Column Name
Children: OPS_JOB_ID OPS_JOB_STEP OPS_JOB_ID
OPS_TASK OPS_JOB_ID


OPS_JOB_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job Step
Definition: The operations job 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. The parameters are Output_Dist, Message, and Batch_Selection.
Table Type: REFERENCE





Column Detail - OPS_JOB_STEP


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.
BATCH_SELECTION VARCHAR(2000) Y The default parameter value for batch selection.
BATCH_SELECTION_IND DOUBLE Y Indicates if this step has a batch selection parameter or not.
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.
MESSAGE VARCHAR(100) Y The default parameter value for batch selection.
OPS_DATE_IND DOUBLE Y Indicates if this step has an operations date parameter or not.
OPS_JOB_ID DOUBLE N Foreign key to OPS_JOB. Indicates which job this step belongs to.
OPS_JOB_STEP_ID DOUBLE N Unique identifier for a step record.
OUTPUT_DIST VARCHAR(100) Y The default parameter value for batch selection.
OUTPUT_DIST_IND DOUBLE Y Indicates if this step has an output distribution parameter or not.
REQUEST_NUMBER DOUBLE Y The request number of the request assigned to the step.
SEVERITY_IND DOUBLE Y Indicates if the OpsExec server will stop processing the job if this step returns an error or if it will continue with the next step.
STEP_NAME VARCHAR(100) Y The name of the request assigned to the step.
STEP_NUMBER DOUBLE Y Number to order the sequence of steps within a job.
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.
Z_IND DOUBLE Y Indicates if no data is returned form the request should be translated as an error or success.



Relationship Detail - OPS_JOB_STEP


Child Column in OPS_JOB_STEP(FK) Parent Table Name Parent Column Name
Parents: OPS_JOB_ID OPS_JOB OPS_JOB_ID




Parent Column in OPS_JOB_STEP (PK) Child Table Name Child Column Name
Children: OPS_JOB_STEP_ID OPS_JOB_VERIFY D_STEP_ID
OPS_JOB_VERIFY T_STEP_ID
OPS_SCHEDULE_JOB_STEP OPS_JOB_STEP_ID
OPS_SCHEDULE_PARAM OPS_JOB_STEP_ID


OPS_JOB_VERIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Job Verify
Definition: The operations job verify table stores job dependencies. JobA is dependent upon Job1 if Job1 must finish executing with a specific status before JobA can start.
Table Type: REFERENCE





Column Detail - OPS_JOB_VERIFY


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 Y 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 Y The person who caused the active_status_cd to be set or change.
ALLMATCH_IND DOUBLE Y Indicates if the dependency is enforced for all scheduled instances of the dependent or just a few.
BEG_EFFECTIVE_DT_TM DATETIME Y 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_INTERVAL DOUBLE Y If a dependency is enforced for just a few scheduled instances of the dependent and the dependent's schedule is either daily or weekly, this value determines the daily interval for the enforcement schedule.
DEP_DT_TM DATETIME Y not used
DEP_JOB_STEP_ID DOUBLE Y Not used
DEP_TASK_ID DOUBLE Y not used
D_JJG_DT_TM DATETIME Y The start time of the dependent job within a job group.
D_STEP_ID DOUBLE Y ops_job_step_id of the dependent step
D_TASK_DT_TM DATETIME Y The scheduled time of the dependent task
D_TASK_ID DOUBLE N ops_task_id of the dependent task
END_EFFECTIVE_DT_TM DATETIME Y 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.
FAIL_IND DOUBLE Y Determines whether the dependent will run if a trigger completes (fail_ind = 0) or errors (fail_ind = 1).
LEVEL_TYPE DOUBLE Y not used
OPS_JOB_VERIFY_ID DOUBLE N Unique identifier for a dependency record.
SAMEDAY_IND DOUBLE Y Determines if the trigger runs the same day as the dependent (sameday_ind = 1) or if the trigger runs the day before the dependent (sameday_ind = 0)
SKIP_IND DOUBLE Y Indicates whether the dependent is skipped (skip_ind = 1) or not (skip_ind = 0) if the trigger status is not satisfied.
TRIG_DT_TM DATETIME Y not used
TRIG_JOB_STEP_ID DOUBLE Y not used
TRIG_TASK_ID DOUBLE Y not used
T_JJG_DT_TM DATETIME Y Start time of the trigger job within a job group.
T_STEP_ID DOUBLE Y ops_job_step_id of the trigger step
T_TASK_DT_TM DATETIME Y The scheduled time of the triggering task
T_TASK_ID DOUBLE N The ops_task_id of the triggering task.
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_JOB_VERIFY


Child Column in OPS_JOB_VERIFY(FK) Parent Table Name Parent Column Name
Parents: D_STEP_ID OPS_JOB_STEP OPS_JOB_STEP_ID
T_STEP_ID OPS_JOB_STEP OPS_JOB_STEP_ID
D_TASK_ID OPS_TASK OPS_TASK_ID
T_TASK_ID OPS_TASK OPS_TASK_ID




Parent Column in OPS_JOB_VERIFY (PK) Child Table Name Child Column Name
Children: OPS_JOB_VERIFY_ID OPS_DAY_OF_MONTH OPS_JOB_VERIFY_ID
OPS_DAY_OF_WEEK OPS_JOB_VERIFY_ID
OPS_MONTH_OF_YEAR OPS_JOB_VERIFY_ID
OPS_WEEK_OF_MONTH OPS_JOB_VERIFY_ID


OPS_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 task is scheduled to run.
Table Type: REFERENCE





Column Detail - OPS_MONTH_OF_YEAR


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.
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.
MONTH_OF_YEAR DOUBLE Y Indicates the month of year.
OPS_JOB_VERIFY_ID DOUBLE N Foreign key to ops_job_verify. Indicates to which dependency this month of year belongs.
OPS_MONTH_OF_YEAR_ID DOUBLE N Unique identifier for a month of year record.
OPS_TASK_ID DOUBLE N Foreign key to OPS_TASK. Indicates to which task this month of year 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_MONTH_OF_YEAR


Child Column in OPS_MONTH_OF_YEAR(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