LM_PH_GRID_VW (SQL View)	Index Back
Learner Photo View Used as Related Display field for Learner ID in Grids

LM_PH_GRID_VW

(SQL View)

Learner Photo View

Used as Related Display field for Learner ID in Grids

SELECT P.LM_PERSON_ID , CASE WHEN I.LM_DISP_PHOTO_SS = 'Y' THEN %Coalesce (LPH.EMPLOYEE_PHOTO , CNT.CONTDATA) END AS EMPLOYEE_PHOTO , CASE WHEN I.LM_DISP_PHOTO_SS = 'Y' THEN LPH.PSIMAGEVER END AS PSIMAGEVER FROM PS_LM_IN_DFLT_TBL I , PSCONTENT CNT , PS_LM_PERSON P LEFT JOIN PS_LM_EMPL_PHOTO LPH ON P.LM_PERSON_ID = LPH.LM_PERSON_ID WHERE CNT.CONTNAME = 'PS_DUMMY_PHOTO_L_FL' AND I.LM_DISP_PHOTO_SS = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPLOYEE_PHOTO Image / Attachment CLOB Employee Photograph

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	EMPLOYEE_PHOTO	Image / Attachment	CLOB	Employee Photograph
3	PSIMAGEVER	Number(10,0)	DECIMAL(10) NOT NULL	Image Version