RS_ST_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) A , %Table(RS_WRKR_ORG_STF) B WHERE A.EMPLID = B.EMPLID AND A.SYSTEM_SOURCE='STF' UNION SELECT A.APPLID , %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(APPLICANT) A , %Table(RS_WRKR_ORG_STF) B WHERE A.APPLID = B.EMPLID AND A.APP_PER_STATUS ='A' AND A.APP_STATUS_CODE ='A'

# 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