Custom Athlete Requirements - Variable/Condition

Interface Breakdown

The Variable/Condition portion of the Custom Athlete Requirements interface is based on the data source selection.

For our example rule 'Participation Fee'; our data source will be the 'Decimal Number' designation of the Data Type drop-down within the 'independent' data source set 'equal(=)' to the 'Compare Value(s)' of 60.50. This will allow our system to check if an athlete has paid 'exactly' $60.50 worth of a participation fee in order to be considered eligible to join a sports team. However, this article will endeavor to outline all other possibilities you may encounter during the creation of your rule.

All requirements will require a 'Comparison Operator' in which you will define how existing data is compared with a requirement property. This value can look like...

...

...The Condition determines what type of comparison operation will be done on a value to determine if it is valid. In the case of eligibility requirements, it helps to determine if a value is a "pass" or "fail". Condition's work in conjunction with a value(s) and sometimes with a "quantifier", both of which will be discussed later. Here are the possible conditions:

  • =(equal to) - When using a "=" condition, the variable will be compared for an exact match with provided value. Example: If a athlete must be exactly 16 to pass the eligibility requirement, then "=" would be used with a a value of 16.
  • !=(not equal to) - When using a "!=" condition, the variable will be checked and expected not to match. Example: If a athlete can be any age except 16, then "!=" would be used and a value of 16 would be provided.
  • >(greater than) - This condition indicates that the variable's value must exceed the provided value in order to pass. Only applies to numbers and dates. Example: If a athlete must be at least 16 to play, then a ">" condition can be used with a value of 15 (not 16).
  • <(less than) - This condition indicates that the variable's value must be less than the provided value. Only applies to numbers and dates. Example: If a athlete can no longer play once they turn 16, then the "<" condition can be used with a value of 16.
  • >=(greater than or equal to) - This condition is a combination of the "=" and ">" conditions. Only applies to numbers and dates. Example: If a athlete must be at least 16 to play, then ">=" could be used with a value of 16.
  • <=(less than or equal to) - This condition is a combination of the "=" and "<" conditions. Only applies to numbers and dates. Example: If a athlete becomes to old to play at 16 then the "<=" condition can be used with a value of 15.
  • IN - This op allows you to specify multiple exact value options. Values must be separated by commas with no spaces. Example: If you must either 15, 16 or 17 to play, then the "IN" condition could be used with a value of "15,16,17".
  • NOT IN - This op allows you to specify multiple values that should not match exactly. Values must be separated by commas with no spaces. Example: If you can be any age but 15 and 16, the the "NOT IN" condition can be used with a value of "15,16".

...or...

...

...which could identify a required certification or set of certifications one must hold in order to satisfy a particular rule requirement.

Data Source: Independant

Under the 'Independant' data source selection you have the option of several data types:

...

...with:

Text = An input box that will allow any value containing numbers and/or letters. This will be the least common eligibility requirement and it has the least number of evaluation options.

Whole Number = The requirement is solely a whole number value. An example of this could be a organization that requires all individuals to sell 5 boxes of candy bars.

Decimal Number = The requirement is solely a number value that can contain a decimal. An example of this could be a school that requires all individuals to bring in $60.50 for a Pay-To-Play fee.

Yes/No = This is the simplest independent data type where a user can specify that Yes a requirement has been met or No it has not been met.

Date = Requirement is a date, typically one that expires. An example of this is an individuals Physical Evaluation. When filling in the eligibility information, the user would provide the date of the last physical the individual received. The requirement parameters would like dictate that a athlete fails the check if the date is more than 1 year old.

Data Source: Person Record

Under the 'Person Record' data source selection you have the option of several variables:

...

...in which you can select (if applicable) the variable that you require for your rule. Understanding the following 4 variables will help you understand all the options:

  • Age Yr (Current) - This is the current age of a person represented as a floored integer. This means that the value will be a whole number such as 16, 17, 18, etc... and will be rounded down to 17 if the person is 17.99 years old (hence the term "floored").
  • Age Yr (Jan 1st) - This is the individuals age, represented as a floored integer, as of the last January 1st. Example: If an eligibility report is run on June 1st, and a athlete turned 17 on April 1st, then a result of 16 would be returned. This is because on Jan 1st, the individual was 16.
  • Age Mon (Current) - This is the current age of a person represented as the number of months they have been alive as a floored integer. Example: In Florida you can not be older than 19 years 9 months and compete in FHSAA competitions. To accommodate this, the 19/9 rule will ensure that a person's "Age Mon (Current)" is less than 237 (12*9+9).
  • Age Mon (Sep 1st) - This represents the number of months a person has lived as of the beginning of the last September. It combines all of the above concepts.

Data Source: Person Property

Under the 'Person Property' data source selection you have the option of several properties:

A property is a special attribute or data item as it relates to a particular person in the database. This may not apply to all users so it can be thought of as extended person information.

  • DEK-DE12 - DE means "Date Entered" and the "K" or numbers following the DE represents a school grade level. This property has a data type of "date".
  • GPA - Meaning "Grade Point Average", this represents an individuals GPA. This property has a data type of a "number".
  • Grade - This represents an individuals current grade level. This property has a data type of a "number".
  • Ht - An individual's height.
  • Wt - An individual's weight.

Data Source: Certifications

Under the 'Certifications' data source selection you have the option of several certifications:

Select the certifications an individual must have one, some, or all of to qualify for your rule.

Data Source: Grades

Under the 'Grades' data source selection you have the option of comparing current grades against a mix of current or historical grade values based on certain class or value requirements.

Data Source: Special/Derived

Under the 'Special/Derived' data source selection you have the option of comparing a special or derived variable against another value.

Is this article helpful for you?