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