You can query for athletic recruits to give admissions and coaching staff a shared view of recruited students, where they are from, their application status, and athletic feedback. Use this approach to monitor recruited applicants, coordinate follow-up, and review sport-specific recruitment activity.
Try a Slate example 💼
Copy this Suitcase ID and paste it in Database → Suitcase Import to import a pre-made example query:
fb2758f3-c0fb-4568-a6f7-5939c0e3cbfe:slate-admissions-showcase💡 Tip
Find this query and other importable examples in the Admissions Showcase environment.
Reviewing athletic recruits
Use the Person base so each row represents one person record. Add joins to make address, application, school, and sport information available, then filter by sport so the results include only recruited students with athletic information on their records.
The resulting list can help coaching staff review their recruits while giving admissions staff visibility into application status, territory, school, sport, position, rating, and notes.
Building the query
Create the query
Go to Queries / Reports.
Select New Query.
Configure the following settings:
Name: Athletic Recruitment
Folder: Admissions / Recruitment
Type: Configurable Joins
Base: Person
Select Save.
Add joins
Create joins for the related records that provide location, application, school, and athletic recruitment details.
Select Join.
Create a join to Address by Rank Overall.
Rank: 1
Name: Address 1
Select Join.
Create a join to Application by Rank.
Rank: 1
Name: Application 1
Select Join.
Create a join to School by Level of Study, Rank.
Level of Study: No Level of Study
Rank: 1
Select Join.
Create a join to Schools.
Select Join.
Create a join to Sport.
Rank: 1
Name: Sport 1
Add the sport filter
The sport filter determines which recruited students appear in the results. Include the sports that your staff wants to monitor.
Select Filter.
Select Sport 1 / Sport.
Set the filter to include the relevant sports. The imported example includes:
Baseball
Basketball
Football
Ice Hockey
Lacrosse
Soccer
Softball
Tennis
Volleyball
Wrestling
Select Save.
Add exports
Add exports similar to these so staff can identify each recruit and review the related application and athletic context. Export names and field labels may differ by database.
Person Reference ID
Person Name
Address 1 City
Address 1 Region
Address 1 Country
Address 1 Geomarket
Person Staff Assigned
Schools Name
Application 1 Status
Person Entry Term
Application 1 Application Major
Sport 1 Sport
Sport 1 Position
Sport 1 Rating
Sport 1 Notes
Using the query
Run the query to review recruited students by sport, location, assigned staff member, school, application status, position, rating, and notes. The results can support coordination between admissions and athletics staff without requiring each team to maintain a separate list.
Customizing the query
Change the sport filter to focus on one sport, one team, or a smaller group of sports.
Add entry term, application round, or application status filters to focus on a specific recruitment cycle.
Add exports for email, phone, territory, coach assignment, or additional sport fields if the results will support outreach.
Adjust the sport rank if staff need to review secondary or additional athletic interests.
Add sorts by sport, staff assigned, application status, or geomarket to make the results easier to scan.
📝 Note
Test the query before using it for production communications. Sport values, ratings, and recruitment workflows can vary by database.