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 |