Journey Descriptive Flexfields

You use the Checklist Descriptive Flexfields task in the Setup and Maintenance work area to create and manage journey related flexfields. Review these journey descriptive flexfields, and use them as appropriate to suit your requirements.

Here's the list of journey descriptive flexfields in the application:

Application Table Name

Descriptive Flexfield Code

Name

Used

Availability

PER_ALLOCATED_TASKS

PER_PERSON_ALLOCATED_TASKS_DFF

Person Allocated Task Attributes

For creating journey task of the type Configurable Form.

Available for use.

PER_ALLOCATED_CHECKLISTS

PER_ALLOCATED CHECKLISTS_DFF

Person Allocated Checklist Attributes

For person assigned journey attributes.

Not available for use.

PER_CHECKLISTS_B

PER_CHECKLISTS_DFF

Checklist Attributes

For journey attributes.

Not available for use.

PER_TASKS_IN_CHECKLIST_B

PER_TASKS_IN_CHECKLIST_DFF

Checklist Task Attributes

For journey task.

Not available for use.

Parameters for Journey Descriptive Flexfields

This table shows the parameters that you can use in the assigned tasks DFF (PER_PERSON_ALLOCATED_TASKS_DFF):

Parameter Name

Parameter Description

Data Type

ACTION_TYPE

Action type

Varchar2

ACTUAL_END_DATE

Actual end date

Date

ACTUAL_START_DATE

Actual start date

Date

ALLOCATED_CHECKLIST_ID

Allocated checklist identifier

Number

ALLOCATED_TASK_ID

Allocated task identifier

Number

RESPONSIBILITY_TYPE

Responsibility type

Varchar2

STATUS

Status

Varchar2

TARGET_END_DATE

Target end date

Date

TARGET_START_DATE

Target start date

Date

TASK_IN_CHECKLIST_ID

Task identifier

Number

Only ALLOCATED_CHECKLIST_ID and ALLOCATED_TASK_ID are supported in Journeys.

Example

This example illustrates how to use flexfield parameters to create a value set for an assigned journey task flexfield segment. It shows how you can use descriptive flexfields (DFF) to get the legal employer details of the person to whom a journey task is assigned.

  1. Use the Checklist Descriptive Flexfields task to define the DFF (PER_PERSON_ALLOCATED_TASKS_DFF)

  2. Define the value set to be used in the DFF. Use syntax as indicated in this sample:

    FROM Clause: PER_ALLOCATED_CHECKLISTS C, PER_PERIODS_OF_SERVICE S, PER_LEGAL_EMPLOYERS L
    Value Expression: L.NAME
    WHERE Clause: C.ALLOCATED_CHECKLIST_ID = :{PARAMETER.ALLOCATED_CHECKLIST_ID} AND
    C.PERSON_ID = S.PERSON_ID AND
    S.PERIOD_TYPE = 'E' AND
    S.PRIMARY_FLAG = 'Y'
    AND S.LEGAL_ENTITY_ID = L.ORGANIZATION_ID
    AND L.STATUS = 'A'
  3. Save and deploy the DFF.

  4. Sign in as an employee and view the assigned journey task. The legal employer appears in the list.