GPES_PERSPOI_VW

(SQL View)
 Index Back

Persons of Interest

View of all EMPLIDs with POI in PERSON_ORG

SELECT DISTINCT EMPLID FROM PS_PERSON WHERE EMPLID IN ( SELECT EMPLID FROM PS_PER_POI_TYPE) OR EMPLID IN( SELECT EMPLID FROM PS_PER_ORG_ASGN WHERE PER_ORG = 'POI')

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID