SAFETY & SECURITY
Sector Education and Training Authority

 
VeriDataNet Project
     
Example SASSETA Provider Database (Microsoft Access)
A simple example of the possible data structures that can be implemented for a provider level information system.
Example.SASSETA.Provider.DB.mdb Example.SASSETA.Provider.DB.mdb
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


    • Enter a valid name for the learner file (see file specification for naming standard), select Text Files (*.txt, *.csv, *.tab, *.asc) in the Save as type box, click on Export.


    • 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.


      File51 Learner qualification enrolment information
     
    • Go to the Queries desktop, right click on the EduDex_File51Extract query, select Export


    • Enter a valid name for the learner file (see file specification for naming standard), select Text Files (*.txt, *.csv, *.tab, *.asc) in the Save as type box, click on Export.


    • 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.


      File52 Learner unit standard enrolment/achievement information
     
    • Go to the Queries desktop, right click on the EduDex_File52Extract query, select Export


    • Enter a valid name for the learner file (see file specification for naming standard), select Text Files (*.txt, *.csv, *.tab, *.asc) in the Save as type box, click on Export.


    • 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.