RF Reports Due Report

Parameter

Description
(click in the field to see the List of Values)

Required Parameters

Report Selection

Select Past Due to display all reports that are older than the date on which the Reports Due Report is run. The report will display the number of days past due from the due date.

Select Upcoming to display all reports that have a due date within 60 days from the day the Reports Due Report is run.

Award Status

Select Open to display all open awards with reports due or upcoming.

Note: Open includes award status's of Active, At-risk, and On-Hold.

Select Closed to display all closed awards with reports due or upcoming.

Select All to display all awards regardless of award status with reports due or upcoming.

Report Type

Select Financial to display all reports that have a report type of financial that are due or upcoming.

Select Non Financial to display all reports that are not financial that are due or upcoming.

Select All to display both financial and non financial reports that are due or upcoming.

Order By

Select Award to sort the display of information numerically by Award Number. If this is selected, the sort order of the report is as follows: Award Number, Due Date, Report Name, and Installment Number.

Select Award Principal Investigator to sort the display of information alphabetically by principal investigator's last name. If this is selected, the sort order of the report is as follows: Award PI, Award Number, Due Date, Report Name, Installment Number.

Optional Parameters

Award Location

Select the campus location to display reports due or upcoming for a specific campus.

Display Project Details

Displays project detail for all projects funded by the award. Select Yes to display or No to suppress.

Note: The default value is Yes.

Column Heading

Description of Column

Award

The system-generated Oracle number assigned to the award

Principal Investigator

The last name and first name of the PI listed on the award

Sponsor

The funding source of the award

Award Period

The start date and end date of the award

Due Date

The day, month, and year the report is due

Report Name

The title of the report that is due or past due

Age (in days)

The number of days report is past due

This column is present only when the report is run for past due reports.

PROJECT DETAILS

The following columns display when the Display Project Details parameter is set to Yes.

Project

The project number funded by the award

Project Org

The project location and department

Project PI

The active project principal Investigator at the time the report is run

Project Status

The status of the project at the time the report is run