PCMP_COMPCOMPVW (SQL View)	Index Back
Prof Comp Company Regulation Used in the Professional Compliance module. View of all Professional Compliance Types for a Company.

PCMP_COMPCOMPVW

(SQL View)

Prof Comp Company Regulation

Used in the Professional Compliance module. View of all Professional Compliance Types for a Company.

SELECT DISTINCT B.EMPLID ,B.EMPL_RCD ,B.COMPANY ,A.PCMP_TYPE ,T.PCMP_TYPE_DESCR FROM PS_PCMP_COMP_REG A ,PS_CURRENT_JOB_ALL B ,PS_PCMP_TYPE T WHERE A.COMPANY=B.COMPANY AND T.SETID=B.SETID_JOBCODE AND T.PCMP_TYPE=A.PCMP_TYPE

Related Language Record: PCMP_CMCMVWLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

4 PCMP_TYPE Character(3) VARCHAR2(3) NOT NULL Professiona Compliance Type - Used in the Professional Compliance module. Identifies the different types of professional complianc within a company.

5 PCMP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Professional Compliance Type Description - Used in the Professional Compliance module. Description of professional compliance type.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	PCMP_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Professiona Compliance Type - Used in the Professional Compliance module. Identifies the different types of professional complianc within a company.
5	PCMP_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Professional Compliance Type Description - Used in the Professional Compliance module. Description of professional compliance type.