TCALC_REQ_VW

(SQL View)
 Index Back

Stdnt Tuit Calc Req View

This View lists all Students that require Tuition Calculation.

SELECT DISTINCT D.BUSINESS_UNIT , A.EMPLID , A.STRM FROM PS_STDNT_CAR_TERM A , PS_TERM_TBL B , PS_ACAD_PROG C , PS_HOME_CAMPUS_TBL D WHERE A.TUIT_CALC_REQ = 'Y' AND B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.STRM = A.STRM AND C.EMPLID = A.EMPLID AND C.ACAD_CAREER = A.ACAD_CAREER AND C.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND C.EFFDT = ( SELECT MAX (CC.EFFDT) FROM PS_ACAD_PROG CC WHERE CC.EMPLID = C.EMPLID AND CC.ACAD_CAREER = C.ACAD_CAREER AND CC.STDNT_CAR_NBR = C.STDNT_CAR_NBR AND CC.EFFDT <= B.TERM_BEGIN_DT) AND C.EFFSEQ = ( SELECT MAX(CCC.EFFSEQ) FROM PS_ACAD_PROG CCC WHERE CCC.EMPLID = C.EMPLID AND CCC.ACAD_CAREER = C.ACAD_CAREER AND CCC.STDNT_CAR_NBR = C.STDNT_CAR_NBR AND CCC.EFFDT = C.EFFDT) AND D.INSTITUTION = A.INSTITUTION AND D.ACAD_PROG = C.ACAD_PROG AND D.EFFDT = ( SELECT MAX(DD.EFFDT) FROM PS_HOME_CAMPUS_TBL DD WHERE DD.INSTITUTION = D.INSTITUTION AND DD.ACAD_PROG = D.ACAD_PROG AND DD.EFFDT <= B.TERM_BEGIN_DT) AND d.campus = c.campus

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 STRM Character(4) VARCHAR2(4) NOT NULL Term