SSR_FCSINTR_VW

(SQL View)
 Index Back

Instructor Class View

The Instructor Class View contains by instructor ID and term all the sections that that instructor teaches for the specified term.

SELECT DISTINCT A.STRM ,A.EMPLID ,D.CLASS_NBR ,B.TERM_BEGIN_DT ,D.ACAD_CAREER ,D.ACAD_GROUP ,D.SUBJECT ,D.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CRSE_OFFER_NBR ,A.CRSE_ID ,B.TERM_BEGIN_DT ,B.TERM_END_DT ,D.INSTITUTION ,D.SSR_COMPONENT ,D.ENRL_TOT ,B.DESCR ,E.DESCR ,D.START_DT ,D.END_DT ,D.LMS_PROVIDER ,D.LMS_GROUP_ID ,D.LMS_URL ,D.HOLIDAY_SCHEDULE ,D.DESCR FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_TBL D , PS_INSTITUTION_TBL E WHERE A.CRSE_ID = D.CRSE_ID AND A.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND A.STRM = D.STRM AND A.SESSION_CODE = D.SESSION_CODE AND A.CLASS_SECTION = D.CLASS_SECTION AND D.INSTITUTION = B.INSTITUTION AND D.STRM = B.STRM AND D.ACAD_CAREER = B.ACAD_CAREER AND E.INSTITUTION = D.INSTITUTION AND %EffdtCheck(INSTITUTION_TBL E1, E, B.TERM_BEGIN_DT) AND E.EFF_STATUS = 'A'

# 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 EFFDT Date(10) DATE Effective Date
5 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
6 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
8 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
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_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
12 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
13 TERM_BEGIN_DT Date(10) DATE Term Begin Date
14 TERM_END_DT Date(10) DATE Term Ending Date
15 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

16 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
17 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
18 TERM_DESCR30 Character(30) VARCHAR2(30) NOT NULL Term
19 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution
20 START_DT Date(10) DATE Start Date
21 END_DT Date(10) DATE end date
22 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication
23 LMS_GROUP_ID Character(50) VARCHAR2(50) NOT NULL LMS group object id
24 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
25 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
26 DESCR Character(30) VARCHAR2(30) NOT NULL Description