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 |