SSR_STENRLVWFL

(SQL View)
 Index Back

Stdnt Enroll Table View for FL

This Fluid Student Enrollment view is used to extract key enrollment information from the graded component into the enrollment section. This is done to facilitate maintenance transactions from the enrollment section only.

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , B.SUBJECT , B.CATALOG_NBR , B.CLASS_NBR , B.ASSOCIATED_CLASS , A.UNT_TAKEN , A.GRADING_SCHEME_ENR , A.GRADING_BASIS_ENRL , B.CLASS_TYPE , A.STDNT_ENRL_STATUS , A.ENRL_STATUS_REASON , B.SSR_COMPONENT , A.STDNT_POSITIN , A.CRSE_GRADE_INPUT , A.CRSE_GRADE_OFF , A.GRADE_POINTS , A.RQMNT_DESIGNTN , A.RQMNT_DESIGNTN_OPT , A.INSTRUCTOR_ID , B.CRSE_ID , B.CRSE_OFFER_NBR , B.SESSION_CODE , B.CLASS_SECTION , A.DYN_CLASS_NBR , A.ACAD_PROG , A.RELATE_CLASS_NBR_1 , A.RELATE_CLASS_NBR_2 , B.ACAD_CAREER , B.START_DT , B.END_DT , A.EARN_CREDIT , b.instruction_mode , A.ENRL_DROP_DT , A.ASSOCIATED_CLASS FROM PS_STDNT_ENRL A , PS_CLASS_TBL B WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR

# 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 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: CLASS_TBL_VW

8 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS

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 STDNT_POSITIN Number(8,0) INTEGER NOT NULL Student Position
17 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
18 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
19 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
20 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.
21 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
22 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
23 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
24 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
25 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
26 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
27 DYN_CLASS_NBR Number(5,0) INTEGER NOT NULL Dynamic Class Nbr
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
34 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
35 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode

Prompt Table: INSTRUCT_MODE

36 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date
37 SSR_ASSOC_CL_FL Number(4,0) SMALLINT NOT NULL Associated Class