Do an export of all Faculty and all GradStudents
- Import to the Annual Review table for these persons
- Fields to import:
- id -> id_Person
- Fields to import:
- Use id_Person as a match field to update existing records, make sure to check “add new records
Presentations
- Delete all records in the presentations table
Publications
- Delete all records in the publications table
- Delete all records in the person_publications table
Goals (Faculty)
Export Goals to new table and do these things:
- Change field names
- Progress to old_progress
- Text to progress
- Create/run script to change year to current year
In PharmSchool
delete all Goals records
import these fields from the new table
- id_Person
- Progress
- Year
AR Fields
- Find all AR records
- Run script “AR Prep Set Competed”
- set field year to current year (not yet in a script)