Report Description

This reports identifies students who have a Work Study award for the selected Payment Period (or) Term and their remaining balance of unearned funds.

Report Parameters / Filters

• Enterprise
• Institution (multi-select)
• Campus (multi-select)
• Site (multi-select)
• Type
  
  • Term Based
  • Non-Term Based
  • NonStandard Term
• Term (multi-select)
• Payment Period Start Date Range From
• Payment Period Start Date Range To 
• Program Start Date Range From
• Program Start Date Range To
• Award Status (multi-select)
• Fund Official Type (multi-select)
• Student is Active?
  • All
  • Yes
  • No

Output Columns

• Federal Award Year

• External Student ID (1 thru 4 as applicable)

• First Name
• Last Name
• Payment Period
• Payment Period Start Date
• Payment Period End Date
• Registered units
• Fund Name
• Fund Official Type
• Award Status
• Award Amount
• Paid Amount (Total Earnings)
• Balance (Sum([AwardDisbursement].[amount]) - sum([ActualEarningsData].[ActualEarnings]) AS [Balance])
• Percentage of Award disbursed (paid amount divided by award amount)
• Student is Active?