SSR_INSTR_EXAM

(SQL View)
 Index Back

Instructor Exam Schedule


SELECT DISTINCT A.EMPLID , B.STRM , B.CLASS_NBR , C.CLASS_EXAM_SEQ , C.EXAM_DT , C.EXAM_START_TIME , C.EXAM_END_TIME , C.FACILITY_ID , C.CLASS_EXAM_TYPE , C.COMBINED_EXAM , B.SUBJECT , B.CATALOG_NBR , B.CLASS_SECTION , B.DESCR , B.SSR_COMPONENT , B.START_DT , B.END_DT , B.INSTITUTION , B.HOLIDAY_SCHEDULE , B.ENRL_TOT FROM PS_CLASS_INSTR A , PS_CLASS_TBL B , PS_CLASS_EXAM C WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND B.CRSE_ID = C.CRSE_ID AND B.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND B.STRM = C.STRM AND B.SESSION_CODE = C.SESSION_CODE AND B.CLASS_SECTION = C.CLASS_SECTION

# 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 STRM Character(4) VARCHAR2(4) NOT NULL Term
3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 CLASS_EXAM_SEQ Number(2,0) SMALLINT NOT NULL Class Exam Sequence Nbr
5 EXAM_DT Date(10) DATE NOT NULL Exam Date
6 EXAM_START_TIME Time(15) TIMESTAMP NOT NULL Exam Starting Time
7 EXAM_END_TIME Time(15) TIMESTAMP NOT NULL Exam Ending Time
8 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID

Prompt Table: FACILITY_TBL

9 CLASS_EXAM_TYPE Character(4) VARCHAR2(4) NOT NULL Class Exam Type
FIN=Final Exam
MAK=Makeup of Final Exam
10 COMBINED_EXAM Character(1) VARCHAR2(1) NOT NULL Combined Exam

Y/N Table Edit

11 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

Default Value: CRSE_OFFER.SUBJECT

12 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

Default Value: CRSE_OFFER.CATALOG_NBR

13 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
14 DESCR Character(30) VARCHAR2(30) NOT NULL Description

Default Value: CRSE_CATALOG.DESCR

15 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

Prompt Table: %EDITTABLE2

16 START_DT Date(10) DATE NOT NULL Start Date

Default Value: SESSION_TBL.SESS_BEGIN_DT

17 END_DT Date(10) DATE NOT NULL end date

Default Value: SESSION_TBL.SESS_END_DT

18 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
19 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
20 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total