EMPLIDSTRMOPRIDSS_LAM_TERM_VW1(SQL View) |
Index Back |
|---|---|
Gradebook - find term.View used by Gradebook and Class Assignments components to select terms for instructors to choose from. |
| SELECT DISTINCT A.EMPLID , A.STRM , C.OPRID FROM PS_STDNT_ENRL A , PS_LAM_CLASS_ACTV B , PSOPRDEFN C WHERE A.STDNT_ENRL_STATUS = 'E' AND A.ENRL_STATUS_REASON IN ('ENRL','EWAT') AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.EMPLID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |