SSR_REQS_PRR_VW

(SQL View)
 Index Back

PERC Action Student View

This view is used to select students who have been identified to have an action in the PERC process.

SELECT B.INSTITUTION , B.STRM , B.CLASS_NBR , B.EMPLID , B.ACAD_CAREER , A.SSR_REQS_STATUS , A.SSR_REQS_TYPE , B.ENRL_ACTN_RSN_LAST , B.ENRL_STATUS_REASON , B.STDNT_ENRL_STATUS , B.ENRL_DROP_DT , B.CRSE_GRADE_OFF , C.SSR_REQS_ACTION FROM PS_SSR_REQS_HEADR A ,PS_STDNT_ENRL B ,PS_SSR_REQS_ACTN C WHERE A.SSR_REQS_TYPE = 'P' AND (A.SSR_REQS_STATUS = 'C' OR A.SSR_REQS_STATUS = 'N') AND A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.INSTITUTION = B.INSTITUTION AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND B.ENRL_DROP_DT IS NULL AND A.EMPLID = C.EMPLID AND A.ACAD_CAREER = C.ACAD_CAREER AND A.INSTITUTION = C.INSTITUTION AND A.STRM = C.STRM AND A.CLASS_NBR = C.CLASS_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 STRM Character(4) VARCHAR2(4) NOT NULL Term
3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 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
6 SSR_REQS_STATUS Character(1) VARCHAR2(1) NOT NULL Post Enroll Reqs Status
C=Conditional
E=Enrollment Component
N=Not Satisfied
O=Overriden
P=Permitted
S=Satisfied
X=Unknown
7 SSR_REQS_TYPE Character(1) VARCHAR2(1) NOT NULL Requisite Record Type
E=Enrollment
P=Post Enrollment
8 ENRL_ACTN_RSN_LAST Character(4) VARCHAR2(4) NOT NULL Last Enrl Action Reason
9 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
10 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting
11 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date
12 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
13 SSR_REQS_ACTION Character(1) VARCHAR2(1) NOT NULL Drop / Approved
A=Approved
D=Drop Request