| 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. |
Ideal goal: Single spreadsheet each month with current snap-shot of all CCB people
| Table of Contents |
|---|
Data export needed for billing and Remedy reporting
Required data
- chemistry staff (include researchers, post docs, visiting scholars, regular staff) and faculty (including visiting profs and emeritus)
- graduate students
Fields needed for each research and staff / faculty group
Required
- Name- First
- Name- Last
- Cornell NetID
- Group affiliation
Optional, when available
- Room #, Building
- Title*
- Primary account number (Q: Non-Research vs. Research-only?)
...
- Res Assoc Sr
- Admin Asst 3
- Admin 6
- Publ Asst 4
- Res Spt Spc 3
- Etc.
Processes figured out so far
ChemIT has created for Kevin a folder, R:\Public - all Chem Staff\Chem staff files\, which is available to Kevin on his R: drive.
...
- In FileMaker, open remote fm.arts.cornell.edu. (We suggest adding as a favorite host.)
Purposes
- CCB Groups within Active Directory (managed by ChemIT).
- For access to CCB file servers, NMR access (in the future, possibly), Chem Community Headnode (possibly).
- ChemIT monthly billing
- ChemIT activity reports from Remedy (Remedy identification)
- ChemIT staff's knowledge of who is who
- Ideally with pictures (from PatH. And/or from WorkDay), at least for grads.
Question: Of value to the Stockroom? To Billing? To other CCB units?