How do you query parents who haven't completed Parent Data Confirmation?
Aeries has the Data Confirmation Status Report
Report Overview:
- The Data Confirmation Status report provides valuable insights into the confirmation status of student data.
- You can run this report at the school level, focusing on students who have not completed all data confirmation steps.
Tagging Students:
- After running the report, students will be tagged with a specific Query Tag Value.
- For our purpose, we’ll focus on students with a Query Tag of “N,” indicating that their data confirmation is incomplete.
Creating the Query
To retrieve the list of Students without All Data Confirmed, run the following query:
LIST STU RTG STU.ID STU.NM STU.GR RTG.RNM RTG.QT RTG.QV IF RTG.RNM = PrintInformationConfirmationStatus AND RTG.QT = N
Customization
- You can modify the Query Value:
- Change from "N - Students with unconfirmed data" to "Y Students with all the data confirmed" as needed.
With this query, you’ll have a clear list of parents who need to complete the data confirmation process.