Import_Export Student Data - CEO tab

Use the CEO tab to:

Export:

- student classes
- student details
- fee and charge details
- student religious background
- junior school literacy and reading recovery results.
Import:

- pre-test literacy data
- post-test literacy data
- reading recovery data
- student addresses.

Note: Only Catholic schools in Victoria use this option. In this case, the MCEECDYA export is not required, as the CEO provide this data on behalf of the school.

Check the information in School Settings Maintenance to ensure the data is up to date.

Opening the CEO tab

To open the CEO tab:

Select Module > Students > Student Data Import/Export from the main menu.
The WA SCSA tab of the Import/Export Student Data window is displayed.
Tip: You can also access the student import and export functions by clicking .
Click the CEO tab.
The CEO tab of the Import/Export Student Data window is displayed.

Export mode fields

The following fields are displayed if the Export mode is selected.

Important: Refugees that have become Australian citizens are not reported as refugees. You can update the citizenship status of refugees to Australian Citizen by selecting a record with an ExternalSystemCode of AC in the Status drop-down list of the International tab of Current Student Maintenance. See Current Student Maintenance - International tab.

For information about updating the records available in the Status drop-down list, see luCitizenshipStatus lookup table.

Field

Description

File to Create

Type of export file to create.

Note: The School and School Board Information must be the first file produced.

File

Description

School and School Board Information

Export school information including class groupings, LOTE provided, timetable structure, number of families, and school board and parish details.

View configuration details

School and School Board Information

CEO field	Description
CEOSchoolCode	CEO school code assigned to your organisation.
	Key configuration details
	This value is defined using the School System Code field on the Page 1 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab.
BoardMembersFemale	Number of female board members at your organisation.
	Key configuration details
	This value is defined using the Number of Board Members - Female field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
BoardMembersMale	Number of male board members at your organisation.
	Key configuration details
	This value is defined using the Number of Board Members - Male field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
BoardName	Name of your school board.
	Key configuration details
	This value is defined using the Board Name field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
BoardType	Type of school board.
	Key configuration details
	This value is defined using the Board Type field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
PresidentCanonicalAdminParish	Canonical administrator for your organisation.
	Key configuration details
	This value is defined using the President of Canonical Admin Parish field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
ClassGroupComments	Comments about the class group.
	Key configuration details
	This value is defined using the Class Group Comments field on the Page 1 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 1 sub-tab.
LOTE1CEOCode to LOTE6CEOCode	External codes used to identify the LOTE (Languages Other Than English) programs taught at your organisation. Note: You can record up to six LOTE programs.
	Key configuration details
	These values are defined using the Ext Code field on the LOTE Codes tab of School Settings Maintenance. See School Settings Maintenance - LOTE Codes tab.
LOTE1ProgramTypeCEOCode to LOTE6ProgramTypeCEOCode	Program types used for the LOTE (Languages Other Than English) programs taught at your organisation. Note: You can record up to six LOTE programs.
	Key configuration details
	These values are defined using the ProgramType field on the LOTE Codes tab of School Settings Maintenance. See School Settings Maintenance - LOTE Codes tab. Note: You need to load CEO values into the luLOTEProgramType lookup table to correctly populate the Parish field. For information about loading lookup tables for external systems, see Loading lookup tables for external systems.
LOTE1LessonDurationMinutesPrep to LOTE6LessonDurationMinutesPrep to LOTE1LessonDurationMinutesYear6 to LOTE6LessonDurationMinutesYear6	Lesson duration for each LOTE Program taught to junior school students at your organisation.
	Key configuration details
	These values are defined using the LOTE Code, Level and Lesson Duration (Minutes) fields on the LOTE by Year Level tab of School Settings Maintenance. See School Settings Maintenance - LOTE by Year Level tab.
LOTE1LessonsPerWeekPrep to LOTE6LessonsPerWeekPrep to LOTE1LessonsPerWeekYear6 to LOTE6LessonsPerWeekYear6	Number of lessons per week for each LOTE Program taught to junior school students at your organisation.
	Key configuration details
	These values are defined using the LOTE Code, Level and Number of lessons per Week fields on the LOTE by Year Level tab of School Settings Maintenance. See School Settings Maintenance - LOTE by Year Level tab.
LOTE1NumberOfTermsPrep to LOTE6NumberOfTermsPrep to LOTE1NumberOfTermsYear12 to LOTE6NumberOfTermsYear12	Number of terms for each LOTE Program taught to all students at your organisation.
	Key configuration details
	These values are defined using the LOTE Code, Level and Number of Terms fields on the LOTE by Year Level tab of School Settings Maintenance. See School Settings Maintenance - LOTE by Year Level tab.
LOTE1SelectionCriteriaCEOCodePrep to LOTE6SelectionCriteriaCEOCodePrep to LOTE1SelectionCriteriaCEOCodeYear6 to LOTE6SelectionCriteriaCEOCodeYear6	Criteria used to select the students for each LOTE Program taught to junior school students at your organisation.
	Key configuration details
	These values are defined using the LOTE Code, Level and Selection Criteria Code fields on the LOTE by Year Level tab of School Settings Maintenance. See School Settings Maintenance - LOTE by Year Level tab.
LOTEPolicyCEOCodeYear7 to LOTEPolicyCEOCodeYear12	CEO language policy code for each secondary school year level.
	Key configuration details
	These values are defined using the CEOLanguagePolicyCode field in the luYearLevel lookup table. See luYearLevel lookup table.
LOTE1StudyPeriodsPerCycleYear7 to LOTE6StudyPeriodsPerCycleYear7 to LOTE1StudyPeriodsPerCycleYear12 to LOTE6StudyPeriodsPerCycleYear12	Number of study periods per cycle for each LOTE Program taught to secondary school students at your organisation.
	Key configuration details
	These values are defined using the Study periods per cycle field on the LOTE by Year Level tab of School Settings Maintenance. See School Settings Maintenance - LOTE by Year Level tab.
TimetableCycleDays	Number of days in the timetable cycle.
	Key configuration details
	This value is defined using the CycleDays field of the luTimetableGroup lookup table. See luTimetableGroup lookup table.
TimetablePeriodsPerCycle	Number of periods in a day.
	Key configuration details
	This value is defined using the Periods field of the luTimetableGroup lookup table. See luTimetableGroup lookup table.
TimetableAverageMinutes	Average period duration in minutes.
	Key configuration details
	This value is defined using the TimeFrom and TimeTo fields on the Timetable Definition tab of Timetable Maintenance. See Timetable Maintenance - Timetable Definition tab.
LanguagesPolicy	Languages policy of your organisation.
	Key configuration details
	This value is defined using the Languages Policy field on the Page 1 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab.
AdminSystemName	SMS system used by your organisation. Note: This value is hard-coded to "Synergetic".
Version	Version of Synergetic used by your organisation.
SchoolHasBoardFlag	Whether your organisation has a governing board.
	Key configuration details
	This value is defined using the School has a Board field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
OtherSchoolsServed	Other schools served by your organisation's board.
	Key configuration details
	This value is defined using the Other Schools Served by the Board field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab.
ExternalSystemCode	External system code used to identify the body of canonical jurisdiction that your organisation operates under.
	Key configuration details
	This value is defined using the ExternalSystemCode linked to the body of canonical jurisdiction selected using the Body of Canonical Jurisdiction field on the Page 2 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab - Page 2 sub-tab. Note: You need to load CEO values into the luSchoolCanonicalJurisdictionBody lookup table to correctly populate the Body of Canonical Jurisdiction field. For information about loading lookup tables for external systems, see Loading lookup tables for external systems.

School Fees and Charges

Export fee information including school fees and charges and other fees including recurrent, capital, and other fees.

View configuration details

School Fees and Charges

CEO field	Description
CEOSchoolCode	CEO school code assigned to your organisation.
	Key configuration details
	This value is defined using the School System Code field on the Page 1 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab.
Year0SchoolFees to Year12SchoolFees	Total school fees for each year level.
	Key configuration details
	These values are defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SchoolFeesRecurrent. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
FamilySchoolFees	Total school fees for all year levels.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SchoolFeesRecurrent. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Year0CapitalFee to Year12CapitalFee	Total capital fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SchoolFeesCapital. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
FamilyCapitalFee	Total capital fees for all year levels.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SchoolFeesCapital. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Year0210 to Year12210	Total compulsory tuition fees for each year level.
	Key configuration details
	These values are defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of CompulsoryTuition. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Family210	Total compulsory tuition fees for all year levels.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of CompulsoryTuition. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
RegistrationFee	Application fee amount.
	Key configuration details
	This value is defined using the Deposit Type field of Enrolment Deposit Definitions Maintenance. See Maintaining enrolment deposit definitions. The application fee has a Deposit Type of A (Application Fee).
EnrolmentFee	Non-refundable enrolment fee amount.
	Key configuration details
	This value is defined using the Deposit Type field of Enrolment Deposit Definitions Maintenance. See Maintaining enrolment deposit definitions. The enrolment fee has a Deposit Type of E (Enrolment Fee).
EnrolmentFeeRefundable	Refundable enrolment fee amount.
	Key configuration details
	This value is defined using the Deposit Type and Refundable Deposit fields of Enrolment Deposit Definitions Maintenance. See Maintaining enrolment deposit definitions. The refundable enrolment fee has the Refundable Deposit field selected and a Deposit Type of E (Enrolment Fee).
InterestFreeLoan	Interest-free loan amount.
	Key configuration details
	This value is defined using the Deposit Type field of Enrolment Deposit Definitions Maintenance. See Maintaining enrolment deposit definitions. The interest-free loan has the Refundable Deposit field selected and a Deposit Type of I (Interest Free Loan).
InterestFreeLoanComment	Additional comment for the interest-free loan.
	Key configuration details
	This value is defined using the Deposit Type and Comment fields of Enrolment Deposit Definitions Maintenance. See Maintaining enrolment deposit definitions. The comment is entered into the Comment field of the interest-free loan with a Deposit Type of I (Interest Free Loan).
FeeDiscountsComment	Leave this field blank.
NumberFamilies	Total number of families sending students to your organisation.
	Key configuration details
	This value is defined by calculating the number of primary (SC1) contacts linked to students for the current file year. Note: You can define primary (SC1) contacts using the Relations tab of Current Student Maintenance. See Current Student Maintenance - Relations tab.
Year0ExcursionLevyTotal to Year12ExcursionLevyTotal	Combined total of all levy fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with SynergyMeaning of CampLevies, ExcursionLevies, SacramentLevies, SportsLevies, SwimmingLevies. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
TwoTieredFeeStructureFamilyFlag	This value is always "No".
TwoTieredFeeStructureStudentFlag	This value is always "No".
TwoTieredFeeStructureLowestFee	This value is always "0".
FeeStructureOneChildFlag to FeeStructureFourOrMoreChildFlag	Whether a two-tiered fee structure is offered on a per-student basis.
	Key configuration details
	These values are defined using the Fee Structure for One Child, Fee Structure for Two Children, Fee Structure for Three Children fields of the Page 1 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab.
DebtorBillingPeriods	Number of billing periods that you charge your debtors.
	Key configuration details
	This value is defined using the Debtor Billing Periods Per Year field on the Page 1 sub-tab of the Debtors tab of Synergetic Financial Configuration. See Synergetic Financial Configuration - Debtors tab.
Year0SwimmingLevy to Year12SwimmingLevy	Total swimming levy fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SwimmingLevies. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Year0CampLevy to Year12CampLevy	Total camp levy fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of CampLevies. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Year0ExcursionLevy to Year12ExcursionLevy	Total excursion levy fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of ExcursionLevies. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Year0SacLevy to Year12SacLevy	Total sacrament levy fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SacramentLevies. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.
Year0OtherLevy to Year12OtherLevy	Other levy fees for each year level.
	Key configuration details
	This value is defined by calculating the sum of fees linked to fee categories with a SynergyMeaning of SportsLevies. See luDebtorFeeCategory lookup table. Note: You can select the fee category used for fees charged at your organisation using the Fee Category field on the General tab of Debtor Fee Maintenance. See Debtor Fee Maintenance - General tab.

February Census

Export census data for all students attending as of the February census date.

View configuration details

February Census

CEO field	Description
SchoolCode	CEO school code assigned to your organisation.
	Key configuration details
	This value is defined using the School System Code field on the Page 1 sub-tab of the School tab of School Settings Maintenance. See School Settings Maintenance - School tab.
CampusNumber	Campus of the student.
	Key configuration details
	This value is defined using the Campus field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab. The values of the Campus field are defined using the luCampus lookup table. See luCampus lookup table.
StudentID	Synergetic ID of the student.
	Key configuration details
	This value is defined using the Synergetic Community ID of the student.
StudentSurname	Surname of the student.
	Key configuration details
	This value is defined using the Surname field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
StudentGiven1	Given name of the student.
	Key configuration details
	This value is defined using the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
StudentGiven2	Middle names of the student.
	Key configuration details
	This value is defined using the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
Gender	Gender of the student. Note: You can define the list of genders used at your organisation using the luGender lookup table. See luGender lookup table.
	Key configuration details
	This value is defined using the Gender field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
BirthDate	Date of birth of the student.
	Key configuration details
	This value is defined using the Date of Birth field on the Other tab of Community Maintenance. See Community Maintenance - Other tab.
ParishCode	Parish of the student.
	Key configuration details
	This value is defined using the Parish field on the Other tab of Community Maintenance. See Community Maintenance - Other tab. The values of the Parish field are defined using the luParish lookup table. See luParish lookup table. Note: You need to load CEO values into the luParish lookup table to correctly populate the Parish field. For information about loading lookup tables for external systems, see Loading lookup tables for external systems.
EntryDate	Date the student entered your organisation.
	Key configuration details
	This value is defined using the Entry Date field on the Entry tab of Current Student Maintenance. See Current Student Maintenance - Entry tab.
YearLevel	Year level of the student.
	Key configuration details
	This value is defined using the Year Level field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab. The values of the Year Level field are defined using the luYearLevel lookup table. See luYearLevel lookup table.
ClassInSchool	Form or tutor group of the student.
	Key configuration details
	This value is defined using the Form and Tutor Group fields on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab. The values of the Form field are defined using the luForm lookup table. See luForm lookup table. The values of the Tutor Group field are defined using the luTutor lookup table. See luTutor lookup table.
PartTimeFlag	Whether the student is part-time.
	Key configuration details
	This value is defined using the FTE field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab. This value is Y when FTE is less than 1.0. Otherwise, this value is N.
FTE	FTE of the student at your organisation.
	Key configuration details
	This value is defined using the FTE field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
OtherSchoolCEOCode	School code identifying the other external school the student is attending.
	Key configuration details
	This value is defined using the SchoolCode field on the Other Schools Attended sub-tab of the External tab of Current Student Maintenance. See Current Student Maintenance - External tab. Note: You need to load CEO values into the luSchool lookup table to correctly populate the SchoolCode field. For information about loading lookup tables for external systems, see Loading lookup tables for external systems.