PCMP_DEFJOBCDVW (SQL View)	Index Back
Prof Comp Default Jobcd Vw Used in the Professional Compliance module. View showing default compliance types for a jobcode.

PCMP_DEFJOBCDVW

(SQL View)

Prof Comp Default Jobcd Vw

Used in the Professional Compliance module. View showing default compliance types for a jobcode.

SELECT DISTINCT B.BUSINESS_UNIT ,A.JOBCODE ,A.PCMP_TYPE FROM PS_PCMP_TYPE_JOBCD A , PS_JOB B , PS_BUS_UNIT_TBL_HR C WHERE C.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.SETID=C.DEFAULT_SETID AND A.JOBCODE=B.JOBCODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	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.