Journeysnotes
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| Context | String | Context |
| ContextualAction | String | ContextualAction |
| ExcludePersonal | String | ExcludePersonal |
| Facets | String | Facets |
| FilterAttributes | String | FilterAttributes |
| JourneyId | Long | JourneyId |
| LevelFilter | String | LevelFilter |
| SearchTerms | String | SearchTerms |
| SubCategoryFilter | String | SubCategoryFilter |
| SubjectAssignmentId | Long | SubjectAssignmentId |
| SubjectPersonId | Long | SubjectPersonId |
| Finder | String | finder |