Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before using your timetable, you need to ensure that:

...

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

...

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

 

...

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

...

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

 

 

 

...