EMPL_PHOTO

(SQL Table)
Index Back

Employee Photo

EMPL_PHOTO is used to capture an image data type for employee or applicant/external candidate photographs.

  • Parent record: PERSONAL_DATA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PHOTO_SIZENAME Character(4) VARCHAR2(4) NOT NULL Photo Size Name
    PAGE=PAGE

    Default Value: PAGE

    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