SSR_CSRVF_TRMVL(SQL View) | 
Index Back | 
|---|---|
CS Favs & Recently Vw TermsCS Favs & Recently Vw Terms | 
| SELECT DISTINCT A.STRM ,B.LANGUAGE_CD ,B.DESCR FROM PS_SSR_CLSRCH_RVF A , PS_TERM_VAL_LANG B WHERE A.STRM = B.STRM AND A.STRM <> ' ' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | Term | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |