Current Job or Requisition

Indicates whether a job is a Currently Requisition or has progressed to a Current Job at job creation, advertising, assessment, onboarding or archived stages.

Job Template Name

The name of the job template used for each job. Will be blank if job was not created from a job template, or a requisition not yet attached to a job template.

Requisition Process Name

The name of the requisition process used for each job. Will be blank if job was not created from a requisition.  Note - use of this field does not limit Process Step fields to requisition steps only (use Process Type).

Assessment Process Name

The name of the assessment process used for each job. Will be blank if requisition or job is not attached to an assessment process.  Note - use of this field does not limit Process Step fields to assessment steps only (use Process Type).

Process Step Is Current

Indicates if a process step is the current workflow step (Yes) or not (No). Use this field as a filter to limit Process Step fields to just the current step.

Process Step Last Edited

The latest date that a step decision was made, as in make successful or unsuccessful. Does not include accessing steps and updating forms without making a step decision.

Process Step Permission Type

Indicates if step permission is assigned to All users with access to job, specific users, user groups and/or job roles. Will return separate rows for each type of permission. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.

Process Step Permissioned To

Indicates the User Full Name (Last, First format), Group name, or User and Role (Last, First (Role)) format for User, User Group or Role permission types respectively. May include multiple values if multiple permission types, users and/or user groups were assigned to a step. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.

Process Step Task - Date Last Accessed

The date any user last accessed a task for a given step. Single date per task across all users (not an individual date for each user).

Process Step Task - Full Name

The full name (Last, First) for any user that accessed a task for a given step.

Application Note - Reinstatement Requested

The reason given when a candidate requests to reinstate their withdrawn application.

Application Note - Withdrawn Application

The reason given when a candidate withdraws their application.

Application Reinstatement Requested

Indicates if a withdrawn candidate has requested a reinstatement of their withdrawn application.

Assessment Step - Is Current

Indicates if an assessment step is the current assessment step (Yes) or not (No). Use this field as a filter to limit Assessment Step fields to the candidate's current step.

Reference Request Status

The reference check status for an application, for when the online reference module is used.

Job Edited Date

The date that the last edits or changes were made against a job, including job details, configuration or job status update. In dd/MM/yyyy (01/01/2000) format by default. Single value per job.

Job Status Type

The job status type for the current status of each job. Single value per job.

Job Status Display Order

The order in which job statuses are displayed, for the current status of each job.

Job Status Is For Requisitions

Indicates if a job's current job status is used for requisitions only, and thus indicates if a job is a currently a requisition.

Job Template Name

The name of the job template used to create each job. Will be blank if job was not created from a job template, or a requisition not yet attached to a job template.

Role Description

The description for a role against a job.

Role Is Mandatory

Indicates if the role is mandatory.

Role Order Index

The order that job roles appear in.

Application Count - Late Application Given

Number of applications that have a late application expiry date. Includes those that may have then been submitted.

Application Count - Late Application Outstanding

Number of applications that have a late application expiry date and have not been submitted (application status is incomplete).

Application Count - Reinstatement Requested

Number of applications where reinstatement has been requested after being withdrawn, including those that have since been reinstated.

Application Count - Reinstatement Request Outstanding

Number of applications where reinstatement has been requested but not actioned after being withdrawn (application status is reinstatement requested).

Application Reinstatement Requested

Indicates if a withdrawn candidate has requested a reinstatement of their withdrawn application.

Current Application Process Step Name

The step name for a candidate's current application step.

Current Application Process Step Number

The step number for a candidate's current application step.

Current Application Process Step Status

The step status for a candidate's current application step.

Online Testing Status

The testing status for a candidate's online assessment.

Reference Request Status

The status for each reference request through the reference module.

Late Application Expiry Date Time

The date and time that a late application expires for a candidate. In dd/MM/yyyy hh:mm AM (01/01/2000 12:00 AM) format by default.

Entered Audience Date Time

The date and time a candidate logged into an application source. Usually the same as the application started date (in timestamp format).

Application Count - Application Flag

Number of distinct applications with an Application Flag.

Candidate Count - Global Flag

Number of distinct candidates with a Global Flag.

Application Count - All Notes

Number of distinct applications with a Note against them.

Application Count - Reinstatement Requests

Number of distinct applications with a Reason for Reinstatement Request Note.

Application Count - Withdrawn Notes

Number of distinct applications with a Reason for Withdrawn Application Note.

Reinstatement Requested Note

The reason given when a candidate requests to reinstate their withdrawn application.

Withdrawn Application Note

The reason given when a candidate requests to reinstate their withdrawn application.

Job Status Is For Requisitions

Indicates if a job's current job status is used for requisitions only, and thus indicates if a job is a currently a requisition.

Job Status Type

The job status type for the current status of each job. Single value per job.

