Item No. I
Curricular Groups Member display on SIO Mega (specific to Physical Oceanographers):
https://scripps.ucsd.edu/testemilik
***reference attachment for logic
Proposed People DB instructions to data stewards If Emeritus / Mentor (i.e. interacts with students)
Display Title: Emeritus
SIO Status - one of the following:
RTAD
RTAD PENDING
RETIRED
Question for Web Committee: Where should these folks maintain web visibility?:
Scripps Scholars
Scripps Profile
People Directory
Curricular Groups Member display
Additional question for Web Committee: What’s the protocol if member requests to not be listed?
Do we maintain web visibility for some and/or all of the following:
Scripps Scholars
Scripps Profile
People Directory
Curricular Groups Member display
Item No. II
Propose setting up a MySql view using stored procedures
MySql view is good for selecting results but you can’t alter data
Stored procedures are similar to functions - i.e. you can alter the data
Attachments:
