USER_PH_PAGE_VW

(SQL View)
 Index Back

User Photos - Resize

Used to resize the User Photos in batch

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.PHOTO_SIZENAME WHEN USR.HRCD_PHOTO_SELECT = 'NO' THEN NULL ELSE HR.PHOTO_SIZENAME END) WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'N' THEN HR.PHOTO_SIZENAME END AS PHOTO_SIZENAME , CASE WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'Y' THEN (CASE WHEN USR.HRCD_PHOTO_SELECT = 'MY' THEN USR.PHOTO_IMGNAME WHEN USR.HRCD_PHOTO_SELECT = 'NO' THEN NULL ELSE HR.PHOTO_IMGNAME END) WHEN I.DISP_PHOTO_SS_FLG = 'Y' AND I.ADD_PHOTO_FLG = 'N' THEN HR.PHOTO_IMGNAME END AS PHOTO_IMGNAME , 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) 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 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 = 'PAGE' OR USR.PHOTO_SIZENAME = 'ORIG') LEFT JOIN PS_EMPL_PHOTO HR ON P.EMPLID = HR.EMPLID AND (HR.PHOTO_SIZENAME = 'PAGE' OR HR.PHOTO_SIZENAME = 'ORIG') WHERE CNT.CONTNAME = 'PT_DUMMY_PHOTO' AND I.DISP_PHOTO_SS_FLG = 'Y'

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 PHOTO_SIZENAME Character(4) VARCHAR2(4) NOT NULL Photo Size Name
    CARD=Card Size
    FAIL=Failed
    LIST=List Size
    ORCH=Org Chart Size
    ORIG=Original Size
    PAGE=Page Size
    SUCC=Success
    3 PHOTO_IMGNAME Character(254) VARCHAR2(254) NOT NULL Photo Image Name
    4 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph
    5 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version