LM_DUMMYINST_VW (SQL View)	Index Back
Dummy Instructor view We intentionally dont want this view to return any rows. It will be used for drop downs that is populated manually and we dont want ptools to fire its automatic query.

LM_DUMMYINST_VW

(SQL View)

Dummy Instructor view

We intentionally dont want this view to return any rows. It will be used for drop downs that is populated manually and we dont want ptools to fire its automatic query.

SELECT A.LM_PERSON_ID , A.LM_NAME_DISPLAY FROM PS_LM_PERSON_NAME A WHERE A.LM_PERSON_ID =0

# 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_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

#	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_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field