Greetings Friends,
We're editing a query that display the sum of the offered, accepted, and authorized amounts in a student's financial aid package.
We want to keep the display to one row per student and add a Y/N flag to indicate whether the offered total includes a private loan.
For us, a private loan is defined using attributes from ITEM_TYPE_FA:
- FA_SOURCE = P (Private)
- FIN_AID_TYPE = L (Loan)
So far, we've only been able to get two rows for the students who have private loans. On one row is their private loan amount and everything else is on a separate line. We're using his expression to do that:
case when (C.FIN_AID_TYPE) = 'L' and (C.FA_SOURCE) = 'P' then 'Y'
else 'N'
end
Can anyone suggest a different approach?
Thank you!
Cheers,
Jessica
------------------------------
Jessica Holler
jessica.holler@duke.edu------------------------------