SSR_FCSCEX_SSVW

(SQL View)
 Index Back

SS Final Exam View for Faculty

The Final Exam View contains by instructor ID and term all the exam information for the instructor teaches for the specified term.

SELECT DISTINCT A.STRM ,A.EMPLID ,C.CLASS_NBR ,E.LAST_NAME_SRCH ,E.FIRST_NAME_SRCH ,E.NAME ,B.TERM_BEGIN_DT ,C.ACAD_CAREER ,C.ACAD_GROUP ,C.SUBJECT ,C.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CRSE_OFFER_NBR ,A.CONTACT_MINUTES ,A.CRSE_ID ,B.TERM_BEGIN_DT ,B.TERM_END_DT ,C.INSTITUTION ,C.SSR_COMPONENT ,C.DESCR ,C.ENRL_TOT ,B.DESCR ,D.DESCR ,C.LMS_PROVIDER ,C.LMS_GROUP_ID ,C.LMS_URL ,F.CLASS_EXAM_SEQ ,F.EXAM_TIME_CODE ,F.EXAM_DT ,F.EXAM_START_TIME ,F.EXAM_END_TIME ,F.FACILITY_ID ,F.CLASS_EXAM_TYPE ,F.COMBINED_EXAM ,C.START_DT ,C.END_DT ,C.HOLIDAY_SCHEDULE FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_TBL C , PS_INSTITUTION_TBL D , PS_HCR_PERSON_NM_I E , PS_CLASS_EXAM F WHERE A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.CLASS_SECTION = C.CLASS_SECTION AND C.INSTITUTION = B.INSTITUTION AND C.STRM = B.STRM AND C.ACAD_CAREER = B.ACAD_CAREER AND D.INSTITUTION = C.INSTITUTION AND %EffdtCheck(INSTITUTION_TBL D1, D, B.TERM_BEGIN_DT ) AND D.EFF_STATUS = 'A' AND A.EMPLID = E.EMPLID AND A.CRSE_ID = F.CRSE_ID AND A.CRSE_OFFER_NBR = F.CRSE_OFFER_NBR AND A.STRM = F.STRM AND A.SESSION_CODE = F.SESSION_CODE AND A.CLASS_SECTION = F.CLASS_SECTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 EFFDT Date(10) DATE Effective Date
8 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
9 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
10 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
11 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
12 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
13 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
14 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
15 CONTACT_MINUTES Number(4,0) SMALLINT NOT NULL Contact Minutes
16 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
17 TERM_BEGIN_DT Date(10) DATE Term Begin Date
18 TERM_END_DT Date(10) DATE Term Ending Date
19 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

20 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
CLN=Clinical
CON=Continuance
DIS=Discussion
FLD=Field Studies
IND=Independent Study
LAB=Laboratory
LEC=Lecture
PRA=Practicum
RSC=Research
SEM=Seminar
SUP=Supervision
THE=Thesis Research
TUT=Tutorial
21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
22 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
23 TERM_DESCR30 Character(30) VARCHAR2(30) NOT NULL Term
24 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution
25 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication
26 LMS_GROUP_ID Character(50) VARCHAR2(50) NOT NULL LMS group object id
27 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
28 CLASS_EXAM_SEQ Number(2,0) SMALLINT NOT NULL Class Exam Sequence Nbr
29 EXAM_TIME_CODE Character(8) VARCHAR2(8) NOT NULL Exam Time Code
30 EXAM_DT Date(10) DATE Exam Date
31 EXAM_START_TIME Time(15) TIMESTAMP Exam Starting Time
32 EXAM_END_TIME Time(15) TIMESTAMP Exam Ending Time
33 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
34 CLASS_EXAM_TYPE Character(4) VARCHAR2(4) NOT NULL Class Exam Type
FIN=Final Exam
MAK=Makeup of Final Exam
35 COMBINED_EXAM Character(1) VARCHAR2(1) NOT NULL Combined Exam
36 START_DT Date(10) DATE Start Date
37 END_DT Date(10) DATE end date
38 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule