LM_INSTR_SRCH

(SQL View)
 Index Back

Instructor Search

Instructor Search View

SELECT C.OPRID , A.LM_PERSON_ID , D.FIRST_NAME , D.LAST_NAME , A.LM_INSTR_STAT , D.NAME , D.LAST_NAME_SRCH , D.FIRST_NAME_SRCH , A.LM_VENDOR_ID , D.LM_NAME_DISPLAY FROM PS_LM_INSTR A , PS_LM_INSTR_LE B , PS_LM_OPRID_LE_VW C , PS_LM_PERS_NAME_VW D WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND B.LM_LE_ID = C.LM_LE_ID AND A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_INSTR_STAT= '01' AND D.LM_ACTIVE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

Prompt Table: LM_PERSON

3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
5 LM_INSTR_STAT Character(2) VARCHAR2(2) NOT NULL Instructor Status
01=Active
02=Inactive

Default Value: 01

6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
9 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
10 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field