How do you query parents who haven't completed Parent Data Confirmation?


Aeries has the Data Confirmation Status Report

  1. 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.
  2. 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.