Invenias Power BI: People View

The People view for Invenias PowerBI provides the core data associated with People Records. It serves as the cornerstone for any Dashboard featuring People-related information, encompassing Candidate, Client Dashboards, or any Dashboard where you require the names of People to be displayed.

What It Does

Comprehensive People Information: Offers detailed insights into People, including their status as Clients or Candidates, preferred employment types, and various Name Fields, streamlining the process of managing and engaging with them effectively.

Columns

This view returns the following columns:

Column Name	Column Type	Description	Joins To
PersonId	Guid	The unique identifier for the person.	N/A
FullName	String	The full name of the person, created using various name fields listed below.	N/A
FirstName	String	The first name of the person.	N/A
FamilyName	String	The family name (surname) of the person.	N/A
MiddleName	String	The middle name of the person.	N/A
MaidenName	String	The maiden name of the person.	N/A
Suffix	String	The suffixes of the person.	N/A
Title	String	The title of the person. E.g. Mr, Ms, Herr, etc.	N/A
PersonNumber	String	The Invenias Person Record number. This is prefixed with a P.	N/A
IsVIP	Boolean	A boolean field to indicate if the person is a VIP.	N/A
IsClient	Boolean	A boolean field to indicate if the person is a Client.	N/A
ClientStatusId	Guid	The identifier for the Client Status.	PeopleClientStatusView
IsCandidate	Boolean	A boolean field to indicate if the person is a Candidate.	N/A
CandidateStatusId	Guid	The identifier for the Candidate Status.	PeopleCandidateStatusView
IsPermanentCandidate	Boolean	A boolean field to indicate if this person is a Candidate interested in Permanent positions.	N/A
IsContractCandidate	Boolean	A boolean field to indicate if this person is a Candidate interested in Interim/Contract positions.	N/A
IsNonExecCandidate	Boolean	A boolean field to indicate if this person is a Candidate interested in Non Exec positions.	N/A
EmploymentType	String	The label for the Employment type e.g. Permanent.	N/A
IsSupplier	Boolean	A boolean field to indicate if this person is a Supplier.	N/A
IsPartner	Boolean	A boolean field to indicate if this person is a Partner.	N/A
IsDoNotContactChecked	Boolean	A boolean field to indicate this person should not be contacted.	N/A
IsDoNotMailshotChecked	Boolean	A boolean field to indicate this person should not be contacted via mailshots.	N/A
MaritalStatusId	Guid	The identifier for the Marital Status.	PeopleMaritalStatusView
GenderId	Guid	The identifier for the Gender.	PeopleGendersView
NationalityId	Guid	The identifier for the Nationality.	PeopleNationalitiesView
IsRelocateChecked	Boolean	A boolean field to capture if this person is willing to relocate for a new position.	N/A
IsTravelChecked	Boolean	A boolean field to capture if this person is willing to travel for a new position.	N/A
DateOfBirth	DateTime	The person’s Date of Birth.	N/A
NoticePeriodId	Guid	The identifier for the person’s notice period.	PeopleNoticePeriodsView
Nickname	String	The nickname of the person.	N/A
AvailableDate	DateTime	The date when this person is available for new positions. Typically used with interim / contract Candidates.	N/A
CreatorId	Guid	The identifier for the User who created the person Record.	UserInformationView
DateCreated	DateTime	The date the person Record was created.	N/A
ModifierId	Guid	The identifier for the User who last modified the person Record.	UserInformationView
DateModified	DateTime	The date the person record was last modified.	N/A
OwnerId	Guid	The identifier for the User who is the Owner of the person Record.	UserInformationView