University of North Carolina
American Recovery and Reinvestment Act
Weekly Updates: Director of Sponsored Programs distributes weekly updates to the designated ARRA point of contact for each campus, the UNC Post-Award Workgroup (comprised of campus-based contract and grant directors) and the SPARC group (comprised of campus-based sponsored programs directors [pre- and post-award] and other staff involved in research administration).
Campus Reporting: Campuses have been reporting ARRA proposals, preliminary notices of award (Just-In-Time submissions to NIH) and awards to UNC-GA. Activity is reported via an excel spreadsheet every Thursday. Award information is for awards formally received and processed by the campus. Information on ARRA proposals and awards will be extracted on demand by UNC-GA once the RAMSeS system is implemented for UNC-GA (scheduled for early June). This capability already exists for the SPARC system (see system reference below).
Post-Award Workgroup: This group is comprised of campus-based contract and grant directors. The group corresponds regularly via an established list serve and conducts televideo conferences and conference calls with ARRA reporting and compliance being a major topic of discussion.
Proposal Development and Submission Systems:
There are currently three systems used for capturing proposal and award information:
- SPARC – a system developed by UNC-GA. This system will be phased out in late fall 2009 The system has been updated to include an ARRA “flag” on the proposal and award screen, allowing campuses and UNC-GA to identify ARRA proposals and awards.
- RAMSeS – a system developed by UNC-CH and used by UNC-CH and six other campuses. The remaining campuses except NCSU will be transitioned to the RAMSeS system by late fall. The RAMSeS system has been updated to include an ARRA “flag” allowing campuses to identify ARRA proposals and awards and provides for robust reporting capabilities.
- RADAR – a system developed and used exclusively by NC State University. This system has been updated to include an ARRA “flag” allowing the campus to identify ARRA proposals and awards and provides for robust reporting capabilities.
- System-wide reporting - Data from the RADAR system is exported to the RAMSeS system
allowing UNC???GA to conduct system wide data extracts
There are currently three financial accounting systems in use:
- Financial Reporting System (FRS) – a system used by UNC-CH and UNC-GA. The system has been updated to include attribute(s) to identify ARRA contract and grant financial accounts.
- PeopleSoft – a system used by NC State University. The system has been updated to include attributes(s) to identify ARRA contract and grant financial accounts.
- Banner – a system used by the remaining fifteen campuses. Campuses are updating their
instance of Banner to include attribute(s) to identify ARRA contract and grant financial accounts (FRAGRANT and FTMFUND).
- Campuses will provide the required federal reporting for all ARRA awards in accordance with OMB requirements, to be finalized and released in June. The proposed data elements have been communicated to the campuses (ARRA Weekly Update April 8, 2009) and the Post-Award Workgroup has been discussing strategies for capturing the data for federal reporting purposes. Several campuses are considering creating a standard template for Principal Investigator driven data, such as Description of Project or Activity (ARRA-2-02), Evaluation of Completion State of Project (ARRA-2-03) and Employment Impact (ARRA-2-04). The template would be “pushed” to the PI using workflow capabilities in RAMSeS in advance of reporting deadlines.
- Campuses have been encouraged to designate an ARRA reporting coordinator.
- First tier subrecipients will be required to provide their DUNS number, congressional district and primary performance location with the executed award documents and campuses will include the appropriate ARRA-related terms and conditions in award documents.
UNC-GA provides the consolidated report of proposals, preliminary notices of award (Just-In-Time submissions to NIH) and awards to the N.C. Office of Economic Recovery and Investment.