Type |
Name |
Description |
Path(s) |
Query
|
Grants and Agreements Self Service
|
The Grants and Agreements Self Service environment contains information for creating reports regarding Awards (detail, financial accounts, allocations, or award investigators), Proposals (details, budget details, or proposal investigators), Agreements, Transaction Workflow (detail or summary), or Effort (proposed or committed).
|
Team Content > Grants and Agreements
|
Report
|
GA101 - Proposal Detail
|
This report provides a detailed list of proposals selected by user specified proposal submit date and other criteria. Continuations are not included in the report. It can be run as a standalone report and is also available as a drill-down from the Proposal Summary reports.
|
Team Content > Grants and Agreements
|
Report
|
GA102 - Proposal Summary by Department
|
This report provides a summary of proposals by financial department selected by user specified proposal submit date and other criteria. Continuations are not included in the report. It also provides a drill through to the GA101 - Proposal Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA103 - Proposal Summary by PI
|
This report provides a summary of proposals by PI, financial department and prime sponsor selected by user specified proposal submit date and other criteria. Continuations are not included in the report. It also provides a drill-through to the GA101 - Proposal Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA104 - Proposal Summary by Sponsor
|
This report provides a summary of proposals by prime sponsor selected by user specified proposal submit date and other criteria. Continuations are not included in the report. It also provides a drill-through to the GA101 - Proposal Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA201 - Award Allocation Detail
|
This report provides a detailed list of authorized, non cost-share award allocations selected by user specified allocation reporting date and other criteria. It can be run as a stand-alone report and is also available as a drill-down from the Award Summary reports.
|
Team Content > Grants and Agreements
|
Report
|
GA202 - Award Allocation by Department
|
This report provides a summary of authorized, non cost-share award allocations by financial department selected by user specified allocation reporting date and other criteria. It also provides a drill-through to the GA201 - Award Allocation Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA203 - Award Allocation by PI
|
This report provides a summary of authorized, non cost-share award allocations by PI, financial department and prime sponsor selected by user specified allocation reporting date and other criteria. It also provides a drill-through to the GA201 - Award Allocation Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA204 - Award Allocation by Sponsor
|
This report provides a summary of authorized, non cost-share award allocations by prime sponsor selected by user specified allocation reporting date and other criteria. It also provides a drill-through to the GA201 – Award Allocation Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA301 - Agreement Detail
|
This report provides a detailed list of agreements and amendments selected by user specified criteria. Report can be run by a variety of criteria including dates, states, PI, negotiator/owner, primary contact etc. It can be run as a stand-alone report and is also available as a drill-down from the Agreement Summary reports.
|
Team Content > Grants and Agreements
|
Report
|
GA302 - Agreement Summary by Department
|
This report provides a summary by financial department of agreements and amendments selected by user specified criteria. Report can be run by a variety of criteria including dates, states, PI, negotiator/owner, primary contact etc. It also provides a drill-through to the GA301 - Agreement Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA303 - Agreement Summary by PI |
This report provides a summary by PI, negotiator, primary contact and financial department of agreements and amendments selected by user specified criteria. Report can be run by a variety of criteria including dates, states, PI, negotiator/owner, primary contact etc. It also provides a drill through to the GA301 - Agreement Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA304 - Agreement Summary by Agreement Type
|
This report provides a summary by agreement type, negotiator and primary contact of agreements and amendments selected by user specified criteria. Report can be run by a variety of criteria including dates, states, PI, negotiator/owner, primary contact etc. It also provides a drill-through to the GA301 - Agreement Detail report.
|
Team Content > Grants and Agreements
|
Report
|
GA401 - Current Awards - All Roles
|
This report provides a list of all active awards (where the user selected date falls within the Award Start Date and Award End Date) for the specified investigator(s) and includes their committed effort and role data. Investigators who do not have any committed effort on an award are also included in the report (with blank effort data).
|
Team Content > Grants and Agreements
|
Report
|
GA402 - Pending Proposals - All Roles
|
This report provides a list of all pending proposals (whose Start Date is greater than or equal to the specified date) for the specified investigator(s) and includes their proposed effort and role data. Investigators who do not have any proposed effort on a proposal are also included in the report (with blank effort data). Proposals of type Letter of Intent, Preliminary and Continuations are not included in the report.
|
Team Content > Grants and Agreements
|
Report
|
GA403 - Completed Roles - All Roles
|
This report provides a list of all completed awards (whose Award End Date falls within the specified date range) for the specified investigator(s) and includes their role(s) on the awards. Report includes only awards that are in Active, Completed, Transferred Out and Terminated states.
|
Team Content > Grants and Agreements
|
Report |
GA501 - RA Workload Detail |
This report provides a list of all Research Administrator workload items across 6 different CERES Project Types by user specified criteria. Report can be run for a set of Research Administrators, Principal Investigators, and/or departments. Report can be run for current “In Process” items or for past "Completed" items based on date range options. |
Team Content > Grants and Agreements |
Report |
GA502 - RA Workload Summary |
This report provides a summary by Research Administrator and month of workload details across 6 different CERES Project Types by user specified criteria. Report can be run for a set of Research Administrators, Principal Investigators, and/or departments. Report can be run for current “In Process” items or for past "Completed" items based on date range options. |
Team Content > Grants and Agreements |
Report |
GA503 - SR Specialist Workload Detail |
This report provides a list of all SR Specialist workload items across 7 different CERES Project Types by user specified criteria. Report can be run for a set of SR Specialist, Principal Investigators, and/or departments. Report can be run for current “In Process” items or for past "Completed" items based on date range options. |
Team Content > Grants and Agreements |
Report |
GA504 - SR Specialist Workload Summary |
This report provides a summary by SR Specialist and month of workload details across 7 different CERES Project Types by user specified criteria. Report can be run for a set of SR Specialist, Principal Investigators, and/or departments. Report can be run for current “In Process” items or for past "Completed" items based on date range options. |
Team Content > Grants and Agreements |
Report
|
GM002 - Pre-Billing Status Report for Cost Reimbursable |
Pre-Billing Status Report for Cost Reimbursable
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM004 - Salary Detail Report
|
GM004 queries payroll data (including earned payroll, adjusting journals and fringe benefits) for specific projects and contracts.
|
Team content > Finance Facilities and Research Administration > Central > Sponsored Programs Management-Restricted
|
Report
|
GM006 - Billing Parameter Exception Query
|
Billing Parameter Exception Query
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM007 - Pre-Billing Letter of Credit Summary Report
|
Pre-Billing Letter of Credit Summary Report
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM008 - Revenue recognition Report
|
Revenue recognition Report
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM009 - Unapplied Deposits Report
|
Unapplied Deposits Report
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM011 - Sponsored Research Expenditures Report
|
Returns Direct Costs, F&A, and Total Costs by project ID. It can be run for a specific date range by school, department, PI, or Project type. As of Sept. 2010, this report also shows fiscal year-to-date information when reviewing current period charges.
Please note: The direct costs on this report may vary from the GM045 - Sponsored Project Budget Statement because this report does NOT include budget-checked expenses that have not yet been approved.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM014 - F&A Revenue Offset Setup Report
|
Contains the current demographic data to validate the correct recovery department and percentage has been setup.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM019 - Milestone (Deliverable) Status Report
|
Milestone (Deliverable) Status Report
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM020 - No automatic Carry Forward
|
No automatic Carry Forward
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM023 - Multi-Project Summary
|
This report presents summary award and project data in order to facilitate budgetary and expenditure oversight at the award level for multi-project grants and confirm that the sum of the project budgets is equal to the awarded amount.
This report will allow GCFAs and management to monitor project budgets that may exceed Awarded amounts and follow-up with the Award PI who is responsible for all expenditures on all projects under a particular award
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Manageme
|
Report
|
GM024 - Pre-Spending Project Monitoring
|
Pre-Spending Project Monitoring
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM026 - Project Information Lookup Report
|
Gives departments the ability to look up active Projects by department ID or project ID. Specifically, Recharge Centers can determine whether expenses can be charged. Report returns basic demographic data on a project such as Department, Title, PI, Begin/End Dates.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM028 - Project Close Out Notification Report
|
Project Close Out Notification Report
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM030 - Award Amount Expected
|
Analysis of awarded proposals that are active during a selected time period by breaking down dollars by funding received, funding by anticipated out years, and funding by option years.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Projected Proposal/Award Trends
|
Report
|
GM032 - Subcontract Analysis
|
Subcontract Analysis
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM033 - Project Account Summary
|
Distributed by the central offices to notify PI’s and Business Managers that the Award and Project have been set up in PeopleSoft and spending can begin on the project as well as notifying them of key changes to existing projects. Basic demographic data about the Award and Project is displayed along with the posted budget amounts broken out by Account and Activity.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM035 - Industry Clinical Trial Activity Report
|
Shows clinical trial activity by Fiscal Year, Sponsor, Department and PI. The activity displayed compares the Total Maximum Award Amount to the Cumulative Expenses to the Total Cash Received.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM038 - BI Limit Budget Exception
|
BI Limit Budget Exception
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM041 - Budget Category Query
|
Budget Category Query
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM044 - Sponsored Project Portfolio
|
Used by PI’s, Department Administrators, and ASRSP to view budget balances by project and by project/budget category.
- The first level report displays balances for active projects including direct and indirect expenditures as well as encumbrances by department and/or principal investigator.
- The second level report drills through into the Budget Overview for a particular project which breaks out the available balance by sponsor and cost share commitments. Each balance is then broken out by budget category (includes expenses and encumbrances).
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM045 - Sponsored Project Budget Statement
|
Used by PI's, Dept. Admins, and ASRSP to review the status of direct and indirect expenditures against the total budget amount along with project demographic data. The dollars are broken out and shown by Current Accounting Period, Fiscal Year to Date, and Inception to Date.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM047 - Milestone (Deliverable) Report
|
Used by department administrators and PIs in tracking upcoming deliverable due dates to assist in meeting sponsor and institutional requirements.
|
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM049 - Aging Submitted Proposals
|
Analysis of the proposals that are pending for a PI, school, or department. Sorted by the number of days since submitted, the report gives the ability to see a list of proposals which may not have been funded.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Proposal Aging
|
Report
|
GM052 - Faculty Proposal Activity
|
Proposal activity for a specified group of faculty.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Faculty Group Proposals / Awards
|
Report
|
GM053 - OSR Negotiation Metrics
|
OSR Negotiation Metrics
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Negotiation Reports - OSR
|
Report
|
GM055 - Negotiation Status Report
|
List of proposals with all associated contract negotiations along with the most recent status, comment and comment date.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Negotiation Reports
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Negotiation Reports - OSR
|
Report
|
GM057 - Faculty Award Activity
|
Award activity for a specified group of faculty.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Faculty Group Proposals / Awards
|
Report
|
GM059 - Proposed and Funded Cost Share
|
Proposals with requested and funded cost sharing.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Cost Sharing
|
Report
|
GM060 - Active Awards - All Roles
|
Part of the Current, Pending and Completed Support package. All awards for a chosen researcher (any role) that are active during a chosen budget period. The total direct costs, total costs, and effort for the award are displayed along with the total funded for the project.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Current, Pending, and Completed Support
|
Report
|
GM063 - Sponsor Trends: Awards
|
Analysis of the awards by Parent Sponsor Type by showing the number of awards and total awarded. Drill throughs to Parent Sponsor and Funding Mechanism give the ability to get a further breakdown of sponsor funding.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Proposal/Award Trends
|
Report
|
GM064 - Monthly Award Detail
|
Comprehensive list of all grants and contracts awarded over a time period
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Annual/Monthly Reports
|
Report
|
GM065 - Proposals Summary by Sponsor Type
|
Comparison of the count and dollar total of proposals submitted in a selected month, by sponsor type, as well as a year to month comparison for three fiscal years.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Annual/Monthly Reports
|
Report
|
GM066 - Proposals Summary by Management Area
|
Comparison of the count and dollar total of proposals submitted in a selected month, by department, as well as a year to month comparison for three fiscal years
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Annual/Monthly Reports
|
Report
|
GM067 - Awards Summary by Management Area
|
Comparison of the count and dollar total of awards received in a selected month, by management area, as well as a year to month comparison for three fiscal years
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Annual/Monthly Reports
|
Report
|
GM068 - Awards Summary by Sponsor Type
|
Comparison of the count and dollar total of awards received in a selected month, by sponsor type, as well as a year to month comparison for three fiscal year.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Annual/Monthly Reports
|
Report
|
GM070 - Awards with Required Cost Sharing
|
Awards from US sponsors with required cost sharing.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Cost Sharing
|
Report
|
GM071 - Monthly Proposal Detail
|
Comprehensive list of all proposals submitted over a time period.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Annual/Monthly Reports
|
Report
|
GM072 - Award Analysis
|
Total number of awards and total awarded by school. The first drill throughs provide the ability to see the total number of awards and total awarded by department. The second drill through gives the detailed award information related to the query. A broad range of prompts allow for specific or wide ranging queries.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Proposal/Award Trends
|
Report
|
GM073 - Proposal Success Rate
|
Proposal success rate, measured by the percentage of proposals funded divided by the number of proposals submitted to sponsors over a specified time period.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Proposal/Award Trends
|
Report
|
GM074 - Proposal Analysis
|
Total number of proposals and total proposed by school. The first drill throughs provide the ability to see the total number of proposals and total proposed by department. The second drill through gives the detailed proposal information related to the query. A broad range of prompts allow for specific or wide ranging queries.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Proposal/Award Trends
|
Report
|
GM084 - Completed Awards within Three Years - All Roles
|
Part of the Current, Pending and Completed Support package. All awards that have been completed within the past there years from a chosen date for a research are displayed.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Current, Pending, and Completed Support
|
Report
|
GM085 - Pending Proposals - All Roles
|
Part of the Current, Pending and Completed Support package. All proposals that are still pending for a research are displayed along with the year 1 requested effort and total proposed dollars.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Current, Pending, and Completed Support
|
Report
|
GM086 - Project Balances Report
|
Project Balances Report
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM089 - Internal Recharge Center Query
|
Internal Recharge Center Query
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > Central > Accounting Services
|
Report
|
GM090 - Award Projection Report
|
The GM090 report displays budgeted award amounts from InfoEd in a fiscal year representation.
|
Team content > Finance, Facilities, and Research Administration Reports > InfoEd Reports > Projected Proposal/Award Trends
|
Report
|
GM091 - Sponsor Payments Received Report
|
Presents details of payments received by contract, with a breakout by project. Payment activity includes all forms of payments as well as a subset of write-offs and other maintenance items. Note: For converted non-clinical awards, payment data prior to December 2008 is not available.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM091 - Sponsor Payments Received Report
|
Presents details of payments received by contract, with a breakout by project. Payment activity includes all forms of payments as well as a subset of write-offs and other maintenance items. Note: For converted non-clinical awards, payment data prior to December 2008 is not available.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM092 - Subcontract Monitoring Report
|
The GM092 includes a complete list of fully-executed subcontracts, with current status for funding, disbursement, and burn rates (percent disbursed).
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
|
Report
|
GM093 - Cost Share Commitment Status
|
The GM093 (Cost Share Commitment Status) report presents revenue and expense data from NUFinancials Commitment Control for sponsored projects with cost sharing. It grants users a multi-year view of budget, revenue and expense on cost share funds, which elsewhere is available only on a single fiscal year basis. It also provides a comprehensive view of all departments committing cost share funds to a given sponsored project.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM094 - Cost Share Journal Details
|
The GM094 (Cost Share Journal Details) report presents a detailed list of revenue transfers made to support cost share expenditures, as well as budget journals used to establish revenue budgets for departments contributing funds to support the cost sharing. It may be run independently or via a drill on project id from the GM093.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|
Report
|
GM095 - Clinical Trial Actuals Balance Report
|
Report Objectives and Benefits
The creation of this report will benefit the University by reducing the amount of time needed to assemble information from various other financial reports. Providing this information in a single report will also reduce the losses sustained by not invoicing clinical sponsors in a timely manner. Additionally, there are time limits for invoicing sponsors of clinical trials and this report will assist in managing invoices within those time limits.
|
Team content > Finance, Facilities, and Research Administration Reports > Central > Sponsored Programs Management
Team content > Finance, Facilities, and Research Administration Reports > School > Sponsored Programs Management
|