Award List Dashboard

The Award List dashboard displays the list of open awards ordered by contract statuses. This dashboard also lists the awards funded by federal sponsors and awards enabled for cost sharing.

The dashboard uses the Projects - Grants Management - Award Funding Real Time subject area.

The dashboard consists of the Award List analysis and you can drill down to Award Project Funding Details from the Award List analysis.

Key Insights

This dashboard answers the following business questions:

• Which awards are currently active?

• Which awards are past their end dates but haven't been closed?

• What is the allocated funding amount for each project of an active award?

Frequently Asked Questions

The following table lists the frequently asked questions about this dashboard.

FAQ	Answer
How do I find this dashboard?	Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports
Who uses this dashboard?	Grants Administrator Principal Investigator
When do I use this dashboard?	When you need to review award statuses and project funding details for active awards.
What can I do with this dashboard?	You can: View awards in this analysis by: Award Status Award Organization Cost Sharing Federal Sponsor Drill down into the Award Project Funding Details analysis using the Award Number column.
What type of dashboard is this?	Oracle Transactional Business Intelligence

Details

The following table lists the prompts and filters used in the dashboard.

Column	Type	Rules
Award Status	Dashboard prompt	Choice list Select multiple values enabled Default selection specific values: Active, Under amendment, Expired
Award Organization	Dashboard prompt	Choice list Values limited by Award Status Select multiple values enabled Default selection: All values
Federal Sponsor	Dashboard prompt	Choice list Select multiple values enabled Default selection SQL: SELECT "Primary Sponsor"."Federal Sponsor" FROM "Projects - Grants Management - Award Funding Real Time" WHERE "Primary Sponsor"."Federal Sponsor"!='NULL' FETCH FIRST 65001 ROWS ONLY
Cost Sharing	Dashboard prompt	Choice list Select multiple values enabled Default selection SQL: SELECT "Award"."Cost Shared by Internal Source" FROM "Projects - Grants Management - Award Funding Real Time" WHERE "Award"."Cost Shared by Internal Source"!='NULL' FETCH FIRST 65001 ROWS ONLY

The following table lists the views for the Award List analysis.

View	Displayed Information
View Name	Award List
View Sections	None
Table Column and Measures	Award Number Sponsor Award Number Principal Investigator Award Status Award Owning Organization Sponsor Name Federal Sponsor Award Start Date Award End Date Cost Sharing Allocated Funding Amount Unallocated Funding Amount Total Funding Amount Award Ledger Currency