Attachment 10 - e-Timesheet - template.xlsx

XLSX spreadsheet 121 KB Posted

Attached to
ICE Medical Staffing Industry Day
Solicitation number
ICE-DCR-2021-02
Issued by

About this file

This document contains templates for monthly timesheets to track hours worked by employees under an ICE medical staffing contract. The timesheets include spaces to record in and out times by day, total weekly hours, regular and overtime hours by month. They require signatures from the employee and technical monitor. Guidance is provided on defining a work week as seven days from Sunday to Saturday, and on the process for approving overtime hours before the 15th and end of each month.

The federal contract opportunity notice announces an upcoming ICE industry day on July 28, 2021 to discuss a forthcoming RFP for medical staffing services. The event will provide an overview of IHSC's mission and medical staffing needs, and the acquisition strategy. Vendors are limited to three attendees each and must register by July 27. The document includes templates for submitting pre-and post-industry day questions to ICE by July 23 and August 8, respectively.

View the file

Other files

File Type Posted
Pre Conference - Questions.pdf PDF
Post Conference - Questions.pdf PDF
Industry Day Presentation.pdf PDF
IHSC 101 - Industry Day.pdf PDF
Industry Day Attendee List.pdf PDF
Attachment 15 - Contract Discrepancy Report - template.pdf PDF
Attachment 12 - Facility Orientation Checklist - template.pdf PDF
Vendor Questions Template.xlsx XLSX spreadsheet
Attachment 08 - Competency Assessment by Position Description.xlsx XLSX spreadsheet
RFP ONLY - Attachment 03 - Shift Requirement Document - SAMPLE.xlsx XLSX spreadsheet
RFP ONLY - Attachment 02 - HSA-Clinical Lead-NM-CSM Function Guide.pdf PDF
Attachment 13 - IHSC CP and PA Agreement - template.pdf PDF
RFP ONLY - Attachment 05 - Deductions Calculator v1 - template.xlsx XLSX spreadsheet
RFP ONLY - Attachment 01 - Site Staffing Plan - IDIQ.xlsx XLSX spreadsheet
Attachment 02 - QASP.pdf PDF
Attachment 09 - DOL Wage Determinations.xlsx XLSX spreadsheet
Attachment 07 - Schedule Submission Calendar.xlsx XLSX spreadsheet
Attachment 03 - Pricing Schedule.xlsx XLSX spreadsheet
Attachment 05 - IHSC Locations - IDIQ.xlsx XLSX spreadsheet
Attachment 06 - IHSC Credentialing and Privileging Directive.pdf PDF
RFP ONLY - Attachment 04 - Corporate Experience Questionaire.docx DOCX document
Attachment 04 - Position Descriptions.pdf PDF
Attachment 01 - Performance Work Statement.pdf PDF
Attachment 11 - Sites Status Report.xlsx XLSX spreadsheet
Section B-M.pdf PDF
Attachment 14 - Contractor Employee Separation Clearance Checklist - template.pdf PDF
Show all 26

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

January IHSC Contract Employee Time Sheet SITE:

Month:1/1/211/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon12/270.00
Tue12/280.00
Wed12/290.00
Thu12/300.00
Fri12/310.00
Sat1/10.00
Sun1/20.000.00
Mon1/30.00
Tue1/40.00
Wed1/50.00
Thu1/60.00
Fri1/70.00
Sat1/80.00
Sun1/90.000.00
Mon1/100.00
Tue1/110.00
Wed1/120.00
Thu1/130.00
Fri1/140.00
Sat1/150.00
Sun1/160.000.00
Mon1/170.00
Tue1/180.00
Wed1/190.00
Thu1/200.00
Fri1/210.00
Sat1/220.00
Sun1/230.000.00
Mon1/240.00
Tue1/250.00
Wed1/260.00
Thu1/270.00
Fri1/280.00
Sat1/290.00
Sun1/300.000.00
Mon1/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 01/14/2021

