Discussion of Student Financial and Financial Aid:
Difference between Student Financial and Financial Aid
Student Financials: This is related to bursars and it applies to students once they enrolled any classes, canceled classes, tuition or any education related expense. Charges and payment method apply to all current students. Sometimes student might receive waived of charges based on their eligibility. The payment method could be process through financial aid, cash, checks or money orders depends on students eligibility.
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:
CU_BAR_SF_00005
A. ITEM_SF - ACCOUNT TERM -
C. STDNT_CAR_TERM - STRM - TERM
in prompt: choose account term instead strm. WHY? because we are dealing with student financial side that's why its better to take account term.
Expression:
Why Length 16?
CU_BAR_SF_00009:
A. TERM_TBL - STRM
H. STDNT_CAR_TERM - STRM
Choose STRM from H. record from TERM_TBL. Does it matter where you choose from?
CU_BAR_SF_00010C:
Why same records have been used twice?
CU_BAR_SF_00011:
Expression: '' this empty quotation is just created or where it has been used in query?
Financial Aid:
ANTICIPATED_AID (define):
CU_BAR_SF_00002:
In subquery :
C.NET_AWARD_AMT - Net Award Amount greater than 0 (Why this > 0)?
CU_BAR_FA_00003:
HAVING criteria, GROUP BY (how to do this?)
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?)