Attachment_5 _Reporting_Dictionary.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- Next Generation Delivery Service (NGDS) Federal contract opportunity
- Solicitation number
- HTC711-17-R-CC01
About this file
NGDS Atch 5
View the file
Other files for this federal contract opportunity
Show all 50
Next Generation Delivery Service (NGDS) has more files on GovTribe.
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
1. Instructions
| Attachment 5 | ||
| NGDS Reporting Dictionary | ||
| Tab | Column | Instruction |
| 2. Data_Field_Dictionary | Include each data file that will be transferred to the Government, including Customer Record File and Shipment Detail |
Additional data files sent by the Contractor to fulfill reporting requirements (e.g. separate surcharge file) shall also be detailed
- Clear example data prior to population of data A, "Data File Name" Provide 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 |
- char for fields with fixed-lengths
- varchar for fields containing variable-lengths
- integer for fields containing only whole numbers
- decimal for fields containing decimal numbers
- date for fields containing dates 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")
- For decimal fields include the max number before the decimal point and max number after
- e.g. Invoice Cost, "8,2" would denote a maximum amount of 99999999.99
| 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, listed in Appendix 6.10 Shipment Detail Report Required Data Elements, that this data field satisfies |
| 3. 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 or varies on origin/destination then leave blank |
| 4. 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.
5. 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
| 6. Accessorial_ (Surcharge)_Codes | A, "Accessorial (Surcharge) Code" | Provide the Code used in the report to denote the accessorial (surcharge) |
| B, "Accessorial (Surcharge) Code Title" | Identify the accessorial (surcharge) title |
2. Data_Field_Dictionary
| Data File Name | Contractor Field Name | Field Type |
| Field Length | Field Format / Description | Mapped Government Field |
(N/A if none)
| Example Detail Report | Inv Date | date | 10 | YYYY-MM-DD | Invoice_Date |
| Service Types | char | 3 | Refer to tab 3 | Service_Type_Code | |
| Service Category | varchar | 15 | express, ground, international | Service_Category | |
| Package Weight | int | 3 | Measured in kilograms | Billed_Weight | |
| Example Surcharge Report | Inv Date | date | 8 | DDMMYYYY | Invoice Date |
| Surcharge Cost | decimal | 8,2 | Measured in USD | Surcharge_Cost | |
| Surcharge Code | varchar | 3 | Refer to tab 6 | Surcharge_Code | |
| Clear Example Data Prior to Completion |
3. Service_Type_Codes Service Type Code Service Type Description Allowable Time in Transit
4. Delay_Codes Contractor Delay Code Contractor Delay Code Description Applicable Government Excusable Delay Code
5. 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 |
6.Accessorial_(Surcharge)_Codes Accessorial (Surcharge) Code Accessorial (Surcharge) Code Title
File details come from the government source that posted it. Updated .