Content Comparison

...

• • Faculty Information Survey
    • Any fields for which PAC is the "single source of truth" should be read-only.
    • The primary program field should only display if it has a value.
    • If there is no primary program field, the reported primary program field should display.
    • In addition to the fields created above, there should be numerous form fields. These are form fields because they are based on activities over the past 1-2 years. So that if the faculty member takes the same survey next year, these fields will NOT be pre-populated.
      • How many awards/honors have you won in the past two years, with the following prompts:
        • 0
        • 1
        • 2
        • 3
        • 4
        • 5 or more
      • Number of peer reviewed journal articles published in the past year (with the same prompts as above)
      • Number of non-peer reviewed journal articles in the past year (with the same prompts as above)
      • Number of conference presentations in the past year (with the same prompts as above)
      • Number of books published in the past year (with the same prompts as above)
      • Number of book chapters published in the past year (with the same prompts as above)
      • Other activities - textbox.
    • Create the following replicate blocks with the fields listed below:
      • Awards and Honors
        • Award/Honor name - textbox
        • Awarding organization - textbox
        • Year awarded - select (2024/2023)
      • Journal Articles
        • Journal title - textbox
        • Article title - textbox
        • Published year - select (2024/2023)
      • Books
        • Book title - textbox
        • Article title - textbox
        • Published year - select (2024/2023)
      • Book Chapters
        • Book title - textbox
        • Chapter title - textbox
        • Published year - select (2024/2023)
  • Communications 
    
    • Create a confirmation email/screen, thanking the faculty member for completing the survey.
    • Create/send announcement and reminder emails to faculty members asking them to complete the form consistent with the messaging here:

      Lref gdrive file
      url https://docs.google.com/document/d/1FC6UOLTvbGAqHzr_1QfVp71kRLVGkRW0svRbPCUrvwg/edit?tab=t.0

  • Query
    • Create a query displaying the results of the survey.