PCMP_RIRECERVW2

(SQL View)
 Index Back

Prof Comp RI Re-certification

Used in the Professional Compliance module. View or regulated individual re-certifications.

SELECT A.PCMP_MGR_SUPER_ID ,A.EMPLID ,A.PCMP_DEV_AREA ,A.PCMP_DEV_DESCR ,A.NAME ,A.BUSINESS_UNIT ,A.EXPIRATN_DT ,A.PCMP_AE_SW FROM PS_PCMP_RECERT_TAO A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 PCMP_DEV_AREA Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Contains a development area for a given devlopment plan. This can be either an accomplishment, a competency, a training course, or a general activity.
4 PCMP_DEV_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Development description.
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 EXPIRATN_DT Date(10) DATE Expiration Date
8 PCMP_AE_SW Character(1) VARCHAR2(1) NOT NULL Used in the Professional Compliance module. Switch used in the re-certification application engine programs to signal whether notification is to be sent.
N=No
Y=Yes