RS_XS_WRKR_POOL

(SQL View)
 Index Back

SELECT A.EMPLID , A.POOL_ID FROM %Table(RS_POOL_MEMBER) A , %Table(RS_MEMBER_DATES) B , %Table(RS_WRKR_ELGBL_V) C WHERE A.EMPLID = C.EMPLID AND A.POOL_ID = B.POOL_ID AND A.MEMBER_ID = B.MEMBER_ID AND B.START_DATE <= %CurrentDateIn AND (B.END_DATE >=%CurrentDateIn OR B.END_DATE IS NULL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.