CleanStack
DashboardNew PipelineTemplates
TemplatesHR Roster Cleaner
HR54 uses

HR Roster Cleaner

Prepares employee roster exports for HRIS import: enforces employee ID, deduplicates, normalizes salary, fills missing manager.

Expected Input Schema

salary·str
status·str
hire_date·str
last_name·str
department·str
first_name·str
manager_id·str
employee_id·str

Transform Rules (5)

1
drop nullsemployee_id

Records without employee IDs cannot be processed by any HRIS system.

2
deduplicateemployee_id

Duplicate employee records corrupt headcount metrics and payroll runs.

3
type castsalarytarget_type: float

Salary data exported as formatted strings must be numeric for compensation analytics.

4
trim whitespacedepartment

Department names entered via form often have inconsistent spacing that breaks grouping.

5
fill nullsmanager_idvalue: NONE

C-suite executives and contractors may have no direct manager — NONE is a valid sentinel.