Please note this list will not fully flatten if the student has 3+ siblings on their contact card. ​
  1. Core > Analysis > Manage Lists
  2. Manage Basic & Advanced Lists
  3. Add > Create Advanced Lists
  4. On Select Objects under Constituent Information add in:
    • User Base
    • User Role  
    • User Base: in the pop select Peer/Peer Relationship [1]. User Id2 = User Base. User ID > Select
    • Peer/Peer Relationship: in the pop up select User Base. User ID = Peer/Peer Relationship User Id1
    • User Base: in the pop select Peer/Peer Relationship. User Id2 = User Base. User ID > Select
    • Peer/Peer Relationship
  5. Remove all inner joins from each object
User-added image
  1. In the Display Fields tab select, Select Fields on the lower-left
  2. Expand User Base and select First Name and Last Name
  3. Expand Peer/Peer Relationship > User Base [1] select First Name and Last Name > Select
  4. Expand Peer/Peer Relationship > User Base [2] select First Name and Last Name > Select
  5. Select the Filters tab
  6. Under Global Filters, click the ‘+’ to add a new row
  7. Under Fields, in the dropdown select User Role. Role any of Student
  8. Under Object Filters, click the ‘+’ to add a new row – add a new row for each of the following filters:
    • Peer/Peer Relationship. Rel Ordinal equal to 1
    • Peer/Peer Relationship. Rel Ordinal equal to 2
    • Peer/Peer Relationship. Short Description 1 is Sibling
    •  Peer/Peer Relationship[1]. Short Description 1 is Sibling
User-added image
  1. Preivew 
  2. Give the list a name & Save