USER_PH_RZ_VW

(SQL View)
 Index Back

User Photos - Resize

Used to resize the User Photos in batch

SELECT EMPLID ,PHOTO_SIZENAME ,EMPLID %Concat '.jpg' ,HRCD_PHOTO_SELECT ,LASTUPDOPRID ,LASTUPDDTTM ,HRCD_PHOTO ,PSIMAGEVER FROM PS_HRCD_USER_PHOTO WHERE PHOTO_SIZENAME = 'ORIG' AND HRCD_PHOTO IS NOT NULL

  • 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 HRCD_PHOTO_SELECT Character(2) VARCHAR2(2) NOT NULL Company Directory
    HR=Display HR System Photo
    MY=Display My Photo
    NO=No Photo
    5 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    7 HRCD_PHOTO Image / Attachment(256) VARCHAR2(256) User Uploaded Photo
    8 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version