RA_SRCHTERM_LVW

(SQL View)
 Index Back

Term View

Term View - search prompt related language record

SELECT DISTINCT A.STRM , A.LANGUAGE_CD , A.DESCR , B.DESCR , C.DESCR FROM PS_TERM_TBL_LANG A , PS_ACAD_CAR_LANG B ,PS_INSTITUTION_LNG C WHERE A.INSTITUTION = B.INSTITUTION AND A.LANGUAGE_CD = B.LANGUAGE_CD AND (A.ACAD_CAREER = B.ACAD_CAREER OR A.ACAD_CAREER = ' ') AND A.INSTITUTION=C.INSTITUTION AND A.LANGUAGE_CD = C.LANGUAGE_CD AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_ACAD_CAR_LANG 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_LNG CC WHERE C.INSTITUTION = CC.INSTITUTION AND CC.EFFDT <= %CurrentDateIn)

  • Related Language Record for RA_SRCHTERM_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Career
    5 DESCR30 Character(30) VARCHAR2(30) NOT NULL Institution