American Recovery & Reinvestment Act (ARRA) - Stimulus Funding Reporting

 
 
 
 

Background

Requirements

Completing the Form

FAQs

 
     
 
BACKGROUND

Each ARRA award requires a separate report to the Federal sponsor.  Emory currently has over 65 awards.  Each requires up to 74 fields of information for each report; the Office of Grants and Contracts Accounting (OGCA) needs six fields or about 8% from the Principal Investigator on each ARRA award.   Below is the information required.  The first part (in italics) of each section is a simplified version of what is needed followed by a detailed explanation from the OMB guidance and sometimes NIH.

REQUIREMENTS

Project Status:  The completion status is one of four possible choices.  The government has limited us to:

  • Not started
  • Less than 50% completed
  • Completed 50% or more
  • Fully complete

“Evaluation of completion status of the project, activity, or federally awarded contract action funded by the Recovery Act.  The status of the work should be based on performance progress reports and other relevant non-financial performance information.  For awards funding multiple projects such as formula block grants, provide your best estimate of completion of all projects based on any aggregate data and information.”

Quarterly Activities/Project Description:  This is an up to 2,000 character field that describes the overall purpose and outcomes expected but with emphasis on what has occurred.  This is not meant to be a technical progress report; however, it can be in layman’s terms since the general public will be able to view it. 

“A description of the overall purpose and expected outputs and outcomes or results of the award and first-tier Subaward(s), including significant deliverables and, if appropriate, units of measure.  For an award that funds multiple projects such as a formula block grant, the purpose and outcomes or results may be stated in broad terms.  For Federally Awarded Contracts: A description of all significant services performed/supplies delivered, including construction, for which the prime contractor invoiced in this calendar quarter.”

Number of Jobs Created/Retained:  This is a 10 character field where we report the total number of FTEs for jobs created and/or retained by a specific award.  Faculty with tenure cannot be in either classification unless reporting FTEs for summer salary for nine month appointments; however, anyone else on the project could be construed as a job created and/or retained.   This is a cumulative number for the project.  The percent of effort should be used to estimate the annual FTEs.

“Jobs created and retained.  An estimate of the number of jobs created and jobs retained in the United States and outlying areas.  At a minimum, this estimate shall include any new positions created and any existing filled positions that were retained to support or carry out Recovery Act projects, activities, or directly by the recipient or federal contractor.  For grants and loans, the number shall include the number of jobs created and retained by sub recipients and vendors.  The number shall be expressed as “full-time equivalent” (FTE), calculated cumulatively as all hours worked divided by the total number of hours in a

full-time schedule, as defined by the recipient or federal contractor.

For instance, two full-time employees and one part-time employee working half days would be reported as 2.5 FTE in each calendar quarter.  A job cannot be reported as both created and retained.  As used in this instruction, the United States means the 50 States and the District of Columbia, and outlying areas mean commonwealths and territories.”

NIH has added “Per OMB guidance, prime recipients should report this as a single, combined number of jobs created/retained by both the prime and sub-recipients and vendors.  Consistent with the OMB definition, data on jobs created/retained by vendors of prime and sub-recipients should be reported to the extent this data is readily available to prime and sub-recipients.  Job estimates regarding vendors of prime or sub-recipients should be limited to direct job impacts for the vendor and not include “indirect” or “induced” jobs.

While NRSA fellows/trainees are not considered employees, for purposes of ARRA reporting these individuals should be reported as jobs created/retained when ARRA funds have been awarded to a training grant or individual fellowship.  One full-time appointment for 12 months would equal 1.0 FTE for the number of jobs; a full-time appointment for only 6 months would equal 0.5 FTE.”

Description of Jobs Created/Retained:  This is a 4,000 character field to describe the jobs created and/or retained.  Here you would describe the employment impact of the funded work including the types of jobs created and retained at Emory AND any Emory subcontractor.  This is a report on the whole award to Emory, not just the portion Emory retains.

 "A narrative description of the employment impact on the Recovery Act funded work.  This narrative is cumulative for each calendar quarter and, at a minimum, will address the impact on the recipient's or federal contractor's workforce (for grants and loans, recipients shall also include the impact on the workforce of sub- recipients and vendors).  At a minimum, provide a brief description of the types of jobs created and jobs retained in the United States and outlying areas. "Jobs or positions created" means those new positions created and filled, or previously existing unfilled positions that are filled, as a result of Recovery Act funding.  "Jobs or positions retained" means those previously existing positions that are retained as a result of Recovery Act funding.  This description may rely on job titles, broader labor categories, or the recipient's existing practice for describing jobs as long as the terms are widely understood and described the general nature of the work."

