...
Education Horizons Group has recently completed a SQL script query to enable the extraction of Student Registration initial data for the Australian Early Development Census (AEDC) - 2021 as per their data template, which Principals should have received from the AEDC (AEDC Principals Page).
When run against the Synergetic Database, this SQL will return the data and column headers as specified by the AEDC.
SQL Only
This solution is a SQL query only and does not include a an AEDC facility within the Synergetic Application User Interface.
Obtaining the SQL
The AEDC - 2021 SQL statement is available from this page for both v.69 and v.70.
...
- From the Section above, download the v70 or v69 SQL for your Synergetic Version.
- Save locally and Open the .sql file, Synergetic highly recommends using SQL Server (or equivalent SQL tool).
- Due to the complexity of the SQL, the use of MS Excel to extract the data is strongly advised against.
- Edit these fields as appropriate:
- RunDate
- Maintain the Date Format as 'd mmm yyyy'
- YearLevel
- RunDate
Change in the Query here:
...
Extract from SQL:
--NOTE: Change the values below to the appropriate run date and Year Level code for extracting students
...
Submit the data to AEDC as per the their instructions you received from them.
Requesting Assistance
As always, if you have any further questions or concerns, our Support team is available to assist:
...