Table Detail Report

OPS2_SCHED_CTRL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - OPS2_SCHED_CTRL_GROUP


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.
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.
EXTERNAL_USERNAME VARCHAR(100) Y The name of the non-Millennium (e.g. Olympus) user that modified the record.
INITIALIZE_DT_TM DATETIME N The date and time this scheduled control group was initialized.
OPS2_CTRL_GROUP_ID DOUBLE N Foreign key to OPS2_CTRL_GROUP. Indicates to which control group this scheduled control group represents.
OPS2_SCHED_CTRL_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_SCHED_CTRL_GROUP table.
ORIG_OPS2_SCHED_CTRL_GROUP_ID DOUBLE N This field is used to track versions of the scheduled control group. 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.
SCHEDULE_DATE_DT_TM DATETIME N The scheduled day this scheduled control group processes.
STATUS_CD DOUBLE N State of the scheduled control group.
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_SCHED_CTRL_GROUP


Child Column in OPS2_SCHED_CTRL_GROUP(FK) Parent Table Name Parent Column Name
Parents: OPS2_CTRL_GROUP_ID OPS2_CTRL_GROUP OPS2_CTRL_GROUP_ID
ORIG_OPS2_SCHED_CTRL_GROUP_ID OPS2_SCHED_CTRL_GROUP OPS2_SCHED_CTRL_GROUP_ID




Parent Column in OPS2_SCHED_CTRL_GROUP (PK) Child Table Name Child Column Name
Children: OPS2_SCHED_CTRL_GROUP_ID OPS2_SCHED_CTRL_GROUP ORIG_OPS2_SCHED_CTRL_GROUP_ID
OPS2_SCHED_JOB OPS2_SCHED_CTRL_GROUP_ID
OPS2_SCHED_JOB_GROUP OPS2_SCHED_CTRL_GROUP_ID


OPS2_SCHED_DEPENDENCY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Schedule Dependency Relation
Definition: The operations scheduled dependency table stores information about a dependency that has been initialized for a particular operations date.
Table Type: ACTIVITY





Column Detail - OPS2_SCHED_DEPENDENCY_R


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.
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.
OPS2_DEPENDENCY_RELTN_ID DOUBLE N SEQUENCE NAME:SYS_OPS_SEQ Foreign key to OPS2_DEPENDENCY_RELTN. Indicates to which dependency this scheduled dependency represents.
OPS2_SCHED_DEPENDENCY_R_ID DOUBLE N Unique, generated number that identifies a single row on the OPS2_SCHED_DEPENDENCY_R table.
ORIG_SCHED_DEPENDENCY_R_ID DOUBLE N This field is used to track versions of the Scheduled Dependency relationships. 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.
SCHED_PARENT_ENTITY_ID DOUBLE N Identifies the parent object for this row. This will always represent the dependent scheduled item, and never the trigger.
SCHED_PARENT_ENTITY_NAME VARCHAR(32) N The name of the table that contains the parent object.
TRIGGER_JOB_GROUP_SCHED_DT_TM DATETIME Y The scheduled date and time of execution for the scheduled job group representing the 'trigger item' for this scheduled dependency.
TRIGGER_JOB_SCHED_DT_TM DATETIME Y The scheduled date and time of execution for the scheduled job or scheduled job within a scheduled job group representing the 'trigger item' for this scheduled dependency.
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_SCHED_DEPENDENCY_R


Child Column in OPS2_SCHED_DEPENDENCY_R(FK) Parent Table Name Parent Column Name
Parents: OPS2_DEPENDENCY_RELTN_ID OPS2_DEPENDENCY_RELTN OPS2_DEPENDENCY_RELTN_ID
ORIG_SCHED_DEPENDENCY_R_ID OPS2_SCHED_DEPENDENCY_R OPS2_SCHED_DEPENDENCY_R_ID




Parent Column in OPS2_SCHED_DEPENDENCY_R (PK) Child Table Name Child Column Name
Children: OPS2_SCHED_DEPENDENCY_R_ID OPS2_SCHED_DEPENDENCY_R ORIG_SCHED_DEPENDENCY_R_ID


OPS2_SCHED_JOB



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - OPS2_SCHED_JOB


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.
ACTUAL_END_DT_TM DATETIME Y The date and time for when the job or job within a job group finished executing.
ACTUAL_START_DT_TM DATETIME Y The date and time for when the job or job within a job group started executing.
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.
EXTERNAL_USERNAME VARCHAR(100) Y The name of the non-Millennium (e.g. Olympus) user that modified the record.
INITIALIZE_DT_TM DATETIME Y The date and time this scheduled job was initialized.
OPS2_JOB_ID DOUBLE N Foreign key to OPS2_JOB. Indicates to which job or job within a job group this scheduled job represents.
OPS2_SCHED_CTRL_GROUP_ID DOUBLE N Foreign key to OPS2_SCHED_CTRL_GROUP. Indicates to which scheduled control group this scheduled job belongs.
OPS2_SCHED_JOB_GROUP_ID DOUBLE N Foreign key to OPS2_SCHED_JOB_GROUP. Indicates to which scheduled job group this scheduled job belongs.
OPS2_SCHED_JOB_ID DOUBLE N Unique, generated number that identifies a single row on the OPS2_SCHED_JOB table.
ORIG_OPS2_SCHED_JOB_ID DOUBLE N This field is used to track versions of the scheduled jobs. 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.
SCHEDULE_DATE_DT_TM DATETIME N The date and time this scheduled job is scheduled to execute.
STATUS_CD DOUBLE N State of the scheduled job.
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_SCHED_JOB


