RFP ONLY - Attachment 03 - Shift Requirement Document - SAMPLE.xlsx

XLSX spreadsheet 445 KB Posted Oct 5, 2021

Attached to: ICE Medical Staffing Federal contract opportunity
Solicitation number: 70CDCR21R00000008
Issued by: Immigration and Customs Enforcement

About this file

Written by GovTribe AI · Dec 30, 2023

This document outlines staffing requirements for a federal contract opportunity to provide on-site medical staffing services. The contractor will be required to staff various medical positions including nurses, behavioral health professionals, medical technicians, and physicians on a daily, weekly, and monthly basis according to a detailed shift schedule at Immigration and Customs Enforcement health clinic sites. The staffing requirements specify the number of personnel needed for each position for every day over a one month period. The contract will provide staffing for ICE health services on a 24/7 basis, including all holidays.

View the file

Other files for this federal contract opportunity

Other files attached to ICE Medical Staffing, newest first.
File	Type	Posted
70CDCR21R00000008_A0002.pdf	PDF	Oct 25, 2021
A0002_Section B-M_Clean.pdf	PDF	Oct 25, 2021
A0002_Section B-M_Redline.docx	DOCX document	Oct 25, 2021
A0001_Attachment 01 - Performance Work Statement_Redline.docx	DOCX document	Oct 21, 2021
A0001_RFP ONLY - Attachment 04 - Corporate Experience Questionaire_Redline.docx	DOCX document	Oct 21, 2021
70CDCR21R00000008_A0001.pdf	PDF	Oct 21, 2021
A0001_Phase I - Questions.xlsx	XLSX spreadsheet	Oct 21, 2021
A0001_Section B-M_Clean.pdf	PDF	Oct 21, 2021
A0001_Section B-M_Redline.docx	DOCX document	Oct 21, 2021
A0001_RFP ONLY - Attachment 04 - Corporate Experience Questionaire_Clean.pdf	PDF	Oct 21, 2021
Attachment 13 - IHSC CP and PA Agreement - template.pdf	PDF	Oct 21, 2021
A0001_Attachment 01 - Performance Work Statement_Clean.pdf	PDF	Oct 21, 2021
A0001_Attachment 02 - QASP_Clean.pdf	PDF	Oct 21, 2021
A0001_Attachment 02 - QASP_Redline.docx	DOCX document	Oct 21, 2021
Attachment 06 - IHSC Credentialing and Privileging Directive.pdf	PDF	Oct 5, 2021
Attachment 09 - DOL Wage Determinations.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 12 - Facility Orientation Checklist - template.docx	DOCX document	Oct 5, 2021
RFP ONLY - Attachment 02 - HSA-Clinical Lead-NM-CSM Function Guide.pdf	PDF	Oct 5, 2021
RFP ONLY - Attachment 05 - Past Performance Questionnaire.docx	DOCX document	Oct 5, 2021
RFP ONLY - Attachment 06 - Non-Disclosure Agreement.pdf	PDF	Oct 5, 2021
Attachment 01 - Performance Work Statement.pdf	PDF	Oct 5, 2021
Attachment 02 - QASP.pdf	PDF	Oct 5, 2021
Attachment 03 - Pricing Schedule.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 04 - Position Descriptions.pdf	PDF	Oct 5, 2021
Attachment 05 - IHSC Locations - IDIQ.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 07 - Schedule Submission Calendar.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 08 - Competency Assessment by Position Description.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 11 - Sites Status Report.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 10 - e-Timesheet - template.xlsx	XLSX spreadsheet	Oct 5, 2021
Attachment 15 - Contract Discrepancy Report - template.pdf	PDF	Oct 5, 2021
70CDCR21R00000008.pdf	PDF	Oct 5, 2021
Attachment 14 - Contractor Employee Separation Clearance Checklist - template.pdf	PDF	Oct 5, 2021
RFP ONLY - Attachment 01 - Site Staffing Plan - IDIQ.xlsx	XLSX spreadsheet	Oct 5, 2021
RFP ONLY - Attachment 04 - Corporate Experience Questionaire.docx	DOCX document	Oct 5, 2021

Show all 34

On GovTribe

Work with this file on GovTribe

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

HSA Staffing Requirements to CC

Scheduling Period - Jan 3rd - Jan 28th
Date		3		4		5		6		7		8		9		10		11		12		13		14		15		16	17		18		19		20		21		22		23	24		25		26		27
		SUN		MON		TUE		WED		THU		FRI		SAT		SUN		MON		TUE		WED		THU		FRI		SAT	SUN		MON		TUE		WED		THU		FRI		SAT	SUN		MON		TUE		WED
APP - Day 0700-1730	0	1		7		7		7		7		7		1		1		7		7		7		7		7		1	1		7		7		7		7		7		1	1		7		7		7
APP - Evening - Not applicable		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
APP - Night - Not applicable		0		0		0		0		0		0		0		0		0		0		0		0		0		0	0		0		0		0		0		0		0	0		0		0		0

BHP - Day	3	10	13	14	15	9	3	3	10	13	14	15	9	3	3	10	13	14	15	9	3	3	10	13	14	15	9	3
BHP - Evening	3	10	13	14	15	9	3	3	10	13	14	15	9	3	3	10	13	14	15	9	3	3	10	13	14	15	9	3
BHP - Night	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

RN - Day	4	5	5	5	5	5	4	4	5	5	5	5	5	4	4	5	5	5	5	5	4	4	5	5	5	5	5	4
RN - Evening	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4
RN - Night	2	3	3	3	3	3	2	2	3	3	3	3	3	2	2	3	3	3	3	3	2	2	3	3	3	3	3	2

