2.1.1-Attachment 05– G-391 Upload Template.xlsx
XLSX spreadsheet 177 KB Posted
- Attached to
- TRANSPORTATION_SUPPORT_FOR_TEXAS Federal contract opportunity
- Solicitation number
- 70CDCR26R00000021
- Issued by
- Immigration and Customs Enforcement
About this file
This file is a G-391 Upload Template instruction guide and data collection tool for Immigration and Customs Enforcement (ICE) Enforcement and Removal Operations (ERO) contractors to submit transportation mission data.
The template automates the submission of G-391 data reports containing detailed information about alien transportation movements conducted under ICE contracts. Contractors must complete the "Input" tab with required header information including Area of Responsibility (AOR), time period, prime contractor name, invoice number, contract number, and Contracting Officer Representative (COR) name. The template captures comprehensive mission-level data for each transportation movement, including mission number and date, vehicle details (owner, type, number), movement type (air removal, land removal, transfer, medical, legal, pick-up, release, stationary duty, or other), personnel information (contract officers and ICE officers), and demographic data on aliens transported (male, female, transgender, juvenile, family units). Trip-specific information includes start and end locations with odometer readings, departure and arrival times, pickup and dropoff quantities, and up to ten intermediate stops with corresponding location, time, and passenger transfer data. The template includes built-in validation mechanisms with color-coded alerts (red dotted borders for critical missing fields, orange highlighting for invalid data, yellow highlighting for incomplete rows, and blue highlighting for duplicates) to ensure data accuracy before submission. User-defined columns (ED-EM) allow contractors to store additional information, while User-Defined PII columns (ES-FB) are automatically removed prior to upload to the TMO SharePoint site. Users must validate the workbook, delete PII columns if desired, and press the blue "Upload G-391 Workbook" button to submit data; successful uploads require access to both the TMO SharePoint site and ICE intranet.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 2.2.1- 70CDCR26R00000021 A0003.pdf | ||
| A0002 70CDCR26R00000021.pdf | ||
| 2.2.1- Attachment 02- Pricing Template A0002.xlsx | XLSX spreadsheet | |
| 2.2.1- Attachment 02- Pricing Template A0001.xlsx | XLSX spreadsheet | |
| 2.2.1- Attachment 01-PWS A0001.pdf | ||
| Attachment 04- Government Response to Questions A0001.xlsx | XLSX spreadsheet | |
| 2.1.1-Attachment 06– ICE Firearms Policy.pdf | ||
| A0001 70CDCR26R00000021.pdf | ||
| 2.2.1- Attachment 04- Solicitation Question Template (1).xlsx | XLSX spreadsheet | |
| 2.2.1- Attachment 01-PWS.pdf | ||
| 2.2.1- 70CDCR26R00000021.pdf | ||
| 2.2.1- Attachment 03- Consolidated Wage Determinations (1).xlsx | XLSX spreadsheet | |
| 2.2.1- Attachment 02- Pricing Template (1).xlsx | XLSX spreadsheet |
Show all 13
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
Text version
Instructions
| ICE ERO TMO |
| Contractor G-391 Upload Template | Version 6 |
The purpose of this tool is to automate the upload of G-391 data templates from contractors.
| Automation Tool Instructions: |
| 1. Click "Enable Content.", if prompted by the Excel security warning shown to the right. |
| 2. Fill in all required information on the "Input" Tab. |
| 3. Populate User Defined columns and change User Defined column headers, if desired. User Defined columns 1 through 10 (columns ED through EM) are available to store additional information for the consolidated data and User Defined PII columns 1 through 10 (columns ES through FB) will be removed before being uploaded to the TMO SharePoint site. PII information can be included in the User Defined PII columns provided that users securely transfer the file. |
| 4. Click on "Vendors: Click Here to Validate G-391 Workbook" to run validation procedures through the Contractor G-391 Upload Template. This step does not remove User Defined PII columns and does not upload the template to the TMO SharePoint site. |
| 5. Click on "Vendors: Click Here to Delete Extra Columns" to delete content from the User Defined PII columns 1 through 10 (columns ES through FB). This step is optional as the Upload G-391 Workbook also will remove User Defined Columns |
| 6. Verify that there is no Sensitive PII in the spreadsheet other than in the User Defined PII columns 1 through 10. |
| 7. Press the blue "Upload G-391 Workbook" within the "Input" tab. This button deletes content from the User Defined PII columns 1 through 10 (columns ES through FB) and uploads the G-391 templete to the TMO SharePoint site. Please note users must have access to the TMO SharePoint site and have access to the ICE intranet (e.g., VPN, LAN) to successfully upload. |
Vendors: Click Here to Validate G-391 Workbook Vendors: Click Here to Delete Extra Columns CORs: Click Here to Validate and Upload G-391 Workbook
Input
| AOR: | Time Period: | ||||||||||||||||||||||||||||||||||||||||||||||||
| Prime Contractor: | Invoice # | ||||||||||||||||||||||||||||||||||||||||||||||||
| Contract Number: | Sub-Office | Validation Attempts: | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| COR: | AOR-Sub-Office | ||||||||||||||||||||||||||||||||||||||||||||||||
| Upload Template Version 6 * If copying and pasting from a different workbook, it is highly recommended to use "Paste Values" (ctrl + alt + v, then Values). | |||||||||||||||||||||||||||||||||||||||||||||||||
| Add rows only to the bottom of the table below. Add columns only to the right of EC. | Use start and end fields for starting and end location information. Stops should only be used for stops made between the starting and end location. | ||||||||||||||||||||||||||||||||||||||||||||||||
| General | Vehicle | Movement | Total Aliens Moved | Start | Stop 1 | Stop 1 | Stop 2 | Stop 2 | Stop 3 | Stop 3 | Stop 4 | Stop 4 | Stop 5 | ||||||||||||||||||||||||||||||||||||
| Mission # | Mission Date | Vehicle Owner | Vehicle Type | Vehicle Number | Provider | Movement Type | Overtime | Total Overtime Hours | Contract Officers | ICE Officers | Male | Female | Transgender | Juvenile | Family Unit | Start Location | Start Odometer | Start Departure Time | Start Pick Up | Stop 1 Location | Stop 1 Odometer | Stop 1 Arrival Time | Stop 1 Departure Time | Stop 1 Pick Up | Stop 1 Drop Off | Stop 2 Location | Stop 2 Odometer | Stop 2 Arrival Time | Stop 2 Departure Time | Stop 2 Pick Up | Stop 2 Drop Off | Stop 3 Location | Stop 3 Odometer | Stop 3 Arrival Time | Stop 3 Departure Time | Stop 3 Pick Up | Stop 3 Drop Off | Stop 4 Location | Stop 4 Odometer | Stop 4 Arrival Time | Stop 4 Departure Time | Stop 4 Pick Up | Stop 4 Drop Off | Stop 5 Location | Stop 5 Odometer | Stop 5 Arrival Time | Stop 5 Departure Time | Stop 5 Pick Up |
CORs: Click Here to Validate and Upload G-391 Workbook Vendors: Click Here to Validate G-391 Workbook (+) Unhide additional stop (-) Hide additional stop (+ +) Unhide all stops (--) Hide all stops Vendors: Click Here to Delete Extra Columns
Sample
| AOR: | ATL | Time Period: | Jan 17 - Feb 17 | ||||||||||||||||||||||||||||||||||||||||||||||
| Prime Contractor: | Transport Company A | Invoice # | XXXXXXXX | ||||||||||||||||||||||||||||||||||||||||||||||
| Contract Number: | ABCDE-XX-XXXXX | Submission Attempts: | 0 | ||||||||||||||||||||||||||||||||||||||||||||||
| COR: | John Smith | ||||||||||||||||||||||||||||||||||||||||||||||||
| General | Vehicle | Movement | Total Aliens Moved | Start | Stop 1 | Stop 2 | Stop 3 | Stop 4 | Stop 5 | ||||||||||||||||||||||||||||||||||||||||
| Mission # | Mission Date | Vehicle Owner | Vehicle Type | Vehicle Number | Provider | Movement Type | Overtime | Total Overtime Hours | Contract Officers | ICE Officers | Male | Female | Transgender | Juvenile | Family Unit | Start Location | Start Odometer | Start Departure Time | Start Pick Up | Stop 1 Location | Stop 1 Odometer | Stop 1 Arrival Time | Stop 1 Departure Time | Stop 1 Pick Up | Stop 1 Drop Off | Stop 2 Location | Stop 2 Odometer | Stop 2 Arrival Time | Stop 2 Departure Time | Stop 2 Pick Up | Stop 2 Drop Off | Stop 3 Location | Stop 3 Odometer | Stop 3 Arrival Time | Stop 3 Departure Time | Stop 3 Pick Up | Stop 3 Drop Off | Stop 4 Location | Stop 4 Odometer | Stop 4 Arrival Time | Stop 4 Departure Time | Stop 4 Pick Up | Stop 4 Drop Off | Stop 5 Location | Stop 5 Odometer | Stop 5 Arrival Time | Stop 5 Departure Time | Stop 5 Pick Up | Stop 5 Drop Off |
| AOR-MMYY-XXXX | MM/DD/YYYY | Contractor or ICE | Select from list | XX0001 | Prime / Subcontractor Name | Transfer | Yes / No | 10.00 | 2 | 0 | 5 | 5 | 0 | 0 | Yes / No | Stewart Detention Center, 146 CCA Road Lumpkin, GA 31815 | 50000.00 | 10:00 | 5 | Atlanta City Detention Center, 254 Peachtree Street Southwest Atlanta, GA 30303 | 50250.00 | 13:30 | 14:00 | 2 | 2 |
Definitions
| Definitions - ICE Electronic G-391 Database |
| This tab defines acronyms and commonly used terms associated with transportation of aliens by ERO officers and contractor staff for the purpose of completing the monthly G-391 contractor report. Please note that Sensitive PII is not allowed on this spreadsheet. |
1. Contract Details – This section is filled out by the prime contractor.
| · AOR: Three letter abbreviation for the Area of Responsibility (e.g., SNA, MIA). |
| · Prime Contractor: Company or Government Agency who was awarded the transportation contract. |
| · Contract Number: The number associated with the awarded contract for transportation services. |
| · COR: The Contracting Officer Representative who is responsible for managing the contract. |
| · Time Period: The beginning and end dates for the time period when trips were collected for this report. |
| · Total Monthly Invoice Amount: The total invoice amount associated with the contract and time period reported. |
2. Transportation Activities – This section is filled out by the prime contractor for each movement during the time period.
| General |
| · Mission Number: A uniquely identifiable number associated with each transportation movement. |
| · Mission Date: The date that the trip began (MM/DD/YYYY). |
| Vehicle |
| · Vehicle Owner: Owner of the vehicle used for the mission (e.g. Contractor or the Government). |
| · Vehicle Type: Type of vehicle used to perform the mission (e.g., Sedan, Van, Bus). |
| · Bus - Any vehicle with a passenger seat capacity greater of 25 or greater. |
| · Van - Any vehicle with a passenger seat capacity between 6 and 24. |
| · SUV / Mini-Van - Any vehicle with a passenger seat capacity between 3 and 5. |
| · Sedan - Any vehicle with a passenger seat capacity of 2 or less. |
| · Vehicle Number: Vehicle identification number for the ICE or contractor vehicle used to complete the mission. |
| Movement |
| · Provider: The name of the company that provided the movement (subcontractor, prime contractor, or ICE if applicable). |
| · Movement Type: See descriptions below: |
| · Air Removal - Ground transportation of aliens to an airport for final removal via air. |
| · Air Transfer - Transporting aliens in custody to or from an airport for domestic transfers. |
| · Land Removal - Ground transportation of aliens to their country of origin for final removal. (e.g., busing or walking aliens into Mexico). |
| · Legal - Transporting of aliens for legal appointments (i.e. court, lawyer or consulate visits). |
| · Medical - Transporting detainees to a hospital or clinic for medical reasons. |
| · Ambulatory - Chasing an ambulance. |
| · Pick Up - Apprehension of an alien from a non-ICE location. (e.g., pick up from jail / prison). |
| · Release - Transporting aliens that have been released from custody to a U.S. domestic location (i.e. bus terminal). |
| · Transfer - Transporting detainees in ICE custody from one facility to another. |
| · Stationary Duty - Time spent performing detention related guard duties (e.g. front gate guard duty, facility patrols, interview escorts, detainee in/out processing, and other guard duties including remote post duties such as in-patient medical stays). |
| · Other - Transportation for a reason other than moving aliens (e.g. vehicle maintenance, file transfers). |
| · Overtime: Yes/No if overtime was needed for this trip. |
| · Total Overtime Hours: The number of overtime hours for the trip. |
| · Contract Officers: Number of contract staff participating in the mission’s transportation team. |
| · ICE Officers: Number of ICE employees participating in the mission’s transportation team. |
| Total Aliens Moved |
| · Males: Number of adult males transported. |
| · Females: Number of adult females transported. |
| · Transgender: Number of transgender aliens transported. |
| · Juvenile: Number of juvenile aliens transported. |
| · Family Unit: Yes/No if a family unit was transported. |
3. Trip Details – This section is filled out by the prime contractor for each movement during the time period.
| Start |
| · Start Location: Location where the trip began |
| · Start Odometer: The odometer reading of the vehicle before the vehicle leaves the start location |
| · Start Departure Time: The time (HH:MM) when the vehicle left the start location. |
| · Start Pick Up: The number of aliens in the vehicle at the time of departure. |
| Stop 1 - 10 |
| · Stop 1-10 Location: Location where the stop occurred. |
| · Stop 1-10 Odometer: Odometer reading from the vehicle after arriving at the stop location. |
| · Stop 1-10 Arrival Time: The time (HH:MM) when the vehicle arrived at the stop location. |
| · Stop 1-10 Departure Time: The time (HH:MM) when the vehicle left the stop location. |
| · Stop 1-10 Pick Up: The number of aliens that were picked up at the stop location. |
| · Stop 1-10 Drop Off: The number of aliens that were dropped off at the stop location. |
| End |
| · End Location: Location where the trip ended. |
| · End Odometer: The odometer reading of the vehicle when the vehicle arrives at the end location. |
| · End Arrival Time: The time (HH:MM) when the vehicle arrived at the end location. |
| · End Drop Off: The number of aliens dropped off at the time of arrival at the end location. |
· Comments: Any comments regarding the trip that are relevant to the invoice or trip details.
Validation Explanations
| Validation Explanations |
| This G-391 template includes validation mechanism that highlights missing or invalid data inputs. Please refer to the table below for additional information on the color-coded validation flags. |
| Cells with red dotted borders Indicate critical key fields that are missing. These fields must be populated in order for the upload to be successfully completed. |
| - Critical Key Fields: AOR, Prime Contractor, Contract Number, COR, Time Period, Mission #, Mission Date, Vehicle Owner, Vehicle Type, Provider, Movement Type |
| Rows with yellow highlighted Mission # indicate that one or more trip fields are incomplete or have invalid input. Look for cells highlighted in orange or with red borders to identify missing or invalid input. If Mission # is highlighted in yellow and there are no cells highlighted in orange, please confirm that all applicable stop information is populated. |
| Cells that are highlighted in orange indicate missing or invalid data input. |
| - Examples of Invalid Input: input does not match drop-down choices and/or incorrect data format such as number, date, etc.; Total trip miles equal 0 or exceed 2000 miles; last stop and end location are identical |
Mission # and Mission Dates cells highlighted in blue indicate duplicate trips. There should not be duplicate trips included in the G-391 upload.
image1.PNG image2.7D2FF230 image3.png image4.png
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 .