STDNT_BDGT_SRCH

(SQL View)
 Index Back

Student Budget Search View

STDNT_BDGT_SRCH is based roughly on STDNT_AID_SRCH, with the added criteria to exclude those students who are currently being processed in the Batch Budget Assignment process.

SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , B.NAME FROM PS_STUDENT_AID A , PS_PEOPLE_SRCH B WHERE A.EMPLID = B.EMPLID AND A.EMPLID IN ( SELECT DISTINCT D.EMPLID FROM PS_STDNT_FA_TERM D WHERE D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.STRM=( SELECT MAX(D1.STRM) FROM PS_STDNT_FA_TERM D1 WHERE D1.EMPLID=A.EMPLID AND D1.INSTITUTION=A.INSTITUTION AND D1.AID_YEAR=A.AID_YEAR AND D1.EFF_STATUS = 'A') AND D.EFFDT = ( SELECT MAX(D2.EFFDT) FROM PS_STDNT_FA_TERM D2 WHERE D2.EMPLID = D.EMPLID AND D2.INSTITUTION = D.INSTITUTION AND D2.STRM = D.STRM AND D2.EFFDT <= %CurrentDateIn) AND D.EFFSEQ = ( SELECT MAX(D3.EFFSEQ) FROM PS_STDNT_FA_TERM D3 WHERE D3.EMPLID = D.EMPLID AND D3.INSTITUTION = D.INSTITUTION AND D3.STRM = D.STRM AND D3.EFFDT = D.EFFDT)) AND A.EMPLID NOT IN ( SELECT C.EMPLID FROM PS_STDNT_BDGT_ASGN C WHERE C.PROCESSING_MODE = 'B' AND C.AID_YEAR = A.AID_YEAR)

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 NAME Character(50) VARCHAR2(50) NOT NULL Name