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.

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