LN_ORIG_TERM_VW

(SQL View)
 Index Back

Loan Orig Term VW

Loan Origination term Vw

SELECT a.emplid , a.institution , a.strm , a.aid_year , b.descr FROM PS_STDNT_FA_TERM a , ps_term_val_tbl b WHERE a.strm=b.strm AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_STDNT_FA_TERM B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.STRM = A.STRM AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(B1.EFFSEQ) FROM PS_STDNT_FA_TERM B1 WHERE B1.EMPLID = A.EMPLID AND B1.INSTITUTION = A.INSTITUTION AND B1.AID_YEAR = A.AID_YEAR AND B1.STRM = A.STRM AND B1.EFFDT = A.EFFDT) AND A.EFF_STATUS = 'A'

  • Related Language Record: LNORIGTERMVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description