WorkerJourneysallStepTasks
WorkerJourneysallStepTasks
Columns
| Name | Type | Description |
| WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
| WorkerJourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
| ParentWorkerJourneyId | Long | Unique identifier of the parent enterprise onboarding checklist. |
| StageName | String | Name of the phase in a journey with multiple phases. |
| StageSequence | Int | Sequence of the phase in a journey with multiple phases. |
| Name | String | Name of the journey task. |
| Type | String | Code for the task action type. |
| TypeMeaning | String | Meaning of the task type. |
| SubType | String | Task action subtype code. Available only for I 9 and Electronic Signature task types. |
| SubTypeMeaning | String | Task action subtype. Available only for I 9 and Electronic Signature task types. |
| RequiredFlag | Bool | Indicates whether the task is mandatory or optional. Valid values are Yes and No. The default value is No. |
| Status | String | Code for the task status. |
| StatusMeaning | String | Status of the task. |
| StatusCategory | String | Category of the status. |
| Sequence | Int | Task display ordering sequence. Default is 1. |
| DependentTaskId | Long | Primary key or unique identifier of the dependent task. |
| DependentTaskName | String | Name of the dependent task. |
| TargetStartDate | Date | Expected initiation date of the task. |
| TargetEndDate | Date | Due date of the task. |
| ActualStartDate | Date | Date on which the task was opened. |
| ActualEndDate | Date | End date of the task. |
| CompletionDate | Date | Date on which the task was completed. |
| DeferredStartDate | Date | Start date for the deferred task. |
| Description | String | Description of the task. |
| Notes | String | Notes for the task. The notes text is stored as a CLOB object. To use in the payload, the text should be converted to a base64 encoded string using either a conversion tool or a prerequisite script. |
| AllowNoteTitleFlag | Bool | Indicates whether the Notes title is hidden or not. Valid values are Yes and No. The default value is No. |
| AllowCommentFlag | Bool | Indicates whether comments are enabled for a task. Valid values are Yes and No. The default value is No. |
| AllowAttachmentFlag | Bool | Indicates whether attachments are enabled for a task. Valid values are Yes and No. The default value is No. |
| NoteTitle | String | Title of the Notes section in the task. |
| Comments | String | Comments for the task. |
| ActionURL | String | URL associated with the task that's entered on the setup screen. |
| ReportPath | String | Path to the report in BI Catalog. |
| ConfigurableFormContext | String | Descriptive flexfield context code for configurable form task type. |
| ApplicationTaskName | String | Display name of the application task. |
| PerformerType | String | Task performer type. |
| PerformerTypeMeaning | String | Task performer type meaning. |
| PerformerPersonId | Long | Person identifier of the task performer. Applicable only in case of a single task performer. |
| PerformerName | String | Person display name of task performer in case of single performer. Else, returns responsibility type name. |
| OwnerType | String | Task owner type. |
| OwnerTypeMeaning | String | Task owner type meaning. |
| OwnerPersonId | Long | Identifier of the task owner. Applicable only in case of a single task owner. |
| OwnerName | String | Person display name of task owner in case of single owner. Else, returns responsibility type name. |
| CompletedByPersonId | Long | Person identifier of the person who completed the task. |
| CompletedByDisplayName | String | Name of the person who completed the task. |
| SignDate | Date | Date on which the electronic signature was provided for an electronic signature task. |
| SignAddress | String | Internet protocol address where the electronic signature was provided. |
| SignerEmail | String | Email address of the signer for an electronic signature task. |
| SignerName | String | Name of the signer for an electronic signature task. |
| AccessActivity | String | Setting that determines if the signed in user can access the task. |
| AccessAttachments | String | Setting that determines if the signed in user can access the task attachments. |
| AccessComments | String | Setting that determines if the signed in user can access the task comments. |
| AccessContact | String | Setting that determines if the signed in user can access the task contact details. |
| AccessNotes | String | Setting that determines if the signed in user can access the task notes. |
| ActionComplete | String | Setting that determines if the signed in user can mark the task as complete. |
| ActionEditDueDate | String | Setting that determines if the signed in user can edit the due date of the task. |
| ActionEdit | String | Setting that determines if the signed in user can edit the task. |
| ActionReassign | String | Setting that determines if the signed in user can reassign the task. |
| ActionReject | String | Setting that determines if the signed in user can mark the task as not applicable. |
| ActionRemove | String | Setting that determines if the signed in user can remove the task. |
| ActionReopen | String | Setting that determines if the signed in user can reopen a completed task. |
| ActionSendReminder | String | Setting that determines if the signed in user can send a reminder for a task. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AllocatedAfterDate | Date | AllocatedAfterDate |
| AssignmentId | Long | AssignmentId |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| Context | String | Context |
| ContextualAction | String | ContextualAction |
| Facets | String | Facets |
| JourneyId | Long | JourneyId |
| Overdue | String | Overdue |
| PersonId | Long | PersonId |
| SearchTerms | String | SearchTerms |
| StatusFilter | String | StatusFilter |
| SubCategoryFilter | String | SubCategoryFilter |
| WorkerJourneyId | Long | WorkerJourneyId |
| Finder | String | finder |