SSR_CLASS_TBLV1(SQL View) |
Index Back |
---|---|
Class Table ViewThe Class Table View is a view of the Class Table for prompt selection based on Crse ID, Strm, Session |
SELECT A.CRSE_ID ,A.STRM ,A.SESSION_CODE ,A.CLASS_NBR ,A.CRSE_OFFER_NBR ,A.CLASS_SECTION ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.ACAD_GROUP ,A.ACAD_CAREER ,A.INSTITUTION ,A.SSR_COMPONENT ,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.SSR_DROP_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 ,A.CRS_TOPIC_ID ,A.SCHEDULE_PRINT FROM PS_CLASS_TBL A WHERE A.CLASS_TYPE = 'E' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
2 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
3 | 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 |
4 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
5 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
6 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
7 | TERM_ALT | Character(4) | VARCHAR2(4) NOT NULL |
Term Alternate Key
Prompt Table: TERM_TBL |
8 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
9 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
10 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Academic Group
Prompt Table: ACAD_GROUP_TBL |
11 | 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 |
12 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
13 | 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 |
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 | SSR_DROP_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 |
23 | ENRL_CAP | Number(4,0) | SMALLINT NOT NULL | Enrollment Capacity |
24 | WAIT_CAP | Number(4,0) | SMALLINT NOT NULL | Wait List Capacity |
25 | MIN_ENRL | Number(4,0) | SMALLINT NOT NULL | Minimum Enrollment Number |
26 | ENRL_TOT | Number(4,0) | SMALLINT NOT NULL | Enrollment Total |
27 | WAIT_TOT | Number(4,0) | SMALLINT NOT NULL | Wait List Total |
28 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
29 | CAMPUS_EVENT_NBR | Character(9) | VARCHAR2(9) NOT NULL | Event ID |
30 | ROOM_CAP_REQUEST | Number(4,0) | SMALLINT NOT NULL | Requested Room Capacity |
31 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
32 | STDNT_SPEC_PERM | Character(1) | VARCHAR2(1) NOT NULL | Student Specific Permissions |
33 | START_DT | Date(10) | DATE | Start Date |
34 | END_DT | Date(10) | DATE | end date |
35 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
36 | INSTRUCTION_MODE | Character(2) | VARCHAR2(2) NOT NULL | Instruction Mode |
37 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
38 | SCHEDULE_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Print
A=All N=No Y=Yes |