PCMP_SUPER_VW

(SQL View)
 Index Back

Prof Comp Supervisor View

Used in the Professional Compliance module. List of Supervisors.

SELECT A.PCMP_MGR_SUPER_ID ,B.NAME FROM PS_PCMP_MGR_SUPER A ,PS_PERSON_NAME B WHERE B.EMPLID=A.PCMP_MGR_SUPER_ID AND A.PCMP_MGR_SUPER='S' AND NOT EXISTS ( SELECT 'X' FROM PS_PCMP_MGRSUP_RI S WHERE S.EMPLID=A.PCMP_MGR_SUPER_ID)

  • Related Language Record: PERSON_NAME_LNG

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