SSR_APTSYT_TMVL

(SQL View)
Index Back

APT Sync Search View for Term


SELECT DISTINCT t.strm , tl.language_cd , tl.descr FROM PS_SSR_APT_SYN_TRK t ,ps_term_val_tbl te ,ps_term_val_lang tl WHERE te.strm = t.strm AND te.strm = tl.strm

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