DAT - Common Student Tables: Actions

Student Actions play an important role in the Status/Substatus Calculation - Student as well as tracking if (Re) Enrollment Contracts 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 Operators 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 Actions. 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 Actions 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.

Schedule Demo

Please, make sure that all required fields (marked with *) are completed.

School Name *

Relation to School *

select

Last Name *

Your First Name *

Your Email *

Your Phone # *

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.