Previous icon

Next icon

luYearLevel lookup table

Description

The luYearLevel lookup table is used to define:

Rules for creating new academic years

You must have the next year's campus and year levels defined. When you create the new academic year, the particular year level is 'rolled up' into the next year level (and possibly a different campus).

You must specify the next year level for both boys and girls if your organisation is co-educational. If there is no valid next year level defined, the students are not transferred.

Select the relevant flags to clear the Form, House, Tutor Group and two Locker fields, if required.

Examples

Lookup Table Maintenance - luYearLevel (part 1)

Lookup Table Maintenance - luYearLevel (part 2)

Lookup Table Maintenance - luYearLevel (part 3)

Lookup Table Maintenance - luYearLevel (part 4)

Fields

Field

Description

Code

Numeric code for the year level.

Description

Description title for the year level-campus combination.

Campus

Campus code for the year level.

Each campus is defined in the luCampus lookup table.

When creating current students, if you have different year levels at each campus, you can filter the Year Level based on the selected Campus. In the following example, the Senior campus is selected. The Year Level drop-down list only shows year levels that apply to the campus.

Create New Student - School window (Filter Year Level based on Campus)

This uses the Code and Description fields:

  • based on the selected Campus
  • sorted using the YearLevelSort field.

Lookup Table Maintenance - luYearLevel (Filtering Year Level by Campus)

YearLevelSort

Number used to sort the drop-down list of year levels.

YearLevel-
Coordinator

Name of the coordinator for the year level-campus combination.

NextYear-
CampusMale

Campus to transfer male students to, who are in this year level-campus combination, when creating a new academic year.

NextYear-
LevelMale

Year level to transfer male students to, who are in this year level-campus combination, when creating a new academic year.

Note: Set the value for year 12 students to an invalid year level so that they will not be transferred to the next academic year. For example, 99.

NextYear-
CampusFemale

Campus to transfer female students to, who are in this year level-campus combination, when creating a new academic year.

NextYear-
LevelFemale

Year level to transfer female students to, who are in this year level-campus combination, when creating a new academic year.

Note: Set the value for year 12 students to an invalid year level so that they will not be transferred to the next academic year. For example, 99.

TimetableGroup

Timetable group code for the year level-campus combination.

Note: You can define timetable groups in the luTimetableGroup lookup table. See luTimetableGroup lookup table in the System maintenance manual.

ClearFormFlag

Select this field to clear the Form field on the School tab of students who are transferred when the new academic year is created.

Current Student Maintenance - School tab (Form)

See Current Student Maintenance - School tab - Status sub-tab in the Current students manual.

ClearHouseFlag

Select this field to clear the House field on the School tab of students who are transferred when the new academic year is created.

Current Student Maintenance - School tab (House)

See Current Student Maintenance - School tab - Status sub-tab in the Current students manual.

ClearTutorFlag

Select this field to clear the Tutor field on the School tab of students who are transferred when the new academic year is created.

Current Student Maintenance - School tab (Tutor Group)

See Current Student Maintenance - School tab - Status sub-tab in the Current students manual.

YearsUntil-
Graduation

Used to determine peer year when transferring current students to past students. For example year 12 students have 0 years until graduation, while year 7 students have 5 years until graduation.

Important Note: This field must be set consistently across all year levels, or Synergetic's calculation of a student's Peer Year may be incorrect.

CEOLanguage-
PolicyCode

CEO language policy code for the selected year level. Typical values include:

  • CL - Compulsory
  • CLESL - Compulsory (except for ESL students)
  • O - Optional.

YearLevelGroup

 

Link the year level to a year level group. These can be used to:

  • link year levels for custom Crystal Reports
  • filter whether award points are applied to students based on their year level on the Awards sub-tab of Subject Assessment Maintenance. See Defining criteria and points for an award in the Curriculum manual.

 

Note: You can define year level groups in the luYearLevelGroup lookup table. See luYearLevelGroup lookup table in the System maintenance manual.

 

