LM_INSTR_P_VW (SQL View)	Index Back
Instructor Prev Taught View This view is used for select processing on the instructor search page. This view should not be used for any other purpose. The view returns instructors along with courses they have previously taught. In the search page the view is used to return all instructors who have previously taught a specific catalog item.

LM_INSTR_P_VW

(SQL View)

Instructor Prev Taught View

This view is used for select processing on the instructor search page. This view should not be used for any other purpose. The view returns instructors along with courses they have previously taught. In the search page the view is used to return all instructors who have previously taught a specific catalog item.

SELECT D.LM_PERSON_ID ,D.LM_INSTR_STAT ,E.NAME ,E.LM_NAME_DISPLAY ,E.LAST_NAME_SRCH ,E.FIRST_NAME_SRCH ,D.LM_LANG_CD1 ,D.LM_VENDOR_ID ,D.LM_COST ,D.CURRENCY_CD ,D.LM_COST_TYPE ,A.LM_CI_ID ,B.LM_SES_DT FROM PS_LM_ACT A , PS_LM_SES B , PS_LM_SES_INSTR C , PS_LM_INSTR D , PS_LM_PERS_NAME_VW E WHERE B.LM_ACT_ID = A.LM_ACT_ID AND C.LM_ACT_ID = A.LM_ACT_ID AND C.LM_SES_ID = B.LM_SES_ID AND C.LM_INSTR_ID IN ( SELECT DISTINCT(CC.LM_INSTR_ID) FROM PS_LM_SES_INSTR CC WHERE CC.LM_ACT_ID = A.LM_ACT_ID AND CC.LM_SES_ID = B.LM_SES_ID) AND D.LM_PERSON_ID = C.LM_INSTR_ID AND E.LM_PERSON_ID = C.LM_INSTR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
Prompt Table: LM_PERSON_VW

2 LM_INSTR_STAT Character(2) VARCHAR2(2) NOT NULL Instructor Status
01=Active
02=Inactive
Default Value: 01

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

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

5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

6 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

8 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID

9 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

11 LM_COST_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Type Units
01=Per Hour
02=Per Day
03=Per Week
04=Fixed Cost
05=Per Student

12 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

13 LM_SES_DT Date(10) DATE Session Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID Prompt Table: LM_PERSON_VW
2	LM_INSTR_STAT	Character(2)	VARCHAR2(2) NOT NULL	Instructor Status 01=Active 02=Inactive Default Value: 01
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
5	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
8	LM_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Vendor ID
9	LM_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Cost
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
11	LM_COST_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Cost Type Units 01=Per Hour 02=Per Day 03=Per Week 04=Fixed Cost 05=Per Student
12	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
13	LM_SES_DT	Date(10)	DATE	Session Date