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.

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