ccle_getClasses
DRAFT – (these are unconfirmed speculations at this point)
Purpose
This stored procedure is used by Moodle’s course creator script to get the class information including description, course status, and url back to Registrar site for use on the class website.
Input Params
- TERM (Required) – (3 chars) 2 digit year, plus F, W, S or 1 for Summer, e.g. “09S” = 2009 Spring
- SRS (Required) – (9 digit) – SRS is unique numeric code for classes within a term.
Output
| name | estimated type/length | description |
| subj_area | CHAR (7) | Subject area abbreviation as defined by the registrar. |
| coursenum | CHAR (8) | Course number a.k.a. catalog number, display version, no leading zeros. e.g. "M115C " |
| sectnum | CHAR (6) | Section number, display version, no leading zeros |
| crsidx | CHAR (8) | Course number, index version, with leading zeros and prefixes C(oncurrent) or M(ultilisted) added at end. e.g. "0115C M " Spaces count. |
| classidx | CHAR (6) | Class number – new field used to combine all sections and activities. |
| secidx | CHAR (6) | Section number, index version, with leading zeros |
| secttype | VARCHAR (1) | Section Type P – Primary Section S – Secondary Section |
| srs | CHAR (9) | 9 digit number that along with term, uniquely identifies every course at UCLA. But only shows up in one table in SR2 so it’s less useful now. |
| term | CHAR (3) | Term, e.g. “09F” |
| division | CHAR (2) | Division, e.g. AA=Arts & Architecture, GS=, HU=Humanities, SS=Social Sciences, IS=,EN=Engineering |
| acttype | CHAR (3) | Activity Type – from Registrar’s Abbbreviations e.g. DIS – Discussion FLD – Field Studies LAB – Laboratory LEC – Lecture RGP – Research Group Meeting SEM – Seminar STU – Studio TUT – Tutorial |
| coursetitle | VARCHAR (254) | The course title describes the subject matter of the course. |
| sectiontitle | VARCHAR (240) | Some courses have subtitles or section titles which define a specific topic or focus for the course. |
| enrolstat | CHAR (1) | C – closed H – hold O – open W – waitlisted X – cancelled |
| session_group | CHAR (1) | Which Summer Session, or blank. A – Summer Session A B – Summer Session B C – Summer Session C |
| session | CHAR (2) | Session of the course i.e. RG = regular session. Used by Registrar’s Office internally to control events that are date based. |
| URL | VARCHAR (109) | Link to Registrar Class Listing website for this class |
| crs_desc | VARCHAR (1200) | Course official description. e.g. (Same as History M155.) Lecture, three hours; discussion, one hour (when scheduled). Designed for juniors/seniors. Social, economic, cultural , and political development of Los Angeles and its environs from time of its founding to present. Emphasis on diverse peoples of area, changing physica l environment, various interpretations of city, and Los Angeles’ place among American urban centers. P/NP or letter grading. |
Example
ccle_getClasses '09F','221009200'
| subj_area: | HIST |
| coursenum: | 1C |
| sectnum: | 1 |
| crsidx: | 0001C |
| classidx: | 001 |
| secidx: | 001 |
| secttype: | P |
| srs: | 221009200 |
| term: | 09F |
| division: | SS |
| acttype: | LEC |
| coursetitle: | Introduction to Western Civilization: Circa 1715 to Present |
| sectiontitle: | NULL |
| enrolstat: | H |
| session_group: | |
| session: | RG |
| URL: | http://www.registrar.ucla.edu/schedule/detselect.aspx?termsel=09F&subareasel=HIST&idxcrs=0001C |
| crs_desc: | Lecture, three hours; discussion, two hours. Broad, historical study of major elements in Western heritage from the world of the Greeks to that of the 20th century, designed to further beginning students’ general education, introduce them to ideas, attitudes, and institutions basic to W estern civilization, and acquaint them, through reading and critical discussion, with representative contemporary documents and writings of enduring in terest. P/NP or letter grading. |
