EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
STRMCLASS_NBRA=Approve
G=Grade
P=Post
SSR_LAM_INSTR_V(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.EMPLID , A.INSTITUTION , A.STRM , A.CLASS_NBR , B.GRADE_RSTR_ACCESS FROM PS_CLASS_TBL A , PS_CLASS_INSTR B WHERE B.CRSE_ID = A.CRSE_ID AND B.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND B.STRM = A.STRM AND B.SESSION_CODE = A.SESSION_CODE AND B.CLASS_SECTION = A.CLASS_SECTION AND (B.GRADE_RSTR_ACCESS = 'A' OR B.GRADE_RSTR_ACCESS = 'G' OR B.GRADE_RSTR_ACCESS = 'P') |
| # | 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 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 4 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 5 | GRADE_RSTR_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Grade Roster Access
A=Approve G=Grade P=Post |