GPNZ_EEBLGRP_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.

GPNZ_EEBLGRP_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 ,C.PAY_ENTITY ,B.BALANCE_GRP_NUM FROM PS_JOB A , PS_JOB_JR B , PS_GP_PYGRP C WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT = A.EFFDT AND B.EFFSEQ = A.EFFSEQ AND C.GP_PAYGROUP = A.GP_PAYGROUP

# 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 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.

#	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	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.