...
Financial Aid: It does not apply to all students. It only applies those who are eligible in terms of low income or scholarships / awards or loans such as tap/ pall grant. This apply once a student process an application and get accepted. This has nothing to do with payment and charges.
Student Financial query review:
CU_BAR_SF_00005:
This query generates a report on revenue detail based on student academic career level of standing. Retrieve all the students through maximum effective date(means their latest activities).
...
No, the quotation was never used in this query. It was created because to make an union with an empty field but later user changed his mind.
Financial Aid query review:
ANTICIPATED_AID (define): A pending financial aid award can be serve as a payment for eligible financial aid student for his/her class. This award can be equal or not greater than tuition fees
CU_BAR_SF_00002:
In subquery :
C.NET_AWARD_AMT - Net Award Amount greater than 0 (Why this > 0)?
...
This query contain with 3 sub-queries and an union. In sub-query we are looking for latest record through A. anticipated _ aid.
CU_BAR_FA_00003:
HAVING criteria, GROUP BY (how to do this?)
| Panel |
|---|
AND B.STRM = A.ACCOUNT_TERM AND A.ACCOUNT_BALANCE > 0 ) GROUP BY B.EMPLID, A.ACCOUNT_BALANCE HAVING A.ACCOUNT_BALANCE - sum ( B.NET_AWARD_AMT) <= 0 ORDER BY 1 |
A.ACCOUNT_BALANCE - sum (B.NET_AWARD_AMT) not greater than 0 (Why?)
The query is not looking for student who has $ 0 balance. Moreover, award amount is always equal or grater than tuition.