RS_ST_PROJEXP

(SQL View)
 Index Back

SELECT B.EMPLID , B.RESUME_TEXT FROM %Table(RS_WRKR_ELGBL) A , %Table(FO_EMP_RESUME) B WHERE A.EMPLID = B.EMPLID AND A.SYSTEM_SOURCE='STF' AND B.RESUME_TEXT IS NOT NULL UNION ALL SELECT B.APPLID AS EMPLID , B.RESUME_TEXT FROM %Table(APPLICANT) A , %Table(FO_APP_RESUME) B WHERE A.APP_PER_STATUS='A' AND A.APP_STATUS_CODE = 'A' AND A.APPLID = B.APPLID AND B.RESUME_TEXT IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 RESUME_TXT Long Character CLOB Project Experience Tag