EPO_OC_PHOTO_FL

(SQL View)
 Index Back

Employees photos

Returns EE photo if it is configured for access. Otherwise it returns the Dummy photo.

SELECT P.EMPLID , CASE WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'Y' THEN %Coalesce(HR.EMPLOYEE_PHOTO , CNT.CONTDATA) WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'N' THEN %Coalesce(HR.EMPLOYEE_PHOTO , CNT.CONTDATA) WHEN I.DISP_PHOTO_SS_FLG = 'N' THEN CNT.CONTDATA END AS EMPLOYEE_PHOTO , CASE WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'Y' THEN HR.PSIMAGEVER WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'N' THEN HR.PSIMAGEVER WHEN I.DISP_PHOTO_SS_FLG = 'N' THEN NULL END AS PSIMAGEVER FROM PS_INSTALLATION_HR I , PSCONTENT CNT , PS_PERSON P LEFT JOIN PS_EMPL_PHOTO HR ON P.EMPLID = HR.EMPLID AND HR.PHOTO_SIZENAME = 'CARD' WHERE CNT.CONTNAME = 'PS_DUMMY_PHOTO_L_FL'

# 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
3 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version