Difference between revisions of "V1.4 SP 20.0"

From FPDS-NG

 
(18 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
<tr><th width=30% align="center"><b>Description</b></th><th width=34% align="center"><b>Start Date</b></th>
 
<tr><th width=30% align="center"><b>Description</b></th><th width=34% align="center"><b>Start Date</b></th>
 
<th width=34% align="center"><b>End Date</b></th></tr>
 
<th width=34% align="center"><b>End Date</b></th></tr>
<tr><td nowrap>BETA Installation </td><td nowrap>Thursday June 13, 2013</td><td nowrap>Thursday June 13, 2013</td></tr>
+
<tr><td nowrap>BETA Installation </td><td nowrap>Thursday June 13, 2013</td><td nowrap>Friday June 14, 2013</td></tr>
<tr><td nowrap>Functional Qualification Testing </td><td nowrap>Friday June 14, 2013</td><td nowrap>Thursday June 20, 2013</td></tr>
+
<tr><td nowrap>Functional Qualification Testing </td><td nowrap>Tuesday June 18, 2013</td><td nowrap>Thursday June 20, 2013</td></tr>
 
<tr><td nowrap>Installation in Production</td><td nowrap>Friday June 28, 2013</td><td nowrap>Friday June 28, 2013</td></tr>
 
<tr><td nowrap>Installation in Production</td><td nowrap>Friday June 28, 2013</td><td nowrap>Friday June 28, 2013</td></tr>
 
</table>
 
</table>
Line 16: Line 16:
 
<tr><td nowrap>NASA Specific Data Dictionary</td><td align="center">No</td></tr>
 
<tr><td nowrap>NASA Specific Data Dictionary</td><td align="center">No</td></tr>
 
<tr><td nowrap>Use Case Summary</td><td align="center">No</td></tr>
 
<tr><td nowrap>Use Case Summary</td><td align="center">No</td></tr>
<tr><td nowrap>Validation Rules</td><td align="center">No</td></tr>
+
<tr><td nowrap>Validation Rules</td><td align="center">Yes</td></tr>
<tr><td nowrap>Reporting</td><td align="center">No</td></tr>
+
<tr><td nowrap>Reporting</td><td align="center">Yes</td></tr>
 +
<tr><td nowrap>ezSearch</td><td align="center">Yes</td></tr>
 +
<tr><td nowrap>Atom Feeds</td><td align="center">Yes</td></tr>
 
<tr><td nowrap>Online Help</td><td align="center">No</td></tr>
 
<tr><td nowrap>Online Help</td><td align="center">No</td></tr>
 
<tr><td nowrap>Computer-Based Training</td><td align="center">No</td></tr>
 
<tr><td nowrap>Computer-Based Training</td><td align="center">No</td></tr>
Line 26: Line 28:
 
<th width=18% align="center"><b>SPR #</b></th><th width=30% align="center"><b>Enhancement/Problem</b></th><th width=38% align="center"><b>Solution</b></th><th width=25% align="center"><b>Impact to Users and Integrators</b></th>
 
<th width=18% align="center"><b>SPR #</b></th><th width=30% align="center"><b>Enhancement/Problem</b></th><th width=38% align="center"><b>Solution</b></th><th width=25% align="center"><b>Impact to Users and Integrators</b></th>
 
<tr>
 
<tr>
<td style="width:95px" valign="center">FPDSHD-113057</td>
 
<td>Users cannot correct the New Base after a Transfer Action if there are existing mods after it.
 
  
<td>For the FPDS-NG action ‘correct’, FPDS-NG shall not restrict users from correcting a ‘New Base’ irrespective of the Award/IDV Status of any subsequent Modifications.
+
<td style="width:95px" valign="center">FPDSIRB-192</td>
 +
<td>FPDS-NG is incorrectly allowing selection of a 1-character or 2-character PSC Category on an Other Transaction Award or IDV and the records may be approved with such a value.
  
This requirement shall apply to all Awards/IDVs.
+
<td>FPDS-NG shall only display 4-character PSCs in the look-up screen and shall only allow 4-character PSCs to be validated and approved successfully on an Other Transaction Award or IDV.
  
 
</td>
 
</td>
Line 37: Line 38:
  
 
<tr>
 
<tr>
<td style="width:95px" valign="center">FPDSHD-113670</td>
 
<td>When correcting base contracts, the “Contracting Officer’s Determination of Business Size” value on any Rerepresentation mods is getting overridden with that from the base.
 
  
<td>When the base contract is corrected, FPDS-NG shall not propagate “Contracting Officer's Business Size Selection” from the base to the ‘Rerepresentation’ or ‘Rerepresentation of non-Novated Merger/Acquisition’ modification.
+
<td style="width:95px" valign="center">FPDSHD-116158</td>
 +
<td>It is reported that records are missing from FPDS-NG Standard Reports, but the data exists in the Award database.  The records missing from reports are found to not have data in two of the tables containing vendor information about each record.  The missing data in these tables has caused the records to not be included in the nightly refresh that would include them in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. This does not impact the Data Archives as they are generated from the transactional tables.
 +
 
 +
Vendor information is saved to 4 different tables when an Award or IDV is saved in FPDS-NG: Vendor, Vendor Location, Socio-Economic Indicators, and Business Types.  The issue has occurred because a server has thrown an exception that was not handled and data was not stored to all 4 tables for a given transaction.
 +
 
 +
<td>1. FPDS-NG shall not store partial information of the vendor while finalizing a contract. FPDS-NG shall store complete Vendor information in all four tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types) on all final records. This will ensure that records appear in Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds.
 +
 
 +
2. The exception that has occurred to cause the issue shall be handled so that if the transaction cannot be completed with data in all 4 Vendor tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types), then the transaction shall be rolled back and no partial entry shall be permitted.CWS will get the system error when the transaction rolls back.  System shall throw an exception so that production operations team can perform the maintenance on the server.
 +
 
 +
3. FPDS-NG shall add a verification process to catch discrepancies in counts between the Award/IDV transaction tables and the Reports Repository from which Standard and Ad Hoc Reports are generated. (A verification check between the Reports Repository and the ezSearch index already exists).
 +
 
 +
4. FPDS-NG shall perform a Data Management fix to populate the Vendor tables that are missing data so that the records shall become available in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds.
  
 
</td>
 
</td>
Line 47: Line 57:
 
<tr>
 
<tr>
  
<td style="width:95px" valign="center">FPDSIRB-173</td>
+
<td style="width:95px" valign="center">FPDSHD-115807</td>
<td>The values for the "National Interest Action" (NIA) and "Local Area Set Aside" (LASA) are defaulted as "Select One" on error records.
+
<td>FPDS-NG is incorrectly propagating the value for TOSA on an ‘update’ XML request when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’.
  
<td>1. FPDS-NG shall retain the user provided values for NIA and LASA on the base errored out documents.
+
<td>FPDS-NG shall not propagate the value for TOSA from the IDV when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’.
 
 
2. FPDS-NG shall retain the user provided values for NIA and the propagated value of LASA on the modification errored out documents.
 
 
 
3. The following documents shall be addressed:
 
    Purchase Order
 
    Delivery/Task Order
 
    Definitive Contract
 
    BPA Call
 
    FSS
 
    GWAC
 
    BOA
 
    BPA Call
 
    IDC
 
 
 
4. The resolution applies the FPDS-NG actions - Create and Update.
 
 
</td>
 
</td>
 
<td align="center">No</td>
 
<td align="center">No</td>
Line 71: Line 66:
 
<tr>
 
<tr>
  
<td style="width:95px" valign="center">FPDSHD-84802</td>
+
<td style="width:95px" valign="center">FPDSHD-115803</td>
<td>The user reported a conflict between the posted requirement state and the behavior of the Referenced IDV Modification Number on the Other Transaction documents.
+
<td>When the length of the “Maximum Order Limit” value is greater than ‘15’, the Atom Feeds are not displaying the value as expected.
  
 
<td>
 
<td>
 +
1. FPDS-NG shall display a validation rule on the IDVs indicating that the length of the “Maximum Order Limit” shall not exceed 20. The length includes the two decimal places.
  
<b>Web Portal</b>:
+
Sample edit: <b>Length of the “Maximum Order Limit” shall not exceed 20. The maximum value allowable value is ‘999,999,999,999,999,999.99’.</b>
  
