LM_EMPL_PHT_HST (SQL Table)	Index Back
Employee Photo EMPL_PHOTO is used to capture an image data type for learner photographs. Images can be uploaded in the Personal Information Home page in Self Service - History Table

LM_EMPL_PHT_HST

(SQL Table)

Employee Photo

EMPL_PHOTO is used to capture an image data type for learner photographs. Images can be uploaded in the Personal Information Home page in Self Service - History Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

4 EMPLOYEE_PHOTO Image / Attachment CLOB Employee Photograph

5 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	EMPLOYEE_PHOTO	Image / Attachment	CLOB	Employee Photograph
5	PSIMAGEVER	Number(10,0)	DECIMAL(10) NOT NULL	Image Version