View source for FAADC Version 1.2 new

From FPDS-NG

You do not have permission to edit this page, for the following reason:
The action you have requested is limited to users in the group: Users.
You can view and copy the source of this page.
__NOEDITSECTION__
==Schedule==
<TABLE  id="box-table-a" border=2>
<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>
<tr><td nowrap>Beta Deployment</td><td nowrap>July 01, 2024</td><td nowrap>July 01, 2024</td></tr>
<tr><td nowrap>Government Acceptance Testing </td><td nowrap>July 08, 2024</td><td nowrap>July 19, 2024</td></tr>
<tr><td nowrap>Production Deployment </td><td nowrap>November 16, 2024</td><td nowrap>November 16, 2024</td></tr>
</table>

==Document Changes==
<TABLE border=2 id="box-table-a">
<tr><th align="center"><b>Documentation</b></th><th align="center"><b>Changes Required</b></th></tr>
<tr><td nowrap>XML Specifications</td><td align="center">Yes</td></tr>
<tr><td nowrap>Web Services</td><td align="center">Yes</td></tr>
<tr><td nowrap>Data Dictionary</td><td align="center">Yes</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">Yes</td></tr>
<tr><td nowrap>Validation Rules</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">Yes</td></tr>
<tr><td nowrap>User Manual</td><td align="center">Yes</td></tr>
</table>

<b>*Note: In addition to the release notes content below, more detailed information regarding the FAADC V1.2 Version Change can  be found at the following link:</B>
<font color="blue">https://www.fpds.gov/downloads/FAADC/FAADC_XSD_Specification_Changes_for_Version_1.2.pdf</font>

This link contains:
* Version change summary
* Changes to Web Services (WSDL Changes)
* WSDL Mapping for new elements
* XML Specification Changes
* and more

==SPR Listing==
<TABLE id="box-table-a" border=2 style="width: 1080px">
<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>

<td style="width:95px" valign="top">IAEMOD-9905
</td>

<td valign="top">Version 1.1 genericTag Data Elements created with new XML tags in Version 1.2 and resetting of genericTags

<td valign="top">
The FAADC application shall be updated as part of the genericTag maintenance during a version change, data elements utilizing genericTags in Version 1.1 will be given their own XML tags for future use in Version 1.2. The genericTags will be reset to nullify existing logic so they can be used for future purposes. The following data elements utilized genericTags in Version 1.1 and will have new XML tags in Version 1.2:
<ol>
<li>Indirect Cost Federal Share Amount, which used <i>‘genericFloat01'</i>, will now have a new XML tag of <i>'indirectCostFederalShareAmount'</i>.</li>

<li>Funding Opportunity Goals Text, which used <i>‘genericString01’</i>, will now have a new XML tag of <i>'fundingOpportunityGoalsText'</i>.</li>

<li>Service-Disabled Veteran-Owned Business Joint Venture, which used <i>'genericString02’</i>, will now have a new XML tag of <i>'isServiceDisabledVetOwnedJointVenture'</i>.</li>

<li>SBA-Certified Women-Owned Small Business, which used <i>‘genericString03’</i>, will now have a new XML tag of <i>'isSBACertifiedWomenOwnedSmallBusiness'</i>.</li>

<li>SBA-Certified Economically Disadvantaged Women-Owned Small Business, which used <i>‘genericString04'</i>, will now have a new XML tag of <i>'isSBACertifiedEconDisadvWomenOwnedSmallBusiness'</i>.</li>

<li>Small Business Joint Venture, which used <i>‘genericString05’</i>, will now have a new XML tag of <i>‘isSmallBusinessJointVenture'</i>.</li>
</ol>
</td>

<td align="center">Yes</td>
<ul>
<tr>

<td style="width:95px" valign="top">IAEENH-885/IAEMOD-9907
</td>

<td valign="top">Enable FAADC to collect multiple CFDA Numbers/Descriptions

<td valign="top">The FAADC application shall be updated to permit the collection of up to 5 Assistance Listings Numbers and Descriptions on a single award. The Assistance screen will be updated to include a new ‘Assistance Listings and Amounts’ section that will include all Assistance Listing information, their dollar amounts, as well as a ‘Predominant Assistance Listing’ checkbox, a ‘Remove Assistance Listing’ button, and an ‘Add Assistance Listing’ button.

[[Image:FAADC V1.2 Assitance user screen.png|500x433px|link=]]

Please <b>[[Media:FAADC V1.2 Assitance user screen.png|click here]]</b> to see the updated V1.2 Assistance user screen

A new version of the ASSISTANCE and ASSISTANCEDELETED Atom Feeds will be created to reflect the multiple Assistance Listings. The 1.1 Atom Feeds will be decommissioned 6 months after (April 16, 2025) V1.2 Atom Feeds are implemented.

A new Version 1.2 WSDL will be deployed. WSDL Version 1.1 will be retired and will only allow ‘Correct’ and ‘Get’ actions to be performed.

Data Elements 2K: ‘Correction Delete Indicator’, 2L: 'Correction Delete Indicator Description' and 2M: ‘FABS Sent Date’ will be tracked at the Individual Assistance Level instead of at the previous record level.

Data Element 7A will change XML tag name from <i>‘CFDANumber’</i> to <i>‘ALNumber’</i>.

Data Element 7B will change XML tag name from <i>‘CFDAProgramTitle’</i> to <i>‘ALProgramTitle’</i>.

The following data elements will now be auto calculated and will no longer allow input from the user:

*4A - Federal Action Obligation
*4C - Non-Federal Funding Amount
*4D - Face Value of Direct Loan or Loan Guarantee
*4E - Original Loan Subsidy Cost

The FAADC application shall be updated with these new data elements:

*7C - Predominant Assistance Listing
*4H - Assistance Listing’s Federal Action Obligation Amount
*4I - Assistance Listing’s Non-Federal Funding Amount
*4J - Assistance Listing's Face Value of Direct Loan or Loan Guarantee
*4K - Assistance Listing’s Original Loan Subsidy Cost

The FAADC application shall be updated with the following validation rules:

*FAADC:7A3 - <i>“An Assistance Listing number cannot be used more than once on a record.”</i>
*FAADC:7A4 - <i>“Only a maximum number of 5 Assistance Listings can be added to a record. Please limit the Assistance Listings to 5.”</i>
*FAADC:7A5 - <i>“Deleting this Assistance Listing will cause the R&D dollar values to not equal the Federal Action Obligation on an Amendment(s). Please change the dollar values on the Amendment(s) first, then you can delete this Assistance Listing."</i>
*FAADC:7C1 - <i>“The Predominant Assistance Listing cannot be deleted from an award that has been sent to USASpending.gov. In order to remove this Assistance Listing from the award, the record will have to be deleted and recreated."</i>
*FAADC:7C2 - <i>“One Assistance Listing must be marked as the ‘Predominant Assistance Listing’."</i>
*FAADC:7C3 - <i>“Only one Assistance Listing can be the ‘Predominant Assistance Listing’."</i>

The FAADC application shall be updated with the following validation rules which are now based on the auto calculated dollar amounts. The rule verbiage shall also be updated as follows:

*FAADC:4A2 - <i>“When "Action Type" is "NEW" or "CONTINUATION" on a Base award, the sum of all Assistance Listing "Federal Action Obligation" values must be greater than or equal to $0.00."</i>
*FAADC:4A5 - <i>“The sum of all the Research and Development dollar fields must equal the sum of all Assistance Listing "Federal Action Obligation" values on the record."</i>
*FAADC:4B2 - <i>“When "Action Type" is "NEW" or "CONTINUATION" on a Base award, the sum of all Assistance Listing "Non-Federal Funding Amount" values must be greater than or equal to $0.00."</i>
*FAADC:4D1 - <i>“When "Action Type" = "NEW" or 'CONTINUATION" on a Base Award, the sum of all Assistance Listing “Face Value of Direct Loan or Loan Guarantee” values must be greater than or equal to $0.00."</i>
*FAADC:4E1 - <i>“When "Action Type" = "NEW" or 'CONTINUATION" on a Base Award, the sum of all Assistance Listing "Original Loan Subsidy Cost" values must be greater than or equal to $0.00."</i>

<td align="center">Yes</td>
<ul>
<tr>

<td style="width:95px" valign="top">IAEENH-1228/IAEMOD-27666</td>

<td valign="top">New "Discretionary" data element in FAADC required due to DATA Act requirements related to funding opportunity numbers

<td valign="top">The FAADC application shall be updated to add a new data element named “Discretionary” which will have values “Yes” and “No” only.

