ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

Journeystasks

Journeystasks

Columns

Name Type Description
JourneysJourneyId [KEY] Long Finds all journey templates that match the primary key specified.
JourneyTaskId [KEY] Long Unique identifier of the journey task.
Name String Name of the journey task.
TaskCode String Code of a task in a journey template.
Type String Task action type code.
TypeMeaning String Task action type.
SubType String Task action subtype code. Available only for action types I-9 and Electronic Signature.
SubTypeMeaning String Task action subtype. Available only for action types I9 and Electronic Signature.
RequiredFlag Bool Indicates whether the task is mandatory or optional. Valid values are Yes and No. Default is No.
Status String Code for the task status.
StatusMeaning String Status of the task.
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.
TaskGroupId Long Unique identifier of the journey task group.
TargetDuration Int Target duration for the task.
TargetDurationUOM String Unit of measure for the target duration.
TargetDurationUOMMeaning String Meaning of the unit of measure used in the target duration.
DelayDuration Int Delay duration for the task.
DelayDurationUOM String Unit of measure used in specifying delaying the duration.
DelayDurationUOMMeaning String Meaning of unit of measure used in delay duration.
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 can be added. Valid values are Yes or No. The default is No.
AllowCommentFlag Bool Indicates whether comments can be added to the task. Valid values are Yes or No. The default is No.
AllowAttachmentFlag Bool Indicates whether attachments can be added to the task. Valid values are Yes or No. The default is No.
NoteTitle String Title of the notes.
ActionURL String The URL associated with the task that's entered on the setup screen. To retrieve a navigable URL, use the getNavigationURL custom method of the resource.
PerformerType String Task performer type.
PerformerTypeMeaning String Task performer type meaning.
PerformerResponsibilityType String Responsibility type of the journey task performer.
PerformerResponsibilityTypeMeaning String Responsibility type meaning of the journey task performer.
PerformerPersonId Long Internal identifier of the journey task performer.
OwnerType String Task owner type.
OwnerTypeMeaning String Task owner type meaning.
OwnerResponsibilityType String Responsibility type of the journey task owner.
OwnerResponsibilityTypeMeaning String Responsibility type meaning of the journey task owner.
OwnerPersonId Long Internal identifier of the journey task owner.
AttachmentDocumentTypeId Long Description for the AttachmentDocumentTypeId attribute in the tasks resource, which is part of the journeys root resource.
AttachmentDocumentTypeName String Description for the AttachmentDocumentTypeName attribute in the tasks resource, which is part of the journeys root resource.
QuestionnaireId Long Internal identifier of the questionnaire.
QuestionnaireName String Name of the questionnaire.
ConfigurableFormContext String Context for configurable form task type.
ApplicationTask String Application task type.
ApplicationTaskName String Name of application task type.
ReportPath String Path to the report in BI Catalog.
DigitalSignatureTemplateId String Identifier of the digital signature template.
SignatureValidationConfiguration String Validation type for electronic signature.
WorkAuthorizationConfiguration String Work authorization for I 9 task.
ProcessCloudConfiguration String Configuration of the process automation.
LearningItemId Long Unique identifier of the learning item.
LearnEnrollmentId Long Identifier of the learning enrollment.
LearnEnrollmentType String Type of learning enrollment.
LearnCommunityId Long Identifier of the learning community.
LearningContentType String Type of learning content.
LearningContentTypeMeaning String Meaning of the learning content type.
VideoType String Type of video.
VideoTypeMeaning String Meaning of video type.
VideoURL String URL of the video.
AnalysisPath String OTBI analysis path for an analytics task type.
AnalysisParameters String Parameters associated with an analytics task type.
DisplayOptions String Type of OTBI analysis.
DocumentTypeId Long Description for the document type identifier attribute. Identifier of the document type.
DocumentTypeName String Name of the document type.
SaveDocumentsToDORFor String Attachments to add to document records for a document type.
SaveDocumentsToDORForMeaning String Meaning of add attachments document records.
SaveAttachmentsToDORFor String Document records of person for whom to save task attachments.
SaveAttachmentsToDORForMeaning String Meaning of save attachments to document records.
EligibilityProfileId Long Identifier of the eligibility profile.
EligibilityProfileName String Name of the eligibility profile.
ActivationEligibilityProfileId Long Identifier of the eligibility profile used for the activation criteria in a journey task.
ActivationEligibilityProfileName String Name of the eligibility profile used for the activation criteria in a journey task.
EvaluationOffset Int Number of days to consider for eligibility evaluation.
EnableExpiryFlag Bool Indicates whether the task should expire. Valid values are Yes and No. The default value is No.
ExpiryRelativeTo String Criteria based on which the task expires.
ExpiryRelativeToMeaning String Meaning of the criteria based on which the task expires.
ExpiryDuration Int Duration after which the task expires.
ReminderDuration Int Duration of the task reminder.
ReminderRecurrence String Recurrence of the reminder.
ReminderRelativeTo String Reminder relative to task duration.
ReminderRelativeToMeaning String Meaning of reminder relative to task duration.
ReminderTemplateId Long Primary key or unique identifier of the reminder notification template.
DisplayFeatures String Task display features.
AddToLibraryFlag Bool Indicates whether the task can be added to personal task library. Valid values are Yes or No. The default is No.
FeedFlag Bool Indicates whether the atom feed is enabled for a journey task.
InitiatedFeedFlag Bool Indicates whether the atom feed is enabled when a journey task is initiated.
ReassignedFeedFlag Bool Indicates whether the atom feed is enabled when a journey task is reassigned.
CompletedFeedFlag Bool Indicates whether the atom feed is enabled when a journey task is completed.
DeletedFeedFlag Bool Indicates whether the atom feed is enabled when a journey task is deleted.
CreatedBy String User who created the task.
CreationDate Datetime Task creation date.
LastUpdatedBy String User who last updated the task.
LastUpdateDate Datetime Date on which task was last updated.
ActionCompleteLabel String Setting that enables to change the label of the complete action.
ActionRejectLabel String Setting that enables to change the label of the not applicable action.
ActionAddToCalendarLabel String Setting that enables to change the label of the add to calendar action.
ActionSaveLabel String Setting that enables to change the label of the save as draft action.
ActivityAction1Label String Setting that enables to change the label of action 1.
ActivityAction2Label String Setting that enables to change the label of action 2.
ActivityAction3Label String Setting that enables to change the label of action 3.
ActivityAction4Label String Setting that enables to change the label of action 4.
ActivityAction5Label String Setting that enables to change the label of action 5.
SourceTaskId Long Primary key or unique identifier of the source task.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CategoryFilter String CategoryFilter
CodeFilter String CodeFilter
Context String Context
ContextualAction String ContextualAction
ExcludePersonal String ExcludePersonal
Facets String Facets
FilterAttributes String FilterAttributes
JourneyId Long JourneyId
LevelFilter String LevelFilter
SearchTerms String SearchTerms
SubCategoryFilter String SubCategoryFilter
SubjectAssignmentId Long SubjectAssignmentId
SubjectPersonId Long SubjectPersonId
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839