RA_PUPD_PRFPLVW

(SQL View)
 Index Back

Profile Prompt Language View

This related language view returns authorized profiles for the Manage Profile Updates page.

SELECT C.OPRID , A.RA_PROFILE_ID , A.LANGUAGE_CD , A.RA_PROFILE_NAME , A.DESCR254 FROM PS_RA_PROFILE_LNG A , PS_RA_PROFILE B , PS_RA_PRF_SCRTY_VW C WHERE A.RA_PROFILE_ID=B.RA_PROFILE_ID AND A.RA_PROFILE_ID=C.RA_PROFILE_ID AND B.RA_PROFILE_TYPE='USER' AND B.RA_PROFILE_GROUP='IND' AND B.RA_PROFILE_STATUS='ACT' AND B.RA_PROFILE_UPDATE <> 'N'

  • Related Language Record for RA_PUPD_PRFP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RA_PROFILE_NAME Character(80) VARCHAR2(80) NOT NULL Profile - Name
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254