GPNZ_RCPYE1_VW (SQL View)	Index Back
Payee View Used in Payroll Register - GPNZ_RC_PY11

GPNZ_RCPYE1_VW

(SQL View)

Payee View

Used in Payroll Register - GPNZ_RC_PY11

SELECT DISTINCT B.PAY_ENTITY , B.EMPLID , C.NAME FROM PS_GP_PYE_PRC_STAT B , PS_PERSON_NAME C WHERE B.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name