| 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
- Obtain each January, which Sharon does for other reasons.
- Data fields are:
Manager, First Name, Last Name, Netid, Job Profile Name, Email - Primary Work, Job Family Group, Employee Type
- Note: Please include "Job Profile Name" or prof. positions not complete. Was missing from Jan. 2018 pull. "Position/Job Title" was included which helped, but not as good.
- Note: There were 163 entries, January 2018.
Oliver then:
- Corrects by hand the few under "First Name" (Floyd) and "Last Name" (Peng, SLin).
- Corrects the many under "Manager, prep by hand" (~64) and via automation under "Manager, corrected for Faculty" (~33)
...
- . Look at previous year's for guidance.
- Re-does all the appropriate NC's under "Mark if Not Charged" (~35). Again, look at previous year's for guidance.
- Don't forget to add the "missing" faculty 4: Hoffmann, Widom, Cerione, DiSalvo. And "missing" 3 staff: Johnson, Walcott, Leitch.
...
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:
...