GPHK_BALGRP_VW

(SQL View)
Index Back

GPHK - Balance Group View

This view is used to retreive the latest balance group number for a given employee ID.

SELECT A.EMPLID , A.BALANCE_GRP_NUM FROM PS_JOB_JR A WHERE A.BALANCE_GRP_NUM = ( SELECT MAX(A1.BALANCE_GRP_NUM) FROM PS_JOB_JR A1 WHERE A1.EMPLID = A.EMPLID)

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