Importing the Learner Unique Identifier (LUI) file

You can import the Learner Unique Identifier (LUI) file to update student records with the LUI numbers used to identify the students in the Queensland Curriculum and Assessment Authority (QCAA) system.

Before completing the import process you need to download the Learner Unique Identifier (LUI) file from the QCAA website and update the fields. This file has the following fields:

Field configurations and mandatory fields

Field configurations

You can click the link below to view configuration details for each field in the Learner Unique Identifier file.

 Learner Unique Identifier (LUI) field configurations

Learner Unique Identifier file

ColumnHeadingDescription
ALUI

Learner Unique Identifier assigned to the student.

Configuration
Mandatory
BFamily Name

Surname of the student.

Configuration
CGiven NameGiven names of the student.
Configuration
DMiddle NameMiddle name of the student.
Configuration
EPreferred NamePreferred name of the student.
Configuration
FDate of BirthDate of birth of the student.
Configuration
GGenderGender of the student.
Configuration
HStudent IDSynergetic ID assigned to the student.
Configuration
Mandatory
  • This field is defined when students are added to the Synergetic community database.

Mandatory fields

You can click the link below to view mandatory fields for the Learner Unique Identifier file import.

 Click to view mandatory/optional fields
Mandatory
  • LUI
  • Student ID.

Note: The other values are not used by Synergetic.


To import the Learner Unique Identifier (LUI) file:

  1. Download the LUI Upload file from the QCAA website.
  2. Open the QCAA tab of the Import/Export Student Data window.
    The QCAA tab of the Import/Export Student Data window is displayed.
  3. Select the Year and Campus.
  4. Select Import using the Mode field.
  5. Click  to the location of the LUI Upload file.
    The Open window is displayed.
  6. Navigate to the file location containing the LUI file.
  7. Select the file.
  8. Click .
    The Import Results window is displayed.
  9. Review the message displayed in the Outcome column. This field displays the following messages:

    LUI loaded when the LUI is successfully loaded for the selected student
    LUI not loaded - Student ID <Student ID> not found in Synergetic when a student ID in the LUI Import file does not exist in Synergetic.

    Note: You must create a new student record, update the import file to with the new student IDs, and then repeat the import. For information about creating new student records, see Creating new students.

    LUI <LUI> found against other Student <Student ID> when the LUI for a student is recorded against other student records.
    LUI <LUI> was overwritten when an LUI other than the LUI supplied in the file was detected in the Government Student Number field of the Codes tab and overwritten.

  10. Click .
    The Learner Unique Identifier (LUI) file is imported.

    Note: The LUI is populated into the Government Student Number field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.


    Important: You must populate the LUI into the Government Student Number field for Synergetic to be able to use QCAA functionality.