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.

× How can we help you? Available from 08:00 to 17:00