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. It is used in the Personnel Administration and Career/Succession Planning applications.

  • 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 EMPLOYEE_PHOTO Image / Attachment CLOB Employee Photograph
    3 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version