rs_operator_messages
The following table lists the columns for the rs_operator_messages view. The equivalent jcs_operator_messages view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| JOB_ID | NUMBER | The unique ID of a job (if message is job-related) |
| TYPE | VARCHAR2 | The type of message: M=Message without requiring a reply, A=Message requiring a reply, <null>=Message already replied |
| SEQNO | NUMBER | The sequence number of the Operator Message |
| TEXT | VARCHAR2 | The text of the message |
| DATA_TYPE | VARCHAR2 | The required data type of the reply |
| ANSWER_VARCHAR2 | VARCHAR2 | The default value provided for a varchar2-reply |
| ANSWER_DATE | TIMESTAMP | The default value provided for a date-reply |
| ANSWER_NUMBER | NUMBER | The default value provided for a number-reply |
| INPUT_FORMAT | VARCHAR2 | The input format for the reply |
| CHECK_STRING | VARCHAR2 | The SQL-check for the reply |
| CTIME | TIMESTAMP WITH TIME ZONE | The date and time the message was createdThe timezone is specified as an Olson name. |
| CTIME_SORT | NUMBER | The date and time the message was created as number (has Oracle index) |
| ATIME | TIMESTAMP WITH TIME ZONE | The date and time the message was answered or the job was abortedThe timezone is specified as an Olson name. |
| CREATOR_AUDSID | NUMBER | The audit identification of the user creating the message |
| CREATOR_USER | VARCHAR2 | The user creating the message |
| CREATOR_MACHINE | VARCHAR2 | The machine of the user creating the message |
| ANSWER_AUDSID | NUMBER | The audit identification of the user answering the message |
| ANSWER_USER | VARCHAR2 | The user answering the message |
| ANSWER_MACHINE | VARCHAR2 | The machine of the user answering the message |
| MONITOR_ID | NUMBER | The monitor ID of the condition that created the alert |
| ETIME | TIMESTAMP WITH TIME ZONE | The endtime of the alertThe timezone is specified as an Olson name. |
| SEVERITY | NUMBER | The severity of the alert |
| CONFIRMED | VARCHAR2 | Is the alert confirmed |
Note: TYPE: M = Message, A = a question to be answered, null = an answered question
Note: TEXT: This is only the first 2000 characters of the complete text
Note: DATA_TYPE: In version 9, only VARCHAR2/String Operator Messages are allowed.
Note: ANSWER_NUMBER: Always empty, because in version 9, only VARCHAR2/String Operator Messages are allowed.
Note: CHECK_STRING: Where this was a PL/SQL expression in version 7 or before, it is now a regular expression
Note: INPUT_FORMAT: Input format is not supported in version 9
Note: CREATOR_AUDSID: This column is not supported in version 9
Note: CREATOR_USER: Instead of the creator, this now returns the user that last changed the Operator Message
Note: CREATOR_MACHINE: This column is not supported in version 9
Note: ANSWER_AUDSID: This column is not supported in version 9
Note: ANSWER_MACHINE: This column is not supported in version 9
Note: MONITOR_ID: This column is not supported yet
Note: ETIME: This column is not supported yet
Note: SEVERITY: This column is not supported yet
Note: CONFIRMED: This column is not supported yet