SSR_MIDTERM_GRD

(SQL View)
 Index Back

Student Mid-term Grades View

Self-service view used to view student mid-term grades.

SELECT B.EMPLID , B.ACAD_CAREER , B.INSTITUTION , A.STRM , A.CLASS_NBR , A.GRD_RSTR_TYPE_SEQ , A.GRADE_ROSTER_TYPE , B.BLIND_GRADING_ID , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.CRSE_GRADE_INPUT , B.TSCRPT_NOTE_ID , B.TSCRPT_NOTE_EXISTS , A.DESCR FROM PS_GRADE_RSTR_TYPE A , PS_GRADE_ROSTER B WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.GRD_RSTR_TYPE_SEQ = B.GRD_RSTR_TYPE_SEQ AND A.GRADE_ROSTER_TYPE = 'MID' AND B.CRSE_GRADE_INPUT <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: STDNT_ENRL_G_VW

2 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

Prompt Table: STDNT_ENRL_C_VW

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

4 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
6 GRD_RSTR_TYPE_SEQ Number(3,0) SMALLINT NOT NULL Grade Roster Type Sequence Nbr
7 GRADE_ROSTER_TYPE Character(4) VARCHAR2(4) NOT NULL Grade Roster
FIN=Final Grade
MID=Mid-Term Grade
8 BLIND_GRADING_ID Number(4,0) SMALLINT NOT NULL Blind Grading ID
9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
10 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
11 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A

Prompt Table: GRADE_TBL_VW

12 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID

Prompt Table: TSCRPT_NOTE_TBL

13 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag

Y/N Table Edit

Default Value: N

14 DESCR Character(30) VARCHAR2(30) NOT NULL Description