RA_PERWRK_NM_VW

(SQL View)
 Index Back

Person Name View

This is a view for Person Names. It is used by many record as a prompt table.

SELECT A.PERSON_ID , A.NAME , A.BO_NAME_DISPLAY , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH , A.PREF_FIRST_NAME , A.TITLE , A.EMPLID , A.SETID , A.NAME_AC , A.BO_ID , A.MARKET FROM PS_RD_PERSON_NM_VW A , PS_BO_ROLE B WHERE A.BO_ID = B.BO_ID AND B.ROLE_TYPE_ID=4

  • 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

    Default Value: NEXT

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