Table Detail Report

OPS_SCHEDULE_CONTROL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Schedule Control Group
Definition: The operations schedule control group table stores information about a control group that has been initialized for a particular operations date.
Table Type: ACTIVITY





Column Detail - OPS_SCHEDULE_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.
EMPTY_IND DOUBLE Y Indicates whether the scheduled control group contains any scheduled tasks 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.
INIT_FLAG DOUBLE Y Indicates the initialization status of the scheduled control group.
OPS_CONTROL_GRP_ID DOUBLE N Foreign key to OPS_CONTROL_GROUP. Indicates to which control group this scheduled control group relates.
OPS_SCHEDULE_CONTROL_GRP_ID DOUBLE N Unique identifier for a scheduled control group record.
SCHEDULE_DT_TM DATETIME N Date portion contains the operations date this scheduled control group has been created for. Time portion has no use.
STATUS_CD DOUBLE N Foreign key to CODE_VALUE. State of the scheduled 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_SCHEDULE_CONTROL_GROUP


Child Column in OPS_SCHEDULE_CONTROL_GROUP(FK) Parent Table Name Parent Column Name
Parents: OPS_CONTROL_GRP_ID OPS_CONTROL_GROUP OPS_CONTROL_GRP_ID




Parent Column in OPS_SCHEDULE_CONTROL_GROUP (PK) Child Table Name Child Column Name
Children: OPS_SCHEDULE_CONTROL_GRP_ID OPS_SCHEDULE_TASK OPS_SCHEDULE_CONTROL_GRP_ID


OPS_SCHEDULE_JOB_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Schedule Job Step
Definition: The operations schedule job step table stores information about a step that has been initialized for a particular operations date.
Table Type: ACTIVITY





Column Detail - OPS_SCHEDULE_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.
AVG_DT_TM DATETIME Y The average time is the offset between the scheduled task schedule_dt_tm and avg_dt_tm (thresh_dt_tm - avg_dt_tm)
AVG_FLAG DOUBLE Y 0 = no average has been calculated. 1 = Runtimes < 5. 2 = average is calculated, but threshold is not applicable. 3 = average is calculated, threshold is calculated.
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.
OPS_EVENT VARCHAR(100) Y Stores run-time errors or information for the scheduled step.
OPS_JOB_STEP_ID DOUBLE N Foreign key to OPS_JOB_STEP. Indicates which step this scheduled step relates.
OPS_SCHEDULE_JOB_STEP_ID DOUBLE N Unique identifier for a scheduled step record.
OPS_SCHEDULE_TASK_ID DOUBLE N Foreign key to OPS_SCHEDULE_TASK. Indicates to which scheduled task this scheduled step belongs.
STATUS_CD DOUBLE N Foreign key to CODE_VALUE. State of the scheduled step.
THRESH_DT_TM DATETIME Y The threshold time is the offset between the scheduled task schedule_dt_tm and thresh_dt_tm (schedule_dt_tm - thresh_dt_tm).
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_SCHEDULE_JOB_STEP


Child Column in OPS_SCHEDULE_JOB_STEP(FK) Parent Table Name Parent Column Name
Parents: OPS_JOB_STEP_ID OPS_JOB_STEP OPS_JOB_STEP_ID
OPS_SCHEDULE_TASK_ID OPS_SCHEDULE_TASK OPS_SCHEDULE_TASK_ID




Parent Column in OPS_SCHEDULE_JOB_STEP (PK) Child Table Name Child Column Name
Children: OPS_SCHEDULE_JOB_STEP_ID OPS_SCHED_DEP D_SCHED_STEP_ID
OPS_SCHED_DEP T_SCHED_STEP_ID


OPS_SCHEDULE_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Schedule Parameter
Definition: The operations schedule parameter table stores the scheduled parameter values for each step. These are the parameter values that will be used at execution time.
Table Type: REFERENCE





Column Detail - OPS_SCHEDULE_PARAM


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 scheduled parameter value for batch selection.
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 scheduled parameter value for message.
OPS_JOB_STEP_ID DOUBLE N Foreign key to OPS_JOB_STEP. Indicates which step this parameter belongs to.
OPS_SCHEDULE_PARAM_ID DOUBLE N Unique identifier for a scheduled parameter record.
OPS_TASK_ID DOUBLE N Foreign key to OPS_TASK. Indicates which task this parameter belongs to.
OUTPUT_DIST VARCHAR(100) Y The scheduled parameter value for output distribution.
THRESH_IND DOUBLE Y Indicates if the threshold for the scheduled step should be monitored or not.
THRESH_PERCENT DOUBLE Y The percentage over average elapsed time that the threshold time is set.
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_SCHEDULE_PARAM


Child Column in OPS_SCHEDULE_PARAM(FK) Parent Table Name Parent Column Name
Parents: OPS_JOB_STEP_ID OPS_JOB_STEP OPS_JOB_STEP_ID
OPS_TASK_ID OPS_TASK OPS_TASK_ID


OPS_SCHEDULE_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Schedule Task
Definition: The operations schedule task table stores the information about a task that has been initialized for a particular operations date.
Table Type: ACTIVITY





Column Detail - OPS_SCHEDULE_TASK


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.
AVG_DT_TM DATETIME Y The average time is the offset between schedule_dt_tm and avg_dt_tm (avg_dt_tm - schedule_dt_tm).
AVG_FLAG DOUBLE Y 0 = no average has been calculated. 1 = Runtimes < 5. 2 = average is calculated, but threshold is not applicable. 3 = average is calculated, threshold is calculated.
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) Y Name of the scheduled task.
OPS_SCHEDULE_CONTROL_GRP_ID DOUBLE N Foreign key to OPS_SCHEDULE_CONTROL_GROUP. Indicates to which scheduled control group this scheduled task belongs.
OPS_SCHEDULE_TASK_ID DOUBLE N Unique identifier for a scheduled task record.
OPS_TASK_ID DOUBLE N Foreign key to OPS_TASK. Indicates which task this scheduled task relates.
PARENT_ID DOUBLE N Foreign key to OPS_SCHEDULED_TASK. Indicates which scheduled job group this scheduled job within a scheduled job group belongs.
SCHEDULE_DT_TM DATETIME Y Date and time this scheduled task should run.
STATUS_CD DOUBLE N Foreign key to CODE_VALUE. State of the scheduled task.
TASK_TYPE DOUBLE Y Indicates if this scheduled task is a job group, job, or job within a job group.
THRESH_DT_TM DATETIME Y The threshold time is the offset between schedule_dt_tm and thresh_dt_tm (thresh_dt_tm - schedule_dt_tm)
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_SCHEDULE_TASK


Child Column in OPS_SCHEDULE_TASK(FK) Parent Table Name Parent Column Name
Parents: OPS_SCHEDULE_CONTROL_GRP_ID OPS_SCHEDULE_CONTROL_GROUP OPS_SCHEDULE_CONTROL_GRP_ID
PARENT_ID OPS_SCHEDULE_TASK OPS_SCHEDULE_TASK_ID
OPS_TASK_ID OPS_TASK OPS_TASK_ID




Parent Column in OPS_SCHEDULE_TASK (PK) Child Table Name Child Column Name
Children: OPS_SCHEDULE_TASK_ID OPS_SCHEDULE_JOB_STEP OPS_SCHEDULE_TASK_ID
OPS_SCHEDULE_TASK PARENT_ID
OPS_SCHED_DEP D_SCHED_TASK_ID
OPS_SCHED_DEP T_SCHED_TASK_ID


OPS_SCHED_DEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: operations scheduled dependency
Definition: The operations schedule dependency table stores the information about a dependency that has been initialized for a particular operations date.
Table Type: ACTIVITY





Column Detail - OPS_SCHED_DEP


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 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.
D_SCHED_STEP_ID DOUBLE N The ops_schedule_job_step_id of the dependent step.
D_SCHED_TASK_ID DOUBLE N The ops_schedule_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.
OPS_JOB_VERIFY_ID DOUBLE N The foreign key to the ops_job_verify table that tells which dependency this record belongs to.
OPS_SCHED_DEP_ID DOUBLE N Unique identifier for a scheduled dependency record.
T_SCHED_STEP_ID DOUBLE N The ops_schedule_job_step_id of the triggering step.
T_SCHED_TASK_ID DOUBLE N The ops_schedule_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_SCHED_DEP


Child Column in OPS_SCHED_DEP(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_STATUS_CD CODE_VALUE CODE_VALUE
D_SCHED_STEP_ID OPS_SCHEDULE_JOB_STEP OPS_SCHEDULE_JOB_STEP_ID
T_SCHED_STEP_ID OPS_SCHEDULE_JOB_STEP OPS_SCHEDULE_JOB_STEP_ID
D_SCHED_TASK_ID OPS_SCHEDULE_TASK OPS_SCHEDULE_TASK_ID
T_SCHED_TASK_ID OPS_SCHEDULE_TASK OPS_SCHEDULE_TASK_ID