PCMP_MGR_VW

(SQL View)
 Index Back

Prof Comp Manager View

Used in the Professional Compliance module. List of Managers.

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='M'

  • 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