2.2. Attachment 7 -ASN Upload Spreadsheet RCTSD Hawaii.xls
XLS spreadsheet 210 KB Posted
- Attached to
- Resource and Capability Transportation Support during Disasters (RCTSD) Hawaii Islands Federal contract opportunity
- Solicitation number
- 70FB7021R00000004
- Issued by
- Federal Emergency Management Agency
About this file
This document contains a synopsis for a solicitation seeking transportation and logistics support services for disaster response in Hawaii. The solicitation will be full and open with an anticipated multiple award of IDIQ contracts. The Federal Emergency Management Agency intends to award firm fixed price contracts with a one year base period and four one-year option periods to provide port operations, transportation services from CONUS ports to Hawaiian islands, and retrograde support. Specific requirements, locations, and periods of performance will be defined in task orders. Offerors must register in the System for Award Management to be eligible for award. The document provides historical loading/discharging locations and hours of operation requirements, and notes compliance with the Jones Act will be necessary.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment 1 Hawaii Price CLIN Structure June 21.xlsx | XLSX spreadsheet | |
| 70FB7021R00000004 Amendment 0001 Signed.pdf | ||
| Vendor Questions 2.2. Attachment 8 Question and Answer(FEMA Responses)..xlsx | XLSX spreadsheet | |
| 2.2 Attachment #2 PWS RCTSD-Hawaii 03-10-2021.pdf | ||
| 2.2 Attachment# 5-SF-91 Accident Report Form.pdf | ||
| 2.2 Attachment #6-SF-364 Report of Discrepancy.pdf | ||
| 2.2 Attachment #3 QASP - RCTSD Hawaii.pdf | ||
| 2.2 Attachment #1 Hawaii Price CLIN Structure.xlsx | XLSX spreadsheet | |
| 2.2.1 Solicitaion RCTSD- Hawaii 70FB7021R00000004.pdf.pdf | ||
| 2.2. Attachment 8 Question and Answer Template.xlsx | XLSX spreadsheet | |
| 2.2 Attachment #4- Report of Survey.pdf | ||
| Synopsis for Resource and Capability Transportation Support during Disasters RCTSD Hawaii.pdf |
Show all 12
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
Data Definition
| Field Name | Group | Spreadsheet Column | Group Id | Data Sheet Order | Xml Tag Name | Description | Max Value or Max Length | Format | Required? | Sheet Name | Column Number | Condition | Has Value | Action | Conditional Fields | Conditional Error message | Group Required (True/False) | Max. Occurs | Max.Occurs Group | Min. Value or Min. Length |
| Source | Header | 1 | 1 | Source | 50 | TEXT | N | Header | 1 | N | 0 | |||||||||
| Action_Type | Header | 1 | 2 | Action_Type | 50 | Create,Update | Y | Header | 2 | N | 0 | |||||||||
| Batch_ID | Header | 1 | 3 | Batch_ID | 10 | TEXT | N | Header | 3 | N | 0 | |||||||||
| Reference_ID | Header | 1 | 4 | Reference_ID | 50 | TEXT | N | Header | 4 | N | 0 | |||||||||
| User_ID | Header | 1 | 5 | User_ID | 50 | TEXT | N | Header | 5 | N | 0 | |||||||||
| Password | Header | 1 | 6 | Password | 50 | TEXT | N | Header | 6 | N | 0 | |||||||||
| Message_Type | Header | 1 | 7 | Message_Type | 40 | TEXT | Y | Header | 7 | N | 0 | |||||||||
| Company_ID | Header | 1 | 8 | Company_ID | 8 | TEXT | Y | Header | 8 | N | 0 | |||||||||
| Purpose_Code | Header | 1 | 9 | Purpose_Code | 50 | TEXT | N | Header | 9 | N | 0 | |||||||||
| Msg_Locale | Header | 1 | 10 | Msg_Locale | 50 | TEXT | Y | Header | 10 | N | 0 | |||||||||
| Version | Header | 1 | 11 | Version | 20 | TEXT | N | Header | 11 | N | 0 | |||||||||
| Internal_Reference_ID | Header | 1 | 12 | Internal_Reference_ID | 40 | TEXT | N | Header | 12 | N | 0 | |||||||||
| Internal_Date_Time_Stamp | Header | 1 | 13 | Internal_Date_Time_Stamp | 50 | TEXT | N | Header | 13 | N | 0 | |||||||||
| External_Reference_ID_Type | Header | 1 | 14 | External_Reference_ID_Type | 40 | TEXT | N | Header | 14 | N | 0 | |||||||||
| External_Reference_ID | Header | 1 | 15 | External_Reference_ID | 40 | TEXT | N | Header | 15 | N | 0 | |||||||||
| External_Date_Time_Stamp | Header | 1 | 16 | External_Date_Time_Stamp | 50 | TEXT | N | Header | 16 | N | 0 | |||||||||
| Sequence_Number | Header | 1 | 17 | Sequence_Number | 50 | TEXT | N | Header | 17 | N | 0 | |||||||||
| DO Number | ASN | 3 | 18 | DONumber | 12 | TEXT | Y | ASN | 1 | N | 0 | |||||||||
| Trailer Number | ASN | 3 | 19 | TrailerNumber | 20 | TEXT | Y | ASN | 2 | N | 0 | |||||||||
| Origin Facility | ASN | 3 | 20 | OriginFacilityId | 20 | TEXT | Y | ASN | 3 | N | 0 | |||||||||
| Destination Facility | ASN | 3 | 21 | DestinationFacilityId | 20 | TEXT | Y | ASN | 4 | N | 0 | |||||||||
| Estimated Delivery Date/Time | ASN | 3 | 22 | EstimatedDeliveryDttm | 20 | TEXT | Y | ASN | 5 | N | 0 | |||||||||
| Actual Shipped Date/Time | ASN | 3 | 23 | ActualShippedDttm | 20 | TEXT | N | ASN | 6 | N | 0 | |||||||||
| Partner Ref Number | ASN | 3 | 24 | PartnerRefNumber | 25 | TEXT | N | ASN | 7 | N | 0 | |||||||||
| CO Number | ASN | 3 | 25 | CONumber | 12 | TEXT | N | ASN | 8 | N | 0 | |||||||||
| GPS (Truck/Trailer) | ASN | 3 | 26 | GPS | 25 | TEXT | N | ASN | 9 | N | 0 | |||||||||
| Shipment | ASN | 3 | 27 | ShipmentId | 12 | TEXT | N | ASN | 10 | N | 0 | |||||||||
| BOL Number | ASN | 3 | 28 | BOLNumber | 50 | TEXT | N | ASN | 11 | N | 0 | |||||||||
| Seal Number | ASN | 3 | 29 | SealNumber | 10 | TEXT | N | ASN | 12 | N | 0 | |||||||||
| Tractor Number | ASN | 3 | 30 | TractorNumber | 25 | TEXT | N | ASN | 13 | N | 0 | |||||||||
| Driver Name | ASN | 3 | 31 | DriverName | 50 | TEXT | N | ASN | 14 | N | 0 | |||||||||
| Driver Number | ASN | 3 | 32 | DriverNumber | 25 | TEXT | N | ASN | 15 | N | 0 | |||||||||
| Item Name | ASN | 3 | 33 | ItemName | 25 | TEXT | Y | ASN | 16 | N | 0 | |||||||||
| Shipped Quantity (Units) | ASN | 3 | 34 | ShippedQty | 10 | TEXT | Y | ASN | 17 | N | 0 | |||||||||
| Lot Number | ASN | 3 | 35 | LotNumber | 25 | TEXT | N | ASN | 18 | N | 0 | |||||||||
| Expiration Date | ASN | 3 | 36 | ExpirationDate | 10 | TEXT | N | ASN | 19 | N | 0 | |||||||||
| Manufacturer | ASN | 3 | 37 | Manufacturer | 25 | TEXT | N | ASN | 20 | N | 0 | |||||||||
| Asset Barcode | ASN | 3 | 38 | AssetBarcode | 25 | TEXT | N | ASN | 21 | N | 0 | |||||||||
| GPS (Asset) | ASN | 3 | 39 | AssetGPS | 25 | TEXT | N | ASN | 22 | N | 0 | |||||||||
| Comments | ASN | 3 | 40 | Comments | 100 | TEXT | N | ASN | 23 | N | 0 | |||||||||
| Distribution Order | ||||||||||||||||||||
| Partner Reference Number | ||||||||||||||||||||
| Trailer Number | ||||||||||||||||||||
| Pickup Facility ID | ||||||||||||||||||||
| Pickup Facility FEDAAC or Name | ||||||||||||||||||||
| Actual Ship Date Time | ||||||||||||||||||||
| Delivery Facility ID | ||||||||||||||||||||
| Delivery City, State | ||||||||||||||||||||
| Delivery Facility FEDAAC or Name | ||||||||||||||||||||
| Estimated Delivery Date Time | ||||||||||||||||||||
| Item Name | ||||||||||||||||||||
| Shipped Qty (Units) | ||||||||||||||||||||
| GPS (Truck/Trailer) | ||||||||||||||||||||
| Bill of Lading Number | ||||||||||||||||||||
| AsnID | Tractor Number | |||||||||||||||||||
| TcAsnID | Driver Info, Carrier | |||||||||||||||||||
| TC_ASN_ID_U | Shipment ID | |||||||||||||||||||
| AsnType | Seal Number | |||||||||||||||||||
| ASN_ORGN_TYPE | NSN | |||||||||||||||||||
| DESTINATION_TYPE | GPS (Asset) | |||||||||||||||||||
| ASN_LEVEL | Lot Number | |||||||||||||||||||
| TC_COMPANY_ID | Expiration Date | |||||||||||||||||||
| ASN.BUSINESS_PARTNER_ID | Manufacturer | |||||||||||||||||||
| ASN_STATUS | Gov’t Barcode | |||||||||||||||||||
| CREATED_DTTM | Comments | |||||||||||||||||||
| LAST_UPDATED_DTTM | ||||||||||||||||||||
| CREATED_SOURCE_TYPE | ||||||||||||||||||||
| LAST_UPDATED_SOURCE_TYPE | ||||||||||||||||||||
| CREATED_SOURCE | ||||||||||||||||||||
| LAST_UPDATE_SOURCE | ||||||||||||||||||||
| TRAILER_NUMBER | ||||||||||||||||||||
| ORIGIN_FACILITY_ALIAS_ID | ||||||||||||||||||||
| ORIGIN_FACILITY _ID | ||||||||||||||||||||
| DESTINATION_FACILITY_ALIAS_ID | ||||||||||||||||||||
| DESTINATION_FACILITY _ID | ||||||||||||||||||||
| DELIVERY_START_DTTM | ||||||||||||||||||||
| ACTUAL_SHIPPED_DTTM | ||||||||||||||||||||
| TRACTOR_NUMBER | ||||||||||||||||||||
| TC_SHIPMENT_ID | ||||||||||||||||||||
| SHIPMENT_ID | ||||||||||||||||||||
| DRIVER_NAME | ||||||||||||||||||||
| BILL_OF_LADING_NUMBER | ||||||||||||||||||||
| INBOUND_REGION_ID | ||||||||||||||||||||
| OUTBOUND_REGION_ID | ||||||||||||||||||||
| ASN_DETAIL_ID | ||||||||||||||||||||
| TC_COMPANY_ID | ||||||||||||||||||||
| ASN_ID | ||||||||||||||||||||
| ASN_DETAIL_STATUS | ||||||||||||||||||||
| CREATED_DTTM | ||||||||||||||||||||
| LAST_UPDATED_DTTM | ||||||||||||||||||||
| CREATED_SOURCE_TYPE | ||||||||||||||||||||
| LAST_UPDATED_SOURCE_TYPE | ||||||||||||||||||||
| CREATED_SOURCE | ||||||||||||||||||||
| LAST_UPDATE_SOURCE | ||||||||||||||||||||
| BUSINES_PARTNER_ID | ||||||||||||||||||||
| TC_ORDER_ID | ||||||||||||||||||||
| TC_ORDER_LINE_ID | ||||||||||||||||||||
| SKU_ID | ||||||||||||||||||||
| SKU_NAME | ||||||||||||||||||||
| SHIPPED_QTY | ||||||||||||||||||||
| BATCH_NBR | ||||||||||||||||||||
| EXPIRE_DATE | ||||||||||||||||||||
| SEAL_NUMBER | ||||||||||||||||||||
| ASN_ID | ||||||||||||||||||||
| SEAL_ID | ||||||||||||||||||||
| SEAL_SEQUENCE |
Parameter
| Password | 0 |
| Action | Create |
| XSD_PATH | |
| XSD_ROOT_ELEMENT | tXML |
| DISABLE_MENU_ITEMS | |
| UTILITY_VERSION | TALON.1.57 |
| SPLIT_VALIDATION_TO_BASIC_n_CONDITIONAL | |
| SERVER_INFO | |
| UTILITY_SPLIT_COUNT | 1 |
| INTERNAL_SHEET_NAMES | ASN |
| PARENT_SHEET_KEYS | |
| SHEET_UNIQUE_KEYS | ASN_ID |
| DATA_START_ROW | 14 |
| SHEET_NAMES | ASN |
| ESCAPE_COLUMNS |
Header
| Full Version | 1.0 | |||||||||||||||
| Date & Time | ||||||||||||||||
| Report as of: | ||||||||||||||||
| FEMA CONTACT | PARTNER CONTACT | |||||||||||||||
| Name | Name | |||||||||||||||
| Phone | Phone | |||||||||||||||
| Notes: | ||||||||||||||||
| Column headers colored YELLOW are required fields and must be completed prior to returning to FEMA | ||||||||||||||||
| Source | Action_Type | Batch_ID | Reference_ID | User_ID | Password | Message_Type | Company_ID | Purpose_Code | Msg_Locale | Version | Internal_Reference_ID | Internal_Date_Time_Stamp | External_Reference_ID_Type | External_Reference_ID | External_Date_Time_Stamp | Sequence_Number |
| ASNUpload | Create | ASNUpload | 1 | 1.0 | ASN | ASN | 111 |
Advanced Shipping Notice
| Full Version | 1.0 | |||||||||||||||||||||
| Date & Time | ||||||||||||||||||||||
| Report as of: | ||||||||||||||||||||||
| FEMA CONTACT | PARTNER CONTACT | |||||||||||||||||||||
| Name | Name | |||||||||||||||||||||
| Phone | Phone | |||||||||||||||||||||
| Notes: | ||||||||||||||||||||||
| Column headers colored YELLOW are required fields and must be completed prior to returning to FEMA | ||||||||||||||||||||||
| DO Number | Trailer Number | Origin Facility | Destination Facility | Estimated Delivery Date/Time | Actual Shipped Date/Time | Partner Ref Number | CO Number | GPS (Truck / Trailer) | Shipment | BOL Number | Seal Number | Tractor Number | Driver Name | Driver Number | Item Name | Shipped Quantity (Units) | Lot Number | Expiration Date | Manufacturer | Asset Barcode | GPS (Asset) | Comments |
&L&D&T&CWarning: This document is FOR OFFICIAL USE ONLY (FOUO).&R Page &P of &N
File details come from the government source that posted it. Updated .