Attachment 5 Reporting Dictionary.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Next Generation Delivery Service (NGDS) Federal contract opportunity
- Solicitation number
- HTC711-17-R-CC01
About this file
DRAFT Atch 5
View the file
Other files for this federal contract opportunity
Show all 43
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
| Tab | Column | Instruction |
| Data_Field_Dictionary | Include each data file that will be transferred to the Government, including Customer Record File and Shipment Detail Report |
Additional data files sent by the Contractor to fulfill reporting requirements (e.g. separate surcharge file) shall also be detailed A, "Data File Name" Include the name of the Data File that is being detailed in the following columns Only include the Data File Name when describing a new Data File, otherwise leave blank
| B, "Contractor Data Field" | Provide the name of the data field provided in the report | |
| C, "Field Type" | Describe the Type the data is presented in (e.g. char, varchar, integer, decimal) | |
| D, "Field Length" | Provide the maximum number of characters allowed for this field (e.g. YYYYMMDD for a date field would be reported as "6") | |
| E, "Field Format / Description" | Describe the format the data appears in (e.g. YYYYMMDD for a date field, cm or inches for a measurement field) | |
| F, "Mapped Government Field" | Provide the required Government Field that this data field satisfies | |
| Service_Type_Codes | A, "Service Type Code" | Provide the Code used in the report to denote the level of service (e.g. E2AM) |
| B, "Service Type Description" | Describe the level of service as stated in the service guide (e.g. Express 2-Day Early Morning Delivery) | |
| C, "Allowable Time in Transit" | Provide the amount of time this service level allows to be considered on-time, if not applicable to a service level leave blank | |
| Delay_Codes | A, "Contractor Delay Code" | Provide the Contractor's Commercial Delay Code used in the report to denote the type of delay |
| B, "Contractor Delay Code Description" | Describe the Contractor's Commercial Delay Code | |
| C, "Applicable Government Delay Code" | Provide the applicable code located in the "Govt_Excusable_Delay_Codes" Tab that the Contractor's Commercial Delay Code maps to. Indicate"Not Applicable" if no logical correlation exists. If a Contractor Delay Code does not map to a Government Excusable Delay Code, that delay code will not be considered excusable for purposes of determining on-time delivery performance. | |
| Govt_Excusable_Delays | A, "Excusable Delay Code" | Use to provide the information in Tab "Delay_Codes", Column C, "Applicable Government Delay Code", do not alter |
| Accessorial (Surcharge)_Codes | A, "Accessorial (Surcharge) Code" | Provide the Code used in the report to denote the accessorial (surcharge) |
| B, "Surcharge Code Description" | Identify the accessorial (surchage) title |
Data_Field_Dictionary
| Data File Name | Contractor Field Name | Field Type | |
| (char, integer, etc) | Field Length | Field Format / Description | Mapped Government Field |
(N/A if none)
| Example File 1 | Field A |
| Field B | |
| Field C | |
| Example File 2 | Field A |
| Field B | |
| Field C | |
| Example File 3 | Field A |
| Field B | |
| Field C |
Service_Type_Codes Service Type Code Service Type Description Allowable Time in Transit
Delay_Codes Contractor Delay Code Contractor Delay Code Description Applicable Government Excusable Delay Code
Govt_Excusable_Delay_Codes
| Excusable Delay Code | Government Excusable Delay Code Description |
| AOG | Acts of God e.g. Earthquake, Flood, Hurricane/Typhoon |
| CUS | Shipment delivery delayed due to customs clearance issues beyond the contractor's control |
| DGP | Shipment delayed due to improper dangerous goods paperwork from shipper |
| HLD | Shipment delayed due to a request from the customer to hold shipment |
| HOL | Shipment delayed due to holiday hours at receiving installation |
| ICI | Shipment delivery delayed due to incorrect consignee information given by shipper |
| IEX | Installation closed due to exercise |
| PKG | Shipment delayed due to improper packaging by customer, freight had to be repackaged |
| POC | Shipment delivery delayed due to point of contact not available to accept delivery |
| RCE | Receiving office closed early, unable to deliver |
| RSC | Shipment delivery delayed due to customer request for rescheduling date of deliver |
| RWY | Shipment delivery delayed due to runway clearance issues, plane could not land |
| SEC | Shipment delivery delayed due to security purpose |
| SRC | Delayed due to strikes, trios, civil commotion |
| WEA | Shipment delivery delayed due to weather restrictions |
Accessorial (Surcharge)_Codes Accessorial (Surcharge) Code Accessorial (Surcharge) Code Title
File details come from the government source that posted it. Updated .