HCR_EMPL_PHOT_I

(SQL View)
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.

SELECT A.EMPLID , A.PSIMAGEVER FROM PS_EMPL_PHOTO A

  • 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 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version