...
The decision to participate in the survey is made by Schools. This topic provides instructions for running a SQL script that will export student and parent /guardian data used in the pre-population step of the data submission.
...
- Download the appropriate SQL file for your version of Synergetic from the Hotfix page. See AEDC Hotfix page.
- Open the relevant file in SQL Server Management Studio.
The AEDC2021_DataExtract.sql file is displayed. - Update the fields highlighted below.
Update:
• @RunDate field with the date you want to run as at.
Note: The date must be entered in the format 'd mmm yyyy' (e.g. 1 Apr 2021).
• @YearLevel field of the year level to be exported. - Click
The results of the query are displayed in the Results tab. . - Copy the data into the AEDC template.
- Submit to the AEDC as per their instructions.