SCAS Data Extract (Vic)

Overview

The SCAS Data Extract (Vic) program provides a tool for Victorian schools to extract student data to a CSV (comma-separated value) file. This file can be uploaded into the Student Conveyance Allowance System (SCAS) using the 'Import Student Enrolment Data' facility.

SCAS (Student Conveyance Allowance System) is an online conveyance allowance claims system for Victorian schools.

General Tab

Fields from the 'General' tab can be used as selection criteria to filter the data that will be included in the Excel® sheet. These tabs are similar to those displayed in TASS.web Student Admin > Student Records > Student Information > Students.

User Defined Tab

Use the fields on this tab to further filter the students who will be included in the export.

Process Tab

This tab is used to enter information that will be included in your report and to choose the file format.

Address

The default for this field is to include the school's nominated 'Default Address' that is set up in TASS.web Student Admin > Parent Records > Setup Information > Parent Records Setup on the 'Parents' tab, for each address record extracted.

If you nominate to use an address other than the school default address, the system will look at this address (that you nominate here) first. If it doesn't find any detail for a record, it will then revert to using the default address.

Select 'GO' to proceed and create the upload file.

SCAS Format

Field #	SCAS Field	Max Gov Field Length	Value	TASS Program/Field Name
1	Student VSN	9	Mandatory	TASS.web Student Admin > Student Records > Student Information > Students. 'VSN Number'. (Also 'Student VSN' on 'VSR' tab.)
2	Student Identifier	10	Mandatory	TASS.web Student Admin > Student Records > Student Information > Students. 'Student Code'.
3	Student First Name	20	Mandatory	TASS.web Student Admin > Student Records > Student Information > Students. 'Given Names' (first name only).
4	Student Surname	30	Mandatory	TASS.web Student Admin > Student Records > Student Information > Students. 'Surname'.
5	Student Date of Birth	10	Mandatory Must be dd/mm/yyyy format	TASS.web Student Admin > Student Records > Student Information > Students. 'Date of Birth'.
6	Student Full Time Equivalent	3	Mandatory Must be N.N format	'1.0'.
7	Student Enrolment Date	10	Mandatory Must be dd/mm/yyyy format	TASS.web Student Admin > Student Records > Student Information > Students. 'Date of Entry'.
8	Student Exit Date	10	Optional Must be dd/mm/yyyy format	TASS.web Student Admin > Student Records > Student Information > Students. 'Date of Leaving'.
9	Student Year Level	2	Mandatory	TASS.web Student Admin > Student Records > Student Information > Students. 'Year Group'
10	Student Contact Number	30	Mandatory	TASS.web Student Admin > Parent Records > Parent Information > Parents. 'Home Phone'.
11	Student Residential Address 1	30	Mandatory	TASS.web Student Admin > Parent Records > Parent Information > Parents. 'Address Line 1' OR 'Address Line 2' if 'Address Line 1' is NULL.
12	Student Residential Address 2	30	Mandatory, if field 11 is null	TASS.web Student Admin > Parent Records > Parent Information > Parents. 'Address Line 2' OR 'Address Line 3' if 'Address Line 1' is NULL.
13	Student Residential Suburb	30	Mandatory	TASS.web Student Admin > Parent Records > Parent Information > Parents. 'Town/Suburb'.
14	Student Residential Postcode	4	Mandatory	TASS.web Student Admin > Parent Records > Parent Information > Parents. 'Post Code'.
15	Applicant First Name	20	Highly Recommended	NULL.
16	Applicant Surname	30	Highly Recommended	NULL.
17	Applicant Contact	20	Highly Recommended	NULL.
18	Applicant Residential Address 1	30	Highly Recommended	NULL.
19	Applicant Residential Address 2	30	Highly Recommended	NULL.
20	Applicant Residential Suburb	30	Highly Recommended	NULL.
21	Applicant Residential Postcode	4	Highly Recommended	NULL.