BDGT_TRM_97_VW

(SQL View)
 Index Back

Student Fin Aid Term View

This table contains student information by Institution and Term for the 1996-1997 Aid Year. The primary use of this table is to provide a consolidated view of student term data for Financial Aid processing purposes. This record is created from Stdnt_FA_Term.

SELECT a.emplid , a.institution , a.strm , a.aid_year FROM PS_STDNT_FA_TERM a WHERE a.aid_year = '1997' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_STDNT_FA_TERM A1 WHERE A1.EMPLID = A.EMPLID AND A1.INSTITUTION = A.INSTITUTION AND A1.STRM = A.STRM AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_STDNT_FA_TERM A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.STRM = A.STRM AND A2.EFFDT = A.EFFDT) AND A.EFF_STATUS = 'A'

  • 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 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

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

    Default Value: STDNT_AID_SRCH.AID_YEAR

    Prompt Table: STUDENT_AID