Job Edited Date

The date that the last edits or changes were made against a job, including job details, configuration or job status update. In dd/MM/yyyy (01/01/2000) format by default. Single value per job.

System Event

The type of system event that forms a part of the process.

System Event Date

The date the corresponding System Event took place.

Workflow Status

Gives Job Open or Pending Open Date if the job is open (Job Status = Job Open or current date is between open and close dates) or pending open (Job Status = Pending Open Date), otherwise returns the process type for the current process step.

Days Open

Days from Job Open to Job Close (or current date if no close date). DATEDIFF(d, "JobsAndReqsList"."JobAdvertisingOpenDateTime", CASE WHEN "JobsAndReqsList"."JobAdvertisingCloseDateTime" IS NOT NULL THEN "JobsAndReqsList"."JobAdvertisingCloseDateTime" ELSE GETDATE() END)

Process Step Last Edited

The date a process step was last updated. In dd/MM/yyyy (01/01/2000) format by default.

Step Permission Type

Indicates if step permission is assigned to All users with access to job, specific users, user groups and/or job roles. Will return separate rows for each type of permission. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.

Step Permission ALL - Assigned To

Indicates the User Full Name (Last, First format), Group name, or User and Role (Last, First (Role)) format for User, User Group or Role permission types respectively. May include multiple values if multiple permission types, users and/or user groups were assigned to a step. Will be blank for permission type 'All users with access to this job' and for users that have been deleted.

Step Status - History

The step status for a corresponding process step at a point in time. Includes current and previous step statuses for the current and previous steps. In the job context for Requisition, Job Creation and Approval process types only.

Step Status - Date Updated

The date and time that a step moved to the corresponding step status. In dd/MM/yyyy h:mm a (01/01/2000 12:00 am) format by default.

Step Status - Is Current for Step

Indicates if a step status is the current status for the associated step. Includes current and former steps.

Step Status - Step Sequence Number

The sequential order step statuses were applied to a given step, within that step only.

Step Status - Max Step Sequence Number

The maximum sequence number for step statuses applied to a given step, within that step only.

Step Status - Is Current Overall

Indicates if a step status is the current status for the current step.

Step Status - Overall Sequence Number

The sequential order step statuses were applied to a job for its entire workflow, across processes and steps.

Step Status - Max Overall Sequence Number

The maximum sequence number for step statuses applied to a job for its entire workflow, across processes and steps.

Job Status Type

The job status type for the current status of each job. Single value per job.

Assessment Process Name

The name given to an assessment process. Single value per job.

Assessment Step - Is Current

Indicates if an assessment step is a candidate's current assessment step.

Assessment Step - Duration (Days)

The number of whole days (rounded down) between a candidate arriving and exiting an assessment step, or from arriving and when their application was last assessed at that step.

Step Status - History

The step status for a corresponding assessment step at a point in time. Includes current and previous step statuses for the current and previous steps. In the application context for Assessment process types only.

Step Status - Date Updated

The date and time that an application moved to the corresponding step status within the associated assessment step. In dd/MM/yyyy h:mm a (01/01/2000 12:00 am) format by default.

Step Status - Is Current for Step

Indicates if a step status is the current status for an application in the associated assessment step. Includes current and former steps.

Step Status - Step Sequence Number

The sequential order step statuses were applied to an application in a given assessment step, within that step only.

Step Status - Max Step Sequence Number

The maximum sequence number for step statuses applied to an application in a given assessment step, within that step only.

Step Status - Is Current Overall

Indicates if a step status is the current status for an application at its current assessment step.

Step Status - Overall Sequence Number

The sequential order step statuses were applied to an application across the entire assessment process.

Step Status - Max Overall Sequence Number

The maximum sequence number for step statuses applied to an application across the entire assessment process.

Step Status Updated By - Candidate or User

Indicates if the step status resulted from the action of a candidate or user. Original format IsAdminUser is true/Yes = User, false/No = Candidate.

Online Testing Status

The testing status for a candidate's online assessment.

Online Test Name

The name of the online test.

Online Test Provider

The name of the online test provider.

Online Test Process Name

The assessment process using this online test.

Online Test Process Step Name

The assessment process step name using this online test.

Online Test Process StepID

The unique identifier for the process step used for this online test.

Is Current Job Status

Indicates if a job status is the current job status.

Job Status - Days At Status

The number of whole days since the current Job Status was applied, or between Job Status - Date Updated and Next Job Status - Date Changed To, for previous Job Status - History values. Rounded down. CASE WHEN Is Current Job Status = 'Yes' THEN Job Status - Days Since Changed To ELSE Job Status - Days At Previous Status END

Job Status - Days At Current Status

The number of whole days since the current Job Status (current iteration) was applied. Rounded down. CASE WHEN Is Current Job Status = 'Yes' THEN Job Status - Days Since Changed To END

