CIS_ROSTER_CLASS
DRAFT – (these are unconfirmed speculations at this point)
Input Params
- TERM (Required) – (3 chars) 2 digit year, plus F, W, S or 1 for Summer, e.g. “09S” = 2009 Spring
- SUBJECTAREA (Required) – Subject area abbreviation as defined by the registrar
- COURSENUM (Required) – Course number a.k.a. catalog number
- CLASSNUM (Required) – Class number (note this is different from Section Number)
Examples
- CIS_ROSTER_CLASS @term=‘09F’, @sa=‘Anthro ’, @cn=’0008 ‘, @cls=’ 001 ’ – Returns roster for 2009 Fall Anthro 8 class #1. A row will be returned for each student and each section the student is enrolled in.
Result
| name | estimated type/length | description |
| term_cd | CHAR (3) | Term, e.g. “09F” |
| stu_id | CHAR (9) | Student UID |
| full_name_person | CHAR (70) | Name of the student in “LAST, FIRST MIDDLE” format |
| stu_grd_typ_cd | CHAR (2) | AU – Course Audited (No Grade) LG – Letter Grade LN – Law Numeric NG – Non-Graded Section PN – Pass/Not Pass PU – Pass/Unsatisfactory/No Credit (Law) SU – Satisfactory/Unsatisfactory For [SR1] complete list, see Grade Types List except LG (not on the list) might mean “letter grade”. |
| stu_crs_atm_unt | DECIMAL (1,1) | Number of units for the class. Can be blank for non-graded sections. |
| ses_cd | CHAR (2) | Two character session code. RG for almost all classes in fall, winter, spring terms. Various other values during summer terms to describe things like Session A 10-week or 6-week or Session C or Session B for off-campus instruction. |
| enrl_stat_cd | CHAR (1) | Enrol status. For regular students: E – enrolled D – Dropped W – Wait List H – Held For UNEX students: A – Approved C – Cancelled P – Pending |
| srs_crs_no | CHAR (9) | SRS number of the course (actually the section of the course). |
| subj_area_cd | CHAR (7) | Subject area abbreviation |
| crs_catlg_no | CHAR (8) | Catalog number (course number). |
| sect_no | CHAR (6) | Section Number. The numeric part is zero-padded to have three digits, e.g. 001. Primary sections are always numeric only, and discussion sections have a letter afterwards, e.g. 001A, 001B…001Z. Note: Since students enroll through the discussion section, the section number is for the one they are enrolled in. |
| coll_cd | CHAR (2) | College or school that the student is in, e.g. LS: College of Letters and Science, EN: School of Engineering and Applied Science |
| deg_cd | CHAR (4) | |
| major_cd | CHAR (4) | Major code, zero padded to be 4 characters long, e.g. “0201”; “0000” for undecided |
| classif_cd | CHAR (3) | Student classification: UFR – Undergraduate Freshman USO – Undergraduate Sophomore UJR – Undergraduate Junior USR – Undergraduate Senior UNC – ?? UGE – ?? GNC – ?? GMT – Masters Program GMD – MA/MS Leading to Doctorate GD1 – Graduate Doctoral 1 GD2 – Graduate Doctoral 2 |
| ss_email_addr | VARCHAR | Student e-mail address. |
| pte_no | Random number as a mechanism for enrolling wait listed students. Has no meaning once they’re enrolled. | |
| pte_no_used_dt | ||
| enrl_stat_tstmp | CHAR (23) | e.g. 2009-07-24 09:03:32.687 What do the last 4 characters mean? (.687) |
| career_cd | CHAR (1) | |
| career_sufx_cd | CHAR (1) | |
| level_code | CHAR (2) | |
| ug_deg_exp_term_cd | CHAR (3) | Degree expected term; can be blank |
| major_name | CHAR (60) | Major name |
The result is unsorted.
