Key Benefits and Features

When you use this feature, you gain:

• Consolidated employee information from multiple sources in one place
• Optimized data structure for PowerBI reporting and analysis
• Comprehensive coverage of all employee data domains
• Simplified access to complex employee information through views
• Regular data refreshes aligned with business cycles
• Built-in data quality and validation rules
• Standardized data transformations and business rules
• Integrated payroll and benefits information
• Historical tracking of employee changes
• Compliance-ready data structure

Common Use Cases and Scenarios

Use this feature to:

• Create HR dashboards and reports in PowerBI
• Analyze employee demographics and trends
• Process and validate payroll information
• Track position and organizational changes
• Monitor employee skills and certifications
• Generate compliance reports
• Access consolidated employee views
• Validate benefit enrollments and deductions
• Review historical employee information
• Perform workforce analytics

Data Refresh Schedule

• Employee Data: Daily updates
• Position Changes: Daily updates
• Benefits Data: Weekly updates
• Payroll Data: Bi-weekly updates (aligned with pay periods)
• Full Validation: Monthly refresh

Best Practices

• Use provided views when possible
• Consider data refresh timing when running reports
• Implement appropriate security filters
• Test with representative data volumes
• Verify data completeness before analysis
• Follow recommended validation procedures

Core Tables

• Core Employee Information
• Employee Dependents

Position Tables

• Employee Positions
• Reporting Relationships
• Service History
• Skills and Certifications

Benefits Tables

• Benefit Plans
• Benefit Enrollments
• Benefit Deductions

Payroll Tables

• Payroll Transactions
• Payroll Details
• Payroll Benefits
• Employee Earnings
• Direct Deposit Information
• Tax Withholding

Employee Information

• Core.EmployeePersonalDataView - Consolidated personal information
• Position.PositionOrgDataView - Position and organizational details
• Position.EmployeeHistoryView - Historical employment information

Financial Information

• Payroll.CompensationFinancialView - Payroll and compensation data
• Benefits.BenefitsTimeOffView - Benefits and leave information
• Core.EmployeeSummaryView - Comprehensive employee dashboard

Other

• Core.PentegraCensusView - Consolidated emplyee demographic, employment, payroll, and benefits data