Content Comparison

...

A. People DB

...

I. ESTABLISHED:

A. People DB

( see below: III. Field Definitions )

1. Business Rules:

1 . Business offices to have a permanent assignment of the students who are working with PIs in their division. Offices, keys etc for the students are handled in the business office and unless there is a major change (e.g. new advisor in different business office) this would stay fixed throughout the student's tenure. The people database record should NOT be modified to reflect quarterly changes in the source of student funding.

Graduate students: 1) the department enters information for all incoming students, 2) these records are handed over to the business office early in the first year. ( J. Gee addressing concern brought by D. Boomer of CASPO. April 2015 )

Automated reports should provide business offices with information to determine grad students' advisors. Will generate this report.

B. Scripps Directory

1. "Dept/Division" is a calculated value where

...

1. people id
2. business_office
3. home_dept
1. 1. dept
  2. display_title
2. title = working title (via Blink)
  1. sio_role
1. phone (if empty, will not display)
2. mail_code (if empty, will not display)

D. Scripps Profiles

...

E. Faculty List

/wiki/spaces/SIOMEGA/pages/54072965

*** Other heuristics on MegaSite: PHP modules... List of Modules/Files That Include weird Logic (via Edgar/Tomo)/wiki/spaces/SIOMEGA/pages/54073070

II. PENDING:

Current List for PO Curricular Groups:

...

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

Deceased

Retired

Appointment Pending

RTAD

RTAD Pending

Sabbatical

PPS Separated

Past Affiliate

Leave of Absence

Visa Pending

...

Table plus

width	100%

Field Name

Module

Contributor

Description

Data Source

Data Location

First introduced

Controlled Vocab Options

Tied to Scripps Scholar

Jump To...

Search

Tomo

Only meant to be a really quick "jump" to specific records using IDs. Used as a temporary solution until a proper search / landing page is spec'ed.

This field can take

nickname
SIO ID (people_id)
Employee ID (eid)
ISIS ID / Student ID (pid)
partial name
- Simpson, Homer
- Simpson, H
- Simpson
- Homer
- Homer Simpson
- Homer S
- Simp

Dept Affiliation (Select Business Office) aka 'dept'

Employment / HR

lists all appointed depts, the selected item indicates "Business Office" ( see Business Office below ). Comes from PPS Employee field: "Dept. All" which is a concatenation of Dept Codes (don't know how dept codes are determined but could be tied to Appointments ). Dept codes are looked up with our internal Contact DB, "dept_lookup" table.

PPS. However, app. allows for "local" values

V1

Business Office

Employment / HR

people_values field "business_office", not pre-populated so clients should fallback to home_dept if business_office == NULL).

people_valuesV1

V1

Yes

Home Department

Employment / HR

Yes

Home Department

Employment / HR

Home Department follows the person's FTE. That's why we've decided to use the PeopleDB to supply the Scripps Scholars site with Home Dept. information via the Business Office fieldFor FTEs this field should be changed in PPS. Home Department follows the person's FTE. That's why we've decided to use the PeopleDB to supply the Scripps Scholars site with Home Dept. information via the Business Office field. If a student doesn't have a PPS entry you can 'override' the field by hovering over the field on the top-rigth; once on the right spot you'll see a paper icon appear that you select; then you can type into the field. I don't recall if it auto-completes but just make sure it's the same spelling as other people with the same Home Department.

home_dept = pps_employee.home_dept_code ("codes" are translated using contact.dept_lookup ) no pps_appointment fields are used here.

people_values

V1

Dept Affiliation (Add New to List):

Employment / HR

Provides ablitiy to add an affiliated department not present in Dept Affiliation list. Affiliations are loosely defined. For more granular membership use Business Office and Home Department.

dept = pps_employee.emp_all_depts ("codes" are translated using contact.dept_lookup ) no pps_appointment fields are used here.

people_values (can have multiplt entrees)

V1

Publish Profile

Employment / HR

As of Aug. 2014 these heuristics may no longer be used: Three (3) states subdivided by role: 1. Field is blank (default) : A) For students: only show name and email address B) For staff and faculty: show everything 2. NO: A) For students: only name and email address B) For staff and faculty: only name and email address 3. YES: All data is displayed for students, staff & faculty <help>A 'Yes' means profile will be displayed on Scripps web site</help>

V1

Exempt

Employment / HR

Jerry recommended adding this field after learning nonexempt employees will be sub 2 positive time reporting biweekly, starting January 2013.

PPS: Binary values are 1 or 0 and are found here: sio_people.pps_appointment.app_flsa_exemption_flag

V1

Primary Email

Employment / HR

Official UCSD email. Pulled from PPS. Used for MegaSite if no Display Email is selected.

Display Email

Employment / HR

Needs to be selected in People app. Used for MegaSite and SS.

Business Office Section

Employment / HR

Auto-filled based on ““Business Office” selected in "Dept Affiliation" field. Ended up creating a new people_values field "biz_section" that actually stores (therefore can be queried) the translated value from "business_office" value (if exists)

people_values

Phone (all)

Employment / HR

for Local data it's not enforcing but makes user feel bad if format is not (xxx)xxx-xxxx . Offie and Fax pulled from Blink are usually is format (xxx)xxx-xxxx.

is_supervisor

Employment / HR

is_supervisor values are completely local, i.e. do not get updated whenever the cron runs. Overrides are there to prevent local changes from being overwritten by the "official" data sources, and get inactivated once the predefined conditions fail. And in this case, for example, since is_supervisor = Yes didn't get deleted during today's cron update, condition of "IF is_supervisor = Yes does not exist" fail, and that particular override inactivates. I

heeraHEERA

PPS

SIO Role

Employment / HR

Staff - Casual Restricted: Used primarily for undergrads working; don't have a Blink record and fields such as 'Phone' need to be 'overridden'.

Academic - Teaching Professor: One of several roles used to populate Faculty List on Mega. The unique case of Geoffrey Cook (2015)

Local

Academic Voting Section

Employment / HR

people_values

First/Last Name

Employment / HR

Middle Name

Employment / HR

Helpful in determining if record already exists.

NIckname

Blink doesn't allow letters with accents or punctuation marks. Local field does allow these. Can be used in Search fields.

Blink/Local

Working Title

Employment / HR

Diane Boomer

"Working Titles" don't appear in PPS at all. I suspect that they initially come to the BLINK Directory from the employee's Job Description card. After that, the BLINK Title (synonymous with our 'working title) can be edited by the employee or anyone authorized to make changes to the employee's BLINK directory listing. If the employee never bothers to review and update his/her title in the BLINK Directory, there's probably no other update mechanism, and the Title remains the same despite promotions or reclassifications. Just noticed a similar case (again, thanks to People App) for Gregory Roberts. His working title in the app was "Asst Proj Sci" even though he was promoted to Assoc Researcher a few years ago. I looked him up in the BLINK Directory. Sure enough, his title there was "Asst Proj Sci." I requested a BLINK directory update to change his title to associate researcher in the directory listing. I expect the update will go into effect tomorrow. Again, this has nothing to do with PPS. His PPS appointment titles are all up to date. Working Title is not a PPS field.

Blink's Employee Title defaults to its payroll title. However, a working title can be used as well, but not both. Working title is manually entered by either the Directory Contact or Directory Services.

via Fema

V1

SIO Status

Employment / HR

”RTAD”, “RTAD Pending,”Leave of Absence” and “Visa Pending” in SIO Status will be treated as “Active” in the Scripps Directory.

Add: 'Sabbatical' and 'Appointment Pending'... should also be ‘Active’

Past Affiliate is 'Inactive'.

Local

RTAD Pending, Appointment Pending,...

UCSD Status aka 'pps_status'

Employment / HR

<help>This field is used to determine if record should be listed under Scripps Directory of the new website. Override to Active for this record to show up.</help>

PPS

Publish Directory Info

Employment / HR

field has 3 states: 1. A) Field is blank (default) directory info depends on the PPS Status and SIO Status. i.e if person has been separated in PPS and no SIO Status has been selected, then the person will be removed from directory. If person has been separated in PPS and the SIO Status has any of the choices considered to be 'active', such as RTAD, then the person will not be removed from directory. If SIO Status is 'Past Affiliate' selected then the person will be be removed from directory. B) If record is set to NO, then person will not show up in directory irrespective of their PPS and SIO Status. Trumps everything. C) If record is set to YES, then person will show up in directory irrespective of their PPS and SIO Status.

Local

v1.2b

blank/Yes/No

Directory Title

Employment / HR

<help>Only used for Scripps Directory on Megasite; Takes ultimate precedence</help>

This is the order of precedence used to establish which title will show on the Scripps Web “People” Directory: Directory Title > Display Title > Blink/Working Title > SIO Role For example, if the first three fields are blank, it will be the SIO Role that will show in the directory.

- October 13, 2014 (via Edgar )Just an update: Megasite profiles and Scrippsscholars will now display Directory Title first if available as well.

Local

TItle

Employment / HR

Working Title.

Blink

Display Title

Employment / HR

Used for academics only. Evolved from Scripps Scholars

Local

PPS Appointment Title

Employment / HR

PPS

Employment / HR

Local

Supervisor

Relationships Module:

campus Timekeeping

Supervisee

Relationships Module:

campus Timekeeping

Work Director

Relationships Module:

campus Timekeeping

Work Directee

Relationships Module:

campus Timekeeping

Advisor(s) & Advisee

Relationships Module:

campus TimekeepingFMP

Work DirecteePI/Sponsor

Relationships Module:

campus

TimekeepingLocal -

Advisor(s) & Advisee

Relationships Module:

FMP

SIO Separation and Departure Dates

Hiring/Separation

PI/Sponsor

Relationships Module:

Local -

SIO Separation and Departure Dates

Hiring/Separation

If date is in the past the record becomes 'inactive' in People DB but record is still alive in the directory. ( True as of 3/2015) The heuristic for SIO Separation Date is working as it should but we need to have it translate to the directory. The most elegant solution would be that the end-user doesn't have to do anything more than having entered an SIO Separation Date or SIO End Date. Setting a directory flag in people_values could be a good solution, updated via a stored procedure tied to the end date check.

HR

UCSD Separation Date

Hiring/Separation

should not show ‘Indef’ if the download = “that funky future date”. Instead, leave field blank. - e. g. Marie Nordstroem.

PPS

Country of Citizenship

Personal Data

The Country of Citizen data are considered Sensitive and should have limited visibility in the DB. Not sure how limited or what mechanism we'll use to keep it limited, if indeed it's needed at all. I suspect that it's needed for issues like Export Control, where visitors or students from sanctioned countries need to be identified so that funding agency export control requirements are met.agency export control requirements are met.

Occupying Space

Space

marking an occupying space as "Primary Space" writes to marinara's space.sio_occupants.primary = "Y" (note that "primary" is a MySQL reserved word; use `primary` in query). history IN people coming FROM space db app AND primary space history IN space

Local -

Assigned Space

Space

for V1.0 "Assigned Space" is not saved. will disable the edit field for V1.0 release. however it's only designed to assign a person to a space that's not assigned to somebody else (this app will not kick existing assignees out), it's probably a better idea to simply link to the space db.

Local -

Occupying SpaceSpace

marking an occupying space as "Primary Space" writes to marinara's space.sio_occupants.primary = "Y" (note that "primary" is a MySQL reserved word; use `primary` in query). history IN people coming FROM space db app AND primary space history IN space

Local -

Assigned Space

Space

for V1.0 "Assigned Space" is not saved. will disable the edit field for V1.0 release. however it's only designed to assign a person to a space that's not assigned to somebody else (this app will not kick existing assignees out), it's probably a better idea to simply link to the space db.

Local -

IV. Tool Tips: https://sio-stash.ucsd.edu/projects/SSA/repos/sio-people-database/browse/config.xml

...

A. Candidates

1. heuristic for the large font 'name+dept+sio role' used in the View/Edit page, top left: <last name> <nickname (if exists) | first name> < middle initial> <home department> < so_role>

( as for Davidson somebody needs to save a new business_office for him. Sent email to Monica and Diane. -lxa Monica confirmed change on 2/25/15. )

2. Proper Capitalization of People's names. ( brought up by James )

B. Approved

C. In Production

VI. Attachments:

Image Removed

VII. NOTES:

*****

...

Current List for PO Curricular Groups:

https://scripps.ucsd.edu/doctoral/program-areas/physical-oceanography-po

...

***** other options:

Deceased

Appointment Pending

Sabbatical

Other Pending Issues:

****

VIII. Meeting Minutes

A. February 25, 2015 Web committee

Needs:
1. Reporting - Jeff Gee
2. Stored Procedures - Web programmers

...

from I. Established:

I. C. Scripps Scholars

CONTACT (sidebar) heuristics missing Business Office check. (Edgar)

from II. Pending:

1. Members by Curricular Group. Requested by PO & IGPP - Jeff Gee says each division will provide a static list to web group to be used on Mega Site. He will send email to department heads.

2. Deceased people: As soon as flag is set in sio_status, remove from directory, add link to obituary notice in Profile and update title to reflect DOB - DOD, and Scripps Scholars site will remain up in perpetuity if it was pre-existing. Landing page will not display deceased person in list of Scripps Scholars sites.

(Luis to notify HR data stewards of new Decease flag.)

3. It is confirmed we follow official PPS name. (Luis to notify HR data stewards of new protocol)

Added to Stored Procedures.

...

IV. Tool Tips: https://sio-stash.ucsd.edu/projects/SSA/repos/sio-people-database/browse/config.xml

V. Stored Procedures:

A. Candidates

1. heuristic for the large font 'name+dept+sio role' used in the View/Edit page, top left: <last name> <nickname (if exists) | first name> < middle initial> <home department> < so_role>

( as for Davidson somebody needs to save a new business_office for him. Sent email to Monica and Diane. -lxa Monica confirmed change on 2/25/15. )

2. Proper Capitalization of People's names. ( brought up by James )

3. 'Sabbatical' and 'Appointment Pending' values in sio_status... make the record ‘Active’ (via Tomo )

4. SIO End/Departure Dates set Flag to remove Person from directory. ( Sea Grant issue, discussed with Tomo already )

5. Delete erroneous records.

B. Approved

C. In Production

VI. Attachments:

Image Added

VII. NOTES:

*****

Curricular Groups Member display on SIO Mega (specific to Physical Oceanographers):
https://scripps.ucsd.edu/testemilik

Current List for PO Curricular Groups:

https://scripps.ucsd.edu/doctoral/program-areas/physical-oceanography-po

***reference attachment 1A. 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

***** other options:

Deceased

Appointment Pending

Sabbatical

Other Pending Issues:

****

VIII. Meeting Minutes ( action items in ()s )

A. February 25, 2015 Web committee

Needs:
1. Reporting - Jeff Gee
2. Stored Procedures - Web programmers

Freeman Gilbert should be taken care of after new rules are implemented.
from I. Established:

I. C. Scripps Scholars

CONTACT (sidebar) heuristics missing Business Office check. (Luis to JIRA for Edgar)

from II. Pending:

1. Members by Curricular Group. Requested by PO & IGPP - (Jeff Gee says each division will provide a static list to web group to be used on Mega Site. He will send email to department heads. )

2. Deceased people: As soon as flag is set in sio_status, remove from directory, add link to obituary notice in Profile and update title to reflect DOB - DOD, and Scripps Scholars site will remain up in perpetuity if it was pre-existing. Landing page will not display deceased person in list of Scripps Scholars sites. (Luis to Store Procedures )

(Luis to notify HR data stewards of new Decease flag.)

3. It is confirmed we follow official PPS name. (Luis to notify HR data stewards of new protocol)

Added to Stored Procedures.

4,6,7. The SIO Separation, SIO Departure fields and Past Affiliate values need to be checked to determine 'active' vs 'inactive' at SIO. PostDocs and Grads' Scripps Scholars sites should remain accessible for 1 year after person is considered 'inactive'. If value: Past-affiliate is set in sio_status AND (Separated Date OR Departure Date) is in past, then person's profile and directory listing are immediately unpublished. ( Luis to JIRA )

8. Student List: Once entered you, the student stays on in perpetuity. Asked for by faculty.

9. For Lab Sites and Project Sites that have not been updated in past year an automated email goes out to Scripps Web group. (Luis to JIRA )

10. Is_retired field will be deprecated. ( Luis to JIRA for Tomo. Luis to notify HR data stewards )

11. old Fatlip table with overrides to be deprecated. Leave as is for now.

Version	Old Version 34	New Version Current
Changes made by	luis avila	luis avila
Saved on	Feb 26, 2015	May 22, 2015

Versions Compared

Key

A. People DB

I. ESTABLISHED:

A. People DB

B. Scripps Directory

D. Scripps Profiles

E. Faculty List

II. PENDING:

III. Field Definitions:

Field Name

Module

Contributor

Description

Data Source

Data Location

First introduced

Controlled Vocab Options

Tied to Scripps Scholar

Jump To...

IV. Tool Tips: https://sio-stash.ucsd.edu/projects/SSA/repos/sio-people-database/browse/config.xml

A. Candidates

C. In Production

VI. Attachments:

VII. NOTES:

VIII. Meeting Minutes

from I. Established:

from II. Pending:

IV. Tool Tips: https://sio-stash.ucsd.edu/projects/SSA/repos/sio-people-database/browse/config.xml

V. Stored Procedures:

A. Candidates

C. In Production

VI. Attachments:

VII. NOTES:

VIII. Meeting Minutes ( action items in ()s )

from I. Established:

from II. Pending:

Content Comparison

Versions Compared

Key

<span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-0">[data-colorid=</span>

A. People DB

A. People DB

B. Scripps Directory

D. Scripps Profiles

E. Faculty List

II. PENDING:

III. Field Definitions:

Field Name

Module

Contributor

Description

Data Source

Data Location

First introduced

Controlled Vocab Options

Tied to Scripps Scholar

Jump To...

IV. Tool Tips: https://sio-stash.ucsd.edu/projects/SSA/repos/sio-people-database/browse/config.xml

A. Candidates

C. In Production

VI. Attachments:

VII. NOTES:

VIII. Meeting Minutes

from I. Established:

from II. Pending:

IV. Tool Tips: https://sio-stash.ucsd.edu/projects/SSA/repos/sio-people-database/browse/config.xml

V. Stored Procedures:

A. Candidates

C. In Production

VI. Attachments:

VII. NOTES:

VIII. Meeting Minutes ( action items in ()s )

from I. Established:

from II. Pending: