---
title: "Querying for International Applications at U.S. Domestic Schools"
slug: "querying-for-international-applications-at-us-domestic-schools"
status: "new"
updated: 2026-06-18T22:17:44Z
published: 2026-06-18T22:17:44Z
canonical: "knowledge.technolutions.net/querying-for-international-applications-at-us-domestic-schools"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Querying for International Applications at U.S. Domestic Schools

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](/docs/suitcase-import) ID and paste it in **Database → Suitcase Import** to import a pre-made example query:

```SuitcaseID
4ac012dc-dfa5-4b79-8ab6-a185729f2b76:slate-admissions-showcase
```

> [!NOTE]
> 💡 Tip
> 
> Find this query and other importable examples in the [Admissions Showcase environment](/v1/docs/showcase-environments).

## 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.

![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Querying for List of International Applications at US Domestic Schools.png)

## 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

1. Go to **Queries / Reports**.
2. Select **New Query**.
3. 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
4. Select **Save**.

### Add joins

The joins make person-level citizenship fields and school-level location fields available from the application row.

1. Select **Join**.
2. Create a join to **Person**.
3. Select **Save**.
4. Select **Join**.
5. From the **Person** join, create a join to **School by Rank Overall**.
6. Add the constraint **Rank** = **1**.
7. 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

1. Select **Filter**.
2. Under **Person**, select **Citizenship Status**.
3. Select **Continue**.
4. Set the filter to `IN`.
5. From the list, select **Foreign National**.
6. Select **Save**.

#### U.S. school country

1. Select **Filter**.
2. Under **School by Rank Overall**, select **Country**.
3. Select **Continue**.
4. Set the filter to `IN`.
5. From the list, select **United States**.
6. 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

1. Select **Preview Results** or run the query.
2. Confirm that each returned application belongs to a foreign-national applicant.
3. 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.