Important Note: This field must be set consistently across all year levels, or Synergetic's calculation of a student's Peer Year may be incorrect.

SubSchool

Sub-school that the year level applies to. This is used mostly by multi-campus organisations that provide schooling for all year levels at each campus.

For example, year levels can be grouped into a:

  • junior school
  • middle school
  • senior school.

Lookup Table Maintenance - luYearLevel (cut down)

For example, you can search for current students based on their sub-school.

Set Current Student Search Criteria window (cut down)

Note: You can define sub-schools in the luSubSchool lookup table. See luSubSchool lookup table in the System maintenance manual.

FormFieldName

The values for the year level as stored as either:

  • Form and Home Room
  • TutorGroup.

This is primarily used for exports that require a field called Form. For example if Home Room is stored then that will be exported as Form.

ExternalSystem-
Code

Used to nominate the Normal Year Level that applies to the year level.

Usually this is a one-to-one correspondence.

Lookup Table Maintenance - luYearLevel (cut down)

ExternalSystem-
Type

Used for mapping data to external systems.

ClearLocker-
BookFlag

Select this field to clear the Locker Book field on the School tab of students who are transferred when the new academic year is created.

Students can be assigned new lockers at the start of the academic year. For example, students may have to transfer to different lockers when they move to a new tutor group based in a different cluster.

Current Student Maintenance - School tab (Locker book)

See Current Student Maintenance - School tab - Status sub-tab in the Current students manual.

ClearLocker-
OtherFlag

Select this field to clear the Locker Other field on the School tab of students who are transferred when the new academic year is created.

Students can be assigned new secondary lockers at the start of the academic year.

Current Student Maintenance - School tab (Locker other)

See Current Student Maintenance - School tab - Status sub-tab in the Current students manual.

ExportSortKey-
Group

Used for sorting NCEA exports at New Zealand schools. NCEA is part of the New Zealand National Qualifications Framework. See the National Certificates of Educational Achievement web site.

Available values are:

  • Form
  • House | YearLevel
  • TutorGroup
  • YearLevel | House.

CommPortal-
PublishFlag

All of the year levels you have selected are displayed on the community portal.

YearLevel-
CoordID

Synergetic ID of the year level coordinator for the year level-campus combination.

CommPortal-
Override-
ConfigKey5

Type in a unique value to represent this year level if you want to configure aspects of the Community Portal differently for this year level.

You can use the same value for several year levels if you want to configure them as a group in the Community Portal. For example, SEN for the senior year levels.

MaxStudents

Maximum number of students of the specified gender that should exist in this year level. This field is only used for reporting purposes.

EducationType

Type of education for the selected year level. You can select:

  • Primary
  • Secondary.

    Note: This field is used to categorise students in the Student Disability Adjustment Crystal Report. See Key current students reports in the Current students manual.

ModifiedDate

Date and time the lookup table entry was last modified.

ModifiedUser

User that last modified the lookup table entry.

Last modified: 22/05/2017 11:25:16 AM

See Also

Maintaining general setup data

luBuilding lookup table

luCampus lookup table

luCountry lookup table

luDepartment lookup table

luFileType lookup table

luForm lookup table

luHouse lookup table

luLocalisation lookup table

luRegion lookup table

luRoom lookup table

luState lookup table

luTutor lookup table

luYearLevelGroup lookup table

luTaskStatus lookup table

BlankTasksList configuration setting

Calendar:Enabled configuration setting

Core:Url configuration setting

CountryCode configuration setting

CustomIconTransparentColour configuration setting

Default:CountryOfBirthCode configuration setting

FirstDayOfWeek configuration setting

OverrideSenderText configuration setting

PrivateList:ExpiryDays configuration setting

PublicList:ExpiryDays configuration setting

RegionCode configuration setting

SuburbUpperCaseFlag configuration setting

TagList:AlwaysShow configuration setting

TagList:AutoClose configuration setting

© 2017 Synergetic Management Systems. Published 20 July 2017.

Top of page