Purpose The Employee Headcount fact table is designed to display quantitative data related to employees. This table integrates with dimension tables, such as Employee_Details, to provide detailed insights into various aspects of employee performance, compensation, and other metrics. The primary purpose is to support data-driven decision-making across the organisation. Use Case Owner: Sam Jopson-WhiteTypical Use Case: Resource … Read more
Purpose The Employee.Details_Plus view extends the foundational Employee.Details dataset, offering enriched employee data for segmentation, reporting, and integration across organisational systems. It consolidates employment, organisational, and job-related details into a comprehensive, consistent format to support analytical and operational needs. Use Case Owner: Sam Jopson-WhiteTypical Use Case: Integration with fact tables for enhanced reporting and analysis, such as … Read more
Purpose The Employee Hours fact table is designed to display quantitative data related to employees. This table integrates with dimension tables, such as Employee_Details, to provide detailed insights into various aspects of employee performance, compensation, and other metrics. The primary purpose is to support data-driven decision-making across the organisation. Use Case Owner: Sarah MartinoTypical Use Case: Calculation … Read more
Purpose The Common View for Employee Details provides a unified and reliable source for core employee data, suitable for integration across departments and systems. It focuses on maintaining essential and concise information, enabling integration with fact tables for reporting and analysis while ensuring compatibility with slicers and dashboards. Use Case Owner: Data EngineeringTypical Use Case: Provides contents … Read more
The Projects entity and its related entities are exclusive to PSA. Project is the top-level entity that is used to capture the work and cost side of operations. Here is a list of the related entities: