SSR_CSIDX_TR2VL

(SQL View)
Index Back

Class Search Index Stats

Class Search Index Stats by Term

SELECT DISTINCT A.STRM , B.LANGUAGE_CD , B.DESCR FROM PS_SSR_CSINDXSYNVW A ,PS_TERM_VAL_LANG B WHERE A.STRM <> ' ' AND B.STRM = A.STRM

  • Related Language Record for SSR_CSIDX_TR2VW
  • # 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