...
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_00002:
In sub-query :
C.NET_AWARD_AMT - Net Award Amount greater than 0 (Why this > 0)?
This is greater than 0 because the query is eliminating students with $ 0 balance. It is also eliminating those students who have 6 or less than 6 credits because they are not eligible for any financial aid.
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_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).
...
The account term has been chosen because we are dealing with student financial side that's why its better to take account term. Moreover, in this query Business_Unit represent as an Institution (BAR01) which has been used through ITEM_SF record.
Expression:
Why Length 16 bites?
If a student take 4 course with 4 credits each then it is 16 then based on their academic level it might increase the number. That's why the 16 bites is just the assumption of the output.
...
Yes, because it totally depends on which record has been used to choose Institution in the criteria.
CU_BAR_SF_00010C:
Why same records have been used twice?
The same records have been twice because the first A.ITEM_SF is looking for charges, it cross referencing to B. ITEM_XREF to look for amount and item description from D.ITEM_TYPE_TBL. The same loop goes to Payment method as well.
...
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 is greater than 0 because the query is eliminating students with $ 0 balance. It is also eliminating those students who have 6 or less than 6 credits because they are not eligible for any financial aid.This query contain with 3 sub-queries and an union.
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.
SSF_APPR_STATUS - Approval S: For a transaction purpose
