Active Workers Report — Column Reference
This page explains every column available in the Active Workers Report. This report shows all workers currently (or recently) on assignment, along with their placement details, rates, contact information, and configurable custom fields.
Direct Link to Report: https://reports.simplevms.com/Report/51/Active-Workers-Master
Grouping Columns
|
Column |
What it shows |
|---|---|
|
Site_Group |
Same as Site — used as a grouping key |
|
Vendor_Group |
Same as Vendor — used as a grouping key |
Site & Location
|
Column |
What it shows |
|---|---|
|
Site |
Name of the site the worker is assigned to |
|
ClientSiteID |
Your organization's internal site identifier |
|
District |
District the site belongs to (shows "No District" if unassigned) |
|
Region |
Region the site's district belongs to (shows "No Region" if unassigned) |
Worker Identity
|
Column |
What it shows |
|---|---|
|
WorkerName |
Worker's full display name |
|
FirstName |
Worker's first name |
|
LastName |
Worker's last name |
|
WorkerID |
SimpleVMS internal ID for the worker |
|
Username |
Worker's login username |
|
ClientWorkerID |
Your organization's identifier for the worker (e.g., badge number) |
|
ClientWorkerID2 |
Secondary client-assigned worker identifier |
|
VendorWorkerID |
The staffing vendor's identifier for the worker |
|
VendorWorkerID2 |
Secondary vendor-assigned worker identifier |
|
PostalCode |
Worker's postal/ZIP code |
|
DateOfBirth |
Worker's date of birth |
|
SSN |
Worker's Social Security Number — only visible to users with SSN access permission |
|
PhoneNumber |
Worker's primary phone number |
|
EmailAddress |
Worker's primary email address |
|
AltEmail |
Worker's alternate email address |
Assignment Details
|
Column |
What it shows |
|---|---|
|
Title |
Worker's job title on this assignment |
|
Status |
Current assignment status (e.g., Active, Inactive) |
|
StartDate |
Date the worker's assignment began |
|
EndDate |
Date the worker's assignment ended (blank if still active) |
|
EndReasonCategory |
High-level category for why the assignment ended |
|
EndReason |
Detailed reason the assignment ended |
|
WorkDays |
Number of distinct days the worker has worked |
|
JobPostingID |
Internal ID of the job posting the worker was placed from |
|
Payrollee |
Indicates if the worker is a payrollee placement |
|
JobTitleShift |
Shift derived from the job title (e.g., 1st, 2nd, 3rd, WKD, No Shift) |
|
Shift2 |
Alternate shift label derived from the job title (Days, Nights, WED, WEN) |
|
LastPunch |
Date and time of the worker's most recent time clock punch (adjusted to site timezone) |
|
FirstPunch |
Date and time of the worker's very first time clock punch (adjusted to site timezone) |
Organization
|
Column |
What it shows |
|---|---|
|
Vendor |
Staffing vendor supplying this worker |
|
Buyer |
Client organization (your company name) |
|
CostCenter |
Worker's primary cost center |
|
GLAccount |
GL account for regular hours (from cost center) |
|
GLAccountOT |
GL account for overtime hours |
|
GLAccountDT |
GL account for double-time hours |
|
Department |
Department the worker is assigned to |
|
Team |
Worker's team; shows "None" if not on a team |
|
Supervisor |
Full name of the worker's buyer-side supervisor |
|
SupervisorUsername |
Username of the buyer-side supervisor |
|
VendorSupervisor |
Full name of the vendor-side supervisor |
|
VendorSupervisorID |
Internal ID of the vendor-side supervisor |
Job Codes
Each worker can have up to five job codes assigned.
|
Column |
What it shows |
|---|---|
|
JobCode1–JobCode4 |
First through fourth job codes assigned to the worker |
|
Shift |
Fifth job code assigned to the worker (labeled "Shift" in this report) |
Rates
|
Column |
What it shows |
|---|---|
|
PayRate |
Worker's hourly pay rate |
|
OTPayRate |
Overtime pay rate (PayRate × 1.5) |
|
DTPayRate |
Double-time pay rate (PayRate × double-time factor) |
|
BillableRate |
Worker's hourly bill rate |
|
OTBillRate |
Overtime bill rate (BillableRate × overtime factor) |
|
DTBillRate |
Double-time bill rate (BillableRate × double-time factor) |
|
OvertimeFactor |
Multiplier for overtime (e.g., 1.5) |
|
DoubletimeFactor |
Multiplier for double-time (e.g., 2.0) |
|
Markup |
Percentage markup of bill rate over pay rate, expressed as a percentage. 0 if either rate is zero. |
Demographics
|
Column |
What it shows |
|---|---|
|
Gender |
Worker's gender |
|
Ethnicity |
Worker's ethnicity |
|
Disabled |
Whether the worker has indicated a disability |
|
Veteran |
Whether the worker is a veteran |
|
CitizenshipStatus |
Worker's citizenship status |
|
ElectedHealthcare |
Whether the worker elected healthcare coverage |
Custom Fields
Custom fields are configured per client. Your administrator assigns labels to these columns — the default names below are placeholders.
|
Column |
What it shows |
|---|---|
|
WorkerCustomText1–10 |
Worker-level custom text fields 1 through 10 (labels defined by your organization) |
|
WorkerCustomCheck1–5 |
Worker-level custom checkbox fields 1 through 5 |
|
CustomText1–10 |
Buyer-level custom text field labels configured for your account |
|
CustomCheck1–5 |
Buyer-level custom checkbox field labels |
|
UserCustom1–5 |
Supervisor-level custom fields (pulled from the supervisor's user profile) |