WorkerJourneys
WorkerJourneys
Columns
| Name | Type | Description |
| WorkerJourneyId [KEY] | Long | Primary key generated by the application. |
| Category | String | Category code of the journey. |
| CategoryMeaning | String | Meaning of the journey category. |
| SubCategory | String | Subcategory of the worker journey. |
| SubCategoryMeaning | String | Subcategory meaning of the worker journey. |
| JourneyId | Long | Identifier of the journey. |
| Instance | String | Instance of the allocated journey to identify if the same journey is allocated to the worker multiple times. |
| Name | String | Name of the journey. |
| Comments | String | Comments for the journey. |
| JourneyDisplayName | String | Display name of the journey. |
| CountryCode | String | Code of the country to which the journey is applicable. |
| Country | String | Name of the country to which the journey is applicable. |
| PersonId | Long | Internal identifier of the journey assignee. |
| DisplayName | String | Display name of the journey assignee |
| PersonNumber | String | Number assigned to the journey assignee to identify the person uniquely. |
| AssignmentId | Long | Internal identifier of the journey assignee's assignment. |
| AssignmentName | String | Business title of the journey assignee. |
| Status | String | Status code of the worker journey. |
| StatusMeaning | String | Status of the worker journey. |
| Description | String | Description of the journey. |
| JourneyTitle | String | Title of the journey that's displayed on the specific journey's landing page. |
| MessageTitle | String | Title for the message displayed in the journey details. |
| MessageSubTitle | String | Subtitle of the message displayed in the journey details. |
| MessageText | String | Message text displayed for the journey. |
| CompletionMessage | String | Message displayed when the journey is completed. |
| BackgroundImageSource | String | Source of the background image. |
| BackgroundImageURL | String | URL of the image displayed on the journey card and journey details page. |
| BackgroundThumbnailURL | String | URL of the journey background thumbnail image. |
| ActionDate | Date | Date as of which the journey is allocated. |
| AllocationDate | Date | Date on which the journey is initiated. |
| AssignedDate | Date | Date on which the journey record was created. |
| CompletionDate | Date | Date on which the journey is completed. |
| ActionOccurrenceId | Long | Unique identifier of the employment action for which this journey is assigned. |
| ObjectId | Long | Unique identifier of the event object for which this journey is assigned. |
| AccessBasicInformation | String | Setting that determines if the signed in user can access the Basic Info section. |
| AccessDeferredTasks | String | Setting that determines if the signed in user can access the Deferred Tasks section. |
| AccessEvents | String | Setting that determines if the signed in user can access the What's Happening section. |
| AccessNotes | String | Setting that determines if the signed in user can access the Notes section. |
| AccessOthersTasks | String | Setting that determines if the signed in user can access the Others' Tasks section. |
| AccessCompletedTasks | String | Setting that determines if the signed in user can access the Completed Tasks section. |
| ActionEdit | String | Setting that determines if the signed in user can edit the worker journey. |
| ActionForceClose | String | Setting that determines if the signed in user can force close the journey. |
| ActionRemove | String | Setting that determines if the signed in user can remove the journey. |
| ActionAddTaskFromLibrary | String | Setting that determines if the signed in user can add a task from the task library for the journey. |
| ActionAddTask | String | Setting that determines if the signed in user can add a task to the journey. |
| 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 task. |
| CreationDate | Datetime | Date on which the task was created. |
| LastUpdatedBy | String | User who last updated the task. |
| LastUpdateDate | Datetime | Date on which the task was updated. |
| AssignedDateForSort | Date | Date by which journeys can be sorted. |
| ContextualAction | String | Transaction flow for which the contextual journey is applicable. |
| InitiatorPersonId | Long | Internal identifier of the journey initiator. |
| InitiatorDisplayName | String | Display name of the journey initiator. |
| Context | String | Context for a journey. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AllocatedAfterDate | Date | AllocatedAfterDate |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| Facets | String | Facets |
| Overdue | String | Overdue |
| SearchTerms | String | SearchTerms |
| StatusCategory | String | StatusCategory |
| StatusFilter | String | StatusFilter |
| SubCategoryFilter | String | SubCategoryFilter |
| Finder | String | finder |