LM_ACT_IDLM_DMTHINSTR_VW(SQL View) |
Index Back |
|---|---|
Delivery Method InstructorUse this view to select the instructor defined on the activity delivery method. |
| SELECT AC.LM_ACT_ID , DM.LM_INSTR_ID FROM PS_LM_ACT_CI_VW AC , PS_LM_DMTHD_TBL DM WHERE DM.LM_INSTR_ID <> 0 AND DM.LM_DMTHD_TYPE_ID = AC.LM_DMTHD_TYPE_ID AND DM.LM_CI_ID = AC.LM_CI_ID AND DM.LM_DMTHD_ID = AC.LM_DMTHD_ID AND DM.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_LM_DMTHD_TBL X WHERE X.LM_DMTHD_TYPE_ID = DM.LM_DMTHD_TYPE_ID AND X.LM_CI_ID = DM.LM_CI_ID AND X.LM_DMTHD_ID = DM.LM_DMTHD_ID AND X.EFFDT <= %CurrentDateIn) |
| # | 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 |