GPAU_EE_BLMLSVW (SQL View)	Index Back
EE BAL Group vw for MLS This table will record all the payee's job record for a combination of Emplid, Balance Grp Number.

GPAU_EE_BLMLSVW

(SQL View)

EE BAL Group vw for MLS

This table will record all the payee's job record for a combination of Emplid, Balance Grp Number.

SELECT DISTINCT A.EMPLID ,B.BALANCE_GRP_NUM FROM PS_JOB A , PS_JOB_JR B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT = A.EFFDT AND B.EFFSEQ = A.EFFSEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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