HR_VT_CONTLNG_V

(SQL View)
 Index Back

SP360 Tools Content Lang View

Used as base for view HR_VT_CNTDTA_VW. This view is used to limit data (content names) displayed.

SELECT DISTINCT CONTNAME , LANGUAGE_CD , DESCR FROM PSCONTDEFNLANG WHERE CONTTYPE = 1

  • Related Language Record for HR_VT_CONT_VW

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