Create List
  1. Go to Navigate to Lists > Manage Lists.
  2. Click the Manage basic and advanced lists block under List Actions.
  3. Click Add > Create Advanced List.

Select Objects

  1. User Base
  2. User Role
  3. User Detail
  4. User Register, School Year, Grade Level
  5. User Address
  6. Parent Child/Relationship
  7. User Base [1]
  8. User Phone
  9. Parent Child/Relationship [1]
  10. User Base [2]
  11. User Phone [1]
  12. Contract
  13. Contract Type
Display Fields
  1. User Base.First Name
  2. User Base.Last Name
  3. User Base.Host ID
  4. Usr Role.Role
  5. Grade Level.Grade Level Description
  6. User Address.Address 1
  7. User Address.Address 2
  8. User Address.City
  9. User Address.State Short
  10. User Address.Postal Code/Zip
  11. User Base [1].First Name
  12. User Base [1].Last Name
  13. User Base [1].E-Mail
  14. User Base [1].Host ID
  15. User Phone.Phone Number
  16. User Base [2].First Name
  17. User Base [2].Last Name
  18. User Base [2].E-Mail
  19. User Base [2].Host ID
  20. User Phone [1].Phone Number
  21. User Detail.Gender
  22. User Detail.Dob
  23. Contract Type.Contract Type
Filters
In Global Filters 
  1. Where Contract.Status is any of Processed
  2. And Contract Type.Contract Type is any of (Specific Contracts to filter)
  3. And User Role.Role is any of Candidate
In Object Filters
  1. And Parent Child/Relationship [1].Rel Ordinal equal to 2
  2. And Parent Child/Relationship[1].Rel Ordinal equal to 1
  3. User Phone [1].Phone Type any of Wireless
  4. User Phone.Phone Type any of Wireless
  5. User Address.Address Type any of Home
  6. Grade Level.Grade Level any of 0,1,2,3,4,5,6,7,8, etc.
  7.