PCMP_SUPER_VW3 (SQL View)	Index Back
Prof Comp Supervisor View Used in the Professional Compliance module. View of Compliance Supervisors.

PCMP_SUPER_VW3

(SQL View)

Prof Comp Supervisor View

Used in the Professional Compliance module. View of Compliance Supervisors.

SELECT A.EMPLID ,B.NAME ,A.PCMP_MGR_SUPER_ID FROM PS_PCMP_MGRSUP_RI A ,PS_PERSON_NAME B WHERE B.EMPLID=A.EMPLID AND A.PCMP_MGR_SUPER='M' AND A.PCMP_RI_STATUS='A' AND A.PCMP_ASSIGNED_DT=( SELECT MAX(C.PCMP_ASSIGNED_DT) FROM PS_PCMP_MGRSUP_RI C WHERE C.EMPLID=A.EMPLID AND C.PCMP_MGR_SUPER='M')

# 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

3 PCMP_MGR_SUPER_ID Character(11) VARCHAR2(11) NOT NULL Professional Compliance Manager/Supervisor ID - Used in the Professional Compliance module. Holds the EMPLID of the Manager/Supervisor.

#	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
3	PCMP_MGR_SUPER_ID	Character(11)	VARCHAR2(11) NOT NULL	Professional Compliance Manager/Supervisor ID - Used in the Professional Compliance module. Holds the EMPLID of the Manager/Supervisor.