| Field Type |
Field Name |
Data Type |
Definition |
| Dimension |
All Stages |
Text |
Used to group all Interview Stages together and toggle between showing individual stages or one "All Stages" column. (Helper dimension for more complex calculations) |
| Dimension |
Interiew Stage |
Text |
Name of a stage which this consideration was in, at some point during this timespan |
| Dimension |
applicationId |
Text |
Unique id of the application the record belongs to |
| Dimension |
Blank |
Text |
Helper dimension to show a blank in the dashboard when there is no data, instead of null |
| Dimension |
Candidate Name |
Text |
The name of the candidate being interviewed |
| Dimension |
considerationArchiveReason |
Text |
Reason why this consideration was archived |
| Dimension |
feedbackType |
Text |
If the feedback type on the interview was a general recommendation or a rating score |
| Dimension |
Interviewer Name |
Text |
Name of the interviewer for a particular interview event |
| Dimension |
interviewEventId |
Text |
Unique id of an interview event |
| Dimension |
interviewStageName |
Text |
Same as Interview Stage, but can be used without "All Stages" grouping |
| Dimension |
panelId |
Text |
Unique id for an interview panel consisting of one or more interview events |
| Dimension |
panelStartDate |
Datetime |
Date for when interview panel is scheduled to begin |
| Dimension |
Posting Location |
Text |
Location of the posting associated with this interview |
| Dimension |
postingDepartment |
Text |
Department of the posting associated with this interview |
| Dimension |
postingHiringManagerName |
Text |
Name of hiring manager of the posting associated with this interview |
| Dimension |
postingId |
Text |
Unique id of the posting associated with this interview |
| Dimension |
postingLastClosedDate |
Datetime |
Date of the most recent time the posting was closed |
| Dimension |
postingLocation |
Text |
Location of the posting associated with this interview |
| Dimension |
postingOwnerName |
Text |
Owner of the posting associated with this interview |
| Dimension |
postingPublishedInternalDate |
Datetime |
Date when the posting was published as Internal |
| Dimension |
postingPublishedPublicDate |
Datetime |
Date the posting was published as Public |
| Dimension |
postingStatus |
Text |
Status of the posting associated with this interview |
| Dimension |
postingTeam |
Text |
Team of the posting associated with this interview |
| Dimension |
postingTitle |
Text |
Job title of the posting associated with this interview |
| Dimension |
profileId |
Text |
Unique id of the profile for the candidate this record belongs to |
| Dimension |
profileOwnerName |
Text |
Name of the owner of this candidate's profile |
| Dimension |
reqId |
Text |
Unique id of the requisition associated with the posting that this interview is for |
| Dimension |
Requisition Code |
Text |
Requisition code for the job posting that this consideration is interviewing for |
| Dimension |
Requisition Department |
Text |
Department of the requisition associated with the posting that this consideration applied to |
| Dimension |
Requisition Hiring Manager |
Text |
Hiring manager of the requisition associated with the posting that this consideration applied to |
| Dimension |
Requisition Location |
Text |
Location of the requisition associated with the posting that this consideration applied to |
| Dimension |
Requisition Name |
Text |
Name of the requisition associated with the posting that this consideration applied to |
| Dimension |
Requisition Owner Name |
Text |
Owner of the requisition associated with the posting that this consideration applied to |
| Dimension |
Requisition Team |
Text |
Team of the requisition associated with the posting that this consideration applied to |
| Dimension |
schedulerName |
Text |
The name of the person who scheduled the panel interview |
| Measure |
Average Feedback |
Numeric |
Average of all available feedback value on a Tableau view / table |
| Measure |
feedbackValue (helper) |
Numeric |
Helper feedback value recorded for an interview in a feedback form |
| Measure |
feedbackValue |
Numeric |
Feedback value recorded for an interview in a feedback form |
| Measure |
stageIndex |
Numeric |
Order of all the stages the candidate passed through during the recruitment process |
| Measure |
Total Submitted Feedback |
Numeric |
Count of all the interview events where feedback was submitted for the candidate |
| Measure |
UpcomingInterviews |
Numeric |
Count of all interview panels where the panel start date is after the End date selected on a dashboard |
