PERSON_POI_VW

(SQL View)
 Index Back

Persons of Interest

View of all EMPLIDs with POI in PER_ORG_ASGN or in PER_POI_TYPE.

SELECT DISTINCT A.EMPLID FROM PS_PERSON A WHERE EXISTS ( SELECT B.EMPLID FROM PS_PER_POI_TYPE B WHERE B.EMPLID = A.EMPLID) OR EXISTS ( SELECT C.EMPLID FROM PS_PER_ORG_ASGN C WHERE C.PER_ORG = 'POI' AND C.EMPLID = A.EMPLID)

  • Parent record: PERSON

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