Journeys
Journeys
Columns
| Name | Type | Description |
| JourneyId [KEY] | Long | Primary key of the journey template. |
| Level | String | Level of a journey template. |
| LevelMeaning | String | Meaning of journey template level. |
| LevelValue | Long | Value of journey template level such as global or personal. |
| Category | String | Category code for the event. Values are from ORA_PER_ONB_CONTENT_SBTYP_EVNT lookup. For example, Insight. |
| CategoryMeaning | String | Meaning of the journey category. |
| SubCategory | String | Subcategory of the worker journey. |
| SubCategoryMeaning | String | Subcategory meaning of the worker journey. |
| Name | String | Name of the journey task. |
| Code | String | Code for the journey template. |
| CountryCode | String | Code of the country for which the journey template is applicable. |
| Country | String | Name of the country for which the journey template is applicable. |
| Description | String | Description of the task. |
| JourneyTitle | String | Title of the journey template. |
| DisplayNameFormat | String | Display name format of a journey template. |
| MessageTitle | String | Title of the message displayed in the journey details. |
| MessageSubTitle | String | Subtitle of the message displayed in the journey details. |
| MessageText | String | Message text displayed for a journey. |
| CompletionMessage | String | Message displayed on journey completion. |
| BackgroundImageSource | String | Source of the background image. |
| BackgroundImageFileName | String | File name of the background image. |
| RawBackgroundImageURL | String | URL of the original background image. |
| BackgroundImageURL | String | URL of the image displayed on the journey details page. |
| BackgroundThumbnailURL | String | URL of the image displayed on the journey card. |
| DateFrom | Date | Date from which the journey template is active. |
| DateTo | Date | Date until which the journey template is active. |
| Status | String | Code for the task status. |
| StatusMeaning | String | Status of the task. |
| AllocationCriteria | String | Criteria to determine journey assignment. |
| AllocationCriteriaMeaning | String | Meaning of assignment criteria. |
| AllocationOffsetDays | Int | Number of days to consider for initiating journey assignment. |
| CompletionCriteria | String | Completion criteria to complete a journey. |
| CompletionCriteriaMeaning | String | Meaning of completion criteria. |
| CompletionOffsetDays | Int | Number of offset days to consider for journey completion. |
| DisplayFeatures | String | Display features of a journey template. |
| ProcessingMode | String | Processing mode to send journey notifications. |
| AllowAssignToSelfFlag | Bool | Indicates whether journey can be assigned to direct reports. |
| AllowAssignToPersonFlag | Bool | Indicates whether journey can be assigned to direct reports. |
| AllowAssignToDirectsFlag | Bool | Indicates whether journey can be assigned to direct reports. |
| AllowAssignToOrganizationFlag | Bool | Indicates whether the journey can be assigned to employees in an organization. |
| AssignedTemplateId | Long | Primary key or unique identifier of the assigned notification template. |
| ForceCompletedTemplateId | Long | Primary key or unique identifier of the force completion notification template. |
| CombinedNotificationTemplateId | Long | Primary key or unique identifier of the combined notification template. |
| ArchiveOffsetDays | Int | Number of days to consider for archiving journeys. |
| PurgeOffsetDays | Int | Number of days to consider for purging journeys. |
| RecurrentScheduleAllowedFlag | Bool | Indicates whether journey recurrence is scheduled. |
| FeedFlag | Bool | Indicates whether the atom feed is enabled. |
| AssignedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey is assigned. |
| InitiatedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey is initiated. |
| CompletedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey is completed. |
| DeletedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey is deleted. |
| CreatedBy | String | User who created the journey template. |
| CreationDate | Datetime | Date on which the journey template was created. |
| LastUpdatedBy | String | User who last updated the journey template. |
| LastUpdateDate | Datetime | Date on which the journey template was updated. |
| ContextualAction | String | Transaction flow for which the contextual journey template is applicable. |
| Context | String | Context for a journey. |
| BackgroundImage | String | Background image displayed on the journey page. |
| CroppedBackgroundImage | String | Cropped background image displayed on the journey page. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| ExcludePersonal | String | ExcludePersonal |
| Facets | String | Facets |
| FilterAttributes | String | FilterAttributes |
| LevelFilter | String | LevelFilter |
| SearchTerms | String | SearchTerms |
| SubCategoryFilter | String | SubCategoryFilter |
| SubjectAssignmentId | Long | SubjectAssignmentId |
| SubjectPersonId | Long | SubjectPersonId |
| Finder | String | finder |