SSR_FCSCCL_SSV2

(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 STRM , EMPLID , CLASS_NBR , LAST_NAME_SRCH , FIRST_NAME_SRCH , NAME , EFFDT , ACAD_CAREER , ACAD_GROUP , SUBJECT , CATALOG_NBR , SESSION_CODE , CLASS_SECTION , CRSE_OFFER_NBR , CONTACT_MINUTES , CRSE_ID , CLASS_MTG_NBR , TERM_BEGIN_DT , TERM_END_DT , INSTITUTION , SSR_COMPONENT , DESCR , ENRL_TOT , TERM_DESCR30 , INSTITUTION_DESCR , MEETING_TIME_START , MEETING_TIME_END , FACILITY_ID , START_DT , END_DT , LMS_PROVIDER , LMS_GROUP_ID , LMS_URL , GRADE_RSTR_ACCESS FROM PS_INSTR_CLASS_VW

# 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 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
18 TERM_BEGIN_DT Date(10) DATE Term Begin Date
19 TERM_END_DT Date(10) DATE Term Ending Date
20 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

21 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
22 DESCR Character(30) VARCHAR2(30) NOT NULL Description
23 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
24 TERM_DESCR30 Character(30) VARCHAR2(30) NOT NULL Term
25 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution
26 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
27 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
28 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
29 START_DT Date(10) DATE Start Date
30 END_DT Date(10) DATE end date
31 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication
32 LMS_GROUP_ID Character(50) VARCHAR2(50) NOT NULL LMS group object id
33 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
34 GRADE_RSTR_ACCESS Character(1) VARCHAR2(1) NOT NULL Grade Roster Access
A=Approve
G=Grade
P=Post