PCMP_DVP_ACT_VW (SQL View)	Index Back
Prof Comp Dev Activity View Used in the Professional Compliance module. View of the General Activities used in the professional compliance process.

PCMP_DVP_ACT_VW

(SQL View)

Prof Comp Dev Activity View

Used in the Professional Compliance module. View of the General Activities used in the professional compliance process.

SELECT A.SETID ,A.PCMP_DEV_ACT ,A.PCMP_DEV_DESCR FROM PS_PCMP_DEV_ACT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID

2 PCMP_DEV_ACT Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Geberal Activity code used in development plans.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID
2	PCMP_DEV_ACT	Character(8)	VARCHAR2(8) NOT NULL	Used in the Professional Compliance module. Geberal Activity code used in development plans.
3	PCMP_DEV_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used in the Professional Compliance module. Development description.