Create union of all undergrad students search

[kcrisman]

trafficstars

In the people search, it could be useful to search for all first-year, sophomore, etc. through senior, but excluding degree conferred. This would just be the union of those.

[russtuck]

Since "degree conferred" means they graduated, these people should probably be included in "Alumni" and not show up otherwise.

[kcrisman]

Since "degree conferred" means they graduated, these people should probably be included in "Alumni" and not show up otherwise.

That would be nice too, but technically is a slightly different request. I suspect the "degree conferred" people are still in the Registrar's system in some fashion, because they do eventually cycle off of that status, I've noticed.

[cpabbot]

These are both good points. We currently have "undergrad conferred" show up under students rather than alumni because they are still part of the Active Directory and not part of the alumni table; it might be worth adjusting the SQL query @Kevin-Chu58 and I worked on fixing during the summer to remove/select this specific case.

However, one benefit of having these students appear alongside all students is that current students looking for someone might forget whether someone has graduated yet and it is nice to have this small buffer built in. For example, it is handy to allow me to search for Nick N who just graduated from CS even though I am a student and technically not allowed to view alumni. Thoughts on this?

Benefit of adjusting this is cleanliness and consistency; downside is student functionality.

[kcrisman]

Agreed - that's why I suggest making a new category for "current enrolled undergrads" or something like that. That is public knowledge to some extent anyway - newspapers always ask colleges to confirm whether a certain person is currently enrolled and they usually comply with that, but no other information.

Message ID: @.***>

[bennettforkner]

Agreed - that's why I suggest making a new category for "current enrolled undergrads" or something like that. That is public knowledge to some extent anyway - newspapers always ask colleges to confirm whether a certain person is currently enrolled and they usually comply with that, but no other information.

This is not public knowledge and would violate FERPA restrictions. We are not authorized to confirm or deny whether a student attends school here unless they give us explicit permission to do so. Even then, it's just for the newspapers in their hometown.

[kcrisman]

Thanks, that's interesting. One often sees in national news that universities confirm this when someone is in trouble legally, and presumably they don't want that info public ... But obviously I'd defer to counsel on something like that.

Any other ideas on solving the practical matter here?

This is not public knowledge and violates FERPA restrictions. We are not authorized to confirm or deny whether a student attends school here unless they give us explicit permission to do so. Even then, it's just for the newspapers in their hometown.

[kcrisman]

Any other ideas on solving the practical matter here

By which I mean that being a freshman is already searchable without violating FERPA, so there should be a way to solve this.

[bennettforkner]

I'm not sure I fully understand who you're saying freshman are "searchable" to. There are a lot of intricacies as far as student data permissioning goes. Here's what I understand & @ChrisImagineer can weigh in if needed:

• Students
  • Can view other students who are not marked as "FERPA Private" (uncommon).
  • Can view facstaff information unless marked as private
  • Cannot view alumni
• Faculty/Staff
  • Can view basic student information & more specific info based on job role requirements (RAs, SFS, Police, etc.).
  • Can view extended information of advisees [I'm not sure that this is actually in practice for any data].
  • Can view other facstaff information unless marked as private
• Alumni
  • Can view facstaff information unless marked as private
  • Can view other alumni basic information
  • Cannot view active student information
• Public (unauthenticated, resigned facstaff, retired faculty, incoming students)
  • Cannot view any profile information for any account