SSR_CLS_TBL_RE

(SQL View)
 Index Back

Class Tbl Related Section View

This Class Table view is used as an edit table for the Related Class Number fields in the Enrollment Request Table. Only Class Sections with the same Course ID, Course Offer Number, Term, Session Code and Associated Class as the main enrollment Class Section are selected.

SELECT B.INSTITUTION ,B.STRM ,A.CLASS_NBR ,B.CLASS_NBR ,B.SUBJECT ,B.CATALOG_NBR ,B.SESSION_CODE ,B.CLASS_SECTION ,B.SSR_COMPONENT ,B.AUTO_ENROLL_SECT_1 ,B.AUTO_ENROLL_SECT_2 FROM PS_CLASS_TBL A , PS_CLASS_TBL B 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_TYPE <> 'E' AND (A.ASSOCIATED_CLASS = B.ASSOCIATED_CLASS OR A.ASSOCIATED_CLASS = 9999) AND A.CLASS_NBR <> B.CLASS_NBR AND A.SSR_COMPONENT <> B.SSR_COMPONENT AND B.CLASS_TYPE = 'E' AND B.SCHEDULE_PRINT = 'Y' AND B.CLASS_STAT = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

3 CLASS_NBR_REQ Number(5,0) INTEGER NOT NULL Class Nbr
4 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

Prompt Table: SUBJECT_TBL

6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
7 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
8 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
9 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
10 AUTO_ENROLL_SECT_1 Character(4) VARCHAR2(4) NOT NULL 1st Auto Enroll Section
11 AUTO_ENROLL_SECT_2 Character(4) VARCHAR2(4) NOT NULL 2nd Auto Enroll Section