LVN- Day	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
LVN- Evening	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
LVN - Night	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

LVN- Day Pill Line (0600 – 1630)	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
LVN- Evening Pill Line (1100-2130)	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
LVN - Night	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

RN – Day (0700-1730) Immunizations	1	4	2	2	2	1	1	4	2	2	2	1	1	4	2	2	2	1	1	4	2	2	2	1
RN – Evening	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
RN - Night	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

LVN- Day (0700-1730) Immunizations	1	2	3	3	1	1	1	2	3	3	1	1	1	2	3	3	1	1	1	2	3	3	1	1
LVN- Evening	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
LVN - Night	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

MRT - Day 0700-1730	1	4	4	4	4	4		1	1	4	4	4	4	4		1	1	4	4	4	4	4		1	1	4	4	4	4	4		1
MRT - Evening 1100-2130	1	1	4	4	4	4	0	1	1	1	4	4	4	4	0	1	1	1	4	4	4	4	0	1	1	1	4	4	4	4	0	1
MRT- Night	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

AA - Day	0	1	1	1	0	1	1	0	1	1	1	0	1	1	0	1	1	1	0	1	1	0	1	1	1	0	1	1
AA - Day	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0
Physician - Day	0	2	2	2	2	2	0	0	2	2	2	2	2	0	0	2	2	2	2	2	0	0	2	2	2	2	2	0
Dentist - Day	0	2	2	2	2	2	0	0	2	2	2	2	2	0	0	2	2	2	2	2	0	0	2	2	2	2	2	0
Dental Assistant - Day	0	2	2	2	2	2	0	0	2	2	2	2	2	0	0	2	2	2	2	2	0	0	2	2	2	2	2	0
Dental Hygenist - Day	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0
Psychiatrist - Day (0700-1730)	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1
Psychiatrist - Day (0700-1730)	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0
Pharmacist - Day	1	2	2	2	2	2	1	1	2	2	2	2	2	1	1	2	2	2	2	2	1	1	2	2	2	2	2	1
Pharn Tech - Day	1	2	2	2	2	2	1	1	2	2	2	2	2	1	1	2	2	2	2	2	1	1	2	2	2	2	2	1
Rad Tech - Day (0700-1730)	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0
Rad Tech - Day (0700-1730)	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1	0	0	0	1	1	1	1

Schedule to be filled by CC

Jan 3-Jan30
	Title	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT
		3	34	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
	RN
	RN
	RN

LVN

LPN

7p-4a

ART

4a-4a

ART

7p-4a

7p-5a

ART

7p-5a

D = 7am -7:30pm	d = 7am - 3:30pm
N = 7pm- 7:30 am	n = 11pm - 7:30am

Sep 23-Oct 20
	Title	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT	SUN	MON	TUE	WED	THU	FRI	SAT
		23	24	25	26	27	28	29	30	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
	CC
	AA

MHP
LCSW	D

CPhT

RDT

MRT
MRT	12D	12D	12D
MRT
MRT

CC to update staffing req.

Scheduling Period - Jan 3rd - Jan 28th
Date		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26
		SUN		MON		TUE		WED		THU		FRI		SAT		SUN		MON		TUE		WED		THU		FRI		SAT		SUN		MON		TUE		WED		THU		FRI		SAT		SUN		MON		TUE
APP - Day	0	1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
APP - Evening		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		1		1		1		1		1		1		1		1		1
APP - Night		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
APP - 1100 to 1930		1		1		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

BHP - Day 1 3 4 3 3 3 1 1 3 3 3 Bartolini, Nancy F: Bartolini, Nancy F:

no shifts covered 3 3 1 1 3 3 3 3 3 1 1 3 3 3 3 Bartolini, Nancy F: Bartolini, Nancy F:

filled at 2		3		1
	BHP - Evening		1		1	1	1	1		1	1	0	1	1	1	1	1	1	0	0	1	1	1	1	1	1	0	0	1	1	1	1	1	0
	BHP - Night		0		0	0	0	0	0	0	0	0	0		0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0	0	0

RN - Day 3 3 3 3 3 3 3 Bartolini, Nancy F: Bartolini, Nancy F:

all shifts uncovered - 3 Bartolini, Nancy F: Bartolini, Nancy F:

filled at 2 Bartolini, Nancy F: Bartolini, Nancy F:

no shifts covered	3	3	3	3	3	3	3	3	3		3	3	3	3	3	3	3	3	3	3	3	3
	RN - Evening	2	2	2	2	2	2	2	2		2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
	RN - Night	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

MRT - Day	2		3		3		3		3		3		2		2		3		3		3		3		3		2		2		3		3		3		3		3		2		2		3		3		3
MRT - Evening	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
MRT- Night	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
MRT 1100 - 1930	1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1

AA - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Physician - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Dentist - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Dental Assistant - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Dental Hygenist - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Psychiatrist - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Pharmacist - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Pharn Tech - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Rad Tech - Day	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

Pink - one shift not filled

Orange - two shifts unfilled

Red - 3 or more shifts not filled (annotate # unfilled in comments

Sheet4 Sample notifications to HSA regarding schedule changes: Call out : Nurse Jones called out for 11/25 no backfill secured or backfill secured for entire or partial shift (annotate coverage) by nurse Bell. Switch of shift: Nurse Bell will be picking up Nurse jones evening shift on 1/05 Emergency Leave: Nurse Jones left her shift at 1300 hours today due to illness Extended leave: Nurse jones will be on sick leave from 01/03 - 101/20. The back fill coverage will be.....I have been unable to back fill the following shifts

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jul 28, 2026.