Today s presentation
Download
1 / 40

Today’s Presentation - PowerPoint PPT Presentation


  • 117 Views
  • Uploaded on

Today’s Presentation. Can also be found after 2:20 pm today at: http://www.med.upenn.edu/orss. Business Objects - Utilizing The Tool from a Departmental Perspective. Richard J Snyder Assoc. Director – Post Award School of Medicine Office of Research Support Services

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Today’s Presentation' - hanna-delgado


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Today s presentation
Today’s Presentation

Can also be found after 2:20 pm today at:

http://www.med.upenn.edu/orss


Business objects utilizing the tool from a departmental perspective
Business Objects - Utilizing The Tool from a Departmental Perspective

Richard J Snyder

Assoc. Director – Post Award

School of Medicine

Office of Research Support Services

Email: [email protected]

Phone: 573-1394

Brian J Squilla

Admin. & Financial Officer

Dept. of Pathology

Email: [email protected]

Phone: 898-8065


Pre award monitoring needs
Pre Award Monitoring Needs Perspective

  • Proposals submitted and awarded

  • AIS’s received and accurately reflect Award

  • Fund Set up/Budgeting/Payroll Distributions


Post award monitoring needs
Post Award Monitoring Needs Perspective

  • Monthly Monitoring/PI Review

    • Allowability (Reasonable, Allocable, Consistently treated)

  • F&A type costs directly charged to Federal Grants

  • Effort charged as proposed

  • Overdrafts/Unobligated Balances

  • Cost Transfers

  • On time FSR’s

  • Expired Funds not disabled

  • Receivables/ Checks received

  • Allocation of Expense to Clinical Trial Awards

  • Protocols Up to Date with Regulatory Affairs (IRB/IACUC)


Departmental needs
Departmental Needs Perspective

  • Keeping your Dept Chair informed about the big picture

  • Developing a FY Grant Budget

  • Effective F&A rate

  • Proposal success rates


Project management reports
Project Management - Reports Perspective

“There are so many reports I’m not sure where to look first.”

Ben Reports

BEN FINANCIALS

PennERS

Business Objects

SALMGMT

GRAMS

PennERA


Project management reports1
Project Management - Reports Perspective

  • The School of Medicine has strived to create useful grant management reports tapping all sources of data and has made them available to the university community via the Corporate Repository. It recommends utilizing Business Objects for the purposes of monthly monitoring. The Business Objects reports are the only reports available that can provide a summary overview with alerters of all the funds for which an ORG is responsible (i.e. RESP ORG).

  • Documentation for queries can be found at:

    http://www.upenn.edu/computing/da/dw/financial_queries.html

    Select “Grants Management”




Expense detail
Expense Detail Perspective




Grant reports rep
Grant Reports.rep Perspective

PI Summary Tab


Grant reports rep1
Grant Reports.rep Perspective

PI Detail Tab


Grant reports rep2
Grant Reports.rep Perspective

Payroll Encumbrances Tab


Grant reports pi rep
Grant Reports – PI.rep Perspective

Taken from the “PI Matrix –all” Tab


Grant reports pi rep1
Grant Reports – PI.rep Perspective

Taken from the “Personnel Matrix” Tab. Note: this covers one period only.

Fund Detail –PI.rep could do this for a range of dates


Org summary analysis of expired funds
ORG Summary - Analysis of Expired Funds Perspective

Why isn’t my fund disabled?



Fundsummary snap ncc estimated unobligated balance
Fundsummary - SNAP/NCC Estimated Unobligated Balance Perspective

Make sure the formula toolbar is checked under View Toolbar.



Fund detail rep
Fund Detail.rep Perspective

This is the “Acct Per. Summary Tab”. There is also a Pay Summary Tab as well as numerous tabs to sort payroll information and expense detail information. Variations of this include: Fund Detail-PI.rep and Fund Detail - cref detail.rep


Grantmonitor rep
GrantMonitor.rep Perspective

This tab of the GrantMonitor can help identify NIH noncompeting Progress Reports that

Might be due. There are also separate tabs which can identify when Subcontracts Progress Reports are due and also T32’s based on which Institute the award is with.


JE Inquiry (by batch between dates).rep Perspective

Note the 3 tabs which are specifically designed for grant entries done by Res Svcs (8760) or the Comptroller’s Office (8720)


Ais full search rep
AIS (full search).rep Perspective

Ability to search on multiple criteria


Ais full search rep1
AIS (full search).rep Perspective

The “New AIS Summary” Tab can give a summary of AIS’s issued in the last 35 days





How can i change the nih cap in the effort report queries
How can I change the NIH Cap in the Effort Report Queries? Perspective

Select:

Data

Variables

Select NIH Cap

Edit

Formula

After editing/ changing the <NIH Cap> variable, the query needs to be rerun. Column Headings will also update on all tabs.


Protocols org rep
Protocols – Org.rep Perspective

This tab gives a summary of protocols by fund #. There are also separate tabs for Human

Protocols by PI, Animal Protocols by PI, Protocols by #, and Expired Protocols.


Success rates rep
Success Rates.rep Perspective


Delegating responsibilities within a dept
Delegating Responsibilities within a Dept Perspective

  • Can you delegate by Org or PI Name?

  • Can I modify queries on the repository to reflect responsibility?


Examples of creating data where data doesn t exist
Examples of creating data where data doesn’t exist Perspective

There is no data available for who the responsible BA is on a fund or who the ORSS Manager is.


Utilizing the created variable in other queries
Utilizing the created variable in other queries Perspective

Mgmt Perspectives:

Monitor changing workloads

Monitor productivity


Creating variables and utilizing filters
Creating Variables and Utilizing Filters Perspective

  • Create Variables utilizing “If Then Else” Logic

    • Ex (If <PI Name> In List Then “Brian Squilla” Else….Else “Undefined”

  • You can than filter on the newly created Variable Object

  • Once you’ve created the variable you can create the same variable in other queries with a “Cut and Paste” of the formula




Filtering the new variable
Filtering the new variable Perspective

1. Click on any Cell in the query.

2. Select “Format” “Filters”

3. Click “Global” and “Add”

4. Select the new variable to filter

5. Select the Value

As you are filtering on individuals, you may want to apply the same filter on all tabs and rename the query, or perhaps you can duplicate a tab by via “Edit” “Duplicate Report”


Pathology Breakdown Perspective


ad