Vision Statement:

1. Operational Excellence in Effort ReportingEffort Certification and Reporting Technology (ecrt) Sessions Audience: Campuses not on the Project TeamJune 18 - 20, 2012 Vision Statement: Implement a compliant, streamlined, electronic effort reporting process that reduces administrative burden.

2. Agenda 2 • Purpose of this session: • To keep you informed and aware of the progress of the effort reporting project • Provide you with the opportunity to become familiar with ecrt in a “sandbox” environment – this is not testing or training • Topics: • Impacts on principal investigators and research administrators • Source data that is displayed in ecrt • Information about your access to ecrt • Next steps

3. About the Project • CNSE • University at Albany • Binghamton University • University at Buffalo • Stony Brook University • Upstate Medical University • SUNY Downstate Medical Center • SUNY ESF • SUNY New Paltz • Buffalo State College 3 • Campus and central office research administrators are collaborating to develop an electronic effort reporting process that: • Reduces administrative burden to principal investigators (PIs) and the research support function • Improves compliance through accuracy and education • Campuses represented on the project team:

4. Impact on Principal Investigators 4 • Electronic tool to certify effort on federal and federal flow-through sponsored programs • E-mail workflow notification • Available anywhere PI has Internet access • Access to more information to better understand what they are certifying • PIs will be able to drill into detailed payroll data • Assigned role of self-certifier in ecrt • Responsible for certifying their effort • May be responsible for certifying effort for their research staff • Campus has flexibility to assign a proxy certifier with firsthand knowledge if needed

5. Impact on Research Administrators 5 • An electronic tool means • No more printing, mailing and filing of hard copy effort statements • Easier to monitor effort statement certifications • New effort reporting roles • Opportunity for process improvements to ensure accurate data and compliance • Oracle is the source system for the data displayed in ecrt

6. Impact on Research Administrators 6 • Human resources administrators • Capturing employee information not previously entered in Oracle • PI e-mail addresses, actual department names and job titles • Communications and training • Central office will provide materials for campuses to use • Campus staff will need to update campus materials as appropriate • Campus web page • Help us announce new tool and training at your campus

7. PI E-mail Addresses 7 • Issue: • E-mail addresses needed for ecrt workflow functionality • Solution: • Update the individual’s Oracle People record with his or her e-mail address • All campuses should now have a process in place to capture this information in Oracle going forward • Rachel Shapiro sent an e-mail on December 1, 2011 • Monitoring options: • Discoverer query: “HR_Reporting Email Check for Active Employees” displays e-mail addresses • Shared under the 650_Reporting username • ecrt: List of All Users Report

8. PI Department Name and Job Title 8 • Issues: • SUNY employees have a “SUNY IFR/Cost Sharing” assignment in Oracle with a “No Job Required” job title • Above information is necessary for IFR processing • Solution: • Update the individual’s actual department name and actual job title on his or her Oracle Assignment form using the extra information option that some campuses are using to capture information used for the Coeus implementation • Actual department name and job title makes ecrt meaningful and relevant to PIs

9. PI Department Name and Job Title 9 • All campuses should now have a process in place to capture this information in Oracle going forward • Rachel Shapiro sent an e-mail on April 11, 2012 • Monitoring options: • Discoverer query: “HR_Reporting Email Check for Active Employees” also displays an individual’s actual department name and job title • Shared under the 650_Reporting username • ecrt: List of All Users Report

10. Introduction to ecrt 10 • Central office is still preparing the environments • An environment for each campus • Each campus will receive an information package when their environment is ready: • URL needed to access environment • Usernames and passwords • Campus effort reporting periods of performance • Simple instructions and scenarios to perform tasks in ecrt • Access ecrt as often as you want • Tasks should take no longer than one hour total • Anticipated timeframe: July

11. Campus Support 11 Direct all questions to: effort@rfsuny.org The staff member below will respond to your questions:

12. Introduction to ecrt 12

13. Access the Introduction Environment 13 Open an Internet browser and navigate to the URL we will send Select your campus from the Institution drop-down menu

14. Access the Introduction Environment 14 Enter the your username and password (case sensitive) Click Login

15. Access the Introduction Environment The primary method of navigating within ecrt are the navigation tabs across the top of the screen • Home – returns the user to the Work List form anywhere in the application • Certify, Manage, Reports, and Administration – Will display only when the user has the right to view the pages within that tab • Links – helpful links picked by the RF 15

16. Run the List of All Users Report 16 • This report will help you verify that e-mail addresses, actual department names and job titles are listed in ecrt for your PIs • If there is missing data: • SUNY employees have a “SUNY IFR/Cost Sharing” assignment in Oracle with a “No Job Required” job title • Update the Coeus Extra Information form in Oracle with the individual’s department name and job title • Missing e-mail addresses • Update the individual’s Oracle People record with his or her e-mail address

17. Run the List of All Users Report • Click Reports • Select the following options from the Reports page: • Category: Monitoring • Reports: List of All Users 17

18. Run the List of All Users Report • Enter the following input parameters: • School/Department: Your campus name • Click Run Report 18

19. Run the List of All Users Report

20. Access an Effort Statement • Select one of the following to view an effort statement: • Navigate to the Certify tab on the menu bar and select My Statements • Click the name on the left side of the screen • Click on an individual effort on the right side of the screen under Status a b c 20

21. Review the Effort Statement 21

22. Run the Payroll Report The Payroll Report lists all payroll transactions charged by an individual during the duration of the Period of Performance for the effort statement. Click the Run Reportsicon above the Awards column header Click Payroll Report 22

23. Run the Payroll Report 23

24. Next Steps 24 Campuses that certify three times per year will use Oracle to certify spring 2012 effort statements Campuses that certify two times per year will use Oracle to certify effort statements for the first half of 2012 Campuses should complete data clean up by July 31, 2012 Central office will send the Introduction to ecrt information to you via e-mail in July Send questions or comments to effort@rfsuny.org