...
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).
Panel |
---|
SELECT A.ACAD_CAREER, C.ACAD_PROG_PRIMARY, A.SEL_GROUP, CASE WHEN C.UNT_TAKEN_PRGRSS BETWEEN 12 AND 30 THEN 'Full' WHEN C.UNT_TAKEN_PRGRSS BETWEEN 0.01 AND 11.99 THEN 'Part' ELSE ' ' END, A.ITEM_TYPE, B.DESCR, B.KEYWORD1, count ( A.EMPLID), sum ( C.UNT_TAKEN_PRGRSS), SUM ( A.ITEM_AMT), TO_CHAR(SYSDATE,'YYYY-MM-DD'),B.SETID,B.ITEM_TYPE,TO_CHAR(B.EFFDT,'YYYY-MM-DD') FROM PS_ITEM_SF A, PS_ITEM_TYPE_TBL B, PS_STDNT_CAR_TERM C WHERE A.BUSINESS_UNIT = :1 AND A.ACCOUNT_TERM = :2 AND B.ITEM_TYPE = A.ITEM_TYPE AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_ITEM_TYPE_TBL B_ED WHERE B.SETID = B_ED.SETID AND B.ITEM_TYPE = B_ED.ITEM_TYPE AND B_ED.EFFDT <= SYSDATE) AND A.BUSINESS_UNIT = B.SETID AND A.ITEM_AMT <> 0 AND A.EMPLID = C.EMPLID (+) AND A.ACAD_CAREER = C.ACAD_CAREER (+) AND A.STDNT_CAR_NBR = C.STDNT_CAR_NBR (+) AND A.BUSINESS_UNIT = C.INSTITUTION (+) AND A.ACCOUNT_TERM = C.STRM (+) GROUP BY A.ACAD_CAREER, C.ACAD_PROG_PRIMARY, A.SEL_GROUP, CASE WHEN C.UNT_TAKEN_PRGRSS BETWEEN 12 AND 30 THEN 'Full' WHEN C.UNT_TAKEN_PRGRSS BETWEEN 0.01 AND 11.99 THEN 'Part' ELSE ' ' END, A.ITEM_TYPE, B.DESCR, B.KEYWORD1,B.SETID,B.ITEM_TYPE,TO_CHAR(B.EFFDT,'YYYY-MM-DD') ORDER BY 1, 2, 3, 4, 5 |
A. ITEM_SF - ACCOUNT TERM -
C. STDNT_CAR_TERM - STRM - TERM
in prompt prompt: choose account term instead strmACCOUNT_TERM instead of STRM. WHY?
The account term has been chosen because we are dealing with student financial side that's why its better to take account term.
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
...