JourneyTaskLibrarynotifications
JourneyTaskLibrarynotifications
Columns
| Name | Type | Description |
| JourneyTaskLibraryLibraryJourneyTaskId [KEY] | Long | Unique identifier of the library journey task. |
| LibraryJourneyTaskNotificationId [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 if the task performer needs to be notified when the event occurs. Valid values are Yes and No. Default is Yes. |
| NotifyOwnerFlag | Bool | Indicates if the task owner needs to be notified when the event occurs. Valid values are Yes and No. Default is No. |
| PerformerTemplateId | Long | Primary key or unique identifier of the notification template for task performer. |
| OwnerTemplateId | Long | Primary key or unique identifier of the notification template for task owner. |
| PerformerNotApplicableTemplateId | Long | Primary key or unique identifier of the notification template when a task is marked as not applicable for task performer. |
| OwnerNotApplicableTemplateId | Long | Primary key or unique identifier of the notification template when a task is marked as not applicable for task owner. |
| PerformerExpiryTemplateId | Long | Primary key or unique identifier of the expiry notification template for task performer. |
| OwnerExpiryTemplateId | Long | Primary key or unique identifier of the expiry notification template for task owner. |
| PerformerForceCompleteTemplateId | Long | Primary key or unique identifier of the force completion notification template for task performer. |
| OwnerForceCompleteTemplateId | Long | Primary key or unique identifier of the force completion notification template for task owner. |
| CreatedBy | String | User who created the notification. |
| CreationDate | Datetime | Date on which the notification was created. |
| LastUpdatedBy | String | User who last updated notification. |
| LastUpdateDate | Datetime | Date on which notification was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| LibraryJourneyTaskId | Long | LibraryJourneyTaskId |
| SearchTerms | String | SearchTerms |
| Finder | String | finder |
| MPersonId | Long | mPersonId |
| PStatus | String | pStatus |