You can query for international applicants who currently attend school in the United States. Use this approach to identify students for targeted communications, financial aid messaging, event invitations, funnel analysis, or data validation when citizenship and school location need to be reviewed together.
Try a Slate example 💼
Copy this Suitcase ID and paste it in Database → Suitcase Import to import a pre-made example query:
4ac012dc-dfa5-4b79-8ab6-a185729f2b76:slate-admissions-showcase💡 Tip
Find this query and other importable examples in the Admissions Showcase environment.
Reviewing U.S.-based international applications
This example returns application records for people whose citizenship status is foreign national and whose ranked school record is in the United States. The results can help you find applicants who may need communications or reporting that differs from domestic applicants and international applicants attending school outside the United States.
The example includes school, citizenship, application round, and staff assignment exports so you can review the applicant context directly from the query results. Your database may use different field names for staff assignment or territory ownership, so choose the equivalent local fields when you rebuild the query.
Building the query
Start from the Application base because each row should represent an application. Then join to the person and the person's ranked school record so the query can evaluate both citizenship and school location.
Create the query
Go to Queries / Reports.
Select New Query.
Configure the following settings:
Name: International applications at U.S. domestic schools
Folder: Admissions / Recruitment, or another folder where admissions queries are saved
Type: Configurable Joins
Category: Records
Base: Application
Select Save.
Add joins
The joins make person-level citizenship fields and school-level location fields available from the application row.
Select Join.
Create a join to Person.
Select Save.
Select Join.
From the Person join, create a join to School by Rank Overall.
Add the constraint Rank = 1.
Select Save.
Add filters
These filters limit the query to international applicants whose ranked school record is in the United States.
Foreign national citizenship status
Select Filter.
Under Person, select Citizenship Status.
Select Continue.
Set the filter to
IN.From the list, select Foreign National.
Select Save.
U.S. school country
Select Filter.
Under School by Rank Overall, select Country.
Select Continue.
Set the filter to
IN.From the list, select United States.
Select Save.
Add exports
Add exports similar to these so reviewers can see the applicant, school, citizenship, application, and assignment context in one result set:
Reference ID: Person / Reference ID
Name: Person / Name
Current School: School by Rank Overall / Name
School City: School by Rank Overall / City
School State: School by Rank Overall / Region
Citizenship (Primary): Person / Citizenship (Primary)
Application Round: Application / Round
Staff Assigned: your local staff, counselor, or territory assignment field
Review the results
Select Preview Results or run the query.
Confirm that each returned application belongs to a foreign-national applicant.
Confirm that the ranked school record is in the United States.
Customizing the query
You can adjust the filters to focus on specific citizenship countries, schools, territories, counselors, or application rounds. If you use the results for communications, test the query with a small audience first and confirm that the included exports provide enough context for review.