Staff

The STAFF table includes scientist related to (meta)data in the database with phone/email and relation to the institution table. Persons from the staff list can have relations to the sample table, to a campaign to define a chief scientist and are used to define the PI related to data. Additionally they are linked as authors to references or data sets.

Define new staff with related institute:

Due to the relation of the staff table to the institution table, define the institute first.

When defining a new staff, the institute needs to be defined first. (Institute is relational to the staff table). Fill out the name, email and phone fields. A click on the ‚institute‘ field will bring the institute list in front. Search for the required institute with the retrieval card, e.g. 'town contains Hamburg' or type in the first letters of the institutes name in the entrance field. Select the required institute by double click. Click on ‚save‘ to store the new staff.

The keyword field can be used to e.g. build up mailing lists or dynamic lists of project members on web pages. Define a new keyword in the thesaurus, e.g. ‚acronym of a project‘_staff. Link the keyword to all project members in the staff list. Define a retrieval: keyword is equal to ...project_staff. Export the result list, configured to just the email column, to a text file, open the file, select all and copy and paste the list to the email address window of your mailer. With the metadata query definition, dynamic lists on web pages can be organized through links.

For upload use the import form