Child Column in OPS2_SCHED_JOB(FK) Parent Table Name Parent Column Name
Parents: OPS2_JOB_ID OPS2_JOB OPS2_JOB_ID
OPS2_SCHED_CTRL_GROUP_ID OPS2_SCHED_CTRL_GROUP OPS2_SCHED_CTRL_GROUP_ID
ORIG_OPS2_SCHED_JOB_ID OPS2_SCHED_JOB OPS2_SCHED_JOB_ID
OPS2_SCHED_JOB_GROUP_ID OPS2_SCHED_JOB_GROUP OPS2_SCHED_JOB_GROUP_ID




Parent Column in OPS2_SCHED_JOB (PK) Child Table Name Child Column Name
Children: OPS2_SCHED_JOB_ID OPS2_SCHED_JOB ORIG_OPS2_SCHED_JOB_ID
OPS2_SCHED_STEP OPS2_SCHED_JOB_ID


OPS2_SCHED_JOB_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Scheduled Job Group
Definition: The operations scheduled job group table stores information about a job group that has been initialized for a particular operations date.
Table Type: ACTIVITY





Column Detail - OPS2_SCHED_JOB_GROUP


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.
ACTUAL_END_DT_TM DATETIME Y The date and time for when the job group finished executing.
ACTUAL_START_DT_TM DATETIME Y The date and time for when the job group started executing.
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.
EXTERNAL_USERNAME VARCHAR(100) Y The name of the non-Millennium (e.g. Olympus) user that modified the record.
INITIALIZE_DT_TM DATETIME N The date and time this scheduled job group was initialized.
OPS2_JOB_GROUP_ID DOUBLE N Foreign key to OPS2_JOB_GROUP. Indicates to which job group this scheduled job group represents.
OPS2_SCHED_CTRL_GROUP_ID DOUBLE N Foreign key to OPS2_SCHED_CTRL_GROUP. Indicates to which scheduled control group this scheduled job group belongs.
OPS2_SCHED_JOB_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_SCHED_JOB_GROUP table.
ORIG_OPS2_SCHED_JOB_GROUP_ID DOUBLE N This field is used to track versions of the scheduled job groups. 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.
SCHEDULE_DATE_DT_TM DATETIME N The date and time this scheduled job group is scheduled to execute.
STATUS_CD DOUBLE N State of the scheduled job group.
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_SCHED_JOB_GROUP


Child Column in OPS2_SCHED_JOB_GROUP(FK) Parent Table Name Parent Column Name
Parents: OPS2_JOB_GROUP_ID OPS2_JOB_GROUP OPS2_JOB_GROUP_ID
OPS2_SCHED_CTRL_GROUP_ID OPS2_SCHED_CTRL_GROUP OPS2_SCHED_CTRL_GROUP_ID
ORIG_OPS2_SCHED_JOB_GROUP_ID OPS2_SCHED_JOB_GROUP OPS2_SCHED_JOB_GROUP_ID




Parent Column in OPS2_SCHED_JOB_GROUP (PK) Child Table Name Child Column Name
Children: OPS2_SCHED_JOB_GROUP_ID OPS2_SCHED_JOB OPS2_SCHED_JOB_GROUP_ID
OPS2_SCHED_JOB_GROUP ORIG_OPS2_SCHED_JOB_GROUP_ID


OPS2_SCHED_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Operations Scheduled 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 - OPS2_SCHED_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.
ACTUAL_END_DT_TM DATETIME Y The date and time for when the step finished executing.
ACTUAL_START_DT_TM DATETIME Y The date and time for when the step started executing.
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.
OPS2_SCHED_JOB_ID DOUBLE N Foreign key to OPS2_SCHED_JOB. Indicates to which scheduled job this scheduled step belongs.
OPS2_SCHED_STEP_ID DOUBLE N Unique generated number that identifies a single row on the OPS2_SCHED_STEP table.
OPS2_STEP_ID DOUBLE N Foreign key to OPS2_STEP. Indicates to which step this scheduled step represents.
OPS_EVENT_TXT VARCHAR(255) Y Stores additional information regarding events related to the state of the scheduled step.
ORIG_OPS2_SCHED_STEP_ID DOUBLE N This field is used to track versions of the scheduled 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.
STATUS_CD DOUBLE N State of the scheduled step
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_SCHED_STEP


Child Column in OPS2_SCHED_STEP(FK) Parent Table Name Parent Column Name
Parents: OPS2_SCHED_JOB_ID OPS2_SCHED_JOB OPS2_SCHED_JOB_ID
ORIG_OPS2_SCHED_STEP_ID OPS2_SCHED_STEP OPS2_SCHED_STEP_ID
OPS2_STEP_ID OPS2_STEP OPS2_STEP_ID




Parent Column in OPS2_SCHED_STEP (PK) Child Table Name Child Column Name
Children: OPS2_SCHED_STEP_ID OPS2_SCHED_STEP ORIG_OPS2_SCHED_STEP_ID