How to Bulk Update Units in the SMS

How to Bulk Update Units in the SMS

Idea
Overview
Bulk updating units in a Student Management System (SMS) enables administrators to efficiently modify course or unit enrolments for multiple students at once. This process often involves importing updated data within the system. 

In this tutorial, we will guide you on how to bulk update units in the SMS.

Notes
Step Tutorial
  1. To update units in bulk, go to Reports.
  2. Click on Units.
  3. When updating Units in bulk, you may select from the previously created Units Report templates.
  4. (Optional) You may also add a new template.

    For steps 1 to 4, refer to the image below:



  5. Enter a Name for your template.
  6. Click Default if you want this report template to be selected every time you visit the Units Report tab.
  7. Click Save.

    For steps 5 to 7, refer to the image below:


  8. Select a date range as your report parameter from one of these fields. 
  9. (Optional) You may also filter from these fields to make your report more specific.
  10. You can opt to select and show AVETMISS fields.
  11. Click Search.

    For steps 8 to 11, refer to the image below:


  12. Use the filters on each column to make your report more specific.
  13. Select the specific students that you plan on updating. You may also select ALL by clicking on the tick box beside First Name.
  14. Once students are selected, a button "Bulk Update" will appear, click the Bulk Update button.

    For steps 12 to 14, refer to the image below:


  15. From the drop-down menu, select the field that you need to edit or update.
  16. Click Add fields.

    For steps 15 and 16, refer to the image below:


  17. Update the Value for this field.
  18. Repeat steps 15 to 17 if updating other unit-related fields are needed.
  19. Click Update to save changes.

    For steps 17 to 19, refer to the image below:
InfoNOTE: Updates made to dates will sync with the LMS within two hours.

Info

The fields available when using Bulk Update may vary depending on the units, program, program instance, configuration and eligibility. Certain fields will only be displayed when the relevant conditions are met.
They can be based on: 

  • Reporting State – State-specific fields are displayed when you have a Program Instance with the corresponding Reporting State configured.
    For example, if your Program Instance has the Reporting State set to WA, WA-specific fields will be available in the Bulk Update fields.
  • VET Student Loans (VSL) – VSL-specific fields are displayed when Enabled VET Student Loans is enabled for the Program Instance.
  • TAFE – TAFE-specific fields are displayed based on the Are you a TAFE? setting:

    • If Are you a TAFE? is set to Yes, TAFE-specific fields will be available.
    • If Are you a TAFE? is set to No, TAFE-specific fields will not be displayed.

Expand the section below to view the available Unit fields, their categories, and the conditions that determine when they are displayed.

Unit Report Bulk Update: Field Reference

Core Date Fields

Core Date Fields

Available for all Clients

Unit Field

Input Type

Visibility Condition

Proposed Start

Date picker

Visible for all

Actual Start

Date picker

Visible for all

Actual End

Date picker

Visible for all

Proposed End

Date picker

Visible for all

Expires After (days)

Text Input

Visible for all

 

Outcome Fields

Outcome Fields

State-based Fields

Unit Field

Input Type

Visibility Condition

Outcome Identifier National

Dropdown

Any Reporting State

Outcome ID - Training Organisation

Dropdown

NSW, SA, WA

 

Delivery / Mode Fields

Delivery / Mode Fields

State-based Fields

Unit Field

Input Type

Visibility Condition

Mode of Delivery

Dropdown

Any Reporting State

Predominant Delivery Mode

Dropdown

NSW, VIC, QLD, SA, WA, TAS

Delivery Mode ID - State

Dropdown

WA

Delivery Mode ID - State 2

Dropdown

WA

Delivery Mode ID - State 3

Dropdown

WA

Delivery Strategy

Dropdown

WA

Full Time Learning Option

Dropdown

QLD

 

Location

Location

Available for all Clients

Unit Field

Input Type

Visibility Condition

Location

Dropdown

Visible for all

 

Funding Fields

Funding Fields

State-based Fields

Unit Field

Input Type

Visibility Condition

Funding Source National

Dropdown

Any Reporting State

Funding Source - State Training Authority

Dropdown

Any Reporting State

Specific Funding Identifier

Dropdown

Any Reporting State

Subsidy

Text Input

Any Reporting State

Tuition Fee

Text Input

Any Reporting State

Resource Fee

Text Input

Any Reporting State

Other Fee

Text Input

Any Reporting State

Funding Eligibility Key

Text Input

VIC

Funding Removed Flag

Dropdown

WA

 

Fee Fields

Fee Fields

State-based Fields

Unit Field

Input Type

Visibility Condition

Client Tuition Fee

Text Input

TAS

Fee Exemption / Concession Type ID

Dropdown

VIC, QLD, WA

Fee Exemption / Concession Type ID 2

Dropdown

VIC

Client Fees – Other

Text Input

VIC

Purchasing Contract Identifier

Text Input

VIC, QLD, SA, WA, TAS, NT

Purchasing Contract Schedule Identifier

Dropdown

VIC, QLD, SA, WA, TAS, NT

 

VET / Schools Fields

VET / Schools Fields

State-based Fields

Unit Field

Input Type

Visibility Condition

VET in Schools Flag

Dropdown

Any Reporting State

Eligibility Exemption Indicator

Dropdown

VIC

VET Student Loans Indicator

Dropdown

VIC

 

 

WA-Specific Fields

WA-Specific Fields

WA-related Fields unless stated otherwise

Unit Field

Input Type

Visibility Condition

Enrolled School ID

Dropdown

WA

Current School Level ID

Dropdown

WA

Training Type ID

Dropdown

WA

Enrolment Category ID

Dropdown

WA

Income Contingent Loan Liability

Text Input

WA

Fee Maintenance Flag

Dropdown

WA

TAFE International Client ID

Dropdown

WA AND TAFE

Employer Contribution Flag

Dropdown

WA

Enrolment Liability Type ID

Dropdown

WA AND TAFE

 

Other Fields

Other Fields

State-based Fields

Unit Field

Input Type

Visibility Condition

Hours Attended

Text Input

VIC, QLD, SA

Associated Course ID

Text Input

VIC, WA

Scheduled Hours

Text Input

Any Reporting State

Delivery Provider ABN

Text Input

VIC

Workplace ABN

Text Input

VIC

Program Unique Supervised Hours

Text Input

VIC

Subject Enrolment ID

Text Input

VIC

 

VSL Fields

VSL Fields

VSL related Fields

Unit Field

Input Type

Visibility Condition

Census Date

Date picker

WA or VSL

Unit of Study is Full Year

Dropdown

VSL

EFTSL

Text Input

VSL

Unit of Study Status Code

Dropdown

VSL

Course Assurance Indicator

Dropdown

VSL

Mode of Attendance

Dropdown

VSL

Student Status Code

Dropdown

VSL

Amount Charged

Text Input

VSL

Amount Paid Upfront

Text Input

VSL

Loan Fee

Text Input

VSL

HELP Loan Amount

Text Input

VSL

Recognition of Prior Learning Code

Dropdown

VSL

Remission Reason

Dropdown

VSL

 

That's it! You've successfully bulk update units in the SMS!


Congratulations on completing this tutorial. We hope this has been helpful to you and your organisation. For any questions or concerns regarding this function, please reach out to us via email at