CLASS_MTG_SE_VW

(SQL View)
 Index Back

Class Mtg Student Enrl View

This Class Table view is used for prompting in the Enrollment Request Panelgroup. Only Class Sections in Student Enrollment are selected.

SELECT b.emplid ,a.institution ,a.strm ,b.acad_career ,a.class_nbr ,a.session_code ,a.class_section ,a.acad_career ,b.stdnt_enrl_status ,b.sessn_enrl_cntl ,a.crse_id ,a.crse_offer_nbr ,c.meeting_time_start ,c.meeting_time_end ,c.start_dt ,c.end_dt ,c.mon ,c.tues ,c.wed ,c.thurs ,c.fri ,c.sat ,c.sun ,b.enrl_drop_dt FROM PS_CLASS_TBL a , ps_stdnt_enrl b , ps_class_mtg_pat c WHERE a.strm = b.strm AND a.class_nbr = b.class_nbr AND b.stdnt_enrl_status = 'E' AND a.crse_id = c.crse_id AND a.crse_offer_nbr = c.crse_offer_nbr AND a.strm = c.strm AND a.session_code = c.session_code AND a.class_section = c.class_section

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 STRM Character(4) VARCHAR2(4) NOT NULL Term

Default Value: STDNT_CAREER.STRM

Prompt Table: TERM_TBL

4 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
5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
6 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
7 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
8 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
9 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting
10 SESSN_ENRL_CNTL Character(3) VARCHAR2(3) NOT NULL Enrollment Control Session
11 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
12 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
13 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
14 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
15 START_DT Date(10) DATE Start Date
16 END_DT Date(10) DATE end date
17 MON Character(1) VARCHAR2(1) NOT NULL Monday
18 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
19 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
20 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
21 FRI Character(1) VARCHAR2(1) NOT NULL Friday
22 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
23 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
24 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date