List of all interviews per panel scheduled in Lever.
Here is a comprehensive list of the the fields and definitions within the Interviews data source.
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 |