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

LM_PH_GRD_PRG_V

(SQL View)

Learner Photo View

Used as Related Display field for Learner ID in Grids

SELECT P.LM_PERSON_ID , E.LM_PRG_REG_ID ,ATT.LM_JOB_TITLE , NM.LM_NAME_DISPLAY , LPH.EMPLOYEE_PHOTO FROM PS_LM_IN_DFLT_TBL I , PS_LM_PRG_REG 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_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

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_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
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