Timesheet Status Report

Overview

Updated 06/21/2023

View status of timesheets (Open, Submitted, Approved, etc) long with various job and contact information. Often used to audit weekly submissions and approvals.

• Click here to go to the Operational Category (list of Standard Reports)

Click on the links below for more information: List of Standard Reports List of BOLD Analyze Reports List of INSIGHTS Dashboards List of Business Intelligence (BI) Reports

CHAPTERS Legend Locating the Report Logic Filter Options Field Details

Legend

Locating the Report

1. Click on Analyze Tab
   The Reports Sub Tab will automatically be selected
2. In the Search Reports field, type TIMESHEET STATUS
3. Click on the Timesheet Status Report

Logic

View status of timesheets (Open, Submitted, Approved, etc) long with various job and contact information.  Often used to audit weekly submissions and approvals.

• Click here to go to the Operational Category (list of Standard Reports)

Filter Options

	Filter Name	Options	Description
	Division	All available Employer list	Use this filter to refine Employer of the Job
	Region	All available Region list	Use this filter to refine Region of the Job
	Office	All available Branch list	Use this filter to refine Branch of the Job
	Company	All available Company List	Use this filter to refine the Company of the Job
	Timesheet Status	All available Timesheet Status List	Use this filter to refine timesheet status
	Timesheet Week End	All available Week End Date (Sunday's Date)	Use this filter to refine weekend date between the date range

Field Details

• Click here to go to the Operational Category (list of Standard Reports)

Field Name	Description	Notes
Requisition ID	Job's Requisition ID
Placement ID	Placement's ID
req_hired_ext_ID	Placement Extension's ID
Timesheet ID	TimeSheet's Week ID
Week Start	Week Start Date
Week End	Week End Date
Batch	If Job>>Time Capture = Batch Hours, shows Yes, Else No.
Applicant ID	Talent's ID
Contractor	Talent's Name
Req ID	Job's ID
Job Title	Job's Title
Mgr ID	Hiring Manager's ID
Manager	Hiring Manager's Name
Company ID	Company's ID
Company	Company's Name
Hired Date	Placements Hired Date
Straight Time	Placements Reg Time
Over Time	Placements Over Time
Double Time	Placements Double Time
Over Time Rule	Placements Over Time Rule
Over Time Pay Rate	Placements Over Time Pay Rate
Double Time Pay Rate	Placements Double Time Pay Rate
Straight Pay Rate	Placement Extensions Reg Pay Rate
Straight Bill Rate	Placement Extensions Reg Bill Rate
Employment Type	Placement Extensions Employment Type description
Tax Type	Placement Extensions Employment Type
Paid	Paid Status
Paid Date	Paid Date
Total Pay	Total Pay Amount
Timesheet Status	Timesheet Status
Expenses Total	Expenses Total
Start Date	Placement Extension's Start Date
End Date	Placement Extension's End Date
Mgr Email	Hiring Manager's Emal
Division	Job's Division
Region	Job's Region
Office	Job's Office
Applicant Email	Talent's Email
Approver 1 Name	Placement's Timesheet Approver Name 1
Approver 1 Email	Placement's Timesheet Approver Email 1
Approver 2 Name	Placement's Timesheet Approver Name 2
Approver 2 Email	Placement's Timesheet Approver Email 2
Approver 3 Name	Placement's Timesheet Approver Name 3
Approver 3 Email	Placement's Timesheet Approver Email 3
Total Bill	Placements Total Bill Amount
Additional Hours/Units	Additional Hours/Units
Total Leave Billed	Leave Bill Amount per Timesheet ID
Total Leave Paid	Leave pay Amount per Timesheet ID
OT Bill Rate	Placements Over Time Bill Rate
DT Bill Rate	Placements Double Time Bill Rate
Wc Code	Job's WC Code
Unadjusted Bill Rate	Placement Extensions Reg Bill Rate
VMS %	Placement Extensions VMS Deduction %
Bill Cycle	Job's Billing Cycle
Sales Rep	Job's Sales Rep
Recruiter Rep	Placement Extension's Recruiter Rep
Placement Office	Placement's Office
Mobile Phone	Talent's Mobile Phone
Job Location	Job's Department Name
Worksite Address1	Job's Worksite Address 1
Worksite Address2	Job's Worksite Address 2
Worksite City	Job's Worksite City
Worksite State	Job's Worksite State
Worksite Zip	Job's Worksite Zip