GPAU_ELG_ELM_VW (SQL View)	Index Back
Element group view This view stores the eligibility group information that an employee belongs to.

GPAU_ELG_ELM_VW

(SQL View)

Element group view

This view stores the eligibility group information that an employee belongs to.

SELECT d.ELIG_GRP ,a.PIN_NM ,b.PIN_NUM ,c.PIN_ELEM_NUM FROM PS_GP_PIN a , PS_GP_ELEM_GRP b , PS_GP_ELEM_GRP_MBR c , PS_GP_ELIG_GRP d , PS_GP_ELIG_GRP_MBR e WHERE a.PIN_NUM = b.PIN_NUM AND a.PIN_NUM = c.PIN_NUM AND a.PIN_NUM = e.PIN_ELEM_GRP_NUM AND b.EFFDT = c.EFFDT AND d.ELIG_GRP = e.ELIG_GRP AND d.EFFDT = e.EFFDT AND b.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GP_ELEM_GRP A1 WHERE A1.PIN_NUM = b.PIN_NUM AND A1.EFFDT <= %CurrentDateIn ) GROUP BY d.ELIG_GRP,a.PIN_NM,b.PIN_NUM,c.PIN_ELEM_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group
Prompt Table: GP_ELIG_GRP

2 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

4 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number
Prompt Table: %RECNAME_EDIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group Prompt Table: GP_ELIG_GRP
2	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
4	PIN_ELEM_NUM	Number(8,0)	INTEGER NOT NULL	Element Number Prompt Table: %RECNAME_EDIT