Activity Code:  This is a 20 character field.  Here we are asked to provide the National Center for Charitable Statistics “NTEE_NPC” code(s) that describe the Recovery Act projects or activities under the award.  We are provided a link of the searchable codes.  While this is an onerous task to determine, it is a one-time requirement unless the project scope changes substantially during the award. 

The link is: http://nccsdataweb.urban.org/PubApps/nteeSearch.php?gQry=all-core&codeType=NPC

The code is alphanumeric with a description.  Most Emory awards will fall in the following categories:

E.  Health Care; F. Mental Health, Substance Abuse; G. Diseases, Disorders & Medical Disciplines; H. Medical Research; U. Science & Technology; V. Social Science; and W. Public, Society Benefit. 

A summary of these codes can be found at: http://nccsdataweb.urban.org/PubApps/nteeSearch.php?gQry=allMajor&codeType=NTEE

“For Grants and Loans:

For awards primarily funding infrastructure projects, enter the North American Industry Classification System (NAICS) code(s) that describe the Recovery Act projects or activities under this award.  A searchable code list is at http://www.census.gov/naics/

For all other awards, provide the National Center for Charitable Statistics “NTEE-NPC” code(s) that describe the Recovery Act projects or activities under this award.  A search code list is at http://nccsdataweb.urban.org/PubApps/nteeSearch.php?gQry=all-core&codeType=NPC.”

 

Award Description: This is another 4,000 character field.  We are expected to provide the award title and description for the overall purpose of the funding action.  This information may be copied and pasted from your award abstract.  This probably is a one-time requirement unless the scope changes during the award.

“For Grants and Loans:

Award title and description with purpose of each funding action, if any.  The description should capture the overall purpose of the award.  For example, “community development,” “comprehensive community mental health services to adults with a serious mental illness,” etc.

For Federally Awarded Contracts:

Provide a description of the overall purpose and expected outcomes, or results of the contract or action under the contract funded by the Recovery Act, including significant deliverables and, if appropriate, associated units of measure.”

NIH added, “Enter project abstract as provided by the HHS Readiness Tool/NIH RePORTER tool, public health relevance statement, or other text that may be more informative to the public.

For summer research experience supplements, provide a sentence such as, “This grant provided a summer research experience for ________ (insert “X” number of high school students(s), college student(s), science educator(s), etc.) in health-related scientific research.” 

For administrative supplements, do not use the abstract from the parent grant, rather create a description of the purpose of the supplement.”
COMPLETING THE FORM

STEP 1 – Access Form at: http://www.ogca.emory.edu/arra

STEP 2 – Enter information about award from e-mail notice.  (You can cut & paste.)

STEP 3 – Click “CREATE NEW REPORT FORM” button

STEP 4 – Enter the six required fields of information (See explanations on page 2 below.)

STEP 5 – Click the “SUBMIT REPORT” button

APPOINTING A PROXY (You can only have one proxy per award.  You can have different proxies on different awards.   You can change proxies at any time by appointing a new proxy.)

STEP 1 – 4 above

STEP 5 – Click “Assign Proxy” box and complete three field of information on proxy

STEP 6 –Click the “SUBMIT REPORT” button

CHANGING/EDITING A PENDING REPORT

STEP 1 – Access Form at: http://www.ogca.emory.edu/arra

STEP 2 – Click on pending report you want to change

STEP 3 – Change/edit any one or all six fields as desired

STEP 4 – Click “UPDATE REPORT”

FREQUENTLY ASKED QUESTIONS

1.  I don’t recognize the Emory award number, where is the 5-2XXXX account number? 

All the old FAS (Financial Accounting System) data has been converted to PeopleSoft.  The number is the Award number in PeopleSoft.  Since all of our reporting periods fall within the PeopleSoft implementation dates, we must use that number.

2.  Do I have to enter all the data from the email to access the form? 

Yes, the OGCA uses it to ensure we are reporting on the correct award, however, you can cut and paste to avoid typos.

3.  Can I have an administrative person complete the form? 

Yes, however, you are responsible for the accuracy of the information and some of the information requires your input and judgment such as the Quarterly Activities/Project Description and the Activity Code.

4.  Who has access to the form? 

The email is being copied to your school administrators.  They will have access to your form and will know if the form has been submitted.  They cannot update the report. In addition, you can appoint a proxy that could access the system and complete/update your reports.    

5. How do I appoint a proxy? 

First, log into the system.  Then enter the three pieces of information required from your email and then click the Create Report button.  Next, enter the proxy information in the upper right.  You can appoint different proxies for different awards and change them, if desired.

6. Why can't I assign a proxy?

