CLASS_TBL_VW7(SQL View) |
Index Back |
---|---|
Class Table ViewThe Class Table View is a view of the Class Table. It is used for displaying related class information in the Enrolment Request panel. |
SELECT A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.ACAD_GROUP ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.ACAD_CAREER ,A.SSR_COMPONENT ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.ENRL_STAT ,A.CLASS_STAT ,A.CLASS_TYPE ,A.ASSOCIATED_CLASS ,A.AUTO_ENROLL_SECT_1 ,A.AUTO_ENROLL_SECT_2 ,A.RESECTION ,A.CONSENT ,A.ENRL_CAP ,A.WAIT_CAP ,A.MIN_ENRL ,A.ENRL_TOT ,A.WAIT_TOT ,A.ACAD_ORG ,A.CAMPUS_EVENT_NBR ,A.ROOM_CAP_REQUEST ,A.DESCR ,A.STDNT_SPEC_PERM ,A.START_DT ,A.END_DT ,A.CAMPUS ,A.INSTRUCTION_MODE FROM PS_CLASS_TBL A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
3 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
4 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Academic Group
Default Value: OPR_DEF_TBL_CS.ACAD_GROUP Prompt Table: ACAD_GROUP_TBL |
5 | TERM_ALT | Character(4) | VARCHAR2(4) NOT NULL |
Term Alternate Key
Default Value: STDNT_CAREER.STRM Prompt Table: TERM_TBL |
6 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Default Value: OPR_DEF_TBL_CS.SUBJECT Prompt Table: SUBJECT_TBL |
7 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
8 | 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 |
9 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
10 | 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 |
11 | 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 |
12 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
13 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
14 | ENRL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Status
C=Closed O=Open W=Wait List |
15 | CLASS_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Class Status
A=Active S=Stop Further Enrollment T=Tentative Section X=Cancelled Section |
16 | CLASS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Class Type
E=Enrollment Section N=Non-Enrollment Section |
17 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL | Associated Class |
18 | AUTO_ENROLL_SECT_1 | Character(4) | VARCHAR2(4) NOT NULL | 1st Auto Enroll Section |
19 | AUTO_ENROLL_SECT_2 | Character(4) | VARCHAR2(4) NOT NULL | 2nd Auto Enroll Section |
20 | RESECTION | Character(4) | VARCHAR2(4) NOT NULL | Resection to Section |
21 | CONSENT | Character(1) | VARCHAR2(1) NOT NULL |
Used by Course Catalog, Class Table, and Class Permissions.
D=Department Consent Required I=Instructor Consent Required N=No Special Consent Required |
22 | ENRL_CAP | Number(4,0) | SMALLINT NOT NULL | Enrollment Capacity |
23 | WAIT_CAP | Number(4,0) | SMALLINT NOT NULL | Wait List Capacity |
24 | MIN_ENRL | Number(4,0) | SMALLINT NOT NULL | Minimum Enrollment Number |
25 | ENRL_TOT | Number(4,0) | SMALLINT NOT NULL | Enrollment Total |
26 | WAIT_TOT | Number(4,0) | SMALLINT NOT NULL | Wait List Total |
27 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
28 | CAMPUS_EVENT_NBR | Character(9) | VARCHAR2(9) NOT NULL | Event ID |
29 | ROOM_CAP_REQUEST | Number(4,0) | SMALLINT NOT NULL | Requested Room Capacity |
30 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
31 | STDNT_SPEC_PERM | Character(1) | VARCHAR2(1) NOT NULL | Student Specific Permissions |
32 | START_DT | Date(10) | DATE | Start Date |
33 | END_DT | Date(10) | DATE | end date |
34 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
35 | INSTRUCTION_MODE | Character(2) | VARCHAR2(2) NOT NULL | Instruction Mode |