ROLE_DEFN_VWLNG

(SQL View)
 Index Back

Role Definition View

ROLE_DEFN_VWLNG is the related language recordfor the record ROLE_DEFN_VW

SELECT a.rolename ,a.language_cd , a.descr , a.descrlong FROM PSROLEDEFNLANG a ,PSROLEDEFN b WHERE a.rolename=b.rolename AND b.roletype = 'U'

  • Related Language Record for ROLE_DEFN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description