RA_PUPD_PRFP_VW

(SQL View)
 Index Back

Profile Prompt View

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

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

  • Related Language Record: RA_PUPD_PRFPLVW

    • # 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 RA_PROFILE_NAME Character(80) VARCHAR2(80) NOT NULL Profile - Name
    4 RA_ONE_OR_MANY Character(1) VARCHAR2(1) NOT NULL Profile - One or Many
    M=Many rows
    N=One row
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254