Defining and setting up timetables

Before using your timetable, you need to ensure that:

  • normal year levels are defined for all teaching staff members
  • timetable reference data is up to date.

Allocating Normal Year Levels for teaching staff

In order for staff timetables to be defined you must first allocate a Normal Year Level for each teaching staff member in the School tab of Staff Maintenance. See Staff Maintenance - School tab in the Human resources manual.

This is required because Timetable Maintenance uses the year level to define the appropriate format of each timetable.

Note: If timetables are not appearing for some staff members, check that these normal year levels have been set.
 

Maintaining timetable reference tables

There are a number of Synergetic database tables that you need to set up with all your organisation's timetabling information.

The relevant tables are:

  • luTimeTableGroup
  • luYearLevel
  • TimetableDefinition
  • TimeTable
  • CalendarEvents.

The following explains the tables that you need to define in order to manipulate the timetable.

luTimetableGroup lookup table

This lookup table defines cycle days in the timetable, actual days in week and periods. See Maintaining lookup tables.

Field

Example

Code

SEN

Description

Senior TT (timetable)

Cycle Days

7

ActualDaysInWeek

5

Periods

6

See luTimetableGroup lookup table.
 

luTimetableOperationMode lookup table

This lookup table defines configurations used when importing timetables automatically into Synergetic. See luTimetableOperationMode lookup table.
 

luYearLevel lookup table

Use this lookup table to define the campus and year level along with the timetable group.

Note: The following sample has been broken into three sections for readability.

See luYearLevel lookup table (Next Year Process).

All fields, including those not shown in the example above, are detailed below.

Field

Example

Additional details

Campus

S

 

Code

7

 

YearLevelSort

107

 

Description

Year 7

 

YearLevelCoordinator

Allan Morton

 

NextYearCampusMale

S

Used to alter records on roll over to new year.

NextYearLevelMale

8

Used to alter records on roll over to new year.

NextYearCampusFemale

S

Used to alter records on roll over to new year.

NextYearLevelFemale

8

Used to alter records on roll over to new year.

TimetableGroup

SEN

 

ClearFormFlag

Not selected

Used to alter records on roll over to new year.

ClearHouseFlag

Not selected

Used to alter records on roll over to new year.

ClearTutorFlag

Not selected

Used to alter records on roll over to new year.

YearsUntilGraduation

5

 

CEOLanguagePolicyCode

 

 

YearLevelGroup

 

 

SubSchool

 

 

FormFieldName

Form

 

ExternalSystemCode

6

 

ClearLockerBookFlag

Selected

Used to alter records on roll over to new year.

ClearLockerOtherFlag

Selected

Used to alter records on roll over to new year.

ExportSortKey

 

 

IncludeInCensusFlag

Selected

 

See luYearLevel lookup table.
 

TimetableDefinition

Define the structure of the timetable for each period in each day.

This information is set up in the Timetable Definition tab of Timetable Maintenance. See Timetable Maintenance - Timetable Definition tab in the Curriculum manual.

 

TimeTable tab

Defines the actual day number, period, room, class and staff member.

This information can be either:

Field

Examples

 

 

 

Group

SEN

SEN

SEN

SEN

Day

3

5

3

5

Period

1

1

2

2

Campus

S

S

S

S

Class

7ART

7ART

7COMP

7COMP

StaffID

6

6

1

1

Room

Room 10

Room 10

Room 11

Room 11

StudentID

0

0

0

0

TimetableDate

NULL

NULL

NULL

NULL

Year

2010

2010

2010

2010

Semester

1

1

1

1

Type

A

A

A

A

T/TSeq

3

1

4

2


CalendarEvents tab

This table is used to define special events that you might want to display on the timetable, as well as the starting day of the calendar cycle. This is important for seven day rotating timetables. See Timetable Maintenance - Calendar Events tab in the Curriculum manual.

To define the start, enter the date, CalendarType as D and the starting day number. For example if Monday 21st January is Day 1, enter D1 in Calendar Type. Also enter the description.

Field

Examples

 

 

CalendarSeq

1

2

3

CalendarDate

2006-01-20

2006-08-28

2006-09-13

CalendarType

D1

 

 

FileType

 

S

 

ClassCampus

 

 

 

ClassCode

 

12SoftA

 

Location

 

 

 

LocationContact

 

 

 

Description

Swimming carnival

 

 

Comment

 

 

 

Result

 

 

 

Using the CalendarEvent table, you can change days in the timetable around. For example, if you have a number of public holidays on the same day of the week and want to redefine the timetable for a week to deliver the public holiday timetable on a different day.