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 |