RQ_CLS_ASN_SRCH(SQL View) |
Index Back |
---|---|
Rq Class Associations SearchClass Associations stores data relating to Associated Class Sections. Class Sections within the same Course ID, Course Offer Number, Term and Session are grouped by setting their Associated Class to the same number. Class Associations entries are created as Class Sections are Scheduled. |
SELECT CRSE_ID ,STRM ,ASSOCIATED_CLASS ,CRSE_OFFER_NBR ,SESSION_CODE ,UNITS_MINIMUM ,UNITS_MAXIMUM ,UNITS_ACAD_PROG ,GRADING_BASIS ,SSR_COMPONENT FROM PS_CLASS_ASSOC WHERE ASSOCIATED_CLASS <> 9999 |
# | 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 |
3 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL | Associated Class |
4 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
5 | 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 |
6 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
7 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |
8 | UNITS_ACAD_PROG | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Progress Units |
9 | GRADING_BASIS | Character(3) | VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading AUD=Audit BMT=Multi-Term Course: Not Graded CNC=Credit / No Credit EQV=Equivalent GRD=Graded HSC=Hundred Point Scale (NLD) LAW=Law MED=Medical School Grades NOG=No Grade Associated NON=Non-Graded Component NQF=NQF Scale OPT=Student Option PNP=Pass/Not Pass SUS=Satisfactory/Unsatisfactory TRN=Transfer Grading Basis TSC=Ten Point Scale (NLD) |
10 | 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 |