RD_PERSON_PN_VW

(SQL View)
 Index Back

Person Primary Name View

Person Primary Name View. This view only contains the primary name of a person.

SELECT A.PERSON_ID , B.SEQ_NBR , B.NAME , B.BO_NAME_DISPLAY , B.LAST_NAME , B.FIRST_NAME , B.NAME_AC , B.PREF_FIRST_NAME , B.MIDDLE_NAME , A.TITLE , A.EMPLID , A.SETID , A.BO_ID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID AND B.PRIMARY_IND = 'Y'

  • Related Language Record: RD_PERSON_PNLVW

    • # 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    7 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
    8 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
    9 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    10 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    12 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    13 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID