hu_facultyCourseStudentsGetAlpha2
DRAFT – (these are unconfirmed speculations at this point)
Input Params
- SRS (Required) – (9 digit) – SRS is unique numeric code for classes within a term. Specifying this parameter will return only that class roster. Note: This can be used to retrieve a specific discussion section roster.
- TERM (Required) – (3 chars) 2 digit year, plus F, W, S or 1 for Summer, e.g. “04S”= 2004 Spring
Example
- hu_facultyCourseStudentsGetAlpha2 ‘123456789’,‘09F’ – Returns roster for 2009 Fall for class or section with this SRS number in alpha order by student name.
Result
| name | estimated type/length | description |
| VARCHAR | Student e-mail address | |
| srs | CHAR (9) | SRS number given to the stored procedure |
| term | CHAR (3) | Term given to the stored procedure |
| uidStudent | CHAR (9) | Student UID |
| name | CHAR (70) | Student name in “LAST, FIRST MIDDLE” format |
| gradeType | CHAR (2) | Blank, SU, PN, … For complete list, see Grade Types List except LG (not on the list) might mean “letter grade”. |
| major | CHAR (8) | Major abbreviation |
| classification | 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 |
| status | 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 |
| pte | CHAR (8) | PTE number; "0 " if not used. |
| sect_no | CHAR (6) | Section Number. 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. |
| sect_no_l | CHAR (6) | Same as sect_no except the numeric part is zero-padded to have three digits, e.g. 001. |
| enrol_cap | INT (3) | Enrollment cap |
| bolid | VARCHAR | Student BOLID |
| StatReason | CHAR (1) | |
| LastUpdDt | INT (5) | |
| LastUpdTm | DECIMAL (5,2) | |
| SmrDrpRfnd | ||
| CollCd | 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 |
The result is sorted by full_name_person (ascending).
Note
This procedure takes 5-10 seconds to run and is much slower than other stored procedures that return class rosters.
