Report Description

This report provides data for all of the COD Export Processes executed from Regent Award.  The award offers drill down capabilities in to the award totals exported and per student award and disbursement details, as well as a summary of the exceptions (errors) related to each export.  Report should be sortable by clicking on the column headings.

Report Parameters / Filters

• Enterprise
• Institution (multi-select – default to all selected)
• Campus  (multi-select – default to all selected)
• Site  (multi-select – default to all selected)
• Process Executed Date From 
• Process Executed Date To 
• Student is Active?
  • All
  • Yes
  • No 

First Level Report

Output Columns

• Batch ID
• IO Process ID
• Executed On
• COD Document ID
• (count of) Students with Errors (link to report drill-down)
• (count of) Students Exported (link to report drill-down)

Second Level Report

Drill-down from “Students with Errors” link

Output Columns

• Campus
• Site
• External Student ID (1 thru 4 as applicable)
• First Name
• Last Name
• Batch ID
• COD Award Type
• Financial Award Year
• Financial Award Amount
• Financial Award Number
• Disbursement Sequence Number
• Disbursement Amount
• Message
• Student is Active?

Third Level Report

Drill-down from “Students Exported” link.  This drill-down will show the data from the export file per student, across all funds.

Output Columns

Summary Info at the top of the report:

• COD Award Type
• Financial Award Year
• Total Awards
• Count of Awards
• Total Disbursements
• Count of Disbursements

Report Output columns:

• Campus
• Site
• External Student ID (1 thru 4 as applicable)
• First Name
• Last Name
• COD Award Type
  
• Financial Award Year
• Financial Award Amount
• Financial Award Number
• Disbursement Number
• Disbursement Amount
• Student is Active?