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:

Click on Institute, click on ‚new‘, fill the fields with the required information. (For institutes at a university, the institute field should contain the name of the institute first, than the university; e.g. Institute for Geosciences, University of Bremen) Click on ‚save‘. 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