EMP_PHOTO_PG_VW

(SQL View)
Index Back

SELECT EMPLID , EMPLOYEE_PHOTO FROM PS_EMPL_PHOTO WHERE PHOTO_SIZENAME = 'PAGE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph