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 |