Quarterly Award Information

The Quarterly Award Information table stores quarterly data for ARRA reporting. This table is accessed by selecting the Quarterly Award Information tab on the ARRA Information table. Advantage security can be set up to secure the records on each table accessible from ARRA based on the Department and/or Unit specified in the Department and Unit fields under the Advantage Security tab on the Ongoing Award Information table.

Data entry on the Quarterly Award Information table can be performed in various ways:

Records on the Quarterly Award Information table are expected to be entered each quarter. Before entry can occur on this table, the Ongoing Award Information table must be set up to include a record for the Funding Agency, Award Number, and Awarding Agency. When inserting a new record on the Quarterly Award Information table, the Funding Agency, Award Number, and Awarding Agency are automatically populated, based on the record that was selected on the Ongoing Award Information table before navigating to this table. The Reporting Calendar Year and Reporting Quarter End Date must also be populated before saving a record on this table.

Set the Final Report field to Yes to create a final report for an award. Only one record per award is supposed to be “Final”, but there are scenarios where entries could be made after the Final entry. A warning message is issued for new Quarterly Award Information table entries (from any quarter) if a final report was already sent (that is, the Final Report Submitted field on the Ongoing Award Information table is Yes).

The Days Allowed to verify quarterly reports (DAYS_TO_VERIFY_ARRA_DATA) parameter on the Application Parameters (APPCTRL) table controls the period in which quarterly ARRA reporting records may be modified. The initial value for this field as established by Federal Rules is 21. Per Federal Rules, quarterly entry may only be modified for 21 days after the end of the quarter ending date. After 21 days, no further changes to the records are allowed and updates should be made in the next quarter.

Records can be deleted at any time until the record is selected for an extract file. Once the record has been extracted (that is, the Last Reporting Extract Date is populated), it cannot be deleted.

Select the Attachment link to associate an attachment with the selected record.