STDNT_ENRL_W_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.

STDNT_ENRL_W_VW

(SQL View)

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 , B.CLASS_NBR , B.CRSE_ID , B.CRSE_OFFER_NBR , B.SESSION_CODE , A.STDNT_ENRL_STATUS , A.ASSOCIATED_CLASS , A.STDNT_POSITIN , B.SSR_COMPONENT 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 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
Prompt Table: CLASS_TBL_VW

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

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

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

11 STDNT_POSITIN Number(8,0) INTEGER NOT NULL Student Position

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	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	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
7	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
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	ASSOCIATED_CLASS	Number(4,0)	SMALLINT NOT NULL	Associated Class Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS
11	STDNT_POSITIN	Number(8,0)	INTEGER NOT NULL	Student Position
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