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.

To do's

• Add emeritus
• Standardize columns so all data can easily be used within one sheet (same column heading titles and order)
  • Idea: Add dummy fields in any DB that won't have data so automatically get correct column heading.
• With Grads: NetID, not NetID-based email
• Add "Grads" to Grads's "Title" field

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*

* Key to "Title" abbreviations within the staff/ facutly data:

The other abbreviations are self explanatory, such as:

• 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.

• Kevin is thus putting the spreadsheet there and 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

• 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?