RS_XS_ATTACHMNT

(SQL View)
 Index Back

SELECT B.EMPLID , B.ATTACHSYSFILENAME FROM %Table(RS_WRKR_ELGBL_V) A , %Table(RS_ATTACHMENTS) B WHERE A.EMPLID = B.EMPLID AND B.DEFAULT_ATTACH = 'Y'

# 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