RB_SRTY_DLT_VW

(SQL View)
 Index Back

Security User Privileges

CRM common object: Security User Privileges view

SELECT C.PERSON_ID ,B.NAME ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH ,B.PREF_FIRST_NAME ,A.TITLE ,A.EMPLID , A.SETID , A.BO_ID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B , PS_RB_SRTY_DELTA C WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID = C.PERSON_ID

  • Related Language Record: RD_PERSON_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: RD_PERSON_NM_VW

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    5 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
    6 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    9 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID