Invenias Power BI: Position View

The Position View delivers a well-structured and accessible format for position-related data.

What It Does

Central Data Hub: Acts as the primary source for position data, extracting and joining all relevant data from the other related views.
Integrated Data Points: Combines essential details about positions, linking to other critical views such as CompanyView and UserInformationView for enriched context.

Columns

This view returns the following columns:

Column Name	Column Type	Description	Joins To
PositionId	Guid	The unique identifier for each position.	N/A
CompanyId	Guid	Links the position to a specific company.	CompanyView
JobTitle	String	The title or designation of the position.	N/A
StartDate	DateTime	The commencement date of the position.	N/A
EndDate	DateTime	The termination or ending date of the position.	N/A
PositionStatus	String	Indicates the current status of the position.	N/A
PositionTypeString	String	Describes the type of the position.	N/A
Benefits	String	Details the benefits associated with the position.	N/A
ReasonForLeaving	String	Provides reason for leaving the position, if applicable.	N/A
LocationId	Guid	Associates the position with a specific location.	CompanyLocationView
CreatorId	Guid	Identifies the creator of the position record.	UserInformationView
DateCreated	DateTime	The date when the position record was created.	N/A
ModifierId	Guid	Indicates the last modifier of the position record.	UserInformationView
DateModified	DateTime	The date when the position record was last modified.	N/A
OwnerId	Guid	The owner of the position record.	UserInformationView