The file's text, extracted by GovTribe without its formatting.
Instructions
| ICE ERO TMO |
| JFRMU Transportation Data Template |
The purpose of this template is to record the UC ground and air movements.
| Instructions: |
| 1. Fill in all invoice related information on the 'Invoice Information' tab. |
| 2. Fill in all movement information on the 'Ground Transportation', 'Commercial Flight', and 'Charter Flight' Tabs. Only movements performed during this month's invoice Period of Performance should be recorded. |
| 3. Once all tabs are completed, save the document with the title "JFRMU Data Transportation Template Month Year", with Month and Year corresponding to the Period of Performance. |
| 4. Send the Excel document via email to the COR and TMO@ice.dhs.gov. |
mailto:TMO@ice.dhs.gov?subject=UAC%20Transportation%20Template%20Month%20Year Invoice Information
| Vendor: |
| Vendor POC: |
| COR: |
| Time Period: |
| Invoice Number: |
| CLIN 0001 Amount: |
| (additional CLINs to be added based on final contract) |
| CLIN 000X Amount: |
| Total Invoice Amount: |
Ground Transporation
| Ground Transportation Entry Instructions: | |
| Please enter a line for every ground movement transporting UCs or FAMUs performed during the invoiced month. | If copying and pasting from a different workbook/resource, it is highly recommended to use "Paste Values" (ctrl + alt + v, then Values). |
| General | | | Vehicle | | UCs Moved | | | FAMUs Moved | | | | | | Trip Details | | | | | Comments |
| Mission # | Mission Date | # of Contract Officers | Vehicle Type | Vehicle # | Male | Female | Transgender | Adult Male | Adult Female | Adult Transgender | Juvenile Male | Juvenile Female | Juvenile Transgender | Start Location Address | End Location Address | Total Trip Hours | Total Guard Hours | Total Miles | |
Commercial Flight
| Commercial Flight Entry Instructions: |
| Please enter a line for every commercial flight ticket purchased during the invoiced month. Include a line for each ticket purchased for contractors, aliens, FAMU members, and UCs. Gender, Juvenile, and Age fields do not need to be entered for Contract Officer Tickets. |
| General Flight Information | | | | | | | | | | | Passenger | | | | Trip | | | Comments |
| Confirmation (Ticket) # | Flight Departure Date | Flight # | Airline | Base Fare | Additional Airline Fees | Broker Fee | Direct Flight | Round Trip? | Canceled? | Reimbursement Amount | Passenger Type | Gender | Juvenile? | Age | Start Airport | Final Destination Airport | Total Air Travel Time | |
Charter Flight
| Charter Flight Entry Instructions: | |
| Please enter a line for every charter flight purchased during the invoiced month. For each entry, list the total number of UC and FAMUs moved by Male, Female, Transgender, and Juvenile breakdowns. Full Route information must also be included using the Start, Stop(s), and End Airports. | If copying and pasting from a different workbook/resource, it is highly recommended to use "Paste Values" (ctrl + alt + v, then Values). |
| General | | | | | | | | | | | UCs Moved | | | FAMUs Moved | | | | | | Trip | | | | | | | Comments |
| Mission # | Flight Date | Flight Operator | Seat Capacity | Aircraft Model # | Aircraft Manufacturer | # of Contractors | Total Cost | Planned Flight Hours | Actual Flight Hours | Flight Completed? | Male | Female | Transgender | Adult Male | Adult Female | Adult Transgender | Juvenile Male | Juvenile Female | Juvenile Transgender | Start Airport | Stop 1 | Stop 2 | Stop 3 | Stop 4 | End Airport | Total Air Travel Time | |
Definitions
| Definitions |
| 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 JFRMU Transportation Data Template. Please note that Sensitive PII is not allowed on this spreadsheet. |
| Invoice Information Tab |
| 1. Invoice Details – This section is filled out by the prime contractor. |
| · Vendor: Company or Government Agency who was awarded the transportation contract. |
| · Vendor POC: Point of Conctact from the Vendor who is responsible for managing this contract. |
| · Invoice Number: The number associated with invoice paying for the recorded 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. |
| Transportation Tabs (Ground, Commercial and Charter Flights) |
| 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/Flight Date: The date that the trip began (MM/DD/YYYY). |
| · Confirmation/Ticket Number: Number associated with each ticket issued per passenger. |
| · Contract Officers: Number of contract staff participating in the mission’s transportation team. |
| · Total Guard Hours: The number of guard hours for the trip. |
| · Total Trip Hours: The total hours taken to perform the trip. Includes Guard Hours. |
| Vehicle |
| · 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 contractor vehicle used to complete the mission. |
| Flight |
| · Total Air Travel Time: Total amount of time (hours) spent in flight. |
| Commercial |
| · Airline: The name of the commercial airline that provided the flight. |
| · Flight Number: Commercial flight number associated with this flight. |
| · Base Fare: Cost of flight (USD) before any additional airline fees (i.e. checked baggage, rebooking fee, upgrades, etc). |
| · Additional Airline Fees: Total of any additional airline fees (i.e. checked baggage, rebooking fee, upgrades, etc, in USD). |
| · Broker Fee: Fee (USD) charged by the broker to book this flight. |
| · Direct Flight: Yes/No if the flight was a direct (non-stop) flight. |
| · Round Trip?: Yes/No if the ticket was purchased as a round trip ticket. |
| · Cancelled?: Yes/No if the flight was cancelled. |
| · Reimbursement Amount: Amount (USD) reimbursed from airline from any cancelled flight. |
| Charter |
| · Aircraft Capacity: Number of passengers able to be transported on this plane. |
| · Aircraft Model: Model of aircraft. |
| · Aircraft Manufacturer: Manufacturer of aircraft. |
| · Total Cost: Total cost (USD) of charter flight. |
| · Planned Flight Hours: Total planned flight hours for this movement. |
| · Actual Flight Hours: Total actual flight hours for this movement. |
| · Flight Completed: Yes/No if the flight was completed. |
| Detainees 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 (FAMU): Yes/No if a family unit was transported. |
| · Unaccompanied Children (UC): Yes/No if a UC was transported. |
| Airport Code Look-Up |
| https://www.iata.org/publications/Pages/code-search.aspx |
| Trip Details |
| Start |
| · Start Location/Airport: Location where the trip began. |
| Stop 1 - 4 (Charter Flights Only) |
| · Stop 1-4 Location: Airport where the stop occurred. |
| End |
| · End Location/Airport: Location/Airport where the trip ended. |
| · Comments: Any comments regarding the trip that are relevant to the invoice or trip details. |
Inputs
| Airline | Direct Flight | Canceled | Reimbursement Amount | Gender | Family Unit | UAC | Passenger Type | Gender | Alien Type | Juvenile | Age | | | | | | | | | | | |
| Southwest | Yes | Yes | | Male | Yes | Yes | Alien | Male | Family Unit | Yes | 0 | | | | | | | | | | | |
| United | No | No | N/A | Female | No | No | Contract Officer | Female | Unaccompanied Minor | No | 1 | | | | | | | | | | | |
| American Airlines | | | | Transgender | | | FAMU | Transgender | | | 2 | | | | | | | | | | | |
| Spirit | | | | | | | UAC | | | | 3 | | | | | | | | | | | |
| Delta | | | | | | | | | | | 4 | | | | | | | | | | | |
| Alaska Airlines | | | | | | | | | | | 5 | | | | | | | | | | | |
| Jet Blue | | | | | | | | | | | 6 | | | | | | | | | | | |
| Other | | | | | | | | | | | 7 | | | | | | | | | | | |
| | | | | | | | | | | 8 | | | | | | | | | | | |
| | | | | | | | | | | 9 | | | | | | | | | | | |
| | | | | | | | | | | 10 | | | | | | | | | | | |
| | | | | | | | | | | 11 | | | | | | | | | | | |
| | | | | | | | | | | 12 | | | | | | | | | | | |
| | | | | | | | | | | 13 | | | | | | | | | | | |
| | | | | | | | | | | 14 | | | | | | | | | | | |
| | | | | | | | | | | 15 | | | | | | | | | | | |
| | | | | | | | | | | 16 | | | | | | | | | | | |
| | | | | | | | | | | 17 | | | | | | | | | | | |
| Vehicle | | | Movement | | | | | | Total Aliens Moved | | | | | | Start | | | | End | | | |
| Vehicle Owner | Vehicle Type | Vehicle Number | Provider | Movement Type | Overtime | Total Overtime Hours | Contract Officers | ICE Officers | Male | Female | Transgender | Juvenile | Family Units | UACs | Start Location | Start Odometer | Start Departure Time | Start Pick Up | End Location | End Odometer | End Arrival Time | End Drop Off |
| Bus | | | | | | | | | | | | | | | | | | | | | |
| Van | | | | | | | | | | | | | | | | | | | | | |
| SUV | | | | | | | | | | | | | | | | | | | | | |
| Sedan | | | | | | | | | | | | | | | | | | | | | |
image1.PNG image2.png
Immigration and Customs Enforcement