Invenias Power BI: Candidates View

The Candidates view for Invenias PowerBI provides the core data associated with Candidates in Assignment Records. This view serves as a cornerstone for any Dashboard using Candidate related information.

What It Does

Comprehensive Candidate Information: Provides related assignment ID, progress status ID, candidate groups, owners, etc., offering detailed insights into the relationship between Assignments and Candidates.

Table of Columns

Column Name	Column Type	Description	Joins To
AssignmentId	Guid	The unique identifier for the Assignment record for each Candidate relation.	AssignmentView
PersonId	Guid	The unique identifier for each person who has a Candidate relation.	PersonView
ProgressStatusId	Guid	The unique identifier for the Candidate Progress Status.	CandidateProgressTrackingView
CandidateGroupId	Guid	The unique identifier for the Candidate Group. Displayed as the “Group” column in the Assignment>Candidates list.	N/A
IsPinned	Boolean	A boolean to indicate if the candidate relation has been pinned in the Assignment>Candidates list.	N/A
RowColor	String	If the Candidate relation has been highlighted in the list, this returns the colour used.	N/A
CreatorId	String	The unique identifier for the User who created the Assignment to Candidate relation.	UserInformationView
DateCreated	DateTime	The date when the Candidate relation was created.	N/A
ModifierId	Guid	The unique identifier fo the User who last modified the Candidate relation.	UserInformationView
DateModified	DateTime	The date the Assignment to Candidate relation was last modified.	N/A
OwnerId	Guid	The unique identifier for the User who is the Owner of the Assignment to Candidate relation.	UserInformationView