GPGB_PS_SS_R_VW (SQL View)	Index Back
EE Payslip - Run Type View Global Payroll UK Country Extension. Run Type View for Employee Self Service Payslip.

GPGB_PS_SS_R_VW

(SQL View)

EE Payslip - Run Type View

Global Payroll UK Country Extension. Run Type View for Employee Self Service Payslip.

SELECT DISTINCT A.OPRID , B.RUN_TYPE , C.DESCR FROM PS_GPGB_SS_SRCH A , PS_GP_CALENDAR B , PS_GP_RUN_TYPE C WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND B.RUN_TYPE = C.RUN_TYPE

# 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 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description