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 |