Excerpt |
---|
Kevin Ashman will kindly do a monthly pull of people within CCB. HR has A. pulls Grads within CCB, per Pat H.'s database. Sharon VanD. (HR) can pull info on all staff, faculty, post-docs, and other researchers. Instruction , per Workday. (Grad data in Workday doesn't have CCB group info so not useful.) Chair's Office has info on all grad studentsfaculty, per JoyceB's (ad hoc?) info. |
See also
Ideal goal
- Single spreadsheet,
...
- with current-at-the-time snap-shot of all CCB people and some info about each person.
Current versions
...
Reality-check on numbers: 350-360 people, depending on time of year
2013 | Aug | Sept | Oct | Notes |
---|---|---|---|---|
Staff | 143 | 146 | 148 | Staff include Admin, HR, Finance, IT, Instruction, Teaching, Labs, |
Grad | 179 | 165 | 162 |
|
Faculty | 38 | 38 | 38 |
|
Totals: | 360 | 349 | 348 |
|
Children Display | ||||||
---|---|---|---|---|---|---|
|
...
|
KevinA's data, from PatH's database.
- Include only "Current" from the Grad student list.
- Don't include "withdraw", for example. (And "Former" Grads already not being included, apparently.)
...
- Just grads.
SharonVanD's data, from Workday
- Get each January
...
Old info. Still of value?
Sharon de Roos
Is listed, but not "in" CCB?
...
Fields needed for each research and staff / faculty group
| 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 |
Postdoctoral Fellow | |
Student | undergraduate employee |
The other abbreviations are self explanatory, such as:
...