Derived Fields can be used like any other data field, but they are derived from other fields of the participant and cannot be changed.
|
Age* |
Derived from date of birth and event date |
| AgeOnDec31 |
Participants age on December 31st in the event year |
|
YearOfBirth2 |
two digit year of birth (e.g. 83), derived from date of birth |
|
LastFirstName |
Combines last and first name to (e.g.) Doe, John |
| FirstLastName |
Combines first and last name to (e.g.) John Doe |
| AccountNoX | Like AccountNo, but the last 3 characters are replaced by X |
| IBANX |
Like IBAN, but the last 3 characters are replaced by X |
| StatusText | Return the status name according to the Status field (DSQ, DNF, etc.) |
| Random | Returns a random value between 0 and 1 |
| TransponderInChipfile |
If existing, this field returns the transponder code assigned by the Chip File |
*Age is normally derived however it can be imported in place of DateOfBirth or YearOfBirth, in this case the DateOfBirth will be stored as the event date on the year which would correspond to the age.