rs_job_notes
The following table lists the columns for the rs_job_notes view. The equivalent jcs_job_notes 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 |
NOTE_ID | NUMBER | The unique id of a job note |
OWNER | VARCHAR2 | The owner of the note |
CREATION_TIME | TIMESTAMP WITH TIME ZONE | Timestamp that notes when the note was createdThe timezone is specified as an Olson name. |
NOTE_TEXT | VARCHAR2 | The actual text of the note |
plsqlTopic
onsiteTopic