1. FPDS-NG shall auto-populate the Referenced IDV Modification Number as per the Date Signed on the Order.
+
2. Atom Feed requests (DoD and Public) shall display the “Maximum Order Limit” value as provided on the IDVs. The value shall be retrieved with two decimal places. E.g.: 99999999999999.00.
 +
 
 +
3. The Data Validation Rules document for V 1.3 and V 1.4 shall be updated with the new validation rule.
 +
 
 +
</td>
 +
<td align="center">No</td>
  
2. If the Date Signed is not provided on the Order, but an attempt is made to select the Referenced IDV, then FPDS-NG shall consider the System Date and auto-populate the respective Referenced IDV Modification Number.
+
<tr>
  
<b>Business Services</b>:
+
<td style="width:95px" valign="center">FPDSHD-114881</td>
 +
<td>The validation rules for "Inherently Governmental Function" are firing when the "Product or Service Code" is corrected from a 'Service' to a 'Product'.
  
1. FPDS-NG shall auto-populate the Referenced IDV Modification Number as per the Date Signed on the Order in the following cases:
+
<td>On the base document:
  
a. The Referenced IDV Modification Number is provided as ‘0’.
+
1. FPDS-NG shall not fire 6M12, 6M13, 6M14 when the PSC is corrected from a Service to a Product. This applies to ‘Correct’ of the documents.
b.  The Referenced IDV Modification Number is provided as not ‘0’.
 
c.  The Referenced IDV Modification Number tag is not sent.
 
d.  The Referenced IDV Modification Number tag is sent, but the value is not provided.
 
  
2. If the Date Signed is not provided on the Order, but an attempt is made to select the Referenced IDV, then FPDS-NG shall consider the System Date and auto-populate the respective Referenced IDV Modification Number in the following cases:
+
2. FPDS-NG shall not fire 6M16 when the Date Signed is prior to 03/01/2012 and when the PSC is a Product. This applies to ‘Create-Update-Validate-Approve’ of the documents.
  
a.  The Referenced IDV Modification Number is provided as ‘0’.
+
On the non-Change PIID modification done against a base (mod 0) document:
b.  The Referenced IDV Modification Number is provided as not ‘0’.
 
c.  The Referenced IDV Modification Number tag is not sent.
 
d.  The Referenced IDV Modification Number tag is sent, but the value is not provided.
 
  
All the above requirements shall apply to the ‘Create’ operation. They also apply to the ‘Update’ and ‘Correct’ operations when the “Date Signed’ is changed on the Order.
+
1. FPDS-NG shall not fire 6M14 (6M15 shall continue to display) when the PSC is corrected from a Product to a Service, and when the Date Signed on the base document is earlier than 03/01/2012. This applies to ‘Correct’ of the documents.
  
 
</td>
 
</td>
Line 105: Line 101:
 
<tr>
 
<tr>
  
<td style="width:95px" valign="center">FPDSHD-108437</td>
+
<tr>
<td>Modifications to the Other Transaction Order, Agreement and IDV are validating the PSC code although it propagates from the base.
 
  
<td>1. FPDS-NG shall not validate the PSC code on the modifications for the following documents:
+
<td style="width:95px" valign="center">FPDSHD-116863-114046</td>
 +
<td>FPDSHD-116863: The correction of “Contracting Officer’s Determination of Business Size” on the base documents is not being propagated to the modifications, as expected.
  
    Other Transaction IDV
+
FPDSHD-114046: Novation modifications that were signed prior to 06/30/2007 are not retaining the user provided value for “Contracting Officer’s Determination of Business Size”.
    Other Transaction Order
 
    Other Transaction Agreement
 
  
2. The resolution applies to the FPDS-NG actions - Create, Update and Correct.
 
</td>
 
<td align="center">No</td>
 
  
<tr>
+
<td>1. Correction of the value for “Contracting Officer’s Determination of Business Size” on the base (modification number = 0) documents shall propagate the value for all types of modifications, except:
  
<td style="width:95px" valign="center">FPDSHD-91657</td>
+
i. Novation Agreement
<td>The Place of Performance Zip Code is retained when the Place of Performance Country Code is corrected from USA to a foreign country.
 
  
<td>
+
ii. Rerepresentation
<b>For all agencies</b>:
 
  
If the “Place of Performance Country Code” is changed from ‘USA’ to a foreign country, then the values for “Place of Performance Zip Code” and “Place of Performance Zip +4 Code” shall be cleared out for the following documents:
+
iii. Rerepresentation of non-Novated Merger/Acquisition
  
    Purchase Order
+
iv. Any modifications that are signed on or later than the above three modifications
    Delivery/Task Order
 
    Definitive Contract
 
    BPA Call
 
  
Note: US Territories are not foreign.
+
2. Correction of  the value for “DUNS Number” on the base (modification number = 0) documents shall propagate the Vendor data (Vendor DUNS, name, address and socio-economic data) for all types of modifications, except:
  
<b>For DHS and DoD</b>:
+
i. Novation Agreement
  
If the “Place of Performance Country Code” is changed from ‘USA’ to a foreign country, then the values for “Place of Performance Zip Code” and “Place of Performance Zip +4 Code” shall be cleared out for the following documents:
+
ii. Vendor DUNS Change (Vendor socio-economic data and Contracting Officer’s Determination of Business Size shall propagate from the base)
 
    Other Transaction IDV
 
    Other Transaction Order
 
    Other Transaction Agreement
 
  
Note: US Territories are not foreign.
+
iii. Any modifications that are signed on or later than the above two modifications
  
<b>For NASA</b>:
+
3. When a Novation is submitted without changing the DUNS Number, a validation rule shall be displayed indicating that the DUNS Number should be changed. The sample validation rule is indicated here:
  
If the “Place of Performance Country Code” is changed from ‘USA’ to a foreign country, then the values for “Place of Performance Zip Code” and “Place of Performance Zip +4 Code” shall be cleared out for the following documents:
+
<b>The DUNS Number on the Novation modification must be different from that on the previous modification.</b>
  
    Intragovernmental
+
</td>
    Cooperative Agreement
+
<td align="center">No</td>
    Training Grant
 
    Funded Space Act Agreement
 
    Grant for Research
 
  
Note: US Territories are not foreign.
+
<tr>
 
 
<b>For all agencies</b>:
 
  
The above requirements shall apply to the 'Update' and 'Correct' FPDS-NG actions, and through Web Portal and Business Services. For Business Services, the Zip Code value must be cleared out for the following scenarios:
+
<td style="width:95px" valign="center">FPDSHD-116533</td>
 +
<td>FPDS-NG is incorrectly displaying an error when attempting to approve a ‘Change PIID’ Modification when it is the first Modification (New Base) after a Transfer Action.
  
    When the tag is not sent
+
<td>FPDS-NG shall allow a ‘Change PIID’ Modification to be successfully approved when it is the first Modification (New Base) after a Transfer Action and it has been validated successfully.
    When the tag is sent without the value
 
    When the tag is sent with a value
 
  
 
</td>
 
</td>

Latest revision as of 16:47, 14 June 2013

Schedule

DescriptionStart Date End Date
BETA Installation Thursday June 13, 2013Friday June 14, 2013
Functional Qualification Testing Tuesday June 18, 2013Thursday June 20, 2013
Installation in ProductionFriday June 28, 2013Friday June 28, 2013

Document Changes

DocumentationChanges Required
XML SpecificationsNo
Web ServicesNo
Data Dictionary No
NASA Specific Data DictionaryNo
Use Case SummaryNo
Validation RulesYes
ReportingYes
ezSearchYes
Atom FeedsYes
Online HelpNo
Computer-Based TrainingNo
User ManualNo

SPR Listing

SPR #Enhancement/ProblemSolutionImpact to Users and Integrators
FPDSIRB-192 FPDS-NG is incorrectly allowing selection of a 1-character or 2-character PSC Category on an Other Transaction Award or IDV and the records may be approved with such a value. FPDS-NG shall only display 4-character PSCs in the look-up screen and shall only allow 4-character PSCs to be validated and approved successfully on an Other Transaction Award or IDV. No
FPDSHD-116158 It is reported that records are missing from FPDS-NG Standard Reports, but the data exists in the Award database. The records missing from reports are found to not have data in two of the tables containing vendor information about each record. The missing data in these tables has caused the records to not be included in the nightly refresh that would include them in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. This does not impact the Data Archives as they are generated from the transactional tables.

Vendor information is saved to 4 different tables when an Award or IDV is saved in FPDS-NG: Vendor, Vendor Location, Socio-Economic Indicators, and Business Types. The issue has occurred because a server has thrown an exception that was not handled and data was not stored to all 4 tables for a given transaction.

1. FPDS-NG shall not store partial information of the vendor while finalizing a contract. FPDS-NG shall store complete Vendor information in all four tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types) on all final records. This will ensure that records appear in Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds.

2. The exception that has occurred to cause the issue shall be handled so that if the transaction cannot be completed with data in all 4 Vendor tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types), then the transaction shall be rolled back and no partial entry shall be permitted.CWS will get the system error when the transaction rolls back. System shall throw an exception so that production operations team can perform the maintenance on the server.

3. FPDS-NG shall add a verification process to catch discrepancies in counts between the Award/IDV transaction tables and the Reports Repository from which Standard and Ad Hoc Reports are generated. (A verification check between the Reports Repository and the ezSearch index already exists).

4. FPDS-NG shall perform a Data Management fix to populate the Vendor tables that are missing data so that the records shall become available in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds.

No
FPDSHD-115807 FPDS-NG is incorrectly propagating the value for TOSA on an ‘update’ XML request when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’. FPDS-NG shall not propagate the value for TOSA from the IDV when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’. No
FPDSHD-115803 When the length of the “Maximum Order Limit” value is greater than ‘15’, the Atom Feeds are not displaying the value as expected.

1. FPDS-NG shall display a validation rule on the IDVs indicating that the length of the “Maximum Order Limit” shall not exceed 20. The length includes the two decimal places.

Sample edit: Length of the “Maximum Order Limit” shall not exceed 20. The maximum value allowable value is ‘999,999,999,999,999,999.99’.

2. Atom Feed requests (DoD and Public) shall display the “Maximum Order Limit” value as provided on the IDVs. The value shall be retrieved with two decimal places. E.g.: 99999999999999.00.

3. The Data Validation Rules document for V 1.3 and V 1.4 shall be updated with the new validation rule.

No
FPDSHD-114881 The validation rules for "Inherently Governmental Function" are firing when the "Product or Service Code" is corrected from a 'Service' to a 'Product'. On the base document:

1. FPDS-NG shall not fire 6M12, 6M13, 6M14 when the PSC is corrected from a Service to a Product. This applies to ‘Correct’ of the documents.

2. FPDS-NG shall not fire 6M16 when the Date Signed is prior to 03/01/2012 and when the PSC is a Product. This applies to ‘Create-Update-Validate-Approve’ of the documents.

On the non-Change PIID modification done against a base (mod 0) document:

1. FPDS-NG shall not fire 6M14 (6M15 shall continue to display) when the PSC is corrected from a Product to a Service, and when the Date Signed on the base document is earlier than 03/01/2012. This applies to ‘Correct’ of the documents.

No
FPDSHD-116863-114046 FPDSHD-116863: The correction of “Contracting Officer’s Determination of Business Size” on the base documents is not being propagated to the modifications, as expected.

FPDSHD-114046: Novation modifications that were signed prior to 06/30/2007 are not retaining the user provided value for “Contracting Officer’s Determination of Business Size”.


1. Correction of the value for “Contracting Officer’s Determination of Business Size” on the base (modification number = 0) documents shall propagate the value for all types of modifications, except:

i. Novation Agreement

ii. Rerepresentation

iii. Rerepresentation of non-Novated Merger/Acquisition

iv. Any modifications that are signed on or later than the above three modifications

2. Correction of the value for “DUNS Number” on the base (modification number = 0) documents shall propagate the Vendor data (Vendor DUNS, name, address and socio-economic data) for all types of modifications, except:

i. Novation Agreement

ii. Vendor DUNS Change (Vendor socio-economic data and Contracting Officer’s Determination of Business Size shall propagate from the base)

iii. Any modifications that are signed on or later than the above two modifications

3. When a Novation is submitted without changing the DUNS Number, a validation rule shall be displayed indicating that the DUNS Number should be changed. The sample validation rule is indicated here:

The DUNS Number on the Novation modification must be different from that on the previous modification.

No
FPDSHD-116533 FPDS-NG is incorrectly displaying an error when attempting to approve a ‘Change PIID’ Modification when it is the first Modification (New Base) after a Transfer Action. FPDS-NG shall allow a ‘Change PIID’ Modification to be successfully approved when it is the first Modification (New Base) after a Transfer Action and it has been validated successfully. No