Skip to content

HR Domain

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

Tables

Table Rows (small) Description
department 30 Organizational departments
position 80 Job titles and levels
employee 500 Employees with department and position assignments
compensation 1,500 Salary history with effective dates
performance_review 1,250 Annual performance reviews with ratings
time_off_request 2,500 PTO, sick, and personal leave requests
training 100 Training course catalog
training_enrollment 2,000 Employee training enrollments
termination 75 Employee terminations

Quick Start

from sqllocks_spindle import Spindle, HrDomain

result = Spindle().generate(domain=HrDomain(), scale="small", seed=42)
print(result.summary())

Key Features

  • Self-referencing manager hierarchy with configurable depth (max 4 levels, 5 roots)
  • Log-normal salary distribution ($28K-$350K) with pay grade bands (G1-G7)
  • Performance ratings following a bell curve (1-5 scale, mode at 3)
  • Leave type distribution (PTO 45%, Sick 25%, Personal 12%, Parental 6%)
  • Termination reasons with rehire eligibility tracking
  • Training enrollment lifecycle with completion scores

Scale Presets

Preset employee
fabric_demo 100
small 500
medium 5,000
large 50,000
xlarge 500,000
warehouse 5,000,000