LM_INSTR_RSL_VW

(SQL View)
 Index Back

Instructor Search Results

Instructor Search Results

SELECT D.OPRID ,A.LM_PERSON_ID ,A.LM_INSTR_STAT ,B.NAME ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH ,A.LM_LANG_CD1 ,A.LM_VENDOR_ID ,A.LM_COST ,A.CURRENCY_CD ,A.LM_COST_TYPE ,B.LM_NAME_DISPLAY FROM PS_LM_INSTR A , PS_LM_PERS_NAME_VW B , PS_LM_INSTR_LE C , PS_LM_OPRID_LE_VW D WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND C.LM_LE_ID = D.LM_LE_ID AND A.LM_INSTR_STAT= '01' AND B.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_VW

3 LM_INSTR_STAT Character(2) VARCHAR2(2) NOT NULL Instructor Status
01=Active
02=Inactive
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
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_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field