SSR_CLS_TBL_R0 (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.

SSR_CLS_TBL_R0

(SQL View)

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.SSR_COMPONENT ,B.CLASS_NBR ,B.SUBJECT ,B.CATALOG_NBR ,B.SESSION_CODE ,B.CLASS_SECTION 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_NBR <> B.CLASS_NBR AND (B.ASSOCIATED_CLASS = 9999 OR A.ASSOCIATED_CLASS = B.ASSOCIATED_CLASS) AND B.CLASS_SECTION <> A.AUTO_ENROLL_SECT_1 AND B.CLASS_SECTION <> A.AUTO_ENROLL_SECT_2 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 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

5 RELATE_CLASS_NBR Number(5,0) INTEGER NOT NULL Related Class Nbr

6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
Prompt Table: SUBJECT_TBL

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

8 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

9 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section

#	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	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
5	RELATE_CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Related Class Nbr
6	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area Prompt Table: SUBJECT_TBL
7	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
8	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
9	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section