The FAADC application shall be updated with the following validation rules to require a selection be made for this data element on all Grants and Cooperative Agreements, and to ensure that when values are provided for “Funding Opportunity Number” and “Funding Opportunity Goals Text," the Grant or Cooperative Agreement is discretionary, competitive, or both:

*FAADC:1K1 - <i>"If "Assistance Type" is Grant or Cooperative Agreement, the "Discretionary" data element is required."</i>
*FAADC:1K2 - <i>"If a value is provided for "Funding Opportunity Number," then either "Competed Opportunity" must be 'Competitive Procedures were used' or "Discretionary" must be 'Yes'."</i>
*FAADC:1K3 - <i>"If a value is provided for "Funding Opportunity Goals Text," then either "Competed Opportunity" must be 'Competitive Procedures were used' or "Discretionary" must be 'Yes'."</i>
</td>

<td align="center">Yes</td>
<ul>
<tr>

<td style="width:95px" valign="top">IAEENH-1229/IAEMOD-27667</td>

<td valign="top">FON Format new mandatory requirements for October 1st, 2023 per OMB memo M22-02

<td valign="top">The FAADC application shall be updated to require acceptable values be provided for both “Funding Opportunity Number” and “Funding Opportunity Goals Text” on all discretionary, competitive Grants and Cooperative Agreements. Additionally, the “Funding Opportunity Number” data element shall be disabled on non-Grants and non-Cooperative Agreements (AssistanceType = 06, 07, 08, 09, 10, or 11).

The FAADC application shall be updated with the following validation rules to ensure values are provided for both “Funding Opportunity Number” and “Funding Opportunity Goals Text” or for neither data element, and to require acceptable values for both data elements on discretionary, competitive Grants and Cooperative Agreements:

*FAADC:1E3 - <i>"If a value is provided for “Funding Opportunity Number”, then “Funding Opportunity Goals Text” must also have a value."</i>
*FAADC:1E4 - <i>"If a value is provided for “Funding Opportunity Goals Text”, then “Funding Opportunity Number” must also have a value."</i>
*FAADC:1E5 - <i>"If "Competed Opportunity" is 'Competitive Procedures were used' and "Discretionary" is 'Yes,' then both “Funding Opportunity Number” and “Funding Opportunity Goals Text” are required."</i>
*FAADC:1E6 - <i>"If "Competed Opportunity" is 'Competitive Procedures were used' and "Discretionary" is 'Yes,' then “Funding Opportunity Number” cannot be 'NOTAPPLICABLE' or 'NA' or 'NONE' or 'BLANK' or '0'."</i>
*FAADC:1J5 - <i>"If "Competed Opportunity" is 'Competitive Procedures were used' and "Discretionary" is 'Yes,' then “Funding Opportunity Goals Text” cannot be 'NOTAPPLICABLE' or 'NOT APPLICABLE' or 'NA' or 'N/A' or 'NONE' or 'BLANK' or '0'."</i>
</td>

<td align="center">Yes</td>
<ul>
<tr>

<td style="width:95px" valign="top">IAEMOD-25630</td>

<td valign="top">Validation rule for FICE incorrectly fires on Amendment

<td valign="top">The FAADC application shall be updated to prevent this validation rule from firing incorrectly on Amendments:

*<i>"Federal Interagency Committee on Education (FICE) Code" must be valid value.”</i>

This affects Assistance Amendment record requests including Validate(isComplete)/Correct/Approve.

</td>

<td align="center">Yes</td>

<tr>

<td style="width:95px" valign="top">IAEMOD-30131

<td valign="top">FAADC Issue with Action Type for Version 1.2

<td valign="top">The FAADC application shall be updated to prevent validation rule FAADC:2D3 from firing:

*<i>"Period of Performance End Date" cannot be earlier than the "Action Date" when users select REVISION as “ACTION TYPE”.</i>

A new validation rule shall be created:
*FAADC:2D6 - <i>When “Action Type” is “New Assistance Award”, “Continuation”, or “Entity Change”, the “Period of Performance End Date” cannot be earlier than the “Action Date”.</i>

This will permit users to report administrative changes after the Period of Performance of an agreement has ended.

</td>

<td align="center">Yes</td>
<ul>
<tr>

</table>
Return to FAADC Version 1.2 new.
Retrieved from "https://beta.fpds.gov/wiki/index.php/FAADC_Version_1.2_new"