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

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)