99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.
Posted May 15, 2020
DAT - Common Student Tables: Households
To connect students to households use the connecting table Relations - Student / Inquiry / Teacher.  Note:  This table is also used to connect Inquiries to Households and Teachers to Households.  Note: The DAT - Basic Student Data Structure shows how the tables mentioned in this article are combined.  Avoid DAT Query And DAT Filter Common Mistakes when including to these tables.

Field Description
Bill To Yes No This indicates if the connected household is the Billing household for the record. “Y” indicates that the household is the Billing household. “N” indicates the household is not a Billing household. Note: A record can only have one Billing household.
Primary Indicator This indicates if the household is the Primary household for the record. “P” indicates that the associated household is the primary household. “N” indicates that the household is a Non-primary household. Note: A record can only have one Primary household.
Relationship This differentiates households as either Parent, Grandparent, or Self. Note: For a relationship of Parent, refer to the Parent1 Type and Parent2 Type for the nature of the relationship. Note: Self is used to indicate a domestic household for an international student. Note: Teacher records always have the relationship of Parent for their household.

Example:  You want to get a list of all students and their grandparents.
  1. Start by Creating New DAT Query
  2. Select Student Info for the DAT Query - Step 1 - Choosing Initial Table
  3. Link Student Info to Relations - Student / Inquiry / Household by DAT Query - Step 1 - Connecting Tables
    • Since we want Grandparents, DAT Query - Step 1 - Adding Condition for Relationship of Grandparent.
  4. Link Relations - Student / Inquiry / Household to Households.
Update

Streamlined Selector and Widget Configuration

1 min read · Updated April 26, 2026

Was this article helpful?

Your feedback goes to the team that maintains this article.

Thanks. We use this to improve the article.

Still have questions?

Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.

Open a ticket

New to PCR Educator?

If you landed here from a search and want to see what PCR can do, the demo is the fastest way in. Thirty minutes, no commitment.

Book a demo