GPAU_EEPYENT_VW (SQL View)	Index Back
Payee job records per TFN This table will record all the payee's job record for a combination of Emplid, Pay Entity, and Contract Number.

GPAU_EEPYENT_VW

(SQL View)

Payee job records per TFN

This table will record all the payee's job record for a combination of Emplid, Pay Entity, and Contract Number.

SELECT DISTINCT A.EMPLID ,B.PAY_ENTITY ,C.DESCR FROM PS_JOB A ,PS_GP_PYGRP B ,PS_GP_PYENT C WHERE B.GP_PAYGROUP = A.GP_PAYGROUP AND C.PAY_ENTITY = B.PAY_ENTITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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