SF_ISET_TERM_VW

(SQL View)
 Index Back

Student Career Term View

This view is used to determine if tuition needs to be recalculated for a Term within an Institution Set.

SELECT DISTINCT A.EMPLID , G.INSTITUTION_SET , D.BUSINESS_UNIT , A.STRM , F.SSF_SS_AUTO_CALC FROM PS_STDNT_CAR_TERM A , PS_TERM_TBL B , PS_ACAD_PROG C , PS_HOME_CAMPUS_TBL D , ps_set_cntrl_rec e , ps_calc_cntl_term f , PS_ISET_BU_DTL G 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.SSR_TRMAC_LAST_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 AND G.BUSINESS_UNIT = D.BUSINESS_UNIT AND e.setcntrlvalue = d.business_unit AND e.recname = 'CALC_CNTL_TERM' AND f.setid = e.setid AND F.ACAD_CAREER = A.ACAD_CAREER AND F.STRM = A.STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 SSF_SS_AUTO_CALC Character(1) VARCHAR2(1) NOT NULL Tuition Auto Calc flag for Self Service pages