The list needs to include a filter for a departure date, so it will exclude employees who are currently working at the school in different roles.

To create an advanced list to query for former employees:

  1. Unmark all of the Inner Joins in Objects to make the list less restrictive; it may be eliminating some former Faculty members.
  2. Add the Filter, Employee Employment.Date Departed with the Condition: is not null to query for any former employee role that DID include a departure date in their employee profile.