SmartRecruit: 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 Last Updated Date | Date | Date when the application was last updated |
| Application Deletion Reason | Enum | The origin of the application deletion, one of the following values: Manual deletion, No consent provided, End of retention period, Candidate self deletion |
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 Tags Values | Text | Combined, comma-separated list of tags for the candidate. |
| Number of Candidate Tags | Number | Counts the total number of tags for the candidate. |
| Candidate Last Updated Date | Date | Date when the candidate was last updated |
| Is Candidate Deferred? | Boolean | Boolean value set to TRUE if candidate is currently deferred, FALSE if not. |
| Current Title | Text | Title of candidate's current or most recent role |
| Current Employer | Text | Company name of candidate's current or most recent role |
| Candidate Deletion Reason | Enum | The origin of the candidate deletion, one of the following values: Manual deletion, No consent provided, End of retention period, Candidate self deletion |
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 |
Candidate Source
| Field name | Type | Description |
|---|---|---|
| Is custom source? | Boolean | Boolean value set to TRUE if a source is custom, or FALSE if it is in the default source library |
| Source subtype | Text | Source sub-type of the candidate, which is the source sub-type from their very first application. |
| Source type | Text | Source type of the candidate, which is the source type from their very first application. |
| Source name | Text | Source of the candidate, which is the source from their very first application. |
| Candidate Source Referrer Email | Text | Email of the referrer |
| Candidate Source Referrer First and Last Name | Text | First and last name of the referrer |
| Candidate Source Referrer ID | Text | Unique identifier of the referrer |
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 |
| Job location - State | Text | Location of the job - State |
| 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 |
| Is Job Template? | Boolean | Boolean value set to TRUE if job is also a job template, FALSE otherwise. |
| Salary Lower Limit | Number | The lower limit of salary range specified when positions are added to the job. |
| Salary Upper Limit | Number | The upper limit of salary range specified when positions are added to the job. |
| Job Approval Process Creation Date | Date | Date when the job approval process was created and sent to approvers. |
| Job Approval Process ID | Number | Unique identifier of the job approval process. |
| Job Approval Process Pending Days | Number | The total number of days that the job approval process has been been in PENDING status. |
| Job Approval Process Status Change Date | Date | Date when the job approval process was APPROVED or REJECTED. |
| List of Job Approvers | Text | Combined, comma-separated list of unique job approvers by name. |
| Number of Job Approvers | Number | Counts the total number of unique job approvers. |
| Job Approval Creator First and Last Name | Text | First and last name of the user who created the job approval. |
| Job Approval Creator Email | Text | Email of the user who created the job approval. |
| Job Approval Employee ID | ID | Unique identifier of the user who created the job approval. |
| Job Approval Comments | Text | Aggregated list of user comments for a job approval. |
| Job Approval Chain Type | Enum | Three types: Sequential, Parallel all approvals required, Parallel with at least one approval required. |
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. |
| Referrer Email | Text | Email of the referrer |
| Referrer First and Last Name | Text | First and last name of the referrer |
| Referrer ID | Text | Unique identifier of the referrer |
Review
| Field name | Type | Description |
|---|---|---|
| Review Date | Date | Date when the review was first created. |
| Review ID | ID | Unique identifier of the review. |
| Review Rating | Number | Rating given in the review. |
| Review Text | Text | Text content of the review. |
| Reviewer Email | Text | Email address of the reviewer. |
| Reviewer First and Last Name | Text | First and last name of the reviewer. |
| Reviewer Id | Text | Unique identifier of the reviewer. |
Scorecard
| Field name | Type | Description |
|---|---|---|
| Criteria ID | ID | The unique identifier of the scorecard criteria |
| Criteria name | Text | Name of the scorecard criteria |
| Criteria description | Text | Description entered for the criteria |
| Criteria questions | Text | Questions entered for the criteria, displayed as a comma separated list |
| Criteria rating | Number | Rating given for the criteria |
| Criteria feedback | Text | Feedback provided for the criteira |
Job Approval
| Field name | Type | Description |
|---|---|---|
| Job Approver ID | ID | Unique identifier of the job approver. |
| Job Approver First and Last Name | Text | Name of the job approver. |
| Job Approver Email | Text | Email of the job approver. |
| Job Approval Status Change Date | Date | Date when user either APPROVED or REJECTED the job approval. |
| Job Approval Pending Days | Number | The total number of days the user left the job approval in PENDING status. |
Offer
| Field name | Type | Description |
|---|---|---|
| Offer ID | ID | Unique identifier of an offer |
| Offer creation date | Date | Date when offer was created. |
| Offer accepted date | Date | Date when offer was accepted by the candidate. |
| Offer extended date | Date | Date when offer was extended to the candidate. |
| Offer Creator ID | ID | Unique identifier of the offer creator. |
| Offer Creator First and Last Name | Text | Name of the offer creator. |
| Offer Creator email | Text | Email of the offer creator. |
| Offer Status | Text | Status of the offer. |
| Offer Approval Process ID | ID | Unique identifier of the offer approval process. |
| Offer Approval Process Status | Text | Current status of the offer approval process. Includes: PENDING, APPROVED, REJECTED |
| Offer Approval Process Creation Date | Date | Date when the offer approval process was created and sent to approvers. |
| Offer Approval Process Pending Days | Text | The total number of days that the offer approval process has been been in PENDING status. |
| Offer Approval Process Status Change Date | Date | Date when the offer approval process was APPROVED or REJECTED. |
| Number of Offer Approvers | Number | Counts the total number of unique offer approvers. |
| List of Offer Approvers | Text | Combined, comma-separated list of unique offer approvers by name. |
| Offer Approval Creator First and Last Name | Text | First and last name of the user who created the offer approval. |
| Offer Approval Creator Email | Text | Email of the user who created the offer approval. |
| Offer Approval Employee ID | ID | Unique identifier of the employee who created the offer approval. |
| Offer Approval Comments | Text | Aggregated list of user comments for a offer approval. |
| Offer Approval Chain Type | Enum | Three types: Sequential, Parallel all approvals required, Parallel with at least one approval required. |
Offer Approval
| Field name | Type | Description |
|---|---|---|
| Offer Approver ID | ID | Unique identifier of the offer approver. |
| Offer Approver First and Last Name | Text | Name of the offer approver. |
| Offer Approver Email | Text | Email of the offer approver. |
| Offer Approval Status Change Date | Date | Date when user either APPROVED or REJECTED the offer approval. |
| Offer Approval Status | Text | Status of the offer approval. |
| Offer Approval Pending Days | Number | The total number of days the user left the offer approval in PENDING status. |
Offer Process
| Field name | Type | Description |
|---|---|---|
| Offer Process ID | ID | Unique identifier of the entire offer process that includes current and pass offers created. |
| Offer Process Start Date | Date | Start date of the offer process, which is also the same date when the earliest offer was created for application. |
| Offer Process Creator ID | ID | Unique Identifier of the user who created the offer process for the application. |
| Offer Process Creator First and Last Name | Text | First and last name of the user who created the offer process for the application. |
| Offer Process Creator Email | Text | Email of the user who created the offer process. |
Interview
| Field name | Type | Description |
|---|---|---|
| Interview ID | ID | Unique identifier of the interview |
| Application status linked to the interview | Text | Status of the application for which the interview was scheduled. |
| Interview creation date | Date | Date when interview is created |
| Interview creation source | Enum | Source of the interview creation: UI, PUBLIC_API, SELF_SCHEDULING. |
| Interview creator email | Text | Email address of the interview creator. |
| Interview creator employee ID | ID | Unique identifier of the interview creator. |
| Interview creator first and last name | Text | First and last name of the interview creator. |
| Interview date | Date | Date of the interview. |
| Interview last update date | Date | Date when the interview was last updated. |
| Interview location details | Text | Detailed location information of the interview. It may be a physical address, phone number or meeting id. |
| Interview location type | Enum | Location type of the interview: COMPANY ADDRESS, JOB'S LOCATION, PHONE, VIDEO, OTHER. |
| Interview time zone | Text | Interview time zone name. |
| Is Interview canceled? | Boolean | Boolean value set to TRUE if the interview has been canceled by the interview creator, set to FALSE otherwise. |
| Earliest interview date | Date | Date of a candidate's first interview. |
| Latest interview date | Date | Date of candidate's latest interview. |
| Number of interviews | Number | Total number of scheduled interviews. |
Interview Timeslot
| Field name | Type | Description |
|---|---|---|
| Interview Timeslot Duration | Number | Duration of the interview timeslot in hours. |
| Interview Timeslot End Time | Date | End date and time of the timeslot. The end time is in the interview time zone. |
| Interview Timeslot Start Time | Date | Start date and time of the timeslot. The start time is in the interview time zone. |
| Interview Timeslot Event Title | Text | Event title of the interview timeslot. |
| Interview Timeslot Resources | Text | Combined, comma-separated list of interview timeslot resources. |
| Interview Timeslot Type | Text | Type of the interview for the timeslot. |
| Number of Interview Timeslots | Number | Total number of timeslots created for the interview. |
| Total Interview Timeslots Duration | Number | Total duration of all the timeslots created for the interview in hours. |
Interviewer
| Field name | Type | Description |
|---|---|---|
| Interviewer Email | Text | Email address of the interviewer |
| Interviewer First and Last name | Text | First and last name of the interviewer. |
| Interviewer ID | ID | Unique identifier of the interviewer |
| Interviewer Status | Enum | Interviewer acceptance status for the appointment: PENDING, TENTATIVE, ACCEPTED, DECLINED. |
Screening Question Answer
| Field name | Type | Description |
|---|---|---|
| Is Diversity Screening Question? | Boolean | Boolean value set to TRUE if the screening question is a diversity question, set to FALSE otherwise. |
| Screening Question Answer | Text | Answer to the screening question. |
| Screening Question ID | ID | Unique identifier of the screening question. |
| Screening Question Text | Text | Long text of the screening question. |
| Screening Question Title | Text | Short title of the screening question. |
| Screening question [Question Name] answer | Text | Answer to the screening question [Question Name] |
| Screening question [Question Name] answered? | Boolean | Boolean value set to TRUE if the question has been answered, set to FALSE otherwise. |
Assessment
| Field name | Type | Description |
|---|---|---|
| Assessment ID | ID | Unique identifier of the assessment. |
| Assessment status | Text | Assessment's status after it was sent to a candidate: Pending, In Progress, Completed, Rejected. |
| Assessment name | Text | The name of the assessment as provided by the partner |
| Assessment type | Text | The assessment types can be: Background Check, Behavioral Assessment, Reference Check, Skills Test, Video Interview, Inline Assessment |
| Partner name | Text | The name of the partner who is providing the assessment. |
| Assessment creation date | Date | Date when an assessment was created for an application. |
| Assessment updated date | Date | Date when assessment was last updated. |
| Assessment requestor ID | ID | Unique identifier of the user who is sending the assessment |
| Assessment requestor first and last name | Text | First and last name of the user who is sending the assessment |
| Assessment requestor email | Text | Email of the user who is sending the assessment |
Employment History
| Field name | Type | Description |
|---|---|---|
| Occupation/Title | Text | Title of candidate's role |
| Company/Business Name | Text | Company name of candidate's job |
| Job Description/Responsibilities | Text | Description of candidates' job responsibilities |
| Is current experience? | Boolean | Boolean value set to TRUE if this entry is candidate's current job, FALSE if it is not. |
| Employment start date | Date | Start date when candidate was employed |
| Employment end date | Date | End date when candidate was employed |
Education History
| Field name | Type | Description |
|---|---|---|
| Education start date | Date | Start date of candidate's education entry |
| Education end date | Date | End date of candidate's education entry |
| Education degree | Text | Degree earned by candidate |
| Education major | Text | Major studied by candidate |
| Educational institution | Text | Name of the educational institution |
Resume
| Field name | Type | Description |
|---|---|---|
| Is resume attached? | Boolean | Boolean value set to TRUE if at least one resume is attached to the candidate's application and FALSE if no resumes are attached |
| Resume last update date | Date | Date when the resume file was last updated |
| File name | Text | Name of the resume file |
Candidate Deferral
| Field name | Type | Description |
|---|---|---|
| Deferral creation date | Date | Date when deferral was created on the candidate |
| Deferral note | Text | Text note added on the candidate about the deferral |
| Deferral expire date | Date | Date until when deferral on the candidate ends |