HR_JC_BU_VW (SQL View)	Index Back
Job code BU view View to select Job Code, Business Unit and Labour Agreement.

HR_JC_BU_VW

(SQL View)

Job code BU view

View to select Job Code, Business Unit and Labour Agreement.

SELECT DISTINCT B.LABOR_AGREEMENT , B.SETID_JOBCODE , A.SETCNTRLVALUE FROM PS_SET_CNTRL_REC A , PS_HR_LBR_JOBCODE B WHERE A.RECNAME = 'JOBCODE_TBL' AND A.SETCNTRLVALUE IN ( SELECT BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_HR) AND A.SETID = B.SETID_JOBCODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

2 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

3 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
2	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
3	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value