RSA Town Hall Meeting - PowerPoint PPT Presentation

Loading...

PPT – RSA Town Hall Meeting PowerPoint presentation | free to view - id: 276c05-ZDc1Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

RSA Town Hall Meeting

Description:

If no one hired yet, put in 0. 3. Description of Jobs (only research working title) For example, PI, co-PI, Research Associate. No other text ... – PowerPoint PPT presentation

Number of Views:20
Avg rating:3.0/5.0
Slides: 21
Provided by: SophiaA8
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: RSA Town Hall Meeting


1
RSA Town Hall Meeting
  • Thursday, October 15, 2009
  • 130-330 pm
  • HSW-300(Parnassus) w/ live broadcast to Rock Hall
    102 (Mission Bay) and Fresno Campus

Controllers Office
2
ARRA FY10 Quarter 1 Reporting
Sneak Preview Quarter 2
Controllers Office
Lana Tomitch, Manager, ARRA, Extramural Funds
October 15, 2009
3
AWARD REPORTING STATISTICS
  • Grand total of all ARRA awards received 193
  • Total amount of awards 100 million
  • 76 million direct costs
  • 24 million FA
  • About 10 of all UCSF research funding for FY09
  • KEEP UP THE GREAT WORK!

4
AWARD REPORTING STATISTICS
Number of prime awards received 187
  • Total awards 98 million
  • 75 million direct costs
  • 23 million FA
  • Includes 2 non-research awards
  • One Federal Work Study Awards
  • One Scholarships for Disadvantaged Students Award
  • Reported on all 187 awards

4
5
AWARD REPORTING STATISTICS
  • Number of sub awards received 6
  • Total amount of awards 2 million
  • 1 million direct costs
  • 1 million FA

6
Additional Data Elements CO Report
  • UC DUNS
  • Funding and awarding agency codes
  • Program source code
  • Activity codes
  • Amount of award
  • Total number of subcontracts
  • Vendor payments total
  • Vendor payments over 25,000 to any one vendor
  • Project name
  • Funds received/invoiced
  • Expenditures

7
Submission to the government
  • October 10, 2009 had to report on all ARRA funds
    received with start date 9/30/09 or prior
  • Data elements pulled from PeopleSoft RAS, GL and
    AP tables
  • OMB provided template with data elements to
    populate
  • OMB gave 2 options Excel spreadsheet or XML
    schema

8
Submission to the government
  • UCSF selected XML schema
  • Team of OAAIS, PMO, OSR, and EMF worked on
    process
  • OAAIS developed technical aspects of downloading
    data from three systems
  • EMF generated a pre-populated XML template for
    each award
  • EMF manually uploaded each XML template
  • OMB sent back confirmation of receipt of XML
    template error free

9
XML Data Page
10
Success!
11
Quarter 2 Reporting
  • New deadline to facilitate furloughs and holiday
    office closures
  • Department data collection close date
    WEDNESDAY, DECEMBER 16, 2009
  • Department data elements to input
  • 1. Project activity description (like a proposal
    abstract)
  • 2. of Jobs Created/Retained (only direct
    charged, not planning to hire)
  • FTE effort divided by 3 months
  • If no one hired yet, put in 0
  • 3. Description of Jobs (only research working
    title)
  • For example, PI, co-PI, Research Associate
  • No other text
  • 4. Click on ARRA Job Supporting Documents
  • Copy of ARRA Jobs Created/Retained Job Aid found
    on the Controllers Office website, EMF,
    Communications
  • Attach file

12
Review of department certification
13
Upload ARRA Jobs Created/Retained Job Aid
14
Jobs Created/Retained Job Aid
15
Total FTE Must Match
16
Quarterly Average Calculation
17
Quarterly Totals Must Match
18
Helpful Q2 hint for departments
  • For new award, go to PeopleSoft, Grants, Award
    Profile
  • Click on the ARRA reporting link
  • Enter Project Activity Description
  • Like an abstract in proposal limit 254
    characters
  • Click on the save button
  • Certify closer to the deadline when you have of
    jobs created/retained and project completion
    status information
  • For continuing awards, go to PeopleSoft, Grants,
    Award Profile
  • Click on the ARRA reporting link
  • Project Activity Description no need to change
  • Add of jobs created/retained
  • Upload FTE spreadsheet, as needed
  • Enter completion status
  • Save and certify

19
Next steps
  • Working with the OMB to improve and streamline
    the subs in and subs out reporting process
  • We will develop improved more refined procedures
    for subs in and out for Quarter 2 reporting
  • Once the new procedures are in place, we will
    host an ARRA Quarter 1 Reporting Lessons
    Learned webinar, date to be determined

20
Department Feedback
  • What worked?
  • What could work better?
  • Questions.
  • Contact Lana Tomitch, ARRA Manager,
  • 476-1993 lana.tomitch_at_ucsf.edu
About PowerShow.com