LAM_STDNT_SCLNG(SQL View) |
Index Back |
---|---|
Student Gradebook Search Rec.Use this search record to restrict operator access to the Student Access Grade Book.This view retrieves class sections where the student grades are being kept by the Grade Book application. |
SELECT D.EMPLID , A.STRM , A.CLASS_NBR , E.OPRID , B.LANGUAGE_CD , B.DESCR FROM PS_CLASS_TBL A , PS_CRSE_CATLG_LNG B , PS_STDNT_ENRL D , PSOPRDEFN E WHERE A.STRM = D.STRM AND A.CLASS_NBR = D.CLASS_NBR AND A.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_CRSE_CATALOG B1 WHERE B1.CRSE_ID = B.CRSE_ID AND B1.EFF_STATUS = 'A' AND B1.EFFDT <= %CurrentDateIn) AND D.EMPLID = E.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
Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_VAL_TBL |
3 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |