LM_ACT_INSTR_VW

(SQL View)
 Index Back

Instructor View

Use this view to select the instructor. The order of selecting the instructor will look in this order: 1) Session view for the first scheduled session. Select the primary instructor. 2) Select the primary instructor on the activity level 3) Select the primary instructor on the delivery method.

SELECT AC.LM_ACT_ID , CASE WHEN SS.LM_INSTR_ID > 0 THEN SS.LM_INSTR_ID WHEN AC.LM_INSTR_ID > 0 THEN AC.LM_INSTR_ID WHEN DM.LM_INSTR_ID > 0 THEN DM.LM_INSTR_ID ELSE 0 END FROM PS_LM_ACT_CI_VW AC LEFT OUTER JOIN PS_LM_SESPRINST_VW SS ON AC.LM_ACT_ID = SS.LM_ACT_ID LEFT OUTER JOIN PS_LM_DMTHINSTR_VW DM ON AC.LM_ACT_ID = DM.LM_ACT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
2 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID