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: Statuses
DAT - Common Student Tables: Statuses
DAT - Common Student Tables: Statuses
The Status by Division table tracks the student status by each division for both the current year and the next year. When linking to this table, specify the school names and school year that are important for your
DAT Filter
or
DAT Query
.
Note
: By default, the software adds a condition for your current school division.
Note
: The
DAT - Basic Student Data Structure
shows how the tables in this article are combined. Avoid
DAT Query
And
DAT Filter
Common Mistakes when including this table.
Field
Description
Name
This is the name of the school division.
School Id
This is the school id for the school division.
Note
: If
Name
is specified, then the
School Id
does not need to be specified.
School Year Str
This is a more readable version of
School Year
School Year
0 corresponds to the current year and 1 corresponds to the next year.
Note
: If
School Year Str
is specified, then the
School Year
does not need to be specified.
Status
The status of the student for the
School Id
/
Name
and
School Year
Substatus
The substatus of the student for the
School Id
/
Name
and
School Year
Example
: You want to exclude Summer School only students as an option on the (Re) Enrollment Forms. To accomplish this, you will want to restrict your filter to students whose current grade is less than the highest grade level and whose status is Enrolled for next year in your non-summer divisions.
Note
: Use the current grade level because the next grade level usually also matches the current grade level for graduating students: A student who is grade 12 this year may also have grade 12 listed for next year.
Note
: Use the next year's status because new students who complete a contract are Enrolled for next year.
Note
: Some students may participate in both the summer and the main divisions. Therefore, the status for the summer division is irrelevant. The student must be enrolled for the main divisions.
Construct the new
DAT Filter
as follows:
Start by
Creating New DAT Query
Select Student Info for the initial table.
DAT Query - Step 1 - Choosing Initial Table
DAT Query - Step 1 - Adding Conditions
to limit the grade levels to non-graduating grade levels in the current year. This is achieved using the
Grade Level
Code
or
Grade Level
Num
field.
Next
DAT Query - Step 1 - Connecting Tables
to link Student Info to Status By Division.
DAT Query - Step 1 - Adding Conditions
for
Status
= Enrolled,
School Year Str
= Next Year, and
School Name
of your non-Summer divisions.
Note
: If available, specifying an Admissions division is usually sufficient.
See also
DAT Query - Step 1 - Choosing Initial Table
DAT Query and DAT Filter Common Mistakes
DAT Query - Step 1 - Adding Conditions
DAT Query - Step 1 - Connecting Tables
DAT - Basic Student Data Structure
Creating New DAT Query
DAT Query - Step 1
School Division
Grade Level
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.