Overview of changes included
Education Horizons Group has recently completed a SQL script to enable the extraction of Student Registration 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 does not include a Synergetic Application User Interface.
Obtaining the SQL
The AEDC - 2021 SQL statement is available from this page for both v.69 and v.70.
1) Download the appropriate zip file from one of the links below:
- Version 70
- Version 69
Extracting AEDC 2021 data
Instructions for gaining the AEDC 2021 data.
- 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
Extract from SQL:
--NOTE: Change the values below to the appropriate run date and Year Level code for extracting students
SELECT
@RunDate = '1 Apr 2021',
@YearLevel = 1
- Run the SQL and save the results and column headers
Submitting the AEDC 2021 data
Submit the data to AEDC as per the instructions you received from them.
Requesting Assistance
As always, if you have any further questions or concerns, our Support team is available to assist:
- Service Desk: https://jira.synergetic.net.au/servicedesk/customer/portal/2
- Phone: 03 9803 8111
Please make sure to mention that your query is in relation to ‘AEDC 2021 Data Extract SQL’ to help our support team action your request as efficiently as possible.