/
MySql sio_people database, tables and fields (via TK)

MySql sio_people database, tables and fields (via TK)

Owned by luis avila
Last updated: Feb 18, 2015

`people`

FieldTypeDescription
people_idprimary key 
lname last / family name
fname first / given name
mname middle name
eid employee id
pid ISIS id / PID / student id
source record origin
activeY, N 
run_id  
aid affiliate id (not used)
dupe_excl stores people_id's marked as "separate" records
sound soundex() value used to find "similar sounding" records

`people_values`

FieldTypeDescription 
people_id   
field   
value   
source name of cron subscript or "people2" 
run_id cron run # last saw this value 
override_id   

`people_values` fields

FieldType#Description
acad_role 0,1obsolete
artemis_app 0+Artemis app name (translated) + role name in parentheses
artemis_id 0,1Artemis app "person" id
barg_unit 0,1bargaining unit
biz_section 0,1business section calculated from business_offce
business_office 0,1business office (dept), selected especially if different from home_dept
cg 0,1obsolete
citizenship 0,1

 

country_residence 0,1 
criticalY,N0,1critical employee flag (local)
curricular_group 0+curricular group(s) (local)
dept 1+ 
display_title 0,1(local)
email 0+ 
email_display 0,1(local)
email_primary 0,1(mixed)
fax 0,1 
grad_advisor_pid 0+obsolete
grad_enroll_year 0,1 
heera 0,1 
hire_date 0,1UCSD most recent hire date
hire_date_orig 0,1UCSD original hire date
home_dept 0,1 
is_retiredY,N0,1(local)
is_supervisorY,N0,1(local)
lab_phone 0,1 
lab_website 0,1 
location 0,1 
mailcode   
nickname   
phone   
pps_app_title   
pps_exempt   
pps_furlough  obsolete
pps_role   
pps_status   
program   
publish_profile   
rab_email   
racfid   
representedY,N calculated value
role   
section   
sep_date   
sio_role   
sio_status   
ss_profile   
staff_role  (not used)
title   
visa_end_date   
visa_type   
website