Discussion of Student Financial and Financial Aid:
Difference between Student Financial and Financial Aid
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?)