Turnover Report — Column Reference
This page explains every column available in the Turnover Report. This report shows workers whose assignments ended within a selected date range, providing details about why they left, when they last worked, and their assignment profile. It is used to analyze attrition patterns.
Direct link to report: https://reports.simplevms.com/Report/52/Turnover-Master
Grouping Columns
|
Column |
What it shows |
|---|---|
|
Site_Group |
Same as SiteName — used as a grouping key |
|
Vendor_Group |
Same as VendorName — used as a grouping key |
Worker Identity
|
Column |
What it shows |
|---|---|
|
WorkerName |
Worker's full display name |
|
WorkerFirstName |
Worker's first name |
|
WorkerLastName |
Worker's last name |
|
Username |
Worker's login username |
|
ClientWorkerID |
Your organization's identifier for the worker |
|
ClientWorkerID2 |
Secondary client-assigned worker identifier |
|
SSN |
Worker's Social Security Number — only visible to users with SSN access permission |
|
DateOfBirth |
Worker's date of birth |
Assignment Details
|
Column |
What it shows |
|---|---|
|
SiteName |
Name of the site the worker was assigned to |
|
VendorName |
Staffing vendor who supplied this worker |
|
CostCenterName |
Worker's primary cost center |
|
Department |
Worker's department |
|
Title |
Worker's job title (falls back to the job posting title if the worker title is blank) |
|
TeamName |
Worker's team |
|
Status |
Final assignment status at termination |
|
StartDate |
Date the assignment began |
|
EndDate |
Date the assignment ended |
|
JobPostingEndDate |
End date from the original job posting (may differ from actual end date) |
|
SupervisorName |
Full name of the worker's buyer-side supervisor |
|
LastPunch |
Date and time of the worker's last recorded time clock punch (adjusted to site timezone) |
Rates
|
Column |
What it shows |
|---|---|
|
BillableRate |
Worker's hourly bill rate |
|
PayRate |
Worker's hourly pay rate |
Termination Information
|
Column |
What it shows |
|---|---|
|
EndReasonCategory |
High-level category for why the assignment ended (e.g., Voluntary, Involuntary, Contract End) |
|
EndReason |
Detailed reason the assignment ended |
|
StatusChangeDate |
Date and time the worker's status was changed to its final value |
Job Codes
|
Column |
What it shows |
|---|---|
|
JobCode1–JobCode5 |
Job codes assigned to the worker (up to five) |
Custom Fields
|
Column |
What it shows |
|---|---|
|
WorkerCustomText1–5 |
Worker-level custom text fields 1 through 5 (labels defined by your organization) |