1 / 71

Sponsored Effort Nuts and Bolts at UD

Sponsored Effort Nuts and Bolts at UD. How to ensure accurate data for effort certification…make your life easier!. Meeting Objectives. Introduction to the web process How do we employ the transactions to do the work for us? Proposal submission data awarded effort ProjectID Chartfield

Download Presentation

Sponsored Effort Nuts and Bolts at UD

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Sponsored Effort Nuts and Bolts at UD How to ensure accurate data for effort certification…make your life easier!

  2. Meeting Objectives • Introduction to the web process • How do we employ the transactions to do the work for us? • Proposal submission data awarded effort • ProjectID Chartfield • Journal Vouchers • LAM • The live process

  3. Assumptions • You have attended the Effort certification training session • You are knowledgeable about your faculty workload policy • You are, or you will work closely with, the effort administrator in your unit (GMQ_DEPT_EFFORT_ADMIN)

  4. Web Process • Web-enabled process effective March 1, 2005 • All certification and adjustments will be handled electronically • 2 effort periods • September – February • March – August • Summer months in same effort period

  5. Web Process • Effort administrators will receive notification of release on or about 3/15/05 and then every 6 months thereafter • Certifications should be routed promptly and must be completed in 60 days

  6. Let’s see it!

  7. Administrative Maintenance

  8. Administrator View

  9. Administrator View (dollar)

  10. Administrator View (percentage)

  11. Administrator View (dollar)

  12. Administrator View (process JV)

  13. Cost Transfers (JV’s) • Must be appropriate/allowable • Should be within 90 days • Not needed if within 5% variance • Recalculate upon ‘refresh’

  14. Effort Journals • UD WebForms FINJournal Voucher • restricts users from submitting a journal for a ‘closed’ effort period • Forces the use of the effort certification process to manage these corrections • ‘closed’ effort periods are restricted • ‘Open’ effort period cost transfers can be handled on the UD WebForms FINJournal

  15. Effort Journals • Journals processed for transactions Prior to PS data (July 1, 2002) will be handled a bit differently • Pull down menu “Prior to PS” • Routes to OVPR for approval • Requires revised paper SAR

  16. Admin View (approval)

  17. Approval • TWO (2) “review and certify” are necessary to complete the process • Effort admin reviews and certifies accuracy and forwards to employee • Employee reviews and certifies • IF employee is no longer at UD, then effort admin can select “certify for former employee”

  18. Annual YTD view (dollars)

  19. Annual AYTD view (percentage)

  20. Employee View (percent)

  21. Employee View (approval)

  22. Employee Annual YTD View

  23. Maintaining Good Data Employing the transactions to do the work for you

  24. Where does the data live? • Proposed effort is added to the proposal budget at submission stage in the Grants System by department administrators • Committed effort is added to the award budget screens in the Grants System by OVPR staff • All the data from the pay transactions and any Journal is captured in the UOD_Trans_DTL table

  25. Effort is proposed Salary is charged Proposed Effort

  26. Proposal stage • Data is added to the detail budget screens in UD Grants System for all UD employee whether PI, Co-PI or senior personnel, listed as resources on your grant proposal • Data should include effort percent and whether it is a summer month(s) • Data inputted at the proposal budget can be queried in GMQ_EFFORT_BY_PI_PROPOSED

  27. Resource page

  28. Budget Line Summary

  29. Budget Line Detail

  30. Effort is proposed Salary is charged Awarded Effort

  31. Award Stage • Once awarded, OVPR confirms the proposed effort has not changed and enters the effort percent on the appropriate Grants System panel • Data can be queried in GMQ_EFFORT_BY_PI_CURRENT

  32. Effort is proposed Salary is charged Effort is Certified Transactions

  33. Project Chart Field • Speedtypes include inherited chart fields • ProjectID is auto-included with grants and contracts • Include ProjectID on non C & G speedtype transactions to relate the transaction to the award (grant or contract)

  34. Labor Allocation Module (LAM) • Use the LAM to discern workload • Use the LAM to delineate the research workload portion into grant related effort and match • LAM is per pay • LAM Percentages remain in effect until changed

  35. Effort Percentages How much to commit for whom and when???

  36. Effort Percentages • Effort entries in your project budget on the personnel-salary and benefits detail page are used for faculty work loads • The minimum amount of effort allocated to a project allowed is 1% for each of the key personnel listed on the proposal (or the minimum required by the program if greater than 1%) • The vast majority of project budgets are for one (1) year. Regardless of what type of appointment (9 month, 10 month, or 11 month) held by a faculty member, the base for calculation of effort is one year (12 months).

  37. Effort Percentages • On the most basic level, efforts are calculated as follows for a typical 9 month faculty member with 3 months of summer research: • 1 month = 1/12 = 8% effort • 2 months = 2/12 = 17% effort • 3 months = 3/12 = 25% effort • For portions of a month, use the decimal equivalent of the fraction (or the percent ) of the month and divide by 12 • ½ month = 50% of month = .5, so 0.5/12 = 4% effort • ¼ month = 25 % of month = .25, so 0.25/12 = 2% effort • 1/3 month = 33% of month = .33, so 0.33/12 = 3% effort

  38. Effort Calculations Or… 50 ways to calculate one month

  39. Workload Example • Dr. Dots has a workload that combines teaching and research • Dr. Dots has a 9 month academic year faculty appointment • Dr.Dots teaches 3 courses in the first semester and 2 in the second semester • Each course is 3 credits

  40. CBA 11.9 12 credit contact hours or 18 teaching contact hours per week per semester constitutes a 100% workload for the semester for the academic year. Assignment of a workload of other credit-contact hours per week or teaching contact hours per week per semester will be prorated as a percentage of workload for the semester, e.g. 9 credit-contact hours per week per semester constitutes a 75% workload for the semester for the academic year; 6 credit-contact hours per week per semester constitutes a 50% workload for the semester for the academic year; 3 credit-contact hours per week per semester constitutes a 25% workload for the semester for the academic year.

  41. Faculty Workloadmonthly distribution

  42. How much is a month?

  43. Workload Calculation

  44. Dr. Dots Example • Dr. Dots has agreed to spend • 60% of his time (effort) performing research related activities, • 30% of his time providing instruction through teaching or advisement of students and • 10% of his time providing service to the public or the institution. • The total workload needs to total 100%.

  45. Dr. Dots Example • So this is good news. We only have 14% committed for Dr. Dots. We still have 46% left to commit or leave uncommitted.

  46. Dr. Dots LAM Example

  47. LAM example (left)

  48. LAM example (right)

  49. LAM (left-more typical)

More Related