RD_PERSON_PNLVW

(SQL View)
 Index Back

Person Primary Name View

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

SELECT A.PERSON_ID ,L.LANGUAGE_CD , L.TITLE FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B , PS_RD_PERSON_LNG L WHERE A.PERSON_ID = B.PERSON_ID AND B.PRIMARY_IND = 'Y' AND A.PERSON_ID = L.PERSON_ID

  • Related Language Record for RD_PERSON_PN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 TITLE Character(35) VARCHAR2(35) NOT NULL Title