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: Actions
DAT - Common Student Tables: Actions
DAT - Common Student Tables: Actions
Student Action
s play an important role in the
Status/Substatus Calculation - Student
as well as tracking if
(Re) Enrollment Contract
s and (Re) Enrollment Forms have been submitted. When linking to this table, specify the academic year for your
DAT Filter
or
DAT Query
.
Note
: You can use
DAT Functional Operator
s to make your filter more generic and reusable.
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 this table.
Field
Description
Academic Year
This indicates which year the action pertains to. A student may have the same action for multiple years.
Example
: Students are expected to submit (Re) Enrollment Forms each year.
Action
Date
This is the date the action takes effect. Some actions are future dated because the student's status is to change on a specific date.
Example
: Graduated actions for seniors are added to student records early to include the graduated date on the Transcripts. They are also future dated so that the student remains enrolled through the rest of the school session.
Action
Description
This is the name of the action.
Example
:
DAT Filter
for students that have not submitted (Re) Enrollment Forms.
Start by
Creating New DAT Query
.
Note
: If you are on a student list like Admin - Students, you can skip to step 3 start a
DAT Filter
.
Select Student Info for the initial table.
DAT Query - Step 1 - Choosing Initial Table
To restrict students to enrolled students see the article for
DAT - Common Student Tables: Statuses
Start a new
DAT Filter
Link Student Info to
Student Action
s.
DAT Query - Step 1 - Connecting Tables
Add a
DAT Query - Step 1
- Adding Condition for
Academic Year
= 20202021
Add a
DAT Query - Step 1
- Adding Condition for
Action
s Description
= Forms Submitted.
Note
: The specific name of your forms submitted action may vary from this example.
Save your filter conditions and Add your filter.
Change your filter to Must Not Have.
See also
DAT Query - Step 1 - Choosing Initial Table
DAT Query and DAT Filter Common Mistakes
DAT Query - Step 1 - Connecting Tables
Status/Substatus Calculation - Student
DAT - Common Student Tables: Statuses
DAT - Basic Student Data Structure
Status/Substatus Calculation
(Re) Enrollment Contract
DAT Functional Operator
Creating New DAT Query
DAT Query - Step 1
Student Action
DAT Filter
DAT Query
Action
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.