Table Detail Report
OPS_TASK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Operations Task |
Definition: | The operations task table stores the information for jobs and job groups and their schedules. |
Table Type: | REFERENCE |
Column Detail - OPS_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. |
AUTOSTART_IND | DOUBLE | Y | Indicates if the operations server will automatically start the schedule task at its designated start time or wait for a manual start from an operator via the OpsView Monitor. |
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_INTERVAL | DOUBLE | Y | Indicates how many days or weeks to skip before the task is scheduled to run again. |
ENABLE_IND | DOUBLE | Y | Indicates if this task is available for initialization by the OpsExec Server or not. |
END_DATE_IND | DOUBLE | Y | Indicates if this task has an ending effective date or if it will run forever. |
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. |
FREQUENCY_TYPE | DOUBLE | Y | Indicates which scheduling model this task uses. |
JOB_GRP_NAME | VARCHAR(40) | Y | Name of the job group. |
JOB_NUMBER | DOUBLE | Y | Number to order the sequence of jobs within a job group. Valid for jobs within a job group only. |
OPS_CONTROL_GRP_ID | DOUBLE | N | Foreign key to OPS_CONTROL_GROUP. Indicates to which control group this task belongs. |
OPS_JOB_ID | DOUBLE | N | Foreign key to OPS_JOB. Indicates which job this task one to one with. This field is not valid for job groups. |
OPS_TASK_ID | DOUBLE | N | Unique identifier of a task record. |
OVERDUE_IND | DOUBLE | Y | Indicates if a recursive task can be skipped if the operations server is running in "catch up" mode when it is first started after a period of being down. Redundant tasks will only run once instead of several times all at once. |
PARENT_ID | DOUBLE | N | Foreign key to OPS_TASK. Indicates to which job group this job within a job group belongs. Valid for jobs within a job group only. |
TASK_TYPE | DOUBLE | Y | Indicates if this task is a job group, job, or job within a job group. |
THRESH_IND | DOUBLE | Y | Indicates if the elapsed time for this task should be monitored. |
THRESH_PERCENT | DOUBLE | Y | The percentage over average elapsed time that the threshold time is set. |
TIME_IND | DOUBLE | Y | Indicates if the task is scheduled to run once or many times during one day. |
TIME_INTERVAL | DOUBLE | Y | Indicates how many hours or minutes to skip before the task is scheduled to run again. |
TIME_INTERVAL_IND | DOUBLE | Y | Indicates the Time Interval units of measure. Minutes or hours. |
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_TASK
Child Column in OPS_TASK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OPS_CONTROL_GRP_ID | OPS_CONTROL_GROUP | OPS_CONTROL_GRP_ID |
OPS_JOB_ID | OPS_JOB | OPS_JOB_ID | |
PARENT_ID | OPS_TASK | OPS_TASK_ID |
Parent Column in OPS_TASK (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OPS_TASK_ID | OPS_DAY_OF_MONTH | OPS_TASK_ID |
OPS_DAY_OF_WEEK | OPS_TASK_ID | ||
OPS_JOB_VERIFY | D_TASK_ID | ||
OPS_JOB_VERIFY | T_TASK_ID | ||
OPS_MONTH_OF_YEAR | OPS_TASK_ID | ||
OPS_SCHEDULE_PARAM | OPS_TASK_ID | ||
OPS_SCHEDULE_TASK | OPS_TASK_ID | ||
OPS_TASK | PARENT_ID | ||
OPS_WEEK_OF_MONTH | OPS_TASK_ID |
OPS_WEEK_OF_MONTH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Operations Week of Month |
Definition: | The operations week of month table stores the week of the month that a task is schedule to run. |
Table Type: | REFERENCE |
Column Detail - OPS_WEEK_OF_MONTH
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. |
OPS_JOB_VERIFY_ID | DOUBLE | N | Foreign key to ops_job_verify. Indicates to which dependency this week of month belongs. |
OPS_TASK_ID | DOUBLE | N | Foreign key to OPS_TASK. Indicates to which task this week of month belongs. |
OPS_WEEK_OF_MONTH_ID | DOUBLE | N | Unique identifier for a week of month 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. |
WEEK_OF_MONTH | DOUBLE | Y | Indicates the week of month. |
Relationship Detail - OPS_WEEK_OF_MONTH
Child Column in OPS_WEEK_OF_MONTH(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 |
SYS_CHG_MESSAGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | system change message |
Definition: | Contains reference information about the non-passive changes introduced into the system. |
Table Type: | REFERENCE |
Column Detail - SYS_CHG_MESSAGE
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. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
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. |
CATEGORY | VARCHAR(60) | Y | A textual description of the category of this message. |
CREATE_DT_TM | DATETIME | Y | The date and time the message was added to the system. |
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. |
LONG_TEXT_ID | DOUBLE | N | A foreign key to the LONG_TEXT_REFERENCE table representing the contents of the message. |
MESSAGE_ID | DOUBLE | N | Unique identifier for this row |
MESSAGE_KEY | VARCHAR(40) | N | A unique key distributed by Cerner to identify this message. |
SUBJECT | VARCHAR(100) | Y | A textual description of the subject of this message |
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 - SYS_CHG_MESSAGE
Child Column in SYS_CHG_MESSAGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
Parent Column in SYS_CHG_MESSAGE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MESSAGE_ID | SYS_CHG_MESSAGE_R | MESSAGE_ID |
SYS_CHG_NOTIFICATION | MESSAGE_ID |
SYS_CHG_MESSAGE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | system change message |
Definition: | Contains the positions of users that a given change message applies to. |
Table Type: | REFERENCE |
Column Detail - SYS_CHG_MESSAGE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
MESSAGE_ID | DOUBLE | N | A foreign key to the SYS_CHG_MESSAGE table that refers to the specific message that this relationship involves. |
MESSAGE_R_ID | DOUBLE | N | Unique identifier for this row |
POSITION_CD | DOUBLE | N | A foreign key to the CODE_VALUE table with CODE_SET = 88 that refers to the position that this relationship involves. |
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 - SYS_CHG_MESSAGE_R
Child Column in SYS_CHG_MESSAGE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MESSAGE_ID | SYS_CHG_MESSAGE | MESSAGE_ID |
SYS_CHG_NOTIFICATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | system change notification |
Definition: | Contains information on who has and hasn't acknowledged the non-passive change descriptions made to the system. |
Table Type: | ACTIVITY |
Column Detail - SYS_CHG_NOTIFICATION
Column Name | Type | Null? | Definition |
---|---|---|---|
MESSAGE_ID | DOUBLE | N | A foreign key to the SYS_CHG_MESSAGE table that refers to the message this notification uses. |
NOTIFICATION_ID | DOUBLE | N | Unique identifier for this row |
READ_DT_TM | DATETIME | Y | The date and time the message was read by the user. |
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. |
USERNAME | VARCHAR(50) | N | The username that the message applies to. |
Relationship Detail - SYS_CHG_NOTIFICATION
Child Column in SYS_CHG_NOTIFICATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MESSAGE_ID | SYS_CHG_MESSAGE | MESSAGE_ID |