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.
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 #
- Title
- Primary account number (non-Research vs. Research-only?)
Keys to "title" data, for staff/ facutly data:
Abbreviation |
Explanation |
|---|---|
VS |
Visiting Scholar |
PDA |
Postdoctoral Associate |
PDF |
Postdoctoral Fellow |
Student |
undergraduate employee |
Res Assoc Sr |
(self-explanatory) |
Admin Asst 3 |
(self-explanatory) |
Admin 6 |
(self-explanatory) |
Publ Asst 4 |
(self-explanatory) |
Res Spt Spc 3 |
(self-explanatory) |
Others are self explanatory, such as:
Res Assoc Sr
- Admin Asst 3
- Admin 6
- Publ Asst 4
- Res Spt Spc 3
- Etc.
Process
ChemIT has created for Kevin a folder on hisR: drive for the Chem grad student and staff spreadsheets. Thus, he can put the spreadsheet in R:\Public - all Chem Staff\Chem staff files\
In this way, he is able to update them, and we'll be able to access the most recent copies without emailing and such.
Kevin also has access to the FileMaker grads file on the server. (In FileMaker, open remote fm.arts.cornell.edu (we suggest adding as a favorite host).
Purposes
- 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.