RC_ROLEUSERLNG

(SQL View)
 Index Back

ROLEUSER LANGUAGE VIEW

View selecting active roles from psroleuser, used by solutions to set rolename - Language related view

SELECT DISTINCT K.ROLENAME ,K.LANGUAGE_CD , K.DESCR FROM ( SELECT B.ROLENAME , E.LANGUAGE_CD , E.DESCR FROM PS_ROLEXLATOPR A , PSROLEUSER B , PSOPRALIAS C , PS_RD_PERSON D , PSROLEDEFNLANG E WHERE A.ROLEUSER = B.ROLEUSER AND A.OPRID=C.OPRID AND C.PERSON_ID=D.PERSON_ID AND B.ROLENAME=E.ROLENAME ORDER BY B.ROLENAME) K

  • Related Language Record for RC_ROLEUSER_VW

  • Parent record: PSROLEDEFN

    • # 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