14.24. Levels

This tab is in the Sport Setup tab.

The Levels tab is used to define the competition levels (typically age groups) for the different events.

The age of each participant (the "qualifying age") is calculated based on the birthday field of the person's record in the People table as of the date specified as the Age Date in the Meets table. This age is then compared against the records in the Levels table to determine for which level the person qualifies.

The Minimum Age and Maximum Age values define the range of ages for the Level. People within this range are competitors at that Level. Typically the Min/Max Ages for the different Levels do not overlap, and together cover the entire age range for the sport. Sometimes there may be additional Levels based on additional criteria other than age.

The Min/Max Entry Age values are used to deteremine if a competitor is allowed to compete in an Event based on age. If the Levels are strictly done based on age, with no exceptions, then the Min/Max Entry Ages should be set to the same values as the Min/Max Ages. If people are allowed to compete in Levels outside of their own, the Min/Max Entry Ages should reflect that.

The Use Group Average field can be set to specify that, for group Events that use this Level, the qualifying age is the average (mean) of the qualifying age of all group members rather than the individual qualifying ages of group members.

14.24.1. Query and Edit Tabs

  • The ID field is the unique ID for this Level. The default ID prefix is L

  • The Name field is the name of the level. For example, "Bantam" or "Junior".

  • The Min Entry Age field is the youngest age allowed to compete in this level. If a competitor is younger than the Minimum Age but older or the same as the Min Entry Age, he is competing "up" in this Level. It is common to allow the best younger competitors to compete up in this way.

  • The Minimum Age field is the youngest age included in the level.

  • The Mamimum Age field is the oldest age included in the level. If the level includes only one year, the minimum and maximum ages will be the same number.

  • The Max Entry Age field is the oldest age allowed to compete in this level. If a competitor is older than the Maximum Age but older or the same as the Max Entry Age, he is competing "down" in this Level. Usually the Max Entry Age will be the same as the Maximum Age.

  • The Use Group Average field should be set to True on Levels for which group events should use the group average age. If not set, false is assumed.

14.24.2. Table

ColumnTypeDescription
idStringUnique ID [primary key]
nameStringName of this level
minEntryAgeint Minimum age of competitors allowed at this level
minAgeintMinimum age to belong to this level
maxAgeintMaximum age to belong to this level
maxEntryAgeint Maximum age of competitors allowed at this level
useAverageAgeboolean True if group Events using this Level should use group average age