V69 - Independent Schools Victoria - SFOE Collection (2019)
- Graham Kidd
SFOE - Student Family Occupation and Education data
First Release Version
69.26, Hot-Fix
Table of Contents
Background
Independent Schools Victoria (ISV) collects Student Family Occupation and Education data (SFOE) from Independent Schools and provides it to Victoria’s Department of Education and Training (Vic DET). Victorian Independent Schools are required to submit SFOE data via a spreadsheet template provided by ISV.
SFOE Data Calculation Form 2019.xlsx
Synergetic Solution
Synergetic produce the data that populates the spreadsheet template via:
- Students > Student Data Import/Export > Demographic > Vic > Export File: SFOE
File Creation Parameters
Field | Usage | Description |
|---|---|---|
| Year | Mandatory | Select the File Year for the SFOE collection |
| Term | Mandatory | Select the Term for the SFOE collection |
| Campus | Optional | Select one campus to restrict file creation contents to If blank - all campuses are included. |
| State | Mandatory | Select VIC |
| Export File | Mandatory | SFOE |
| School Code | Not Used | N/A |
| Field Delimiter | Mandatory | Select required file field delimiter |
Year Level From | Optional | Lowest Year Level for the SFOE collection |
Year Level To | Optional | Highest Year Level for the SFOE collection |
| Process Date | Mandatory | The maximum date up until which students will be selected. If a student's Entry Date is after this date, they will be excluded. If a student's Leaving Date is before this date, they will be excluded. |
| File Name | Mandatory | The Location and File Name the SFOE file is to be saved to. |
Note: The ISV specification calls for “local students currently enrolled at the school”. Synergetic has implemented this as all Current students who are not Full Fee, Shortstay, Exchange or External for the current File Year.
The data in the file conforms to the instruction in the ISV template:
- Parent 1 refers to Mother/Guardian 1.
- Parent 2 refers to Father/Guardian 2
Produce the collection file:
Once the output file has been produced, navigate to and open it in MS-Excel (you may need to tell Excel the Field De-limiter).
The file will contain data rows with the seven (7) data columns required by ISV.
Copy these data rows (not including the header row) and drop them into the ISV template, fill in School Name field and submit.