RS_XS_WRK_ORG

(SQL View)
 Index Back

SELECT B.EMPLID , %TrimSubstr(B.SETID,1,5) %Concat 'x' %Concat %TrimSubstr(B.ORG_UNIT,1,30) %Concat 'x' %Concat %TrimSubstr(B.NODE_DETAIL,1,1) AS WOU FROM %Table(RS_WRKR_ELGBL_V) A , %Table(RS_WORKER_ORG) B WHERE A.EMPLID = B.EMPLID

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