RS_UNSSPOOL_MBR

(SQL View)
 Index Back

Unassigne Pool Mbr Prompt

Prompt table for Unassigned Pool Members. ESA for it.

SELECT A.EMPLID ,C.NAME FROM %Table (RS_ELGBL_WRKR) A , %Table (PERSONAL_DATA) C WHERE A.EMPLID = C.EMPLID AND A.SYSTEM_SOURCE = 'RS' AND A.EMPLID = ( SELECT MAX(MBR.EMPLID) FROM %Table (RS_POOL_MEMBER) MBR , %Table (RS_MEMBER_DATES) DT , %Table (RS_MEMBER_GRID) GRD WHERE MBR.POOL_ID = DT.POOL_ID AND DT.POOL_ID = GRD.POOL_ID AND MBR.MEMBER_ID = DT.MEMBER_ID AND DT.MEMBER_ID = GRD.MEMBER_ID AND A.EMPLID = MBR.EMPLID AND MBR.POOL_ID = '0000000001' AND (GRD.END_DATE IS NULL OR GRD.END_DATE >= %CurrentDateIn) AND GRD.START_DATE <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name