Excerpt |
---|
Kevin |
...
A. pulls Grads within CCB, per Pat H.'s database. Sharon VanD. (HR) can pull info on all staff |
...
, post-docs, and other researchers |
...
, per Workday. (Grad data in Workday doesn't have CCB group info so not useful.) Chair's Office has info on all |
...
faculty, 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
...
- http://tinyurl.com/ccb-people
- The file is a 6-page PDF, titled "CCB “CCB people listing by group, Oct 2013"2013”. You will need your NetID credentials to get to the file.
...
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).
Table of Contents |
---|
Documentation and reminders
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.)
To do's
- 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:
...
- Kevin is thus putting the spreadsheet there and is able to update them. And we'll we’ll be able to access the most recent copies without emailing and such.
...