C1a -70FB7020R00000002 Attachment 6 ASN Upload_Spreadsheet v1.3.xlsx
XLSX spreadsheet 118 KB Posted
- Attached to
- Resource and Capability Transportation Support during Disasters (RCTSD) VIPER Federal contract opportunity
- Solicitation number
- 70FB7020R00000002
- Issued by
- Federal Emergency Management Agency
About this file
This solicitation requests transportation support services during disasters in Puerto Rico and the U.S. Virgin Islands. The Federal Emergency Management Agency seeks contractors to supply initial response resources such as water, meals, cots, tarps, generators, and fuel to survivors. Contractors must also transport interagency resources and personnel to support infrastructure repairs, medical services, and distribution of basic needs. The indefinite delivery, indefinite quantity multiple award contracts will have a one year base period and four one-year options. Phase I proposals are due August 31, 2020 and should demonstrate prior experience, technical capability, management approach, and price. Awards will be made based on a best value tradeoff analysis evaluating non-price factors such as experience and technical capability as more important than price.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 70FB7020R00000002 Amendment 0002 Signed by FEMA.pdf | ||
| 70FB7020R00000002 Amendment 0003 Signed by FEMA.pdf | ||
| C1a -70FB7020R00000002 Attachment 1 CLIN Price Structure VIPR - REV 082020.xlsx | XLSX spreadsheet | |
| 70FB7020R00000002 Amendment 0001 Signed by FEMA.pdf | ||
| Government Answers to Contractor Questions REV 082020.xlsx | XLSX spreadsheet | |
| C1a -70FB7020R00000002 Attachment 3_FEMA Form 119-7-1-1 Report of Survey.pdf | ||
| C1a -70FB7020R00000002 Attachment 4 SF-91 Accident Report Form.pdf | ||
| Question and Answer Template.xlsx | XLSX spreadsheet | |
| C1a - 70FB7020R00000002 VIPER RFP.pdf | ||
| C1a -70FB7020R00000002 Attachment 5 SF-364 Report of Discrepancy.pdf | ||
| C1a -70FB7020R00000002 Attachment 1 CLIN Price Structure VIPR.xlsx | XLSX spreadsheet | |
| C1a -70FB7020R00000002 Attachment 2 QASP RCTSD VIPR.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 | TRUE | N | FALSE | 0 | |||||||
| Action_Type | Header | 1 | 2 | Action_Type | 50 | Create,Update | Y | Header | 2 | TRUE | N | FALSE | 0 | |||||||
| Batch_ID | Header | 1 | 3 | Batch_ID | 10 | TEXT | N | Header | 3 | TRUE | N | FALSE | 0 | |||||||
| Reference_ID | Header | 1 | 4 | Reference_ID | 50 | TEXT | N | Header | 4 | TRUE | N | FALSE | 0 | |||||||
| User_ID | Header | 1 | 5 | User_ID | 50 | TEXT | N | Header | 5 | TRUE | N | FALSE | 0 | |||||||
| Password | Header | 1 | 6 | Password | 50 | TEXT | N | Header | 6 | TRUE | N | FALSE | 0 | |||||||
| Message_Type | Header | 1 | 7 | Message_Type | 40 | TEXT | Y | Header | 7 | TRUE | N | FALSE | 0 | |||||||
| Company_ID | Header | 1 | 8 | Company_ID | 8 | TEXT | Y | Header | 8 | TRUE | N | FALSE | 0 | |||||||
| Purpose_Code | Header | 1 | 9 | Purpose_Code | 50 | TEXT | N | Header | 9 | TRUE | N | FALSE | 0 | |||||||
| Msg_Locale | Header | 1 | 10 | Msg_Locale | 50 | TEXT | Y | Header | 10 | TRUE | N | FALSE | 0 | |||||||
| Version | Header | 1 | 11 | Version | 20 | TEXT | N | Header | 11 | TRUE | N | FALSE | 0 | |||||||
| Internal_Reference_ID | Header | 1 | 12 | Internal_Reference_ID | 40 | TEXT | N | Header | 12 | TRUE | N | FALSE | 0 | |||||||
| Internal_Date_Time_Stamp | Header | 1 | 13 | Internal_Date_Time_Stamp | 50 | TEXT | N | Header | 13 | TRUE | N | FALSE | 0 | |||||||
| External_Reference_ID_Type | Header | 1 | 14 | External_Reference_ID_Type | 40 | TEXT | N | Header | 14 | TRUE | N | FALSE | 0 | |||||||
| External_Reference_ID | Header | 1 | 15 | External_Reference_ID | 40 | TEXT | N | Header | 15 | TRUE | N | FALSE | 0 | |||||||
| External_Date_Time_Stamp | Header | 1 | 16 | External_Date_Time_Stamp | 50 | TEXT | N | Header | 16 | TRUE | N | FALSE | 0 | |||||||
| Sequence_Number | Header | 1 | 17 | Sequence_Number | 50 | TEXT | N | Header | 17 | TRUE | N | FALSE | 0 | |||||||
| DO Number | ASNUpload | 3 | 18 | DONumber | 12 | TEXT | Y | ASNUpload | 1 | FALSE | N | FALSE | 0 | |||||||
| Trailer Number | ASNUpload | 3 | 19 | TrailerNumber | 20 | TEXT | Y | ASNUpload | 2 | FALSE | N | FALSE | 0 | |||||||
| Origin Facility | ASNUpload | 3 | 20 | OriginFacilityId | 20 | TEXT | Y | ASNUpload | 3 | FALSE | N | FALSE | 0 | |||||||
| Destination Facility | ASNUpload | 3 | 21 | DestinationFacilityId | 20 | TEXT | Y | ASNUpload | 4 | FALSE | N | FALSE | 0 | |||||||
| Estimated Delivery Date/Time | ASNUpload | 3 | 22 | EstimatedDeliveryDttm | 20 | TEXT | Y | ASNUpload | 5 | FALSE | N | FALSE | 0 | |||||||
| Actual Shipped Date/Time | ASNUpload | 3 | 23 | ActualShippedDttm | 20 | TEXT | N | ASNUpload | 6 | FALSE | N | FALSE | 0 | |||||||
| Partner Ref Number | ASNUpload | 3 | 24 | PartnerRefNumber | 25 | TEXT | N | ASNUpload | 7 | FALSE | N | FALSE | 0 | |||||||
| CO Number | ASNUpload | 3 | 25 | CONumber | 12 | TEXT | N | ASNUpload | 8 | FALSE | N | FALSE | 0 | |||||||
| GPS (Truck/Trailer) | ASNUpload | 3 | 26 | GPS | 25 | TEXT | N | ASNUpload | 9 | FALSE | N | FALSE | 0 | |||||||
| Shipment | ASNUpload | 3 | 27 | ShipmentId | 12 | TEXT | N | ASNUpload | 10 | FALSE | N | FALSE | 0 | |||||||
| BOL Number | ASNUpload | 3 | 28 | BOLNumber | 50 | TEXT | N | ASNUpload | 11 | FALSE | N | FALSE | 0 | |||||||
| Seal Number | ASNUpload | 3 | 29 | SealNumber | 10 | TEXT | N | ASNUpload | 12 | FALSE | N | FALSE | 0 | |||||||
| Tractor Number | ASNUpload | 3 | 30 | TractorNumber | 25 | TEXT | N | ASNUpload | 13 | FALSE | N | FALSE | 0 | |||||||
| Plate State | ASNUpload | 3 | 31 | PlateState | 25 | TEXT | N | ASNUpload | 14 | FALSE | N | FALSE | 0 | |||||||
| Plate Number | ASNUpload | 3 | 32 | PlateNbr | 25 | TEXT | N | ASNUpload | 15 | FALSE | N | FALSE | 0 | |||||||
| Vessel | ASNUpload | 3 | 33 | Vessel | 100 | TEXT | N | ASNUpload | 16 | FALSE | N | FALSE | 0 | |||||||
| Voyage | ASNUpload | 3 | 34 | Voyage | 100 | TEXT | N | ASNUpload | 17 | FALSE | N | FALSE | 0 | |||||||
| Item Name | ASNUpload | 3 | 35 | ItemName | 25 | TEXT | Y | ASNUpload | 18 | FALSE | N | FALSE | 0 | |||||||
| Shipped Quantity (Units) | ASNUpload | 3 | 36 | ShippedQty | 10 | TEXT | Y | ASNUpload | 19 | FALSE | N | FALSE | 0 | |||||||
| Lot Number | ASNUpload | 3 | 37 | LotNumber | 25 | TEXT | N | ASNUpload | 20 | FALSE | N | FALSE | 0 | |||||||
| Expiration Date | ASNUpload | 3 | 38 | ExpirationDate | 10 | TEXT | N | ASNUpload | 21 | FALSE | N | FALSE | 0 | |||||||
| Manufacturer | ASNUpload | 3 | 39 | Manufacturer | 25 | TEXT | N | ASNUpload | 22 | FALSE | N | FALSE | 0 | |||||||
| Asset Barcode | ASNUpload | 3 | 41 | AssetBarcode | 25 | TEXT | N | ASNUpload | 23 | FALSE | N | FALSE | 0 | |||||||
| GPS (Asset) | ASNUpload | 3 | 42 | AssetGPS | 25 | TEXT | N | ASNUpload | 24 | FALSE | N | FALSE | 0 | |||||||
| Comments | ASNUpload | 3 | 43 | Comments | 100 | TEXT | N | ASNUpload | 25 | FALSE | N | FALSE | 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 | TRUE |
| UTILITY_VERSION | TALON.1.57 |
| SPLIT_VALIDATION_TO_BASIC_n_CONDITIONAL | FALSE |
| SERVER_INFO | |
| UTILITY_SPLIT_COUNT | 1 |
| INTERNAL_SHEET_NAMES | ASNUpload |
| PARENT_SHEET_KEYS | |
| SHEET_UNIQUE_KEYS | ASN_ID |
| DATA_START_ROW | 14 |
| SHEET_NAMES | ASNUpload |
| ESCAPE_COLUMNS |
Header
Full Version 1.3
| 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.3 | ASNUpload | ASNUpload | 111 |
mailto:FEMA-LRC-Chief@dhs.gov ASNUpload
Full Version 1.3
| 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 | Plate State | Plate Number | Vessel | Voyage | Item Name | Shipped Quantity (Units) | Lot Number | Expiration Date | Manufacturer | Asset Barcode | GPS (Asset) | Comments |
&D&T Warning: This document is FOR OFFICIAL USE ONLY (FOUO). Page &P of &N
Sheet1
| A | DO Number |
| B | Trailer Number |
| C | Origin Facility |
| D | Destination Facility |
| E | Estimated Delivery Date/Time |
| F | Actual Shipped Date/Time |
| G | Partner Ref Number |
| H | CO Number |
| I | GPS (Truck / Trailer) |
| J | Shipment |
| K | BOL Number |
| L | Seal Number |
| M | Tractor Number |
| N | Plate State |
| O | Plate Number |
| P | Vessel |
| Q | Voyage |
| R | Item Name |
| S | Shipped Quantity (Units) |
| T | Lot Number |
| U | Expiration Date |
| V | Manufacturer |
| W | Asset Barcode |
| X | GPS (Asset) |
| Y | Comments |
image1.png
File details come from the government source that posted it. Updated .