Skip to main content
SmartRecruiters

Report Builder Fields

Here's a list of all fields that are available as columns in the Report Builder. Each section lists the fields available to each entity. 

Application

Field name Type Description
Application creation date Date Date when application was created
Application ID ID Unique identifier for the candidate's job application
Earliest application creation date Date Date when candidate's first application was created
Is internal application? Boolean Boolean value showing if application was internal
Latest application creation date Date Date when candidate's latest appplication was created
Number of applications Number Total number of applications of a candidate
Time in Application State: Lead Number Total number days an application was in state: Lead
Time in Application State: New Number Total number of days an application was in state: New
Time in Application State: In-Review Number Total number days an application was in state: In-Review
Time in Application State: Interview Number Total number days an application was in state: Interview
Time in Application State: Offered Number Total number days an application was in state: Offered
Application Hire date Date Date when application was Hired. If application was marked as Hired multiple times, it is the latest date.
Application Rejection date Date Date when application was Rejected. If application was Rejected mutliple times, it is the latest date.
Application Withdrawal date Date Date when application was Withdrawn. If application was Withdrawn multiple times, it is the latest recent date
Application Transfer date Date Date when application was Transferred. If application was Transferred multiple times, it is the latest recent date
Application reason for rejection Text Rejection reason
Application reason for withdrawal Text Withdrawal reason
Application status before rejection Text The state and step of the application before it was rejected
Application status before withdrawal Text The state and step of the application before it was withdrawn

Application State

Field name Type Description
Application state Enum Current state of the application in relation to the job

Application Status

Field name Type Description
Application status Text Current state and step of the application in relation to the job

Candidate

Field name Type Description
Candidate email Text Email address of the candidate
Candidate first name Text First name of the candidate
Candidate ID ID Unique identifier for the candidate's profile
Candidate last name Text Last name of the candidate
Candidate location Text Location of the candidate
Candidate location latitude Text Location of the candidate - latitude coordinate
Candidate location longitude Text Location of the candidate - longitude coordinate
Candidate phone Text Phone number of the candidate
Number of candidates Number Total number of candidates

 

Candidate City

Field name Type Description
Candidate city Text Location of the candidate - city

Candidate Country

Field name Type Description
Candidate country Text Location of the candidate - country

Job

Field name Type Description
Earliest job creation date Date Date when job was first created (non-editable)
Job creation date Date Date when job was created
Job ID ID Unique identifier for the job
Job req ID Text Requsition ID for the job
Job title Text Name of the job
Latest job creation date Date Date when latest job was created
Number of jobs Text Total number of jobs
Job location Text Location of the job
Job location longitude Text Location of the job - longitude coordinate
Job location latitude Text Location of the job - latitude coordinate
EEO Category Enum EEO category selected at time of job creation
Experience Level Enum Job experience level selected at time of job creation
Department Org field Value Text Values of Department Org field

Job Status

Field name Type Description
Job status Enum Current status of the job (CREATED, SOURCING, INTERVIEW, OFFER, FILLED, CANCELLED)

Job City

Field name Type Description
Job City Text Location of the job - city

Job Country

Field name Type Description
Job Country Text Location of the job - country

Function

Field name Type Description
Function  Enum Standard Job Field - Job Function selected at time of job creation

Industry

Field name Type Description
Industry Enum Standard Job Field - Job Industry selected at time of job creation

Position

Field name Type Description
Earliest position creation date Date Date when the position was first created (non-editable)
Earliest position hire date Date Earliest date when a candidate was hired against this position
Earliest position open date Date Earliest date when the position is being / was opened
Is position hired? Boolean Boolean value showing if position has been hired or not
Latest position creation date Date Date when most recent position was created
Latest position hire date Date Date of the latest hire made against a position
Latest position open date Date Latest date when the position is being / was opened
Maximum Time-To-Hire Number Maximum number of days between a position's open date and the hire date of the candidate for that position
Maximum Time-To-Start Number Maximum number of days between position's open date and date that the new hire starts
Minimum Time-To-Hire Number Minimum number of days between a position's open date and the hire date of the candidate for that position
Minimum Time-To-Start Number Minimum number of days between position's open date and date that the new hire starts
Number of positions Number Aggregates the total number of positions
Position actual start date Date Date when a candidate hired against this position starts work (may be updated throughout the position lifetime)
Position creation date Date Date when the position was created (non-editable)
Position hire date Date Date when a candidate was hired against this position
Position ID ID Unique identifier of the position
Custom Position ID ID Custom Position identifier added when a position is created
Position type Enum Type of the position: (NEW, REPLACEMENT)
Position incumbent name Text Incumbent name, present only if the position type is REPLACEMENT
Position open date Date Date when the position is being / was opened (may be updated throughout the position lifetime)
Position target start date Date Date up to which a candidate is supposed to be hired (may be updated throughout the position lifetime)
Time-To-Hire Number Total number of days between a position's open date and the hire date for the candidate hired for that position
Time-To-Start Number Total number of days between the position's open date and the date that the new hire starts.

Hiring Team

Field name Type Description
Hiring team member employee ID ID Identifier of hiring team member
Hiring team member first name Text First name of hiring team member
Hiring team member last name Text Last name of hiring team memeber
Hiring team member email Text Email address of the hiring team member
Number of hiring team members Number Total number of hiring team members
Hiring team role Text User's hiring team role

Org Field

Field name Type Description
Brands Org Field Value  Text Values of the default Brands Org field
[Field Name] Org Field Value Text Values of the custom Org Field

Job Field

Field name Type Description
[Field Name] Job Field Value  Text Values of the custom Job Field

Source

Field name Type Description
Source Type Text Source type of the application.
Source Subtype Text Source sub-type of the application.
Source Text Source of the application.
Is custom source? Boolean Boolean value set to true if a source is custom, or false if it is in the default source library.