LAM_STDNT_GRD(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 , A.INSTITUTION , A.SUBJECT , A.CATALOG_NBR , D.ACAD_CAREER , A.CAMPUS , A.SESSION_CODE , A.CLASS_SECTION , A.CRSE_ID , A.CRSE_OFFER_NBR , A.DESCR FROM PS_CLASS_TBL A , PS_TERM_VAL_TBL B , PS_LAM_CLASS_ACTV C , PS_STDNT_ENRL D WHERE A.STRM = B.STRM AND A.STRM = C.STRM AND A.CLASS_NBR = C.CLASS_NBR AND A.STRM = D.STRM AND A.CLASS_NBR = D.CLASS_NBR |
# | 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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
5 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Default Value: OPR_DEF_TBL_CS.SUBJECT Prompt Table: SUBJECT_TBL_VW |
6 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
7 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
8 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL |
Campus
Prompt Table: CAMPUS_TBL |
9 | SESSION_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 |
10 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
11 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CATALOG |
12 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL |
Course Offering Nbr
Prompt Table: CRSE_OFFER |
13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |