search

gordon-cs / gordon-360-ui

Gordon 360 User Interface
https://360.gordon.edu
16 stars 14 forks source link

Create union of all undergrad students search #1425

Open kcrisman opened 2 years ago

kcrisman commented 2 years ago

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 commented 2 years ago

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

kcrisman commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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: