Journeysnotes

Columns


Name	Type	Description
JourneysJourneyId [KEY]	Long	Finds all journey templates that match the primary key specified.
JourneyNoteId [KEY]	Long	Unique identifier of the journey notes.
Sequence	Int	Task display ordering sequence. Default is 1.
Type	String	Note subtype code. Values are from the ORA_PER_ONB_CONTENT_SBTYP_NOTE lookup. Example, Meeting Note, Standard Note.
TypeMeaning	String	Note subtype meaning.
Description	String	Description of the task.
EventDate	String	Date for meeting type note.
EventLocation	String	Location for meeting type note.
EventTime	String	Time for meeting type note.
EventOffset	Int	Offset value for the event.
Title	String	Title of the notes.
CreatedBy	String	User who created the notes.
CreationDate	Datetime	Date the notes was created.
LastUpdatedBy	String	User who last updated the notes.
LastUpdateDate	Datetime	Date the notes was last updated.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。