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.
Columns
This view returns the following 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 |