WorkerJourneysnotes
WorkerJourneysnotes
Columns
Name | Type | Description |
WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
WorkerJourneyNoteId [KEY] | Long | Unique identifier of the journey notes. |
Sequence | Int | Display order of the notes. |
Type | String | Note subtype code. Values are from the ORA_PER_ONB_CONTENT_SBTYP_NOTE lookup. For example, Meeting Note, Standard Note. |
TypeMeaning | String | Note subtype meaning. |
Description | String | Description of the note. |
EventDate | Date | Date for the meeting type note. |
EventLocation | String | Location for the meeting type note. |
EventTime | String | Time for the meeting type note. |
Title | String | Title of the note. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AllocatedAfterDate | Date | AllocatedAfterDate |
AssignmentId | Long | AssignmentId |
CategoryFilter | String | CategoryFilter |
CodeFilter | String | CodeFilter |
Context | String | Context |
ContextualAction | String | ContextualAction |
Facets | String | Facets |
JourneyId | Long | JourneyId |
Overdue | String | Overdue |
PersonId | Long | PersonId |
SearchTerms | String | SearchTerms |
StatusCategory | String | StatusCategory |
StatusFilter | String | StatusFilter |
SubCategoryFilter | String | SubCategoryFilter |
WorkerJourneyId | Long | WorkerJourneyId |
Finder | String | finder |