Trade Agreements Report



DescriptionStart Date End Date
BETA Installation Friday May 16, 2014Friday May 16, 2014
Functional Qualification Testing Tuesday May 20, 2014Wednesday May 21, 2014
Retest, if required Monday May 26, 2014Monday May 26, 2014
Installation in ProductionFriday May 30, 2014Friday May 30, 2014

Document Changes

DocumentationChanges Required
XML SpecificationsNo
Web ServicesNo
Data Dictionary No
NASA Specific Data DictionaryNo
Use Case SummaryNo
Validation RulesNo
Online HelpYes
User ManualNo

SPR Listing

SPR #EnhancementSolutionImpact to Users and Integrators
Trade Agreements Report The business goal of the Trade Agreements Report is to provide the data about the several values of procurements covered by international trade agreements in order to comply with reporting requirements of the North American Free Trade Agreement (NAFTA) and the World Trade Organization Agreement on Government Procurement Agreement (GPA). Following are the high level requirements for the Trade Agreements Report:

1. The top level report at the Federal Government level is a summary report for all actions that are covered by NAFTA and GPA trade agreements that displays the base (mod number = 0) action awarded in a given year and the Cumulative Dollars Obligated* on that action for the years when the award contained obligations

*Cumulative Dollars Obligated = Dollars Obligated on the base + Dollars Obligated on all the modifications + Dollars Obligated on all the Orders

2. This report shall display data from FY2009 and until the NAFTA/GPA thresholds are available. This means that the data shall be available for FY2009, FY2010, FY2011, FY2012, FY2013, FY2014, and FY2015.

3. The search criteria must include the following fields:

  .Fiscal Year – Mandatory
  .Department ID - Optional
  .Agency ID - Optional
  .Organization Code - Optional
  .Contracting Office Region - Optional
  .Contracting Office ID - Optional
  .PSC Code - Optional
  .Country of Origin - Optional
  .Type of Report - Optional; one value shall be chosen
      .Set-Asides only 
      .Limited Tendering 
      .Open to Trade Agreements Competition (the default value)

4. The eligible NAFTA and GPA agencies shall apply. TSA (agency code 7013) will be excluded until 2014.

5. PSC exclusions shall apply.

6. A drill path and an Award Detail shall be displayed.

7. The Appendix and the Help File shall be developed accordingly.