Skip to content

hr

sqllocks_spindle.domains.hr

Human resources domain — employees, departments, compensation, and performance.

Classes

HrDomain

Bases: Domain

Human resources domain — employees, departments, compensation, and performance.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - department: Organizational departments (fixed: 30) - position: Job titles and levels (fixed: 80) - employee: Employees with manager hierarchy (anchor: 500 small) - compensation: Salary history per employee - performance_review: Annual performance reviews - time_off_request: PTO, sick, and personal leave - training: Training course catalog (fixed: 100) - training_enrollment: Employee training enrollments - termination: Employee terminations

Methods:
star_schema_map()

Return the star schema mapping for the HR domain.

Produces
  • dim_employee (from employee)
  • dim_department (from department)
  • dim_position (from position)
  • fact_compensation (from compensation)
  • fact_performance (from performance_review)
  • fact_time_off (from time_off_request)
cdm_map()

Return the CDM entity map for the HR domain.

Maps source table names to Microsoft Common Data Model entity names.