ClearInsights Prebuilt Liveboard: Requisition Data Overview

The Requisition Data Prebuilt Liveboard is a comprehensive table that includes all the fields and details associated with individual requisitions within your ClearCompany account.

In this article:
Purpose
Default Filters
Attributes Available
Additional Resources

Purpose

The Requisition Data liveboard serves as a reference tool for stakeholders involved in the recruitment process to see details pertaining to any requisition in the system. The liveboard is ideal for clients who prefer to export their requisition data for further analysis and manipulation outside of ClearCompany. It is especially beneficial for clients with advanced Excel skills, as it includes a wide range of data points.

What kind of questions can this liveboard answer?

1. What is the budget allocation for each requisition and how does it compare to the actual costs incurred during the recruitment process?
2. Which hiring managers are associated with each requisition and how many does each manager have open?
3. How many active candidates are currently associated with each open requisition?
4. How many requisitions are open to backfill previous employees?
5. How many job requisitions are in progress, and what is the distribution among departments and offices?

---

Default Filters

Time Frame: Requisitions opened in the last 90 days.

Attributes Available

Custom Fields

Requisition Custom Fields can also be included. To add custom fields, the prebuilt liveboard must be duplicated.

Attribute	Origin	Description
Requisition ID	Requisition	Depending on your system settings, requisition ID will be either the auto-populated requisition ID or the user-provided requisition ID. When the auto-populate is enabled, ClearCompany assigns the ID upon the requisition's initial save. Requisition IDs must be unique across the organization and cannot be reused, even for unposted or deleted requisitions and templates. For more information, refer to: ATS Settings: Requisitions.
Internal Requisition ID	Requisition	The system sets a unique identifier for a requisition.
Requisition Title	Requisition	Requisition Title is populated from the requisition job title field.
Requisition Role	Requisition	The role is populated from the requisition role dropdown field.
Requisition Status	Requisition	This data point indicates the requisition status, encompassing positions that are either 'Open, Posted', or 'Open, Not Posted".
Posting Status (Public)	Requisition	This is the posting status for requisitions posted to the Public Career Site. This is marked as "Posted" whether the requisitions was posted to the Public Career Site upon creation or manually changed after it was created.
Posting Status (Internal)	Requisition	This is the posting status for requisitions posted to the internal job board.
Hiring Manager	Requisition	This data point is populated from the requisition in the hiring team section.
Recruiter	Requisition	This data point is populated from the requisition in the hiring team section.
Department	Requisition	The department is populated from the requisition in the administrative info section.
Requisition Posted Locations	Requisition	This will list out the selected posting locations for a requisition. This is selected from the requisition Posting Options → Location(s) for Job Boards (US). Up to 30 locations (including remote) can be selected to increase visibility for your job opening. We default your office as one of those locations, but you can remove it and specify other locations if needed.
Requisition Office	Requisition	The office is populated from the requisition in the administrative info section.
Daily Date Requisition Opened	Requisition	The date is displayed as the requisition's open date. This is automatically assigned when the requisition is created, regardless of status. This can be manually changed with the 'Select a open date' field on the requisition.
Daily Date Requisition Closed	Requisition	The date a requisition is closed will be reflected here. This column will display "Null" if the requisition is still open. If the position is reopened and closed, it will replace the date.
EEO Type	Requisition	This data point is populated from the requisition in the administrative info section.
Budgeted Type	Requisition	This data point is populated from the requisition in the administrative info section.
Requisition Salary Range Min	Requisition	The minumum salary range assigned to the requisition. This field is optional and inputted under the Administrative Info section of a requisition.
Requisition Salary Range Max	Requisition	The maximum salary range assigned to the requisition. This field is optional and inputted under the Administrative Info section of a requisition.
Requisition Salary Type	Requisition	The type of salary associated with the requisition’s salary range (e.g., per year, per hour). This field is optional and selected under the Administrative Info section of a requisition.
Daily Desired Start Date	Requisition	This data point is populated from the requisition in the administrative info section.
Replacing	Requisition	The person that the requisition is replacing. This field is optional and selected under the Administrative Info section of a requisition.
Requisition Active Sponsorship	Requisition	This indicates if a requisition is posted using one or more paid sponsorhips (i.e. Indeed Sponsored)
Requisition Furthest Stage Reached	Workflow	The furthest Stage any candidate has reached for the requisition. Although candidates may currently be in other Stages, this serves as an indicator of the furthest progress made by one or more candidates.
Average Requisition Open Days	Requisition	The average number of days between the "Date Requisition Opened" and "Date Requisition Closed" fields of a requisition.
Total Number of Openings	Requisition	The number of openings assigned to the requisition. This field is optional and inputted under the Administrative Info section of a requisition.
Remaining Openings	Requisition	This data point shows the number of remaining openings, based on the number of candidates in the Hired Macrostage versus the number of openings set on the requisition.
Total Count of Active Candidates	Requisition	The total number of active candidates in the requisition. This only includes candidates in the following macro stages: new applicants, screening, interviewing, offer, or hired.
Total Count Candidate ID	Requisition	The total number of candidates in the requisition, active or dispositioned.

---

Additional Resources

ClearInsights: Talent Acquisition Data & Attributes
ClearInsights: Talent Development Data & Attributes
Custom Fields Overview