PERS_POI_ESP_VW

(SQL View)
 Index Back

Persons of Interest VW ESP

View of all EMPLIDs with POI

SELECT DISTINCT A.EMPLID ,A.NAME FROM PS_NAMES A WHERE A.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_NAMES ED WHERE ED.EMPLID = A.EMPLID AND ED.NAME_TYPE = A.NAME_TYPE AND ED.EFFDT <= %CurrentDateIn)

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TUTOR_ID_ESP Character(11) VARCHAR2(11) NOT NULL Tutor ID
    2 NAME Character(50) VARCHAR2(50) NOT NULL Name