Loading...
Wisenet

      SDR File Guidelines

      Related Articles

      SDR | Set up for Reporting | SDR Export Errors

      How to read the SDR files

      There are Five (5) SDR Files mapped to Wisenet Fields.  You can open the SDR files as exported from Wisenet. With a little help from the Data specification for Single Data Return you can review the CSV file descriptions and use these field mappings to see where the data sits in your Wisenet database.

      Each SDR File has a File Specification in which there is a table that provides information to help you read the export file including the Field Title.

      Quick Tip

      The quickest way to find a field is to type it into the Search function just above the table.

      1: Course Enrolment

      1: Course Enrolment (ENRL)

      Note:

      For a Unit Enrolment to appear in the ENRL file it must:

      • be marked as ‘For SDR’
      • have an EFTS value
      • have an Outcome Code = 0, 1, 2, 3, 4, 5, 6, 7 or 8
      • have a Unit Enrolment Start Date Year that is less than or equal to ( <= ) the export year
      • have a Unit Enrolment End Date Year that is greater than or equal to ( >= ) the export year

      2: Learner File

      2: Learner File (LEAR)

      Note:

      For a Learner to appear in the LEAR File it needs to have a record in the ENRL File

      3: Course Register File

      3: Course Register File (REGT)

      Note:

      Unit details will appear in the REGT file:

      • when an enrolment in this Unit appears in the ENRL File
      • taken from the Unit Offer with the latest start date, which has enrolments that appear in the ENRL file
      • this means that at least one unit offer with relevant enrolments should have a start date

      Quick Tip:

      Check which Unit Offer is appearing by using Report 2020

      If the qualification code to be reported is still incorrect, then please update the Host Qualification Code field in the Unit to the correct qualification code. This will overwrite the above date logic and report the correct qualification code in the REGT file. 

      4: Course Completion

      4: Course Completion (COURCOMP)

      Note:

      A Unit Enrolment will appear in the COURCOMP File when:

      • ‘For SDR’ is marked TRUE
      • the Learner is a ‘D’ Type Student
        AND
      • there is a corresponding Unit Enrolment record in the ENRL File
        OR
      • the Unit Enrolment Extension Date Year is the same as the export year, and the Unit Enrolment End Date is prior to the Export Year

      5: Qualification Completion

      5: Qualification Completion (QUALCOMP)

      Note:

      If reporting from Course Enrolment:

      For a qualification completion to appear in the QUALCOMP file it must:

      • be in a Course Offer where For SDR is Ticked
      • have the Course Enrolment > Qualification Issued Flag that is Ticked
      • have the following Reporting Year check logic
        • If Course Enrolment > Nominated Report Period is set then uses this Year to filter, else continue
        • If Course Enrolment > Actual End Date is set then uses this Year to filter, else continue
        • If Course Enrolment > End Date is set then uses this Year to filter, else skip in export.

       

      If reporting from Qualification:

      For a qualification completion to appear in the QUALCOMP file it must:

      • be in a Qualification where For Government Reporting is Ticked
      • have the Qualification Enrolment Status = Awarded or Awarded – Special Consideration
      • have the Qual Enrolment > Issue Year equal to the latest EFTS_MTH_YEAR

       

      Note: If you update these Reporting/Date fields to a subsequent year after reporting in a previous SDR year, a duplicate record will be added to TEC’s system. This will be deprecated as it is essentially a fraudulent claim for a second completion for the same course offer enrolment.