Prep PharmSchool for Annual Review

Do an export of all Faculty and all GradStudents

  • Import¬†to the Annual Review table for these persons
    • Fields to import:
      • id -> id_Person
  • Use id_Person as a match field to update existing records, make sure to check “add new records


  • Delete all records in the presentations table


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

Leave a comment