SSR_TERM_LVW

(SQL View)
 Index Back

Term view (Related language)


SELECT DISTINCT (A.STRM) , B.LANGUAGE_CD , B.DESCR FROM PS_TERM_TBL A , PS_TERM_TBL_LANG B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM

  • Related Language Record for SSR_TERM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description