USC Undergraduate Advisement Database Committee Minutes

Summer Updates

Custom Report Rebuild

• In July, 27.5 hours
• More than double what was estimated!
  
  Holds
• Table can be updated
• Academic Status - will request that order is modified (more recent at top)
  
  Program owner
• Search all LAS students
  
  Reviewed other search examples based on discussion
• Referred or manually added majors - Search students who are not officially in major but added major/program tab (UNDL)
• Comments - Filter comments from all program tabs
  
  To Do
• Record Fixes and Corrections
• Post code clean up and inactive posts (students who were admitted and never enrolled)
• Line breaks to be added to comments and emails
• Multi column sort of student list
• Announcement emails - remove from advising history and add to separate tab
• General areas to focus on in Fall 2010 - Priority ranking (1-9) distributed at today’s meeting
  

Advisement database survey will be distributed to advisors after CAA Survey ends.

Perhaps at next CAA meeting, we can discuss how to better handle student crises.

Filter by Program Owner

Finding it tricky to keep your program filters up-to-date with new posts? The majors, minors, post code and program search fields require that you enter each program individually.

A new filter has been added for you to search for student programs based on the owning school instead of inputting each program separately. The new field is call Program Owner and is located under the ACADEMIC FIELDS section of the search field list.

Here's how it works: just enter the type of programs you are looking for (major, minor, etc.) and the SIS code for your school (LAS, ENGR, BUAD, etc.). For example:

major-LAS
major-LASN
major-BUAD, minor-BUAD

The first example will return all students with at least one major in the College. The second example will return all students with a major in any of the Natural Sciences within the College. And, the third example will return all students with a major or minor in Marshall.

A list of the SIS program owner codes for each school is provided below for your reference:
ACCT - Leventhal School of Accounting
ANSC - Annenberg School for Communication & Journalism
ARCH - School of Architecture
BUAD - Marshall School of Business
CNTV - School of Cinematic Arts
DENT - Ostrow School of Dentistry
EDUC - Rossier School of Education
ENGR - Viterbi School of Engineering
FA - Roski School of Fine Arts
GERO - Davis School of Gerontology
GRAD - The Graduate School
LAS - College of Letters, Arts & Sciences (all programs)
LASH - College of Letters, Arts & Sciences - Humanities
LASN - College of Letters, Arts & Sciences - Natural Sciences & Mathematics
LASO - College of Letters, Arts & Sciences - Other Programs (Undecided, Undeclared)
LASS - College of Letters, Arts & Sciences - Social Sciences
LAW - Gould School of Law
MED - Keck School of Medicine
MUS - Thornton School of Music
PHAR - School of Pharmacy
PPD - School of Policy, Planning, and Development
SOWK - School of Social Work
THTR - School of Theatre