I. ESTABLISHED:
...
2. Lal, Devendra : seeking further clarification. His record was never updated by HR - all updates were automated in PeopleDB via campus uploads. Currently doesn't have an sio_role and UCSD status is 'Active' via an apparent 'override':
| 6134507 | UPDATE | pps_status | Separated |Active | Y | 365 |
Ed Fireman : had sio_status set to 'Deceased' by Michelle Park in October 2013. In October 2014, Tomo changed UCSD_Status from 'Active' to 'Separated'
...
.
| Do not list in directory. Include link in obituary notice in Profile and update title, and Scripps Scholars site will remain up if it was pre-existing. Landing page will not display deceased person in list of sites | Web Committee | 10/30/2014 |
Should
When should 'Deceased' be set in sio_status ?? If so, what should this flag accomplish ?? we may also want to come up with definitive rules for when SIO Status = Deceased. ****
...
7. Directory 'active' = Profile 'active' (are made manually) Edgar has directory 'active' heuristic. If a profile is 'innactive' then the profile is not published.
8. Student List: Once entered you, the student stays on in perpetuity.
9. What happens to Lab Sites when PI 'leaves' ?? (Jerry guesses the treatment is the same as their profile page ??)
...
Active& 'No' https://siointra.ucsd.edu/secure/people2/report.php?r=6b3553a2
(Monica Bailey is apparently not repotting reporting on this field even though she was one of the main data entry HR people to use field. Another was Michelle Parks who is no longer here.)
11. Clean up deprecated 'overrides' from prior version of People:
mysql> select * from people_override where active = 'Y';
+-----------+--------+------------+--------------------------------+----------+--------+-------------+
| people_id | action | field | value1 |
value2 | active | override_id |
+-----------+--------+------------+--------------------------------+----------+--------+-------------+
| 4476042 | INSERT | home_dept | DEVELOPMENT |
NULL | Y | 53 |
| 6356661 | INSERT | pps_status | volunteer |
NULL | Y | 29 |
| 8315078 | INSERT | home_dept | V/C DEV AND UNIV REL |
NULL | Y | 32 |
| 7506211 | INSERT | home_dept | CMBB |
NULL | Y | 40 |
| 7506211 | INSERT | pps_role | Vis Grad |
NULL | Y | 41 |
| 7506211 | INSERT | pps_status | Active |
NULL | Y | 42 |
| 2277551 | UPDATE | pps_status | Separated |
Active | Y | 57 |
| 2277551 | INSERT | pps_role | Volunteer |
NULL | Y | 58 |
| 1638046 | DELETE | email | rlfisher@ucsd.edu |
NULL | Y | 64 |
| 9425108 | INSERT | title | Visiting Scholar |
NULL | Y | 161 |
| 9425108 | UPDATE | pps_status | Separated |
Active | Y | 160 |
| 6607215 | UPDATE | pps_status | Separated |
Active | Y | 315 |
| 2936339 | INSERT | dept | GRD |
NULL | Y | 155 |
| 4539812 | INSERT | dept | GRD |
NULL | Y | 168 |
| 1166192 | INSERT | title | Volunteer |
NULL | Y | 169 |
| 4736840 | INSERT | dept | scripps dept |
NULL | Y | 200 |
| 6405599 | INSERT | nickname | J. Douglas |
NULL | Y | 236 |
| 6134507 | UPDATE | pps_status | Separated |
Active | Y | 365 |
| 2085966 | UPDATE | pps_role | Staff |
Academic | Y | 364 |
| 7568822 | INSERT | pps_status | Active |
NULL | Y | 262 |
| 7568822 | INSERT | title | Senior Director of Development |
NULL | Y | 260 |
| 7568822 | INSERT | home_dept | Development |
NULL | Y | 264 |
| 5261507 | INSERT | title | Volunteer |
NULL | Y | 298 |
| 5261507 | UPDATE | pps_status | Separated |
Active | Y | 296 |
| 5261507 | INSERT | pps_role | Volunteer |
NULL | Y | 301 |
| 5985861 | UPDATE | pps_status | Separated |
Active | Y | 309 |
| 5985861 | INSERT | pps_role | Academic |
NULL | Y | 311 |
| 5985861 | INSERT | acad_role | Visiting Scholar |
NULL | Y | 312 |
| 2085966 | UPDATE | acad_role | Academic Coordinator |
Director | Y | 363 |
| 9745504 | INSERT | section | BIO |
NULL | Y | 350 |
| 2468836 | INSERT | section | EARTH |
NULL | Y | 351 |
| 3535194 | INSERT | section | OCNS&ATMOS |
NULL | Y | 353 |
+-----------+--------+------------+--------------------------------+----------+--------+-------------+
III. Field Definitions:
Special: sio_status
...
Other Pending Issues:
****
Monday, October 13, 2014 6:31 PM