Queries

Queries that include the Extended ID attribute (which uses the column heading of Reference) typically also include the ID or Reference Number attribute as a hidden column. This hidden attribute is used for sorting. For more information about extended IDs, see the Designer Guide.

Active HR Tasks

Purpose:

Lists all HR tasks that have not reached an End status

Prompts:

Activity Reference Number

Fields displayed:

HR Title, Creation Date, Status, Assigned Group, Title, Assigned User

Criteria:

Status is not an End status
AND Activity Reference Number is equal to <prompt user>

Activity Workload List

Purpose:

A prioritized list of activities

Prompts:

None

Fields displayed:

Priority, Class, Lifecycle, Extended ID, Raised By, Assigned Group, Assigned Analyst, Assignment Date, Assignment Number, Title, Status

Criteria:

Current Assignment User is Current User
Current Assignment.Group is Current Group
Current Assignment Group is null

All HR Activities

Purpose:

Lists all HR Activities

Prompts:

None

Fields displayed:

Extended ID, HR Title, Creation Date, Status

Criteria:

None

My HR Tasks

Purpose:

Lists all Activity Tasks that are assigned to the current user or to the current group when no user is specified.

Prompts:

None

Fields displayed:

Task Summary, Creation Date, Extended ID, Activity Raise User

Criteria:

Current Assignment is the Current User
OR Current Assignment is the Current Group
AND Current Assignment User is blank

My HR Workload

Purpose:

Lists all Activities that are assigned to the current user or to the current group when no user is specified.

Prompts:

None

Fields displayed:

Extended ID, Summary / User Name, Creation Date, Status, Requester

Criteria:

Current Assignment is the Current User
OR Current Assignment is the Current Group
AND Current Assignment User is blank

Tasks

Purpose:

Lists all Activity Tasks

Prompts:

None

Fields displayed:

Serial Number, Extended ID (Task Reference), Title, Lifecycle Title, Status

Criteria:

None