RC_INT_PRTY_VW

(SQL View)
 Index Back

Interested Person View

This View is used to get the Name of the Persons interested for a case

SELECT A.PERSON_ID , %Substring(B.BO_NAME_DISPLAY, 1, 50) ,B.NAME_AC ,B.FIRST_NAME ,B.LAST_NAME ,A.EMPLID , A.TITLE FROM PS_RD_PERSON A ,PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID AND B.NAME_TYPE = 'PREFERRED' AND B.PRIMARY_IND = 'Y'

  • 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
    2 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    3 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
    4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 TITLE Character(35) VARCHAR2(35) NOT NULL Title