RS_XS_RECOMMEND

(SQL View)
 Index Back

SELECT B.EMPLID , %TrimSubstr(B.BUSINESS_UNIT,1,5) %Concat 'x' %Concat %TrimSubstr(B.SO_ID,1,15) %Concat 'x' %Concat %TrimSubstr(%NumToChar(B.SO_LINE),1,3) AS REC FROM %Table(RS_WRKR_ELGBL_V) A , %Table(RS_SO_LINE_REC) 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 REC Character(25) VARCHAR2(25) NOT NULL Recommendation Tag