ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

WorkerJourneystasksnotifications

WorkerJourneystasksnotifications

Columns

Name Type Description
WorkerJourneysWorkerJourneyId [KEY] Long Unique identifier of the journey.
TasksWorkerJourneyTaskId [KEY] Long Unique identifier of the journey task.
WorkerJourneyTaskNotificationId [KEY] Long Unique identifier of the journey task notification.
TaskEvent String Code of the task event. For example, task initiated, task updated, task deleted, task completed.
TaskEventMeaning String Meaning of the task event.
NotifyPerformerFlag Bool Indicates whether the task performer needs to be notified when the event occurs. Valid values are Yes and No. The default value is Yes.
NotifyOwnerFlag Bool Indicates whether the task owner needs to be notified when the event occurs. Valid values are Yes and No. The default value is No.
CreatedBy String User who created the notification.
CreationDate Datetime Date on which the notification was created.
LastUpdatedBy String User who last updated the notification
LastUpdateDate Datetime Date on which the notification was updated.

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
StatusCategory String StatusCategory
StatusFilter String StatusFilter
SubCategoryFilter String SubCategoryFilter
WorkerJourneyId Long WorkerJourneyId
Finder String finder

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