SAE_ADH_CLS2_VW

(SQL View)

SELECT CLS.institution ,CLS.strm ,CLS.class_nbr ,CLS.session_code ,CLS.acad_group ,CLS.subject ,CLS.catalog_nbr ,CLS.descr ,CLS.ssr_component ,CLS.class_section FROM %Table(class_tbl) CLS WHERE NOT EXISTS( SELECT ADH_SCTN .CLASS_NBR FROM %Table(SAE_ADH_SECTN) ADH_SCTN WHERE ADH_SCTN.INSTITUTION = CLS.INSTITUTION AND ADH_SCTN.STRM = CLS.STRM AND ADH_SCTN.CLASS_NBR = CLS.CLASS_NBR AND ADH_SCTN.SAE_MODE <> 'D')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term
Default Value: OPR_DEF_TBL_CS.STRM
Prompt Table: TERM_TBL

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

4 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

5 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
Default Value: OPR_DEF_TBL_CS.ACAD_GROUP
Prompt Table: ACAD_GROUP_TBL

6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
Default Value: OPR_DEF_TBL_CS.SUBJECT
Prompt Table: SUBJECT_TBL

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

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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 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 Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_TBL
3	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr
4	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
5	ACAD_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Academic Group Default Value: OPR_DEF_TBL_CS.ACAD_GROUP Prompt Table: ACAD_GROUP_TBL
6	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area Default Value: OPR_DEF_TBL_CS.SUBJECT Prompt Table: SUBJECT_TBL
7	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section