GPUS_PAYEES_VW (SQL View)	Index Back
Retrieve EMPLID for payroll PR This view retrieves Employees for payroll pay runs.

GPUS_PAYEES_VW

(SQL View)

Retrieve EMPLID for payroll PR

This view retrieves Employees for payroll pay runs.

SELECT DISTINCT PPS.CAL_RUN_ID , PPS.EMPLID , D.NAME ,PPS.PYMT_DT FROM PS_GP_PYE_PRC_STAT PPS , PS_PERSON_NAME D WHERE PPS.CALC_TYPE = 'P' AND PPS.EMPLID = D.EMPLID AND PPS.SEL_STAT IN ('A','I')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 PYMT_DT Date(10) DATE Payment Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	PYMT_DT	Date(10)	DATE	Payment Date