Kevin Ashman will kindly do a monthly pull of people within CCB. HR has info on all staff, faculty, post-docs and other researchers. Instruction has info on all grad students. |
See the People list documentation.
Ideal goal: Single spreadsheet, each month, with current snap-shot of all CCB people and some info about each person.
PatH has CCB-taken photos of each Grad student,with their name. PatH to send those photo sheets for us, for each incoming year's worth of Grads (1st year Grads). PatH will add NetIDs to this sheet (7/31/13).
|
Group |
First name |
Last name |
NetID |
Position |
Campus address |
Source |
NOTES: |
---|---|---|---|---|---|---|---|---|
Staff |
PI |
FirstName |
LastName |
NetID |
title |
CampusAddress |
Sharon de Roos |
|
Grads |
Chair |
First |
Last |
email* |
Fill in with: Grad |
|
Pat Hine |
Don't include grads in DB who aren't here. Eg: "withdraw" |
Faculty |
n/a |
n/a |
n/a |
n/a |
Fill in with: *Faculty |
|
Sharon de Roos |
Initially from Sharon's phone directory's Excel file (not a DB); update by hand. It's what Joyce Boda recommends using. |
* When and if Grad DB gets their NetID field 100% populated, pull that one instead of their "email" data. Otherwise, just keep using this field and do the required data munging.
* Key to "Title" abbreviations within the staff/ facutly data:
Abbreviation |
Explanation |
---|---|
VS |
Visiting Scholar |
PDA |
Postdoctoral Associate |
PDF |
Postdoctoral Fellow |
Student |
undergraduate employee |
The other abbreviations are self explanatory, such as:
ChemIT has created for Kevin a folder, R:\Public - all Chem Staff\Chem staff files\, which is available to Kevin on his R: drive.
Kevin also has access to the FileMaker grads file on the server.
Question: Of value to the Stockroom? To Accounting/ billing? To other CCB units?