LM_ACT_IDLM_SESPRINST_VW(SQL View) |
Index Back |
|---|---|
Session Primary InstructorUse this view to select the primary instructor for the first session date. |
| SELECT SR.LM_ACT_ID , SR.LM_INSTR_ID FROM PS_LM_SES_INSTR_VW SR WHERE SR.LM_INSTR_ID > 0 AND SR.LM_ROLE_ID = 6 AND SR.LM_SES_DT = ( SELECT MIN(X.LM_SES_DT) FROM PS_LM_SES_INSTR_VW X WHERE SR.LM_ACT_ID = X.LM_ACT_ID AND SR.LM_ROLE_ID = X.LM_ROLE_ID AND X.LM_SES_DT <= %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 |