When creating an advanced list to query for former employees, it's important to not make the list too restrictive by including many Inner Joins in the Objects.  

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.