SSR_REQS_CLS_VW

(SQL View)
 Index Back

Requisite Class View

This view is used to search for classes that have requisites attached to either the class association or the course offering.

SELECT A.INSTITUTION ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.OPRID ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.CLASS_NBR ,A.ACAD_ORG ,A.ACAD_GROUP ,A.CAMPUS ,A.CRS_TOPIC_ID ,A.SSR_COMPONENT ,A.ACAD_CAREER ,A.DESCR ,A.RQRMNT_GROUP ,A.USE_CATLG_RQS ,A.RQRMNT_GROUP FROM PS_SSR_REQS_SRCH2 A

# 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_VAL_TBL

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

Default Value: OPR_DEF_TBL_CS.SUBJECT

Prompt Table: SUBJECT_TBL

4 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
5 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
6 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
9 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
10 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
11 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
12 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
13 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
14 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
15 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
16 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
17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
19 USE_CATLG_RQS Character(1) VARCHAR2(1) NOT NULL Also Use Catalog Requisite
20 SSR_RQRMNT_GRP2 Character(6) VARCHAR2(6) NOT NULL Requirement Group