You can query for applications that do not have a parent or guardian relationship on the applicant record. Use this approach to identify records that need follow-up before review, communication, or enrollment workflows depend on family or guardian information.
Try a Slate example 💼
Copy this Suitcase ID and paste it in Database → Suitcase Import to import a pre-made example query:
96a35ace-9a32-4090-986a-8307c196b99e:slate-admissions-showcase💡 Tip
Find this query and other importable examples in the Admissions Showcase environment.
Finding applications missing parent or guardian information
This query starts from the Application base so each row represents an application. It then joins to the applicant record and the application round, limits results to active rounds for applicants, and uses a subquery filter to find applicant records with no related person categorized as a parent, step-parent, or legal guardian.
Results can help admissions teams identify records that need data cleanup, applicant follow-up, or additional family information before downstream processes depend on those relationships.
Building the query
Create the query
Go to Queries / Reports.
Select New Query.
Configure the following settings:
Name: Applications Missing Parent or Guardian Information
Folder: Applications
Type: Configurable Joins
Base: Application
Select Save.
Add joins
Create the joins that make round information and applicant-level fields available to the query.
Select Join.
Create a join to Lookup Round.
Select Join.
Create a join to Person.
Add the parent or guardian subquery filter
The subquery filter is the core of this query. It checks the applicant's related person records and returns only applications where no relation has a type in a parent or guardian category.
Select Subquery Filter.
Configure the subquery to look for relation records from the Person join.
Add a filter for the relation type category:
Category: Legal Guardian, Parent, Step-Parent
Set the subquery condition to Not Exists.
Name the filter Parent/Guardian Relation category.
Add filters
Add filters that keep the results focused on applicant applications in active rounds.
Select Filter.
Add the following filters:
Person / Status: Applicant
Lookup Round / Active Status: Active
Add exports
Add exports similar to these so the results give staff enough context to review and follow up on each record. Export names and field labels may differ by database.
Person Reference ID
Person Staff Assigned
Person First
Person Last
Person Entry Term
Application Round
Person Status
Using the query
Run the query to review applications that do not have a parent or guardian relation on the applicant record. These records may need applicant outreach, family contact updates, or relationship cleanup before communications or review processes use parent or guardian data.
Customizing the query
Add an entry term, application round key, or application cycle filter to focus on a specific cohort.
Add application status filters if you only need submitted, incomplete, or active applications.
Add exports for email, phone, mailing address, or staff assignment if the results will support outreach.
Adjust the relation categories if your database uses different categories or relation type conventions for parents and guardians.
Add age, student type, or population filters if parent or guardian information is required only for certain groups.
📝 Note
Test the query before using it for production communications. Parent and guardian requirements vary by institution, population, and local data-entry practices.