GPHK_BALGRP_VW(SQL View) |
Index Back |
---|---|
GPHK - Balance Group ViewThis 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. |