Versions Compared

Version Old Version 32 New Version Current
Changes made by

luis avila

luis avila

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

FAQs

  • What is the URL ??  
    https://sio.ucsd.edu/secure/people2/
  • Who do I contact if my credentials don't work ??
    siohelp@sio.ucsd.edu
  • Who do I contact if I can't find what I need and I am NOT in a hurry ??
    siohelp@sio.ucsd.edu
  • Who do I contact if I can't find what I need and I am in a hurry ??
    lavila@sio.ucsd.edu
  • What is the difference between the Search options ??
    Not much.  All 3 search the nickname field which is important.   The 'Jump To...' one is most limited and clicking on it will describe what criteria can be used.

...

          ISIS is the system through which UCSD student data can be viewed.   In near future we would like to pull undergraduate student data from here.     Similarly,  OGS is the office Office of graduate students Graduate Students and are the data stewards of graduate student data.  

...

 On fatlip (for now, 201505),  you can run the following commands:  

select * from people Where lname = 'HONGSHAN'   ( to acquire the people_id )

select * from people_values where people_id ='8915674'  ( to confirm record has values )

DELETE FROM people WHERE people_id ='8915674'   ( this should suffice to remove the record )

** DELETE FROM people_values WHERE people_id ='8915674'  ( this option was initially recommended by Tomo but Edgar said the removal from the 'People' table would propagate down to the 'People_values' table;  I'll confirm that tomorrow. )

 

 • Where are the values for fields: PI/Sponsor, Supervisor (TimeKeeping) and Advisor(s) ?? 

In table: people_relationships



Discussion Topics

1. Need to create a business process for newly hired faculty and staff  (i.e.  Ryan Hechinger, Anne Pommier )

...