February IHSC Contract Employee Time Sheet SITE:

Month:2/1/212/28/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon1/310.00
Tue2/10.00
Wed2/20.00
Thu2/30.00
Fri2/40.00
Sat2/50.00
Sun2/60.000.00
Mon2/70.00
Tue2/80.00
Wed2/90.00
Thu2/100.00
Fri2/110.00
Sat2/120.00
Sun2/130.000.00
Mon2/140.00
Tue2/150.00
Wed2/160.00
Thu2/170.00
Fri2/180.00
Sat2/190.00
Sun2/200.000.00
Mon2/210.00
Tue2/220.00
Wed2/230.00
Thu2/240.00
Fri2/250.00
Sat2/260.00
Sun2/270.000.00
Mon2/280.00
ERROR:#VALUE!
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

March IHSC Contract Employee Time Sheet SITE:

Month:3/1/213/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon2/280.00
Tue3/10.00
Wed3/20.00
Thu3/30.00
Fri3/40.00
Sat3/50.00
Sun3/60.000.00
Mon3/70.00
Tue3/80.00
Wed3/90.00
Thu3/100.00
Fri3/110.00
Sat3/120.00
Sun3/130.000.00
Mon3/140.00
Tue3/150.00
Wed3/160.00
Thu3/170.00
Fri3/180.00
Sat3/190.00
Sun3/200.000.00
Mon3/210.00
Tue3/220.00
Wed3/230.00
Thu3/240.00
Fri3/250.00
Sat3/260.00
Sun3/270.000.00
Mon3/280.00
Tue3/290.00
Wed3/300.00
Thu3/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

April IHSC Contract Employee Time Sheet SITE:

Month:4/1/214/30/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon3/280.00
Tue3/290.00
Wed3/300.00
Thu3/310.00
Fri4/10.00
Sat4/20.00
Sun4/30.000.00
Mon4/40.00
Tue4/50.00
Wed4/60.00
Thu4/70.00
Fri4/80.00
Sat4/90.00
Sun4/100.000.00
Mon4/110.00
Tue4/120.00
Wed4/130.00
Thu4/140.00
Fri4/150.00
Sat4/160.00
Sun4/170.000.00
Mon4/180.00
Tue4/190.00
Wed4/200.00
Thu4/210.00
Fri4/220.00
Sat4/230.00
Sun4/240.000.00
Mon4/250.00
Tue4/260.00
Wed4/270.00
Thu4/280.00
Fri4/290.00
Sat4/300.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

May IHSC Contract Employee Time Sheet SITE:

Month:5/1/215/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon4/250.00
Tue4/260.00
Wed4/270.00
Thu4/280.00
Fri4/290.00
Sat4/300.00
Sun5/10.000.00
Mon5/20.00
Tue5/30.00
Wed5/40.00
Thu5/50.00
Fri5/60.00
Sat5/70.00
Sun5/80.000.00
Mon5/90.00
Tue5/100.00
Wed5/110.00
Thu5/120.00
Fri5/130.00
Sat5/140.00
Sun5/150.000.00
Mon5/160.00
Tue5/170.00
Wed5/180.00
Thu5/190.00
Fri5/200.00
Sat5/210.00
Sun5/220.000.00
Mon5/230.00
Tue5/240.00
Wed5/250.00
Thu5/260.00
Fri5/270.00
Sat5/280.00
Sun5/290.000.00
Mon5/300.00
Tue5/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

June IHSC Contract Employee Time Sheet SITE:

Month:6/1/216/28/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon5/300.00
Tue5/310.00
Wed6/10.00
Thu6/20.00
Fri6/30.00
Sat6/40.00
Sun6/50.000.00
Mon6/60.00
Tue6/70.00
Wed6/80.00
Thu6/90.00
Fri6/100.00
Sat6/110.00
Sun6/120.000.00
Mon6/130.00
Tue6/140.00
Wed6/150.00
Thu6/160.00
Fri6/170.00
Sat6/180.00
Sun6/190.000.00
Mon6/200.00
Tue6/210.00
Wed6/220.00
Thu6/230.00
Fri6/240.00
Sat6/250.00
Sun6/260.000.00
Mon6/270.00
Tue6/280.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

July IHSC Contract Employee Time Sheet SITE:

Month:6/29/217/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon6/270.00
Tue6/280.00
Wed6/290.00
Thu6/300.00
Fri7/10.00
Sat7/20.00
Sun7/30.000.00
Mon7/40.00
Tue7/50.00
Wed7/60.00
Thu7/70.00
Fri7/80.00
Sat7/90.00
Sun7/100.000.00
Mon7/110.00
Tue7/120.00
Wed7/130.00
Thu7/140.00
Fri7/150.00
Sat7/160.00
Sun7/170.000.00
Mon7/180.00
Tue7/190.00
Wed7/200.00
Thu7/210.00
Fri7/220.00
Sat7/230.00
Sun7/240.000.00
Mon7/250.00
Tue7/260.00
Wed7/270.00
Thu7/280.00
Fri7/290.00
Sat7/300.00
Sun7/310.000.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

August IHSC Contract Employee Time Sheet SITE:

Month:8/1/218/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon8/10.00
Tue8/20.00
Wed8/30.00
Thu8/40.00
Fri8/50.00
Sat8/60.00
Sun8/70.000.00
Mon8/80.00
Tue8/90.00
Wed8/100.00
Thu8/110.00
Fri8/120.00
Sat8/130.00
Sun8/140.000.00
Mon8/150.00
Tue8/160.00
Wed8/170.00
Thu8/180.00
Fri8/190.00
Sat8/200.00
Sun8/210.000.00
Mon8/220.00
Tue8/230.00
Wed8/240.00
Thu8/250.00
Fri8/260.00
Sat8/270.00
Sun8/280.000.00
Mon8/290.00
Tue8/300.00
Wed8/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

September IHSC Contract Employee Time Sheet SITE:

Month:9/1/219/30/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon8/290.00
Tue8/300.00
Wed8/310.00
Thu9/10.00
Fri9/20.00
Sat9/30.00
Sun9/40.000.00
Mon9/50.00
Tue9/60.00
Wed9/70.00
Thu9/80.00
Fri9/90.00
Sat9/100.00
Sun9/110.000.00
Mon9/120.00
Tue9/130.00
Wed9/140.00
Thu9/150.00
Fri9/160.00
Sat9/170.00
Sun9/180.000.00
Mon9/190.00
Tue9/200.00
Wed9/210.00
Thu9/220.00
Fri9/230.00
Sat9/240.00
Sun9/250.000.00
Mon9/260.00
Tue9/270.00
Wed9/280.00
Thu9/290.00
Fri9/300.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

October IHSC Contract Employee Time Sheet SITE:

Month:10/1/2110/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon9/260.00
Tue9/270.00
Wed9/280.00
Thu9/290.00
Fri9/300.00
Sat10/10.00
Sun10/20.000.00
Mon10/30.00
Tue10/40.00
Wed10/50.00
Thu10/60.00
Fri10/70.00
Sat10/80.00
Sun10/90.000.00
Mon10/100.00
Tue10/110.00
Wed10/120.00
Thu10/130.00
Fri10/140.00
Sat10/150.00
Sun10/160.000.00
Mon10/170.00
Tue10/180.00
Wed10/190.00
Thu10/200.00
Fri10/210.00
Sat10/220.00
Sun10/230.000.00
Mon10/240.00
Tue10/250.00
Wed10/260.00
Thu10/270.00
Fri10/280.00
Sat10/290.00
Sun10/300.000.00
Mon10/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

November IHSC Contract Employee Time Sheet SITE:

Month:11/1/2111/30/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon10/310.00
Tue11/10.00
Wed11/20.00
Thu11/30.00
Fri11/40.00
Sat11/50.00
Sun11/60.000.00
Mon11/70.00
Tue11/80.00
Wed11/90.00
Thu11/100.00
Fri11/110.00
Sat11/120.00
Sun11/130.000.00
Mon11/140.00
Tue11/150.00
Wed11/160.00
Thu11/170.00
Fri11/180.00
Sat11/190.00
Sun11/200.000.00
Mon11/210.00
Tue11/220.00
Wed11/230.00
Thu11/240.00
Fri11/250.00
Sat11/260.00
Sun11/270.000.00
Mon11/280.00
Tue11/290.00
Wed11/300.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

December IHSC Contract Employee Time Sheet SITE:

Month:12/1/2112/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon11/280.00
Tue11/290.00
Wed11/300.00
Thu12/10.00
Fri12/20.00
Sat12/30.00
Sun12/40.000.00
Mon12/50.00
Tue12/60.00
Wed12/70.00
Thu12/80.00
Fri12/90.00
Sat12/100.00
Sun12/110.000.00
Mon12/120.00
Tue12/130.00
Wed12/140.00
Thu12/150.00
Fri12/160.00
Sat12/170.00
Sun12/180.000.00
Mon12/190.00
Tue12/200.00
Wed12/210.00
Thu12/220.00
Fri12/230.00
Sat12/240.00
Sun12/250.000.00
Mon12/260.00
Tue12/270.00
Wed12/280.00
Thu12/290.00
Fri12/300.00
Sat12/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

Guidance e-Timesheet Guidance

Situation The purpose of this document is to answer questions regarding the use of and the embedded calculations within the e-timesheet. This document is issued to provide clarification and guidance as to the role, function and utilization of the e-timesheet.

Background The e-timesheet was created to support the administrators in the field when calculating the hours worked for contract staff each month. The contract requires hours worked to be verified by the government so that invoices may be paid accurately and timely.

Assessment Assessment The role of the e-timesheet is to meet the government’s need to accurately calculate the number of regular hours worked and OT hours worked, both billable to and not billable to the government as well as other categories of hours worked.

Operating Parameters of the e-Timesheet
1.This document is completely separate and apart from any vendor’s timekeeping system. It is designed solely for the needs of government personnel calculating the hours worked for the Hours Worked Dashboard each month.
2.The Hours Worked Dashboard must align with the monthly invoice as submitted by the vendor.
3.The e-timesheet is not meant to calculate pay in any manner.
4.The e-timesheet is not to be used to compare or contrast to other timekeeping systems used by a vendor.
5.A work week is defined as a seven day period from Sunday through the following Saturday, regardless of how any given work week may be bisected by a month. Total hours for the work week will always be calculated on Saturday.
6.Overtime is defined as any work hours over 40 hours worked in any work week regardless of how any given work week may be bisected by a month.
*Exception: Individual work schedules may incur over 40 hours in one work week if no more than 80 hours are incurred over a two-week work period.
7.Monthly approved overtime hours will be shown on row 5.
Notes (Workflow Process):
Staff should receive approval from scheduling administrator/supervisor prior to incuring any/all OT.
Staff should complete e-timesheet as hours worked are incurred.
Scheduling administrator should review/verify all vacancy OT no later than close of payroll each week.
On the 15th and at the end of the month:
Employee will print and submit this e-timesheet.
Scheduling administrator will review the e-timesheet for accuracy.
Upon completion (end of the month):
Scheduling administrator will perform a final review.
GTM will review/approve the e-timesheet and then electronically sign the document.
A copy of the e-timesheet should be saved.

Lists

IHSC Sites
Alexandria
Berks
Buffalo
Caroline
Dilley
El Paso
Elizabeth
Eloy
26 Federal
Florence
Folkston
Houston
Jena
Krome
Montgomery
Pearsall
Port Isabel
Tacoma
Taylor
Varick
York
IHSC HQ

File details come from the government source that posted it. Updated .