The Participant Data Fields are specific to each individual participant record.
The following records can be entered or imported for each participant.
| Field | Type |
| Bib | int |
| Lastname |
string (100) |
| Firstname |
string (100) |
| Title |
string (15) |
| YearOfBirth |
int |
| DateOfBirth | date |
| Gender |
string (2) |
| Nation |
string (50) |
| Contest | int |
| Club |
string (100) |
| License |
string (25) |
| Status | int |
| Comment |
string (*) |
| Transponder1 |
string (40) |
| Transponder2 |
string (40) |
| RegNo |
int |
| Street |
string (100) |
| ZIP |
string (10) |
| City |
string (50) |
| State |
string (3) |
| Country |
string (50) |
|
string (100) |
|
| Phone |
string (50) |
| CellPhone |
string (255) |
| Language (See additional info below) | string (2) |
The following fields are automatically generated by the system during creation, see additional links for more information.
| Field | Type |
| ID |
int |
| AccountOwner |
string (50) |
| AccountNo |
string (12) |
| BranchNo |
string (12) |
| Bank |
string (50) |
| IBAN |
string (36) |
| BIC |
string (11) |
| SEPAMandate |
string (35) |
| Voucher |
string (20) |
| Created | date |
| CreatedBy |
string (25) |
| Modified | date |
|
GroupRegPos |
int |
| GroupID | int |
ID Field
ID is a field that is filled automatically with a unique number when the record is created. The field value cannot be changed.
It is useful for updating participants using a unique identifier which does not change, for example if you want to manually re-assign bib numbers.
Status Field
Status holds a number that represents the status of the participant:
- 0: Regular
- 1: Out of competition
- 2: DSQ
- 3: DNF
- 4: DNS
- 5: did not show up
You can use the derived field StatusText to show the status name instead.
If you need to use different status descriptions than the standard ones, you can set up a user-defined field or function, or adapt the existing WithStatus(x) function.
Note that there is only one Status field per participant entry. If you need to define different status values (e.g. in a team event, or in a stage race), you can use Additionnal Text Fields to set up further status fields.
Language
The language field is used when Sending Emails and SMS through RACE RESULT 12, to determine which lnaguage version of the template should be sent, if a multi-lingual template is used.
The Language field is automatically filled when a participant registers using the Online Registration with the language used in the form at the time of registration. The field can also be filled when importing participants or edited using data manipulation.
The default language field will take higher priority than any additional fields added with the same name (including translated versions).
YearOfBirth and DateOfBirth
The Year / Date of Birth field in the Participants window can be used to input a year of birth, a date of birth, or even an age if you activate the option Suppose input is age, if year of birth <100 under Main Window > Participants > General.
If you type or import a year of birth only, the date of birth will be set to January 1st in that year. If you type or import an age, the year of birth will be calculated based on the event date, and the date of birth will be set to the event day.
When importing via Excel, make sure to have only one field in your file with an indication of age, date, or year of birth.
DateOfBirth will be formatted according to the event date format. If you would like to show it in a different format, use the date() function.