4.2 eRecruit Process Step Data

Template First Created

The date and time when this process commenced. The start condition depends on the process type:

* Requisition Process - When the first step in the requisition process started.

* Job Creation Wizard - When the job creation wizard started.

* Assessment Process - When the first applicant reached the first step in the assessment process.

* Candidate Approval - When the first step in the candidate approval process started.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Template Last Edited

The date and time when any step in this process was last edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Template Creation - Last Action (Minutes)

The duration, in minutes, between the creation of the process (e.g. create a job from a template) and the last time ANY (i.e not just the furthest) step in the process was actioned. An action could be editing a requisition form or an assessment form, or pushing an application through the process.

Format: Integer

Template First Action - Last Action (Minutes)

The duration, in minutes, between the first action in a process (e.g. the first application is received) and the last time ANY (i.e not just the furthest) action was performed on ANY step in the process. An action could be editing a requisition form or an assessment form, or pushing an application through the process.

Format: Integer

REQ Process Start - Finish (Minutes)

The duration, in minutes, it took for the requisition process to complete.

If the row is for a step in the requisition process then the value of this field will equal the value of the "Process First Action to Last Action Duration (Minutes)" field. If you are looking at a row for a step for another process then the value of the "Process First Action to Last Action Duration (Minutes)" field will equal the duration of that process.

Format: Integer

APM Process Start - Finish (Minutes)

The duration, in minutes, it took for the assessment process to complete.

If the row is for a step in the assessment process then the value of this field will equal the value of the "Process First Action to Last Action Duration (Minutes)" field. If you are looking at a row for a step for another process then the value of the "Process First Action to Last Action Duration (Minutes)" field will equal the duration of that process.

Format: Integer

Entire Process Start - Finish (Minutes)

The duration, in calendar days, of the complete workflow process for this job.

The workflow process duration is the sum of the duration for each process type, that is:

Requisition Process Duration (Minutes) + Job Creation Wizard Duration (Minutes) + Assessment Process Duration (Minutes) + Candidate Approval Duration (Minutes)

Format: Integer

REQ Completion (%)

The duration of the requisition process epxressed as a percentage of the duration of the complete workflow.

JCW Completion (%)

The duration of the job creation wizard epxressed as a percentage of the duration of the complete workflow.

APM Completion (%)

The duration of the assessment process epxressed as a percentage of the duration of the complete workflow.

JCW Process Start - Finish (Minutes)

The duration, in minutes, it took for the job creation wizard to complete.

If the row is for a step in the job creation wizard then the value of this field will equal the value of the "Process First Action to Last Action Duration (Minutes)" field. If you are looking at a row for a step for another process then the value of the "Process First Action to Last Action Duration (Minutes)" field will equal the duration of that process.

Format: Integer

Process Step First Created

The date and time when this process step commenced. The start condition depends on the process type:

* Requisition Process - When this step in the requisition process is started.

* Job Creation Wizard - When this step in the job creation wizard is started.

* Assessment Process - When the first applicant reached this step in the assessment process.

* Candidate Approval - When this step in the candidate approval process is started.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Process Step Last Edited

The date and time when this step in this process was lasted edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Process Step Time Taken (Minutes)

The duration, in minutes, between the first action in a step (e.g. the first application entering the step) and the last time that step was actioned. An action could be editing a requisition or assessment form, or changing the step status.

Format: Integer

# of Applicants Complete

The number of complete and submitted applications for this job that have an assessment status of "Complete" for this step.

Format: Integer

# of Applicants in Progress

The number of complete and submitted applications for this job that have an assessment status of "In Progress" at this step.

Format: Integer

# of Applicants Not Started

The number of complete and submitted applications for this job that have an assessment status of "Not Started" at this step.

Format: Integer

# of Applicants On Hold

The number of complete and submitted applications for this job that have an assessment status of "On Hold" at this step.

Format: Integer

# of Applicants Pending

The number of complete and submitted applications for this job that have an assessment status of "Pending" at this step.

Format: Integer

# of Applicants Successful

The number of complete and submitted applications for this job that have an assessment status of "Successful" at this step.

Format: Integer

# of Applicants Unsuccessful

The number of complete and submitted applications for this job that have an assessment status of "Unsuccessful" at this step.

Format: Integer

# of Applicants Withdrawn

The number of complete and submitted applications for this job that have an assessment status of "Withdrawn" at this step.

Format: Integer

Process Created On

The date and time when this process was first created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Process is Active

Identifies if this process is currently active and available for use or inactive and not available for use.

Available Values:
* Active
* Inactive

Process is Template

Identifies if this is a process template or a process derived from a process template.

Available Values:
* Process Template
* Process

Process Name

The user entered name of the process template.

The values in this field are based on the names given to the various requisition, assessment or candidate approval processes created in the eRecruit system.

Example Values:
* Request to Recruit
* Job Creation Wizard
* Casual Position - Online Assessment

Step Auto Complete

Identifies if this process step completes automatically or requires user intervention to be completed.

Available Values:
* Automatic
* Manual

Process Step ID

The internal system code that uniquely identifies this process step.

This field should be used to count unique process steps or when creating joins to sub-queries.

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

Process Step is Template

Identifies if this is a process step template or a process step derived from a process step template.

Available Values:
* Process Step Template
* Process Step

Process Step Mandatory

Identifies if the completion of this step is mandatory or optional in the process

Available Values:
* Mandatory
* Optional

Process Step Name

The user entered name of the process step.

The values in this field are based on the names given to the various process steps created in the eRecruit system.

Example Values:
* Request to Recruit
* Job Creation Wizard
* Casual Position - Online Assessment

Process Step Number

The overall sequential number for this step in the process type for this job.

This field is used to sort all steps in the process type in the chronological order they occurred.

Format: Integer

Last Process Step Number

The maximum value of the field "Process Step Number" for a given job.

This field allows the most recently executed step in the process type to be identified.

Format: Integer

Overall Workflow Step Number

The overall sequential number for this step in the workflow for this job. This number sequence spans all process types used in the workflow.

This field is used to sort all steps in the workflow in the chronological order they occurred.

Format: Integer

Last Overall Process Step Number

The maximum value of the field "Overall Workflow Step Number" for a given job.

The overall number of workflow steps for a job is the sum of all of the steps in the processes (i.e. Requisition + Job Creation Wizard + Assessment Process + Candidate Approval Process).

This field allows the most recently executed step in the overall workflow to be identified.

Format: Integer

Process Type Description

The type of process within the overall workflow.

Available Values:
* Requisition Process
* Job Creation Wizard
* Assessment Process
* Candidate Approval

Step Created:

Step Edited:

Step Status

The status of this process step for this job.

Available Values:
* Not Started
* In Progress
* Complete

Creation to Last Modified (Minutes)

The internal system code that uniquely identifies this overall workflow.

This field should be used to count unique workflow or when creating joins to sub-queries.

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

ProcessID

The internal system code that uniquely identifies this process.

This field should be used to count unique processes or when creating joins to sub-queries.

Format: Universally Unique Identifier (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

First Name

The first / given name of the user assigned to this process step.

Last Name

The last / family name of the user assigned to this process step.

Email

The email address of the user assigned to this process step.

Format: Email address

Example Value: martin.james@domain.com

User Group

The eRecruit user group of the user assigned to this process step.

Username

The eRecruit user name of the user assigned to this process step.

Example Value: d.jones

User Group is Vendor

Identifies if the user assigned to this process step is internal to the organisation or an external vendor.

Available Values:
* Internal
* Vendor

Vendor Branch Name

The name of the branch of the vendor user assigned to this process step.

If the user is internal to the organisation the value of this field is empty.

Example Value: Sydney North

Date Task Last Edited

UserRegion

The region entered in the user record of the user with permission to complete this process step.

Permission Type

Identifies the if the permission applied to this process step is allocated to a user or group.

Available Values:
* User
* Group

Permission Target

User Group Name

The name of the group with permission to complete to this process step.

Format: GroupName

Example Value: Graduate Recruiters

User Group Description

The decription of the group with permission to complete to this process step.

Format: Group Description

Example Value: The graduate recruitment team.

User Group Status

Identifies the status in eRecruit of the group with permission  to complete this process step.

Available Values:
* Active
* Inactive

User Group is Vendor

Identifies if the group with permission  to this process step is / are internal to the organisation or an external vendor.

Available Values:
* Internal
* Vendor

Vendor Branch Name

The name of the branch of the vendor group with permission to complete this process step.

If the user is / are internal to the organisation the value of this field is empty.

Example Value: Sydney North

Title

The title of the user with permission to complete this process step.

Example Values:
* Mr
* Ms
* Dr

Middle Name

The first / given name of the user with permission to complete this process step.

First Name

The middle name of the user with permission to complete this process step.

Last Name

The last / family name of the user with permission to complete this process step.

Email

The email address of the user(s) with permission to complete this process step.

Format: Email address

Example Value: martin.james@domain.com

Username

The eRecruit user name of the user with permission to complete this process step.

Example Value: d.jones

User Expiry Date

User Status

Identifies the status in eRecruit of the user with permission  to complete this process step.

Available Values:
* Active
* Inactive

UserGroup

The name of the group that the user with permission to complete to this process step belongs to.

Format: GroupName

Example Value: Graduate Recruiters

User Group is Vendor

The name of the branch of the vendor group with permission to complete this process step.

If the user is / are internal to the organisation the value of this field is empty.

Example Value: Sydney North

Vendor Branch Name

User Timezone Label

User Timezone Name