PCMP_RECERT_TAO (SQL Table)	Index Back
Prof Comp Temp Table Used in the Professional Compliance module. Temporary table used in the re-certification application engine processes.

PCMP_RECERT_TAO

(SQL Table)

Prof Comp Temp Table

Used in the Professional Compliance module. Temporary table used in the re-certification application engine processes.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 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.

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 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.

5 PCMP_DEV_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Development description.

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

8 EXPIRATN_DT Date(10) DATE Expiration Date

9 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
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	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.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	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.
5	PCMP_DEV_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used in the Professional Compliance module. Development description.
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	EXPIRATN_DT	Date(10)	DATE	Expiration Date
9	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 Default Value: N