...
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).
...
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.
CU_BAR_SF_00009:
A. TERM_TBL - STRM
H. STDNT_CAR_TERM - STRM
Choose STRM from H. record from STDNT_CAR_TERM over TERM_TBL. Does it matter where you to choose from?
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 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.
CU_BAR_SF_00011:
Expression: '' this empty quotation is just created or where it has been used in query?
...