STDNT_ENRL_E_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. This is done to facilitate maintenance transactions from the enrollment section only.

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , A.CLASS_NBR , C.CLASS_NBR , C.CRSE_CAREER , C.SESSION_CODE , C.STDNT_ENRL_STATUS , C.ENRL_STATUS_REASON , C.UNT_TAKEN , C.CRSE_COUNT , C.OVRD_GRADING_BASIS , C.GRADING_BASIS_ENRL , C.CRSE_GRADE_OFF , C.CRSE_GRADE_INPUT , C.REPEAT_CODE , C.ASSOCIATED_CLASS , C.RQMNT_DESIGNTN , C.RQMNT_DESIGNTN_OPT , C.RQMNT_DESIGNTN_GRD , C.INSTRUCTOR_ID , C.DROP_CLASS_IF_ENRL , C.TSCRPT_NOTE_ID , C.TSCRPT_NOTE_EXISTS , C.DYN_CLASS_NBR , C.ACAD_PROG FROM PS_STDNT_ENRL A , PS_CLASS_TBL B , PS_STDNT_ENRL C , PS_CLASS_TBL D , PS_CLASS_ASSOC E WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.EMPLID = C.EMPLID AND A.ACAD_CAREER = C.ACAD_CAREER AND A.INSTITUTION = C.INSTITUTION AND A.STRM = C.STRM AND C.STRM = D.STRM AND C.CLASS_NBR = D.CLASS_NBR AND D.CRSE_ID = E.CRSE_ID AND D.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR AND D.STRM = E.STRM AND D.SESSION_CODE = E.SESSION_CODE AND D.ASSOCIATED_CLASS = E.ASSOCIATED_CLASS AND D.SSR_COMPONENT = E.SSR_COMPONENT AND B.CRSE_ID = D.CRSE_ID AND B.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND B.STRM = D.STRM AND B.SESSION_CODE = D.SESSION_CODE AND B.ASSOCIATED_CLASS = D.ASSOCIATED_CLASS AND B.CLASS_TYPE = 'E' AND ((B.SSR_COMPONENT <> D.SSR_COMPONENT) OR (B.SSR_COMPONENT = D.SSR_COMPONENT AND B.CLASS_NBR = D.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 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: CLASS_TBL_VW

6 CLASS_NBR_GRD Number(5,0) INTEGER NOT NULL Enrollment Class Nbr
7 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career

Default Value: CLASS_TBL_VW.ACAD_CAREER

8 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

Default Value: CLASS_TBL_VW.SESSION_CODE

9 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting

Default Value: E

10 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

11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
12 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
13 OVRD_GRADING_BASIS Character(1) VARCHAR2(1) NOT NULL Override Grading Basis
14 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

Prompt Table: %EDITTABLE

15 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

Prompt Table: GRADE_TBL_VW

16 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A

Prompt Table: GRADE_TBL_VW

17 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment

Prompt Table: REPEAT_CODE_TBL

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

Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS

19 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

20 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
21 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
N=Not Satisfied
S=Satisfied
22 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

Prompt Table: %EDITTABLE2

23 DROP_CLASS_IF_ENRL Number(5,0) INTEGER NOT NULL Drop This Class if Enrolled
24 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID

Prompt Table: TSCRPT_NOTE_TBL

25 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag

Y/N Table Edit

Default Value: N

26 DYN_CLASS_NBR Number(5,0) INTEGER NOT NULL Dynamic Class Nbr
27 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program