RA_SRCHTERM_VW

(SQL View)
 Index Back

Term View

View is used as search prompt for profile field definition.

SELECT DISTINCT A.STRM , A.DESCR , B.DESCR , C.DESCR FROM PS_TERM_TBL A , PS_ACAD_CAR_TBL B ,PS_INSTITUTION_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND (A.ACAD_CAREER = B.ACAD_CAREER OR A.ACAD_CAREER = ' ') AND A.INSTITUTION=C.INSTITUTION AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_ACAD_CAR_TBL BB WHERE B.INSTITUTION = BB.INSTITUTION AND B.ACAD_CAREER=BB.ACAD_CAREER AND BB.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_INSTITUTION_TBL CC WHERE C.INSTITUTION = CC.INSTITUTION AND CC.EFFDT <= %CurrentDateIn)

  • Related Language Record: RA_SRCHTERM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Career
    4 DESCR30 Character(30) VARCHAR2(30) NOT NULL Institution