EMPLIDPrompt Table: PEOPLE_SRCH
STRMCLASS_NBRLANGUAGE_CDSS_LAM_CLAS_LNG(SQL View) |
Index Back |
|---|---|
Gradebook - find class.View used by Gradebook. |
| SELECT DISTINCT C.EMPLID , A.STRM , A.CLASS_NBR , D.LANGUAGE_CD , D.DESCR FROM PS_CLASS_TBL A , PS_CLASS_MTG_PAT B , PS_CLASS_INSTR C , PS_CRSE_CATLG_LNG D WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND A.CRSE_ID = D.CRSE_ID AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.STRM = B.STRM AND C.SESSION_CODE = B.SESSION_CODE AND C.CLASS_SECTION = B.CLASS_SECTION AND C.CLASS_MTG_NBR = B.CLASS_MTG_NBR AND C.GRADE_RSTR_ACCESS IN ('A','G','P') AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_CATALOG D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.EFF_STATUS = 'A' AND D1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 3 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |