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

STD_STAT_FL_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 EMPLID , INSTITUTION , ACAD_CAREER , STRM , STDNT_ENRL_STATUS , ENRL_STATUS_REASON , ENRL_DROP_DT FROM PS_STDNT_ENRL_SSVW WHERE GRADING_BASIS_ENRL <> 'NON'

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

3 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

4 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_TBL

5 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting
Default Value: E

6 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

7 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date

#	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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
3	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
4	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_TBL
5	STDNT_ENRL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Student Enrollment Status D=Dropped E=Enrolled W=Waiting Default Value: E
6	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
7	ENRL_DROP_DT	Date(10)	DATE	Enrollment Drop Date