Unfortunately the system was laid out requiring that something is entered in each of the fields prior to assigning a proxy.  We realize that this is causing frustration and expect it to be corrected for the next reporting cycle. So, for this reporting cycle, if you don't put something in each of the six required fields when you hit "Submit Report" button you are told to go back and fill in the required fields.  The quickest way around that is to put something in each field.  For the first and fifth field just to select the first choice.  For the third field enter in 0.  For the rest you can enter TBD.  At that point you can submit and the proxy will be accepted.  As noted, by the next quarter we expect that this will be corrected so a proxy can be assigned immediately and independently from the six required information fields on the form.

7. How much of this information will be made available to the public? 

All of your information and the rest of the information that the OGCA is gathering separately for the individual reports will be publically available in some form on Recovery.gov in the month following the report deadline.  As a result, don’t report confidential information particularly information that might be trademarked or patentable before consulting the Office of Technology Transfer.  Most of this information is meant as general information for the public. 

8. What will happen in the second and subsequent quarterly reporting periods? 

For every award reported in the prior period, the prior period report will be provided online for updating.  If you received one or more new awards during the next reporting period, those would be treated as first-time awards – you or your proxy would have to create a new report form for each.

9.  I noticed that when I cut and pasted my abstract for the award description that the character count did not increase, how are we to know the number of characters? 

Sometimes you have to hit the space bar at the start of the input to get the character field to activate. 

10. What if I have more characters than the field allows? 

When we upload the information to the Federal reporting site any information in excess of a field size will truncate automatically.

11. Do I have to use all of the characters available in the field? 

No, brevity and clear communication are the goals.  Keep in mind the general audience expected to see this.  This is not for peer review.

12. What do we do if we have Arra funded awards not included in emails sent to faculty on Monday, Sept 21st?

Please keep in mind that Quarterly ARRA reporting is CUMULATIVE.  What isn't reported this quarter will be reported the next quarter.  Additional e-mails will be sent as awards are processed through PeopleSoft.  Every attempt will be made to report on all awards received prior to September 30, 2009.  If you feel you award has been officially accepted by Emory and you want to complete your information before your get an e-mail notice you may proceed to the ARRA information web site at: http://www.osp.emory.edu/OSP_other/ARRAReporting.cfm and following the instructions for logging on and completing the online form.  In the Emory Award Number field please enter all nines (9999999999). 

13. Do I have to report if my award hasn't started, just started or has minimal activity?

Yes, but the reporting should be very easy.  Field one is Project Status, just click on the drop down box and select "Not Started" or "Less than 50% completed," as appropriate.  Field two is Quarterly Activities/Project Description, just describe the project and its purpose.  Field three is Number of Jobs Created/Retained, indicate zero (0).  Field four is Description of Jobs Created/Retained.  Here you can describe the jobs you expect to create or retain as the project unfolds.  Field five is for Activity Code.  This field will take a little bit of time trying to figure what is best for your project since this is a new code for the research community but you have a complete listing to select from.  Field six is probably best obtained from the project abstract as long as it isn't too technical.  The general public will probably view this field once the report is submitted.

14. What happens after I click the "Submit Report" button?

The report immediately goes into pending status and sends an e-mail to the OGCA.  If you return to the main page it will be listed as pending.  You can click on it immediately and access it again to change something you just remembered about the award.  Then you click "UPDATE REPORT" when you are happy with the changes.  You can also come back tomorrow or next week to change things again.  Once the OGCA accepts the report, the "Pending" will change to "Approved" and you will not be able to change the report until the next quarter.  These reports will not move to "Approved" until October 1 (at the earliest).  

15. Do I get a copy of the report?

There is nothing sent to the submitter of the report; however, you can print the report at any time for your records.

16. I have a fellowship or trainees, what do i report for the number of jobs created/retained and put in the descriptive field jobs created/retained?

NIH in its guidance for the ARRA reporting the number of jobs created/retained says as follows:“While NRSA fellows/trainees are not considered employees, for the purpose of ARRA reporting these individuals should be reported as jobs created/retained when ARRA funds have been awarded to a training grant or individual fellowship.  One full-time appointment for 12 months would equal 1.0 FTE for the number of jobs; a full-time appointment for only 6 months would equal 0.5 FTE.”

Apply this definition to all fellows/trainees and all agencies.  Keep in mind, the agency gave us ARRA money for the fellowship/trainee award.  The purpose of the ARRA money is to stimulate the economy by creating and retaining jobs.  If we don’t report jobs as a result, it defeats the whole purpose of using ARRA funding for the fellowship or training award.  Keep in mind that these fellows and trainees would probably have been unemployed without this funding.