LM_INSTR_QL_VW

(SQL View)
 Index Back

Instuctor Qualification View

This view is used for select processing on the instructor search page. This view should not be used for any other purpose.

SELECT E.OPRID ,A.LM_PERSON_ID ,A.LM_INSTR_STAT ,B.NAME ,B.LM_NAME_DISPLAY ,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 ,C.LM_CI_ID FROM PS_LM_INSTR A , PS_LM_PERS_NAME_VW B , PS_LM_INSTR_QUAL C , PS_LM_INSTR_LE D , PS_LM_OPRID_LE_VW E WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_PERSON_ID = D.LM_PERSON_ID AND D.LM_LE_ID = E.LM_LE_ID

# 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

Default Value: 01

4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
9 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
10 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

12 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
13 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item