HRCD_OC_PHOT_FL

(SQL View)
 Index Back

Card Size User Photo for NUI

Card Size User Photo for NUI Self Service Transactions. This shows a dummy photo if no other photo is available.

SELECT P.EMPLID , CASE WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'Y' THEN (CASE WHEN USR.HRCD_PHOTO_SELECT = 'MY' THEN USR.HRCD_PHOTO WHEN USR.HRCD_PHOTO_SELECT = 'NO' THEN CNT.CONTDATA ELSE %Coalesce(HR.EMPLOYEE_PHOTO , CNT.CONTDATA) END) 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 (CASE WHEN USR.HRCD_PHOTO_SELECT = 'MY' THEN USR.PSIMAGEVER WHEN USR.HRCD_PHOTO_SELECT = 'NO' THEN NULL ELSE HR.PSIMAGEVER END) 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_HRCD_USER_PHOTO USR ON P.EMPLID = USR.EMPLID AND USR.PHOTO_SIZENAME IN (' ' , 'CARD') 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