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 |