BDGT_TRM2007_VW

(SQL View)
 Index Back

Student Fin Aid Term View

This table contains student information by Institution and Term for the 2006-2007 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 = '2007' 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: HCR_PERSON_I

    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