The RF Award Credit Distribution Report displays the expended dollars for an award based on the credit distributions that have been assigned. The Credit Distribution form in the Oracle Grants Management (GM) system allows a user to assign a credit for direct or indirect cost expenditures among multiple faculty members (PI/Co-PI) and/or departments (Organization). The report displays the credit distribution percentages and calculates the expended dollars by credit distribution.
Expended dollars are calculated by multiplying the expended dollars for the period of time entered on report by the credit distribution percentages. On awards where there is no credit distribution information entered, the default is 100% to the Task Org and the Task Manager.
The report can only be run for awards with the following award purpose codes:
This report should be run as needed to gather credit distribution information entered on awards.
The following table describes the required and optional parameters to use to run the report:
Parameter |
Description |
||
Required Parameters |
|||
Location |
Enter the three-digit location number or select from the List of Values. |
||
Sort By |
Select from the List of Values how the report will group sort and display subtotals. The choices are Award, Organization, and PI. |
||
Award Number |
Enter an award number when you want the report to only display the information for a particular award. |
||
Starting Period |
The starting month and year for which you want to report credit distribution data. For example, MAY-2002. |
||
Ending Period |
The month and year for the last month for which you want to report credit distribution data. For example, if the starting period is MAY-2002 and the ending period is MAY-2002, the system runs the report for the month of May. If the starting period is MAY-2002 and the ending period is JUN-2002, the system runs the report for the months of May and June. |
The following table describes the report output:
Column Heading |
Description of Column |
Award Number |
A unique sequential number assigned to an award. An award is the record established from the award notice or contract received from a customer. An award record contains a funding source (customer), award amounts (funds), start and end dates, terms and conditions, and other information. Awards are used to fund one or more project. |
Project Number |
A unique sequential number assigned to a project. |
Task Number |
A user-assigned Task identifier. |
Task Org |
The three-digit location number followed by the department name to which the task is assigned. |
Credit Org |
The credit organization (department) that was entered on the Credit Distribution form on the project. If a credit organization was not entered, this column displays the task organization. |
Credit PI/Co-PI |
The credit PI/Co-PI that was entered on the Credit Distribution form on the project. If a credit PI/Co-PI was not entered, this column displays the Task PI. |
Award Sponsor |
A name that identifies the organization that is sponsoring the award administered by the Research Foundation (Sponsor). |
Percent |
The percentage that was entered on the Credit Distribution form on the project. If a percentage was not entered, this column displays 100%. |
Direct Cost |
The result of the Total Direct Cost expended for the APT multiplied by the credit percent for the period selected. |
Indirect Cost |
The result of the Total Indirect Cost expended for the APT multiplied by the credit percent for the period selected. |
Total Cost |
The total of Direct Cost plus Indirect Cost. |
Effective Date: 3/14/2007 8:36:57 AM