SSR_CLASS_TBLV1

(SQL View)
Index Back

Class Table View

The Class Table View is a view of the Class Table for prompt selection based on Crse ID, Strm, Session

SELECT A.CRSE_ID ,A.STRM ,A.SESSION_CODE ,A.CLASS_NBR ,A.CRSE_OFFER_NBR ,A.CLASS_SECTION ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.ACAD_GROUP ,A.ACAD_CAREER ,A.INSTITUTION ,A.SSR_COMPONENT ,A.ENRL_STAT ,A.CLASS_STAT ,A.CLASS_TYPE ,A.ASSOCIATED_CLASS ,A.AUTO_ENROLL_SECT_1 ,A.AUTO_ENROLL_SECT_2 ,A.RESECTION ,A.CONSENT ,A.SSR_DROP_CONSENT ,A.ENRL_CAP ,A.WAIT_CAP ,A.MIN_ENRL ,A.ENRL_TOT ,A.WAIT_TOT ,A.ACAD_ORG ,A.CAMPUS_EVENT_NBR ,A.ROOM_CAP_REQUEST ,A.DESCR ,A.STDNT_SPEC_PERM ,A.START_DT ,A.END_DT ,A.CAMPUS ,A.INSTRUCTION_MODE ,A.CRS_TOPIC_ID ,A.SCHEDULE_PRINT FROM PS_CLASS_TBL A WHERE A.CLASS_TYPE = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
2 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

3 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
4 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
5 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
6 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
7 TERM_ALT Character(4) VARCHAR2(4) NOT NULL Term Alternate Key

Prompt Table: TERM_TBL

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

Prompt Table: SUBJECT_TBL

9 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
10 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

Prompt Table: ACAD_GROUP_TBL

11 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
12 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

13 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
14 ENRL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status
C=Closed
O=Open
W=Wait List
15 CLASS_STAT Character(1) VARCHAR2(1) NOT NULL Class Status
A=Active
S=Stop Further Enrollment
T=Tentative Section
X=Cancelled Section
16 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
E=Enrollment Section
N=Non-Enrollment Section
17 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
18 AUTO_ENROLL_SECT_1 Character(4) VARCHAR2(4) NOT NULL 1st Auto Enroll Section
19 AUTO_ENROLL_SECT_2 Character(4) VARCHAR2(4) NOT NULL 2nd Auto Enroll Section
20 RESECTION Character(4) VARCHAR2(4) NOT NULL Resection to Section
21 CONSENT Character(1) VARCHAR2(1) NOT NULL Used by Course Catalog, Class Table, and Class Permissions.
D=Department Consent Required
I=Instructor Consent Required
N=No Special Consent Required
22 SSR_DROP_CONSENT Character(1) VARCHAR2(1) NOT NULL Used by Course Catalog, Class Table, and Class Permissions.
D=Department Consent Required
I=Instructor Consent Required
N=No Special Consent Required
23 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
24 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
25 MIN_ENRL Number(4,0) SMALLINT NOT NULL Minimum Enrollment Number
26 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
27 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
28 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
29 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
30 ROOM_CAP_REQUEST Number(4,0) SMALLINT NOT NULL Requested Room Capacity
31 DESCR Character(30) VARCHAR2(30) NOT NULL Description
32 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions
33 START_DT Date(10) DATE Start Date
34 END_DT Date(10) DATE end date
35 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
36 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode
37 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
38 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
A=All
N=No
Y=Yes