Job Status - Days At Previous Status

The number of whole days between Job Status - Date Updated and Next Job Status - Date Changed To, for the relevant Job Status - History value. Null for the current iteration of the current job status (Is Current Job Status = Yes). Rounded down.

Job Status - Days Since Changed To

The number of whole days between Job Status - Date Updated and at the time of running the report. Rounded down.

Job Status - Total Days At Status

The TOTAL number days a job has spent at a selected Job Status - History value(s). Includes number of whole days since the current Job Status was applied, or between Job Status - Date Updated and Next Job Status - Date Updated for previous Job Status - History values, all summed together. Will be segmented to the granularity of other job status history data in the report. SUM ( CASE WHEN Is Current Job Status = 'Yes' THEN Job Status - Days Since Changed To ELSE Job Status - Days At Previous Status END )

Job Status - Total Days At Previous Status

The TOTAL number of days a job has spent at a selected Job Status - History value(s). Excludes the current iteration of the current job status. Rounded down. Will be segmented to the granularity of other job status history data in the report.

Job Status - Total Days On Hold

The TOTAL number days a job has spent On Hold (Job Status - History contains 'On Hold'). Will be segmented to the granularity of other job status history data in the report. SUM ( CASE WHEN Is Current Job Status = 'Yes' AND Job Status - History LIKE '%On Hold%' THEN Job Status - Days Since Changed To WHEN Is Current Job Status = 'No' AND Job Status - History LIKE '%On Hold%' THEN Job Status - Days At Previous Status END )

Next Job Status - History

The job status that followed the corresponding Job Status - History value, based on Job Status - Sequence Number. Single value per Job Status - History.

Next Job Status - Date Updated

The date that a job was given the next job status after the corresponding Job Status - History value, based on Job Status - Sequence Number. In dd/MM/yyyy (01/01/2000) format by default.

Next Job Status - Sequence Number

The next job status sequence number for the corresponding Job Status - History value, based on Job Status - Sequence Number.

Is Current Application Status

Indicates if an application status is the current application status for an application.

Application Status - Date Changed To

The date that an application was given the corresponding application status. In dd/MM/yyyy (01/01/2000) format by default.

Application Status - Days At Status

The number of whole days between Application Status - Date Changed To and Next Application Status - Date Changed To. Null for the current iteration of the current application status (Is Current Application Status = Yes). Rounded down.

Application Status - Days At Current Status

The number of whole days since the current Application Status (current iteration) was applied. Rounded down. CASE WHEN Is Current Application Status = 'Yes' THEN Application Status - Days Since Changed To END

Application Status - Days At Previous Status

The number of whole days between Application Status - Date Updated and Next Application Status - Date Changed To, for the relevant Application Status - History value. Null for the current iteration of the current application status (Is Current Application Status = Yes). CASE WHEN Is Current Application Status = 'No' THEN Application Status - Days At Status END

Application Status - Days Since Changed To

The number of whole days between Application Status - Date Changed To and at the time of running the report. Rounded down.

Application Status - Total Days At Status

The TOTAL number days an application has spent at a selected Application Status - History value(s). Includes number of whole days since the current Application Status was applied, or between Application Status - Date Updated and Next Application Status - Date Updated for previous Application Status - History values, all summed together. Will be segmented to the granularity of other application status history data in the report. SUM ( CASE WHEN Is Current Application Status = 'Yes' THEN Application Status - Days Since Changed To ELSE Application Status - Days At Previous Status END )

Application Status - Total Days At Previous Status

The TOTAL number of days an application has spent at a selected Application Status - History value(s). Excludes the current iteration of the current application status. Rounded down. Will be segmented to the granularity of other job status history data in the report.

Next Application Status - History

The application status that followed the corresponding Application Status - History value, based on Application Status - Sequence Number. Single value per Application Status - History.

Next Application Status - Date Changed To

The date that an application was given the next application status after the corresponding Application Status - History value, based on Application Status - Sequence Number. In dd/MM/yyyy (01/01/2000) format by default.

Next Application Status - Sequence Number

The next application status sequence number for the corresponding Application Status - History value, based on Application Status - Sequence Number.

Change Type Description

A description of the change made. Generated via the following formula and fields. EventTypeName + ' | ' + CASE WHEN EventTypeName = 'Application Edited' THEN AdditionalInformation ELSE EventResultName END

Change

The details of the change made. Combines a range of fields depending on the event type name and result.

User Responsible - Candidate or User

Indicates if the user responsible for the status log was the candidate or a system user. Original format IsAdminUser is true/Yes = User, false/No = Candidate.

User Responsible - First Name

The First Name of the candidate or user responsible for the status log.

User Responsible - Last Name

The Last Name of the candidate or user responsible for the status log.