RS_ST_ATTACHMNT

(SQL View)
 Index Back

Staffing Resume Attachments


SELECT B.EMPLID , B.ATTACHSYSFILENAME , C.SERVER_PATH , CASE D.PV_URL_ID WHEN ' ' THEN %TrimSubstr(D.ATT_SRV_NAME, 1, 30) ELSE D.PV_URL_ID END FROM %Table(RS_WRKR_ELGBL) A , %Table(FO_EMP_RESUME) B , %Table(PV_ATTACHMENTS) C , %Table(PV_ATT_SERVERS) D WHERE A.EMPLID = B.EMPLID AND A.SYSTEM_SOURCE = 'STF' AND B.SCM_ATTACH_ID = C.SCM_ATTACH_ID AND B.ATT_VERSION = C.ATT_VERSION AND C.SERVER_ID = D.SERVER_ID AND NOT EXISTS ( SELECT 'X' FROM PS_RS_ST_PROJEXP X WHERE X.EMPLID = B.EMPLID) UNION ALL SELECT B.APPLID AS EMPLID , B.ATTACHSYSFILENAME , C.SERVER_PATH , CASE D.PV_URL_ID WHEN ' ' THEN %TrimSubstr(D.ATT_SRV_NAME, 1, 30) ELSE D.PV_URL_ID END FROM %Table(APPLICANT) A , %Table(FO_APP_RESUME) B , %Table(PV_ATTACHMENTS) C , %Table(PV_ATT_SERVERS) D WHERE A.APP_PER_STATUS = 'A' AND A.APP_STATUS_CODE = 'A' AND A.APPLID = B.APPLID AND B.SCM_ATTACH_ID = C.SCM_ATTACH_ID AND B.ATT_VERSION = C.ATT_VERSION AND C.SERVER_ID = D.SERVER_ID AND NOT EXISTS ( SELECT 'X' FROM PS_RS_ST_PROJEXP X WHERE X.EMPLID = B.APPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
3 SERVER_PATH Character(254) VARCHAR2(254) NOT NULL For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
4 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).