GPGB_PS_SS_J_VW (SQL View)	Index Back
EE Payslip - Job Title View Global Payroll UK Country Extension. Job Title View for Employee Self Service Payslip.

GPGB_PS_SS_J_VW

(SQL View)

EE Payslip - Job Title View

Global Payroll UK Country Extension. Job Title View for Employee Self Service Payslip.

SELECT DISTINCT OPRID , JOBCODE , JOBTITLE FROM PS_GPGB_SS_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	JOBTITLE	Character(30)	VARCHAR2(30) NOT NULL	Job Title