Downloadable SETA data file examples
The following links point to downloadable examples for SETA ETQA type data submissions.
1. Example Edu.Dex data files
Simple examples of what the Edu.Dex data files should look like (Example data used is dummy data with SAS SETA type lookup codes).
Example.SASSETA.Data.Files.zip
Contents:
File01 – Learner data SASS-11101041101.dat
File51 – Learner Qualification Enrolment data SASS-11151041101.dat
File52 – Learner Unit Standard Enrolment/Achievement data SASS-11152041101.dat
2. Example SASS Provider Database (Microsoft Access)
A simple example of the possible data structures that can be implemented for a provider level information system (Example data used is dummy data with SAS SETA type lookup codes).
Example.SASSETA.Provider.DB.zip
Data tables:
Data01_Learner Table that stores data relating to the learner
Data51_LearnerQualification Table that stores data relating to the learner’s enrolment on a qualification
Data52_LearnerCourse Table that stores data relating to the learner’s enrolment/achievement on a unit standard
Lookup tables:
All tables that have a prefix “Lookup_” are lookup tables used by each of the data tables. Lookup tables that will need to be maintained on a regular basis are
Lookup_Assessor
Lookup_Course
Lookup_Moderator
Lookup_Provider
Lookup_Qualification
Export Examples:
Note that these exports do not include the implementation of the header record required for each file:
File01 Learner information
Go to the Queries desktop, right click on the EduDex_File01Extract query, select Export and then Text file.
Enter a valid name for the learner file (see file specification for naming standard) and click on Ok. Do not make the extension for the file .dat at this stage (this would generate a MS Access error), leave the extension as .txt.
On the Export Text Wizard screen select the Advanced button, on the Export Specification screen select the Specs… button, select the Export EduDex_File01 specification and click on the Open button – this takes you back to the Export Specification screen.
Click on the OK button – this takes you back to the Export Text Wizard screen.
Click on Finish and then Close.
Remember to change the file extension from .txt (see item 2 above) to .dat before submitting the file to Edu.Dex for data validation.
File51 Learner qualification enrolment information
Go to the Queries desktop, right click on the EduDex_File51Extract query, select Export and then Text file.
Enter a valid name for the learner file (see file specification for naming standard) and click on Ok. Do not make the extension for the file .dat at this stage (this would generate a MS Access error), leave the extension as .txt.
On the Export Text Wizard screen select the Advanced button, on the Export Specification screen select the Specs… button, select the Export EduDex_File51 specification and click on the Open button – this takes you back to the Export Specification screen.
Click on the OK button – this takes you back to the Export Text Wizard screen.
Click on Finish and then Close.
Remember to change the file extension from .txt (see item 2 above) to .dat before submitting the file to Edu.Dex for data validation.
File52 Learner unit standard enrolment/achievement information
Go to the Queries desktop, right click on the EduDex_File52Extract query, select Export and then Text file.
Enter a valid name for the learner file (see file specification for naming standard) and click on Ok. Do not make the extension for the file .dat at this stage (this would generate a MS Access error), leave the extension as .txt.
On the Export Text Wizard screen select the Advanced button, on the Export Specification screen select the Specs… button, select the Export EduDex_File52 specification and click on the Open button – this takes you back to the Export Specification screen.
Click on the OK button – this takes you back to the Export Text Wizard screen.
Click on Finish and then Close.
Remember to change the file extension from .txt (see item 2 above) to .dat before submitting the file to Edu.Dex for data validation.
3. Example SASS Provider Excel File (Microsoft Excel)
A simple example of what the Edu.Dex data looks like in MS Excel (Example data used is dummy data with SAS SETA type lookup codes).
Example.SASSETA.Provider.Files.xls.zip
Export Examples:
Note that these exports do not include the implementation of the header record required for each file:
File01 Learner Information
Go to the File01 worksheet.
Select View, Macros, View Macros, select the ExportFile01 macro and click on Run.
The file will be exported to your “My Documents” directory as File01Export.txt.
File51 Learner Qualification Enrolment Information
Go to the File51 worksheet.
Select View, Macros, View Macros, select the ExportFile51 macro and click on Run.
The file will be exported to your “My Documents” directory as File51Export.txt
File52 Learner Unit Standard Enrolment/Achievement Information
Go to the File52 worksheet.
Select View, Macros, View Macros, select the ExportFile52 macro and click on Run.
The file will be exported to your “My Documents” directory as File52Export.txt.