Skip to main content
SmartRecruiters

Report Builder Fields

Requires:
  • SmartRecruit

 

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 application 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
Time in Application Status: [State/Custom step] Number Total number of days an application was in [State/Custom step] Application Status
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 date
Application Transfer date Date Date when application was Transferred. If application was Transferred multiple times, it is the latest date
Application Status last change date Date Date when the application's status was last updated
Application State: Hired Date Date Date when the application was last moved to Hired
Application State: In-Review Date Date Date when the application was last moved to In-Review
Application State: Interview Date Date Date when the application was last moved to Interview
Application State: Lead Date Date Date when the application was last moved to Lead
Application State: New Date Date Date when the application was last moved to New
Application State: Offer Date Date Date when the application was last moved to Offer
Application State: Rejected Date Date Date when the application was last moved to Rejected
Application State: Transferred Date Date Date when the application was last moved to Transferred
Application State: Withdrawn Date Date Date when the application was last moved to Withdrawn
Application Status: [State/custom step] date Date Date when the application was last moved to [State/Custom step].
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 URL Text URL link to the candidate's application

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
Application custom step Text Current custom step of the application in relation to the job

Application Status Change

Field Name Type Description
Application Status Change Date Date Date when the application was changed to a particular status
Application Status Change Value Text Values of historical state and custom step changes for the application
Application State Change Value Enum Values of historical state changes for the application
Application Custom Step Change Value Text Values of historical custom step changes for the application

Candidate

Field name Type Description
Candidate ID ID Unique identifier for the candidate's profile
Candidate email Text Email address of the candidate
Candidate first name Text First name of the candidate
Candidate last name Text Last name of the candidate
Candidate first and last name Text First and 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 consent status Enum Candidate consent can have 3 statuses: Required, Requested and Acquired
Latest consent acquired date Date Latest date when candidate's consent was acquired. It is empty if candidate has never provided consent.
Latest consent request date Date Latest date when candidate's consent was requested. It is empty if candidate has never been sent a consent request.

 

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
Job ID ID Unique identifier for the job
Job ref ID Text Requisition ID for the job
Job title Text Name of the job
Job creation date Date Date when job was created
Number of jobs Text Total number of jobs
Job Status Last Change Date Date Date when the job's status was last updated
Job Status: Canceled Date Date Date when the job was last moved to CANCELED
Job Status: Created Date Date Date when the job was last moved to CREATED
Job Status: Filled Date Date Date when the job was last moved to FILLED
Job Status: Interview Date Date Date when the job was last moved to INTERVIEW
Job Status: Offer Date Date Date when the job was last moved to OFFER
Job Status: Sourcing Date Date Date when the job was last moved to SOURCING
Job location Text Location of the job - street address
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
Type of Employment Enum Standard Job Field - Type of employment selected at time of job creation
Internal notes Text Internal notes added on a job
Department Org field Value Text Values of Department Org field
Recruiters Text An aggregated list of Recruiters by name on the hiring team of a job
Coordinators Text An aggregated list of Coordinators by name on the hiring team of a job
Hiring Managers Text An aggregated list of Hiring Managers by name on the hiring team of a job
Interviewers Text An aggregated list of Interviewers by name on the hiring team of a job
Executives Text An aggregated list of Executives by name on the hiring team of a job

Job Status

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

Job Status Change

Field name Type Description
Job Status Change Date Date Date when the job was changed to a particular status
Job Status Change Value Enum Value of historical status changes for the job

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.

Hired Position

Field name Type Description
Hired position actual start date Date Date when a candidate hired against this position starts work (may be updated throughout the position lifetime)
Hired position creation date Date Date when the hired position was created (non-editable)
Hired position hire date Date Date when a candidate application was marked as hired against this position
Hired Position ID ID Unique identifier of the hired position (non-editable)
Hired Position Custom ID ID Custom Position identifier added when a position is created
Hired position type Enum Type of the hired position: (NEW, REPLACEMENT)
Hired position incumbent name Text Incumbent name, present only if the position type is REPLACEMENT
Hired position open date Date Date when the hired position is being / was opened (may be updated throughout the position lifetime)
Hired position target start date Date Date up to which a candidate is supposed to be hired (may be updated throughout the position lifetime)
Hired position 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
Hired 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 first and last name Text First and last name of the hiring team member
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

Application Fields (aka Candidate Fields)

Field name Type Description
Application field: [Field Name]  Text Values of the [Field Name] application field
User Application field: [Field Name] Employee ID ID Employee ID value of [Field Name] application field.
User Application field: [Field Name] First name and last name Text First and last name value of [Field Name] application field.
User Application field: [Field Name] Email Text Email value of [Field Name] application 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.