Interviews data source fields and definitions

Follow
Available for Roles LTI seat holder
Permissions • N/A
Packages Advanced Analytics add-on

Here is a comprehensive list of the fields (and their 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
Was this article helpful?
0 out of 1 found this helpful