| Excerpt |
|---|
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 also
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).
| 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 | ||||||
|---|---|---|---|---|---|---|
|
For Kevin
- Include only "Current" from the Grad student list.
- Don't include "withdraw", for example. (And "Former" Grads already not being included, apparently.)
...
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:
...