What are the Default Columns available in Results?
When uploading results, each column must be mapped to either a default column or a custom column you’ve created.
Using the standard default column titles will allow the auto-mapping feature to correctly match any supported column types in your results file.
Please ensure all time values follow the recommended formatting guidelines.
Default columns
| Column Type | Description |
| Age |
Column with age integer
|
| Award Categories |
Column with a comma separated list of award categories (e.g. Overall, 30-39 Age Group)
|
| Award Labels |
Column with a comma separated list of award labels (e.g. Overall, 30-39 Age Group)
|
| Award Ranks |
Column with a comma separated list of award ranks/places (e.g. 3,1)
|
| Bib |
Column with unique bib number
|
| Chip Time |
Column with formatted time (HH:MM:SS.MS)
|
| Chip Time (* Boston Qualifier) |
Column with formatted time (HH:MM:SS.SS)
|
| City |
Column with city name
|
| Country |
Column with 2-3 character code for country
|
| Distance |
Column with the distance the participant has travelled
|
| Distance Unit |
Column with the distance unit
|
| Division |
Column with division label
|
| Division Participant Count |
Column with the number of participants with this participant's division
|
| Division Place |
Column with numeric division placing
|
| Elevation |
Column with the elevation the participant has climbed
|
| Elevation Unit |
Column with the elevation unit
|
| Final Time |
Column with a formatted time for "final time"
|
| Finish Time Local |
Column with a formatted date/time for "finish time local" (YYYY-MM-DD HH:MM:SS)
|
| Gender |
Column with a gender identifier [0|1|2|8|9] or [M|F|N|U|B] or a gender/sex label or UUID
|
| Gender Participant Count |
Column with the number of participants with this participant's gender
|
| Gender Place |
Column with numeric gender placing
|
| Gun Time |
Column with a formatted time for "gun time"
|
| Gun Time (* Boston Qualifier) |
Column with formatted time for "gun time"
|
| Is Anonymous |
Mark result as anonymous such that PII is redacted. Accepts: 1 or 0
|
| Name (First Last) |
Column with full name of participant in [First Name Last Name] format
|
| Name (Last, First) |
Column with full name of participant in [First Name] [Last Name] format
|
| Name First |
Column with just the first name
|
| Name Last |
Column with just the last name
|
| Other (plain text) |
The default plain text column map type used when all other types are not applicable
|
| Overall Pace |
Column with pace time (MM:SS)
|
| Overall Participant Count |
Column with the total number of participants
|
| Overall Place |
Column with numeric overall placing
|
| Participant ID |
Column with the participant id from online registration (not bib number)
|
| Province/State/Region |
Column with 2-3 character code for province/state/region
|
| Race Status |
Column with a race status value (eg. STARTING, IN_PROGRESS, DNS, DNF, DNQ, COMPLETE)
|
| Registration Questions |
The default plain text column map type used when all other types are not applicable
|
| Representing |
Column with a 3-letter country code representing nationality (eg. CAN, USA, GBR)
|
| Source |
The default plain text column map type used when all other types are not applicable
|
| Source |
The default plain text column map type used when all other types are not applicable
|
| Start Chip Time Local |
Column with a formatted date/time for "chip start time" (YYYY-MM-DD HH:MM:SS.SSSSSS)
|
| Start Chip Time Local |
Column with a formatted date/time for "chip start time" (YYYY-MM-DD HH:MM:SS.SSSSSS)
|
| Start Gun Time Local |
Column with a formatted date/time for "gun start time" (YYYY-MM-DD HH:MM:SS.SSSSSS)
|
| Start Gun Time Local |
Column with a formatted date/time for "gun start time" (YYYY-MM-DD HH:MM:SS.SSSSSS)
|
| Tally |
Column with the tally the participant has accumulated
|
| Tally |
Column with the tally the participant has accumulated
|
| Team Name |
Column with Team Name
|
| Team Name |
Column with Team Name
|
| Team questions |
Column with Team questions
|
| Team UUID |
Column with unique Team ID
|