CLASS_ASSOC_VW (SQL View)	Index Back
Class Search Assoc Vw Class Associations stores data relating to Associated Class Sections. Class Sections within the same Course ID, Course Offer Number, Term and Session are grouped by setting their Associated Class to the same number. Class Associations entries are created as Class Sections are Scheduled.

CLASS_ASSOC_VW

(SQL View)

Class Search Assoc Vw

Class Associations stores data relating to Associated Class Sections. Class Sections within the same Course ID, Course Offer Number, Term and Session are grouped by setting their Associated Class to the same number. Class Associations entries are created as Class Sections are Scheduled.

SELECT CRSE_ID , CRSE_OFFER_NBR , STRM , SESSION_CODE , ASSOCIATED_CLASS , GRADING_BASIS , RQMNT_DESIGNTN , CRSE_COUNT , UNITS_MINIMUM , UNITS_MAXIMUM , INSTRUCTOR_EDIT , SSR_COMPONENT FROM PS_CLASS_ASSOC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

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

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 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

6 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Prompt Table: GRADE_BASE_D_VW

7 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
Prompt Table: RQMNT_DESIG_TBL

8 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count

9 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units

10 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units

11 INSTRUCTOR_EDIT Character(2) VARCHAR2(2) NOT NULL Instructor Edit
C=Class Instructor Table Edit
I=Instructor/Advisor Table Edit
N=No Enrollment Choice

12 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
2	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
3	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
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	ASSOCIATED_CLASS	Number(4,0)	SMALLINT NOT NULL	Associated Class
6	GRADING_BASIS	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis ANC=ABC/NC Grading AUD=Audit BMT=Multi-Term Course: Not Graded CNC=Credit / No Credit EQV=Equivalent GRD=Graded HSC=Hundred Point Scale (NLD) LAW=Law MED=Medical School Grades NOG=No Grade Associated NON=Non-Graded Component NQF=NQF Scale OPT=Student Option PNP=Pass/Not Pass SUS=Satisfactory/Unsatisfactory TRN=Transfer Grading Basis TSC=Ten Point Scale (NLD) Prompt Table: GRADE_BASE_D_VW
7	RQMNT_DESIGNTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement. Prompt Table: RQMNT_DESIG_TBL
8	CRSE_COUNT	Number(5,2)	DECIMAL(4,2) NOT NULL	Course Count
9	UNITS_MINIMUM	Number(6,2)	DECIMAL(5,2) NOT NULL	Minimum Units
10	UNITS_MAXIMUM	Number(6,2)	DECIMAL(5,2) NOT NULL	Maximum Units
11	INSTRUCTOR_EDIT	Character(2)	VARCHAR2(2) NOT NULL	Instructor Edit C=Class Instructor Table Edit I=Instructor/Advisor Table Edit N=No Enrollment Choice
12	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