Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT - Common Student Tables: Households
DAT - Common Student Tables: Households
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.
Start by
Creating New DAT Query
Select Student Info for the
DAT Query - Step 1 - Choosing Initial Table
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.
Link Relations - Student / Inquiry / Household to Households.
See also
DAT Query - Step 1 - Choosing Initial Table
DAT Query and DAT Filter Common Mistakes
DAT Query - Step 1 - Connecting Tables
DAT - Basic Student Data Structure
Creating New DAT Query
DAT Query - Step 1
DAT Filter
DAT Query
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.