CLASS_TBL_SE_VW(SQL View) |
Index Back |
---|---|
Class Table Student Enrl ViewThis Class Table view is used for prompting in the Enrollment Request Panelgroup. Only Class Sections in Student Enrollment are selected. |
SELECT B.EMPLID ,B.ACAD_CAREER ,A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.ACAD_GROUP ,A.SUBJECT ,A.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.ACAD_CAREER ,A.SSR_COMPONENT ,A.ENRL_CAP ,A.ENRL_TOT ,A.DESCR ,B.GRADING_BASIS_ENRL ,B.MANDATORY_GRD_BAS ,B.UNT_TAKEN ,B.UNT_BILLING ,B.UNT_PRGRSS ,B.STDNT_ENRL_STATUS ,B.ASSOCIATED_CLASS ,A.CRSE_ID ,B.ENRL_STATUS_REASON ,B.RSRV_CAP_NBR ,B.SESSN_ENRL_CNTL ,B.CRSE_GRADE_INPUT ,B.CRSE_GRADE_OFF ,B.GRD_PTS_PER_UNIT ,B.AUDIT_GRADE_BASIS ,B.EARN_CREDIT ,B.INCLUDE_IN_GPA ,B.UNITS_ATTEMPTED ,B.GRADE_POINTS ,B.GRADE_POINTS_FA ,B.ENRL_ADD_DT ,A.CRSE_OFFER_NBR ,A.CRS_TOPIC_ID ,A.EQUIV_CRSE_ID ,A.OVRD_CRSE_EQUIV_ID ,A.START_DT ,A.END_DT ,A.CLASS_TYPE ,B.RQMNT_DESIGNTN ,B.RQMNT_DESIGNTN_OPT ,B.RQMNT_DESIGNTN_GRD ,B.INSTRUCTOR_ID ,B.CRSE_COUNT ,B.TSCRPT_NOTE_ID ,B.TSCRPT_NOTE_EXISTS ,B.CLASS_PRMSN_NBR ,B.REPEAT_CANDIDATE ,B.REPEAT_CODE ,B.ENRL_ACTN_RSN_LAST ,B.UNT_PRGRSS_FA ,B.NOTIFY_STDNT_CHNG ,B.DROP_CLASS_IF_ENRL ,A.STDNT_SPEC_PERM ,B.ENRL_ACTION_LAST ,B.STDNT_POSITIN ,B.DYN_CLASS_NBR ,A.LOCATION ,A.CAMPUS ,B.UNT_EARNED ,B.GRADING_BASIS_DT ,B.ENRL_DROP_DT ,B.GRADE_DT ,A.COMBINED_SECTION ,B.SEL_GROUP ,B.ASSOCIATION_99 ,B.ENRL_REQ_SOURCE ,B.LAST_ENRL_DT_STMP ,B.LAST_ENRL_TM_STMP ,B.ACAD_PROG FROM PS_CLASS_TBL A , PS_STDNT_ENRL 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 |
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
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 |
6 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Academic Group
Prompt Table: ACAD_GROUP_TBL |
7 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
8 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
9 | 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 |
10 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
11 | CRSE_CAREER | Character(4) | VARCHAR2(4) NOT NULL | Course Career |
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 |
13 | ENRL_CAP | Number(4,0) | SMALLINT NOT NULL | Enrollment Capacity |
14 | ENRL_TOT | Number(4,0) | SMALLINT NOT NULL | Enrollment Total |
15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
16 | GRADING_BASIS_ENRL | Character(3) | VARCHAR2(3) NOT NULL | Grading Basis |
17 | MANDATORY_GRD_BAS | Character(1) | VARCHAR2(1) NOT NULL | Mandatory Grading Basis |
18 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
19 | UNT_BILLING | Number(6,2) | DECIMAL(5,2) NOT NULL | Billing Units |
20 | UNT_PRGRSS | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken-Academic Progress |
21 | STDNT_ENRL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Student Enrollment Status
D=Dropped E=Enrolled W=Waiting |
22 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL | Associated Class |
23 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
24 | 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 |
25 | RSRV_CAP_NBR | Number(3,0) | SMALLINT NOT NULL | Reserve Capacity Sequence |
26 | SESSN_ENRL_CNTL | Character(3) | VARCHAR2(3) NOT NULL | Enrollment Control Session |
27 | CRSE_GRADE_INPUT | Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A |
28 | CRSE_GRADE_OFF | Character(3) | VARCHAR2(3) NOT NULL | Official Grade |
29 | GRD_PTS_PER_UNIT | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points Per Unit |
30 | AUDIT_GRADE_BASIS | Character(1) | VARCHAR2(1) NOT NULL | Audit Grading Basis |
31 | EARN_CREDIT | Character(1) | VARCHAR2(1) NOT NULL | Earn Credit |
32 | INCLUDE_IN_GPA | Character(1) | VARCHAR2(1) NOT NULL | Include in GPA |
33 | UNITS_ATTEMPTED | Character(1) | VARCHAR2(1) NOT NULL |
Units Attempted
I=In Progress N=No Y=Yes |
34 | GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points |
35 | GRADE_POINTS_FA | Number(10,3) | DECIMAL(9,3) NOT NULL | Financial Aid Grade Points |
36 | ENRL_ADD_DT | Date(10) | DATE | Enrollment Add Date |
37 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
38 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
39 | EQUIV_CRSE_ID | Character(5) | VARCHAR2(5) NOT NULL | Equivalent Course Group |
40 | OVRD_CRSE_EQUIV_ID | Character(1) | VARCHAR2(1) NOT NULL | Override Equivalent Course |
41 | START_DT | Date(10) | DATE | Start Date |
42 | END_DT | Date(10) | DATE | end date |
43 | CLASS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Class Type
E=Enrollment Section N=Non-Enrollment Section |
44 | RQMNT_DESIGNTN | Character(4) | VARCHAR2(4) NOT NULL | This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement. |
45 | RQMNT_DESIGNTN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Requirement Designation Option
N=No Y=Yes |
46 | RQMNT_DESIGNTN_GRD | Character(1) | VARCHAR2(1) NOT NULL |
Requirement Designation Grade
N=Not Satisfied S=Satisfied |
47 | INSTRUCTOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Instructor ID |
48 | CRSE_COUNT | Number(5,2) | DECIMAL(4,2) NOT NULL | Course Count |
49 | TSCRPT_NOTE_ID | Character(4) | VARCHAR2(4) NOT NULL | Transcript Note ID |
50 | TSCRPT_NOTE_EXISTS | Character(1) | VARCHAR2(1) NOT NULL | Transcript Note Exists Flag |
51 | CLASS_PRMSN_NBR | Number(6,0) | INTEGER NOT NULL | Class Permission Nbr |
52 | REPEAT_CANDIDATE | Character(1) | VARCHAR2(1) NOT NULL | Repeat Candidate Flag |
53 | REPEAT_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Repeat Code
NTEA=No Taking Exam/Assessment |
54 | ENRL_ACTN_RSN_LAST | Character(4) | VARCHAR2(4) NOT NULL | Last Enrl Action Reason |
55 | UNT_PRGRSS_FA | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken-Fin Aid Progress |
56 | NOTIFY_STDNT_CHNG | Character(2) | VARCHAR2(2) NOT NULL |
Notify Student of Change
DP=Dropped/Class Canceled WE=Enrolled From WaitList WL=WaitList Status Change |
57 | DROP_CLASS_IF_ENRL | Number(5,0) | INTEGER NOT NULL | Drop This Class if Enrolled |
58 | STDNT_SPEC_PERM | Character(1) | VARCHAR2(1) NOT NULL | Student Specific Permissions |
59 | ENRL_ACTION_LAST | Character(2) | VARCHAR2(2) NOT NULL | Last Enrollment Action |
60 | STDNT_POSITIN | Number(8,0) | INTEGER NOT NULL | Student Position |
61 | DYN_CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Dynamic Class Nbr |
62 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
63 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
64 | UNT_EARNED | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Earned |
65 | GRADING_BASIS_DT | Date(10) | DATE | Grading Basis Date |
66 | ENRL_DROP_DT | Date(10) | DATE | Enrollment Drop Date |
67 | GRADE_DT | Date(10) | DATE | Grade Date |
68 | COMBINED_SECTION | Character(1) | VARCHAR2(1) NOT NULL |
Combined Section
C=Combined Section S=Combined Section Skip Mtg Pat |
69 | SEL_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Tuition Group |
70 | ASSOCIATION_99 | Character(1) | VARCHAR2(1) NOT NULL | Association 99 |
71 | ENRL_REQ_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Enrollment Request Source
CR=Class Roll E=Enrollment Request EN=Enrollment FE=Fluid Cls Srch Enrl non-SFF FF=Fluid Cls Srch Enrl SFF FS=Fluid Self Service SFF FX=Fluid Self Service non-SFF IL=Grade Lapse ME=Mass Enrollment PB=Post Enrl Req Chk Batch PD=Req Chk Drop Online PO=Post Enrl Req Chk Online PX=Req Chk Drop Batch QE=Quick Enroll SE=Self-Service Enrollment SF=Student Financials Batch SG=Self Service Grade Posting TA=Test Administration (NLD) WD=Term Withdrawal Engine WL=Wait List Engine |
72 | LAST_ENRL_DT_STMP | Date(10) | DATE | Last Enrollment Date Stamp |
73 | LAST_ENRL_TM_STMP | Time(15) | TIMESTAMP | Last Enrollment Time Stamp |
74 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |