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

LM_PH_GRID_PH_V

(SQL View)

Learner Photo View

Used as Related Display field for Learner ID in Grids

SELECT P.LM_PERSON_ID , E.LM_ENRLMT_ID ,ATT.LM_JOB_TITLE , NM.LM_NAME_DISPLAY , LPH.EMPLOYEE_PHOTO FROM PS_LM_IN_DFLT_TBL I , PS_LM_ENRLMT E , PS_LM_PERS_NAME_VW NM , PSCONTENT CNT , PS_LM_PERSON_JOB ATT , 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' AND E.LM_PERSON_ID = P.LM_PERSON_ID AND NM.LM_PERSON_ID = P.LM_PERSON_ID AND P.LM_PERSON_ID = ATT.LM_PERSON_ID AND %CurrentDateIn BETWEEN ATT.EFFDT AND ATT.LM_END_EFFDT

# 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 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

3 LM_BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title Field currently not used, reserved for future functionality

4 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

5 EMPLOYEE_PHOTO Image / Attachment CLOB Employee Photograph

#	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	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
3	LM_BUSINESS_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Business Title Field currently not used, reserved for future functionality
4	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
5	EMPLOYEE_PHOTO	Image / Attachment	CLOB	Employee Photograph