SSR_VB_ENR_VW

(SQL View)
 Index Back

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , A.CLASS_NBR , B.CATALOG_NBR ,B.SUBJECT , B.CLASS_SECTION , B.START_DT , B.END_DT , A.STDNT_ENRL_STATUS , A.ENRL_STATUS_REASON , A.REPEAT_CODE , A.CRSE_GRADE_INPUT , A.GRADING_BASIS_ENRL , A.ENRL_DROP_DT , A.LAST_UPD_DT_STMP , A.UNT_TAKEN , B.INSTRUCTION_MODE , C.ACAD_PROG_PRIMARY , ( SELECT D.LOCATION FROM PS_LOCATION_TBL D WHERE D.LOCATION=B.LOCATION AND D.SETID=A.INSTITUTION AND D.EFFDT=( SELECT MAX(D1.EFFDT) FROM PS_LOCATION_TBL D1 WHERE D1.SETID=D.SETID AND D1.LOCATION=D.LOCATION AND D1.EFFDT<=%CurrentDateIn)) AS LOC , ( SELECT D.POSTAL FROM PS_LOCATION_TBL D WHERE D.LOCATION=B.LOCATION AND D.SETID=A.INSTITUTION AND D.EFFDT=( SELECT MAX(D1.EFFDT) FROM PS_LOCATION_TBL D1 WHERE D1.SETID=D.SETID AND D1.LOCATION=D.LOCATION AND D1.EFFDT<=%CurrentDateIn)) AS POSTAL FROM %Table(STDNT_ENRL) A , %Table(CLASS_TBL) B ,%Table(STDNT_CAR_TERM) C WHERE A.STRM=B.STRM AND A.CLASS_NBR=B.CLASS_NBR AND A.CRSE_CAREER=B.ACAD_CAREER AND A.INSTITUTION=B.INSTITUTION AND C.INSTITUTION=A.INSTITUTION AND C.ACAD_CAREER=A.ACAD_CAREER AND C.EMPLID= A.EMPLID AND C.STRM=A.STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
4 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
8 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
9 START_DT Date(10) DATE Start Date
10 END_DT Date(10) DATE end date
11 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting
12 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
13 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment
14 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
15 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
16 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date
17 LAST_UPD_DT_STMP Date(10) DATE Last Update Date Stamp
18 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
19 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode
20 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
21 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal