LM_INSTR_PT_VW (SQL View)	Index Back
ENRL ADMIN View A view of pers_name_vw to prompt from for enrollment admin

LM_INSTR_PT_VW

(SQL View)

ENRL ADMIN View

A view of pers_name_vw to prompt from for enrollment admin

SELECT LM_PERSON_ID , NAME , LM_NAME_DISPLAY FROM PS_LM_INSTR_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field