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 |