SSR_ENRL_DTL_VW

(SQL View)
Index Back

Student Enrollment Table View

This Student Enrollment view is used to extract key enrollment information from the graded component into the enrollment section.

SELECT DISTINCT a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.STRM , a.SUBJECT , a.CATALOG_NBR , a.ASSOCIATED_CLASS , a.CLASS_NBR , b.UNT_TAKEN , b.GRADING_SCHEME_ENR , b.GRADING_BASIS_ENRL , a.CLASS_TYPE , a.STDNT_ENRL_STATUS , a.ENRL_STATUS_REASON , a.SSR_COMPONENT , a.DESCR , a.STDNT_POSITIN , b.CRSE_GRADE_INPUT , b.CRSE_GRADE_OFF , b.GRADE_POINTS , b.INSTRUCTOR_ID , b.RQMNT_DESIGNTN , b.RQMNT_DESIGNTN_OPT , a.CRSE_ID , a.CRSE_OFFER_NBR , a.SESSION_CODE , a.CLASS_SECTION , a.ACAD_PROG , A.RELATE_CLASS_NBR_1 , A.RELATE_CLASS_NBR_2 , A.CRSE_CAREER , A.START_DT , A.END_DT FROM PS_STDNT_ENRL_SSVW a , PS_STDNT_ENRL_SSVW b WHERE a.EMPLID=b.EMPLID AND a.ACAD_CAREER = b.ACAD_CAREER AND a.INSTITUTION = b.INSTITUTION AND a.STRM = b.STRM AND a.SUBJECT = b.SUBJECT AND a.CATALOG_NBR = b.CATALOG_NBR AND a.ASSOCIATED_CLASS = b.ASSOCIATED_CLASS AND ((a.SSR_COMPONENT <> b.SSR_COMPONENT) OR (a.SSR_COMPONENT = b.SSR_COMPONENT AND a.CLASS_NBR = b.CLASS_NBR)) AND a.CLASS_TYPE = 'E' AND a.SESSION_CODE = b.SESSION_CODE AND b.SSR_COMPONENT = ( SELECT c.SSR_COMPONENT FROM PS_CLASS_ASSOC c WHERE c.CRSE_ID = b.CRSE_ID AND c.CRSE_OFFER_NBR = b.CRSE_OFFER_NBR AND c.STRM = b.STRM AND c.SESSION_CODE = b.SESSION_CODE AND c.ASSOCIATED_CLASS = b.ASSOCIATED_CLASS)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 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

Prompt Table: STDNT_CAREER

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Prompt Table: TERM_TBL

5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
7 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS

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

Prompt Table: CLASS_TBL_VW

9 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
10 GRADING_SCHEME_ENR Character(3) VARCHAR2(3) NOT NULL Grading Scheme
11 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

Prompt Table: GRADE_BASIS_VW1

12 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
E=Enrollment Section
N=Non-Enrollment Section
13 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting

Default Value: E

14 ENRL_STATUS_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Status Reason
ADRP=Administrative Drop
ALIM=Appointment Limit Exceeded
CANC=Dropped (class cancelled)
CREQ=Co-Requisite Enrollment
DROP=Dropped (was enrolled)
DRWL=Dropped (was wait listed)
ENRL=Enrolled
EWAT=Enrolled from Wait List
FULL=Section is Full
RCAP=Reserve Slots Full
RCMP=Related Component
SLIM=Session Limit Exceeded
TIME=Time Conflict Exsists
TIMR=Time Conflict Resolved
TLIM=Term Limit Exceeded
WDRW=Withdrawn from Class

Default Value: ENRL

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 STDNT_POSITIN Number(8,0) INTEGER NOT NULL Student Position
18 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
19 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
20 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
21 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
22 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.
23 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
24 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

Prompt Table: CRSE_CATALOG

25 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
26 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
27 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
28 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
29 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1
30 RELATE_CLASS_NBR_2 Number(5,0) INTEGER NOT NULL Related Class Number 2
31 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
32 START_DT Date(10) DATE Start Date
33 END_DT Date(10) DATE end date