Step one: Select "Players"
Step 2: Once here, you will select the first drop down box to show all of the filters.
Now you will select "Affiliate name".
Followed by the Affiliation on the right box. Then click the blue "Search" button to the bottom left.
Once this is done you will click "add filter", and a new drop down with all of the filters will appear.
Here you can filter by the wanted requirements.
The right box will allow you to filter by "approved, pending, review, denied, exception, or not created".
Once you click "Search" a list of players will appear matching those filters.