Common Codes Definition
ODF R-SOG-2020_CCDEFN v1.3 APP
30 May 2019
Technology and Information Department
© International Olympic Committee
License
The document accompanying this license and the information contained therein (the Document), whether in a paper or electronic format, is made available to you subject to the terms stated below. By using and/or copying all or part of the Document, you (the licensee) agree that you will comply with the following terms and conditions.
1. You may, on a non-exclusive basis, use the Document only on the condition that you abide by the terms of this license. Subject to this condition and other terms and restrictions contained herein, the Document and the information contained therein may be used (i) to further develop the standards described in the Document for use in relation with the Olympic and Paralympic Games and/or (ii) to develop similar standards for other events than the Olympic and Paralympic Games (both (i) and (ii) are hereinafter designated as the Permitted Use, and works further developing these standards for the Olympic and Paralympic Games or developing similar standards for other events are hereinafter referred to as Derivative Works), and copies of the Document or of Derivative Works may be made and distributed for the purpose of the Permitted Use, PROVIDED THAT the COPYRIGHT and references to the IOC appearing in the Document and the TERMS OF THIS LICENSE are included on ALL such COPIES, and further PROVIDED THAT you do not charge any fee or any other monetary compensation for the distribution of the Document to others. The copyright and other intellectual property rights in the Document remain vested in the IOC and the IOC remains entitled to assert his copyright or other intellectual property rights in the Document against any person or entity who does not comply with the terms of this License.
2. A copy of any Derivative Work shall be provided to the IOC free of charge. Moreover, the IOC is granted a worldwide, perpetual, unrestricted, royalty-free non-exclusive license to use any Derivative Work for the further development of the standards made by or for the IOC in relation to the Olympic and Paralympic Games (these standards and the documents describing them are hereinafter referred to as Further Standards) and to make or have made all kinds of exploitation of the Further Standards, with the right to grant sub-licenses.
3. Except if reproduced in the Document, the use of the name and trademarks of the IOC is strictly prohibited, including, without limitation, for advertising, publicity, or in relation to products or services and their names. Any use of the name or trademarks of the IOC, whether registered or not, shall require the specific written prior permission of the IOC.
4. NO WARRANTY, EXPRESSED OR IMPLIED, IS MADE REGARDING THE ACCURACY, ADEQUACY, COMPLETENESS, RELIABILITY OR USEFULNESS OF ANY INFORMATION CONTAINED IN THE DOCUMENT. The Document and the information contained herein are provided on an "as is" basis. THE IOC DISCLAIMS ALL WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, ANY WARRANTY OF NON-INFRINGEMENT OF PROPRIETARY RIGHTS, MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL THE IOC BE LIABLE TO ANYONE FOR DAMAGES OF ANY KIND ARISING FROM OR RELATING TO YOUR ACQUISITION, USE, DUPLICATION, DISTRIBUTION, OR EXPLOITATION OF THE DOCUMENT OR ANY PORTION THEREOF, INCLUDING BUT NOT LIMITED TO, COMPENSATORY DAMAGES, LOST PROFITS, LOST DATA OR ANY FORM OF SPECIAL, INCIDENTAL, DIRECT, INDIRECT, CONSEQUENTIAL OR PUNITIVE DAMAGES, WHETHER BASED ON BREACH OF CONTRACT OR WARRANTY, TORT OR OTHERWISE. THE IOC FURTHER DISCLAIMS ANY LIABILITY FOR ANY DAMAGE CAUSED WHEN THE DOCUMENT IS USED IN A DERIVATIVE WORK. The IOC further disclaims any liability regarding the existence or inexistence of any intellectual property or other rights that might be claimed by third parties with respect to the implementation or use of the technology or information described in the Document.
The same conditions as those described in this Section shall apply mutatis mutandis to the license granted to the IOC on the Derivative Works in Section 2 above.
5. This License is perpetual subject to your conformance to its terms and conditions. The IOC may terminate this License immediately upon your breach of any of its terms and, upon such termination you will cease all use, duplication, distribution, and/or exploitation in any manner of the Document.
6. This License is governed by the laws of Switzerland. You agree that any disputes arising from or relating to this License will be resolved in the courts of Lausanne, Switzerland.
IF YOU DO NOT AGREE TO THESE TERMS YOU MUST CEASE ALL USE OF THE DOCUMENT NOW.
Contents
3.2.... Background Report Type
3.10.. Discipline Classification (Paralympic only)
3.12.. Event Class (Paralympic only)
3.13.. Event Unit (or simply Unit)
3.16.. Discipline Function (or Results Function)
3.25.. National Olympic/Paralympic Committee (NOC / NPC)
3.28.. Organisation (= NOC/NPC + Sport Federation)
3.38.. Venue (Competition & non-Competition)
3.42.. Weather Snow Conditions
This document defines the set of data that are considered Common Codes from the Technology perspective of the Olympic and Paralympic Games and other major sports competitions.
This document provides the list of entities that are shared between different systems for Games time, and therefore can be treated as Common Codes.
This document also defines the format for each of the fields to ensure consistency across systems.
This document does not define the content of the Common Codes, which are documented separately.
The objective of this document is to provide the basis input to proceed with the definition of the values for the common codes used for Games systems and ODF users.
This document aims to define the Common Codes requirements for all systems used in Games in which these terms apply.
The main audience of this document is the OC, Technology Integrator, the On Venue Results supplier and ODF users
Term |
|
Description |
ACR |
|
Accreditation |
OC |
|
Organising Committee |
ODF |
|
Olympic Data Feed |
ODS |
|
Olympic Diffusion Systems |
OMS |
|
Olympic Management Systems |
OVR |
|
On Venue Results System |
RSC |
|
Results System Codes |
N/A
Generally speaking, a Common Code is any code that is used in two or more systems or has some significant high use. In the IT Games context, this applies to Games systems and ODF users.
As these systems generate and distribute all the results related information during Games time, any system that is a receiver of such information should be aligned in terms of Common Codes.
The default character set is UTF-8. All characters in all supported languages are used, including accented characters.
All Games systems using any or all Common Codes should support the format as defined in this document.
This section describes the specifics of the Paralympics Common Codes.
In principle, Common Codes remain the same in format and content regardless of the Games. However, there are a few exceptions that are listed below. Obviously, the RSC Codes are totally different and are defined separately.
The Paralympics Common Codes need to be managed separately from the Olympic Common Codes as the stakeholders are different. That is, where the data is different then different tables are maintained.
The only additional entities which need to be added are related to athlete classification otherwise the tables are the same as in able bodies competition.
Each table definition makes a comment related to language. Depending on use many tables provide for descriptions in multiple languages. The requirements are defined in this column.
This section details the table definition for each table in the common codes.
Data Element |
Format |
Key |
Language |
Background Report Type Code |
Char(3) |
Unique |
N/A |
Background Report Type Description |
Char(40) |
|
All supported languages |
Background Report Type Long Description |
Char (60) |
|
All supported languages |
A list of all disciplines and a variety of general categories.
Data Element |
Format |
Key |
Language |
Background Sport Code |
Char(3) |
Unique |
N/A |
Background Sport Description |
Char(40) |
|
All supported languages |
Background Sport Long Description |
Char (60) |
|
All supported languages |
List of venue clusters.
Data Element |
Format |
Key |
Language |
Id |
Char (3) |
Unique |
N/A |
Description |
Char (25) |
|
All supported languages |
LongDescription |
Char (50) |
|
All supported languages |
The key code in all ODF messages.
Data Element |
Format |
Key |
Language |
Competition Code |
Char(15) |
Unique |
N/A |
Competition Code Description |
Char(50) |
|
All supported languages |
List of continents, including description in all supported languages:
Data Element |
Format |
Key |
Language |
Continent Code |
Char (3) |
Unique |
N/A |
Continent Name |
Char (30) |
|
All supported languages |
List of countries. This list includes historical countries as well.
Data Element |
Format |
Key |
Language |
Country Code |
Char (3) |
Unique |
N/A |
Country Short Description |
Char (30) |
|
All supported languages |
Country Long Description |
Char (60) |
|
All supported languages |
List of disciplines, including some codes belonging to non-sport ‘disciplines’, such as Ceremonies, Training, etc. including descriptions in all supported languages.
Data Element |
Format |
Key |
Language |
Comments |
Discipline Code |
Char (3) |
Unique |
N/A |
|
Sport Code |
Char (2) |
|
N/A |
Corresponding Sport Code only for competition discipline codes. |
Discipline non-sport flag |
Char (1) |
|
N/A |
‘Competition’ -> ‘N’ ’Non-competition’ -> ‘Y’ |
Discipline Event Order |
Char (4) |
|
N/A |
‘DATE’ if the events within this discipline should be sorted by date or ‘LOC’ if they should be sorted by location |
Discipline Description |
Char (40) |
|
All supported languages |
|
Discipline Scheduled flag |
Char (1) |
|
N/A |
‘Y’ if the discipline must be displayed in Schedules. ‘N’ otherwise. |
IF |
Char(5) |
|
N/A |
International Federation responsible for the Discipline |
List of all possible classes applicable in the Paralympics Games:
Data Element |
Format |
Key |
Language |
Comments |
Discipline Code |
Char (3) |
Discipline+Class unique |
N/A. |
|
Class Code |
Char (8) |
N/A. |
|
|
Class Description |
Char (30) |
|
All supported languages |
|
List of results functions, including description in all supported languages – Each participant in Games will have at least one function, which describes his/her role during Games. Results function is a “translation” of the Accreditation function.
Data Element |
Format |
Key |
Language |
Comments |
Function |
Char (8) |
) |
N/A |
|
Discipline |
Char (3) |
N/A |
||
Category |
Char (1) |
|
|
|
Order |
Number |
|
N/A |
Order numerically with discipline |
Description |
Char (60) |
|
All supported languages |
|
Partic |
Char(1) |
|
N/A |
Y if used in DT_PARTIC/TEAMS message |
Results |
Char(1) |
|
N/A |
Y if used in DT_RESULT message |
List of genders associated to a discipline.
Format |
Key |
Language |
|
Discipline |
Char (3) |
Discipline + Gender unique |
N/A |
Gender |
Char (1) |
||
Description |
Char (40) |
|
All supported languages |
List of events of each discipline-gender, including description in all supported languages.
Data Element |
Format |
Key |
Language |
Comments |
Discipline Code |
Char (3) |
Discipline+Gender +Event must be unique. |
N/A. |
See Discipline |
Gender Code |
Char (1) |
N/A. |
||
Event Code |
Char (18) |
N/A |
|
|
Sort Order |
Number |
|
N/A |
Indicates the event order within a discipline according to the sport rules. |
Event Description |
Char (40) |
|
All supported languages |
|
Event Long Description |
Char (80) |
|
All supported languages |
|
Team Event |
Format(1) |
|
N/A |
Y if team event |
SEQ |
Char (1) |
|
N/A |
Y is used in SEQ |
Allowed classes in each event (Paralympic only).
Data Element |
Format |
Key |
Language |
Discipline Code |
Char (3) |
Discipline+Gender+Event Code+Event Class must be unique |
N/A |
Gender Code |
Char (1) |
N/A |
|
Event Code |
Char (18) |
N/A |
|
Event Class |
Char(8) |
N/A |
List of event units associated to every discipline-gender-event-phase combination, including description supported languages. It also includes some key data related to Event Unit.
Format |
Key |
Language |
Comments |
|
Discipline Code |
Char (3) |
Discipline+ Gender + Event + Phase + Event Unit must be unique |
N/A |
|
Gender Code |
Char (1) |
N/A |
||
Event Code |
Char (18) |
N/A |
||
Phase Code |
Char (4) |
N/A |
||
Event Unit Code |
Char (8) |
N/A |
|
|
Schedule flag |
Char (1) |
|
N/A |
‘Y’ if scheduled through Competition Schedule app. ‘N’ if otherwise. |
Event Unit Medal flag |
Number |
|
N/A |
‘1’ in case of a gold medal event unit. ‘2’ if silver only. ‘3’ if bronze only ‘0’ otherwise. |
Event Unit Type flag |
Char (5) |
|
|
|
Event Unit Short Description |
Char (40) |
|
All supported languages |
|
Event Unit Long Description |
Char (80) |
|
All supported languages |
|
Event Unit Print Description |
Char (80) |
|
All supported languages |
|
List of possible types of competition, it is associated to an event unit.
Data Element |
Format |
Key |
Language |
Event Unit Type Code |
Char (5) |
Unique |
N/A. |
Event Unit Type Description |
Char (50) |
|
All supported languages |
Groups of functions
Data Element |
Format |
Key |
Language |
Function Category Code |
Char (1) |
Unique |
N/A. |
Function Category Description |
Char (40) |
|
English |
List of the first level report titles in printed reports
Data Element |
Format |
Key |
Language |
Comments |
|
Discipline Code |
Char (3) |
Discipline+ ORIS Report Number must be unique |
N/A | ||
---|---|---|---|---|---|
ORIS Report Number |
Char (10) |
|
N/A |
|
|
Description |
Char (250) |
|
All supported languages |
|
List of horse breeds, including description in all supported languages:
Format |
Key |
Language |
|
Breed Code |
Char (6) |
Unique |
N/A |
Breed Description |
Char (50) |
|
All supported languages |
List of horse colours, including description in all supported languages:
Data Element |
Format |
Key |
Language |
Colour Code |
Char (2) |
Unique |
N/A |
Colour Description |
Char (25) |
|
All supported languages |
List of horse genders, including description in all supported languages:
Format |
Key |
Language |
|
Gender Code |
Char (2) |
Unique |
N/A |
Gender Description |
Char (15) |
|
All supported languages |
List of languages used in Games systems.
Note: There are two different tables used. One for OMS with language list for users to select language skills and another in ODS for the supported languages in the ODS systems. The ODS table does not include long description.
Format |
Key |
Language |
|
Language Code |
Char (3) |
Unique |
N/A. |
Language Description |
Char (25) |
|
English |
Language Long Description |
Char (50) |
|
English |
List of locations used in Results systems. It also contains descriptions in all supported languages.
Format |
Key |
Language |
Comments |
|
Location Code |
Char (3) |
Unique |
N/A. |
|
Venue Code |
Char (3) |
|
N/A. |
|
Location Order |
Number |
|
N/A |
Sort order of locations within a venue |
Competition Flag |
Char(1) |
|
N/A |
Y for competition venue else N |
Location Description |
Char (30) |
|
All supported languages |
|
Location Long Description |
Char (50) |
|
All supported languages |
|
List of possible marital statuses:
Data Element |
Format |
Key |
Language |
Marital Status Code |
Char (3) |
Unique |
N/A. |
Marital Status Description |
Char (30) |
|
All supported languages |
List of NOCs/NPCs, including historical organisations; including the description in all supported languages.
Data Element |
Format |
Key |
Language |
Comments |
NOC Code |
Char (3) |
Unique |
N/A. |
|
Country Code |
Char (3) |
|
N/A |
|
Continent Code |
Char (3) |
|
N/A |
|
Description |
Char (20) |
|
All supported languages |
|
Long Description |
Char (60) |
|
All supported languages |
|
Short Description |
Char (16) |
|
All supported languages |
|
Participation flag |
Char (2) |
|
N/A |
‘P’ if participating in these Games, ‘NP’ if not and ‘H’ if Historical. |
Order |
Number |
|
N/A |
Sort Order for ties in medals |
Data Element |
Format |
Key |
Language |
News Type Code |
Char (3) |
Unique |
N/A |
News Type Description |
Char (30) |
|
All supported languages |
News Type Long Description |
Char (60) |
|
All supported languages |
Data Element |
Format |
Key |
Language |
News Sport Code |
Char (3) |
Unique |
N/A |
News Sport Description |
Char (30) |
|
All supported languages |
News Sport Long Description |
Char (60) |
|
All supported languages |
‘Other’ descriptions will be filled with English descriptions for Sports Federations as language does not apply.
This generally includes all sports federations and all NOCs/NPCs
This will not include all organisations for Accreditation which are managed separately.
Data Element |
Format |
Key |
Language |
Comments |
Organisation Code |
Char (12) |
Unique |
N/A. |
|
Organisation Type |
Char (2) |
|
|
If NOC -> ‘OC’ If Sport Federation -> ‘IF’ |
Description |
Char (20) |
|
All supported languages |
Only if NOC |
Long Description |
Char (60) |
|
All supported languages |
NOC Long and Sport Federation description |
It is the Accreditation Status for competitors (athletes and officials). It is owned by ACR.
Data Element |
Format |
Key |
Language |
Accreditation Status Code |
Char(6) |
Unique |
N/A |
Accreditation Status Description |
Char(30) |
|
English only |
List of genders referring to a participant:
Data Element |
Format |
Key |
Language |
Gender Code |
Char (1) |
Unique |
N/A. |
Gender Description |
Char (25) |
|
All supported languages |
List of possible phases within an event, including description in all supported languages:
Data Element |
Format |
Key |
Language |
Comments |
Discipline Code |
Char (3) |
Discipline + Gender + Event + Phase must be unique |
N/A |
|
Gender Code |
Char (1) |
N/A |
||
Event Code |
Char (18) |
N/A |
||
Phase Code |
Char (4) |
N/A. |
|
|
Phase Type Code |
Char (1) |
|
N/A |
|
Phase Description |
Char (40) |
|
All supported languages |
|
Phase Long Description |
Char (80) |
|
All supported languages |
|
Phase Print Description |
Char (80) |
|
All supported languages |
|
List of the different categories of phases (e.g. Press Conference, Official Training, Competition, etc.):
Data Element |
Format |
Key |
Language |
Phase Type Code |
Char (1) |
Unique |
N/A. |
Phase Type Description |
Char (45) |
|
All supported languages |
List of positions related to athletes in a sport.
Format |
Key |
Language |
Comments |
|
Discipline Code |
Char (3) |
N/A |
||
Position Code |
Char (8) |
N/A |
|
|
Position Order |
Number |
|
N/A |
|
Position Description |
Char (25) |
|
All supported languages |
|
List of Record Codes, i.e. Results System Codes that have a record associated. It includes the description in all supported languages.
Format |
Key |
Language |
Comments |
|
Record Code |
Char (34) |
Unique |
N/A |
|
Related Event Code |
Char(34) |
|
N/A |
|
Record Order |
Number |
|
N/A |
Order of Records within the Discipline |
Record Description |
Char (40) |
|
All supported languages |
|
List of the different record types by discipline, including the description in all supported languages.
Data Element |
Format |
Key |
Language |
Comments |
Discipline Code |
Char (3) |
Discipline + Record Type must be unique |
N/A. |
|
Record Type Code |
Char (5) |
N/A |
|
|
Record Type Group |
Char(5) |
|
N/A |
|
Record Type Order |
Number |
|
N/A |
Oder within discipline |
Record Type Description |
Char (40) |
|
All supported languages |
|
List of possible schedule status for an event unit: It includes description in all supported languages.
Data Element |
Format |
Key |
Language |
Schedule Status Code |
Char (15) |
Unique |
N/A. |
Schedule Status Order |
Number |
|
N/A |
Schedule Status Description |
Char (25) |
|
All supported languages |
List of possible session types describing the part of day (morning etc.):
Data Element |
Format |
Key |
Language |
Session Code |
Char (3) |
Unique |
N/A |
Session Description |
Char (20) |
|
All supported languages |
List of sports, including description in all supported languages.
Data Element |
Format |
Key |
Language |
Sport Code |
Char (2) |
Unique |
N/A. |
Sport Description |
Char (30) |
|
All supported languages |
List of sport genders.
Data Element |
Format |
Key |
Language |
Sport Gender Code |
Char (1) |
Unique |
N/A. |
Sport Gender Description |
Char (15) |
|
English |
List of venues, including description in all supported languages:
Data Element |
Format |
Key |
Language |
Comments |
Venue Code |
Char (3) |
Unique |
N/A. |
|
Venue Competition Flag |
Char (1) |
|
N/A |
If competition -> ‘Y’ If non competition -> ‘N’ |
Venue Description |
Char (25) |
|
All supported languages |
|
Venue Long Description |
Char (50) |
|
All supported languages |
|
Indoor/Outdoor |
Char(1) |
|
N/A |
I or O for indoor or ourdoor |
Cluster Code |
Char (3) |
|
N/A |
Associates weather regions to venues.
Data Element |
Format |
Key |
Language |
Comments |
Weather Region Code |
Char (3) |
|
N/A |
|
Venue Code |
Char (3) |
Unique |
N/A |
List of possible weather sky conditions, including description in all supported languages:
Data Element |
Format |
Key |
Language |
Weather Conditions Code |
Char (6) |
Unique |
N/A. |
Weather Conditions Description |
Char (25) |
|
All supported languages |
List of possible weather regions, in which venues are organized. It includes the description in all supported languages.
Data Element |
Format |
Key |
Language |
Weather Region Code |
Char (3) |
Unique |
N/A. |
Weather Region Description |
Char (40) |
|
All supported languages |
Data Element |
Format |
Key |
Language |
Snow Conditions Code |
Char (7) |
Unique |
N/A. |
Snow Conditions Description |
Char (25) |
|
All supported languages |
Data Element |
Format |
Key |
Language |
Wind Direction Code |
Char (3) |
Unique |
N/A. |
Wind Direction Description |
Char (20) |
|
All supported languages |
The Result System Code (RSC) is a thirty-four character code (made up of 5 sub-codes) which uniquely identifies a component of the competition.
The code which uniquely identifies information regarding the results of the competitions is called Result System Code (RSC). This code is constructed from the following elements in the hierarchical order of their importance:
• The first three (3) characters uniquely identify the sport’s discipline code (e.g. “SWM“ for swimming, “ALP” for alpine skiing, etc.);
• The fourth character identifies the gender of the discipline (e.g. “W” for events where only women participate, “X” for events where both genders participate equally);
• The next eighteen (18) characters represent the event. This is further divided into eight characters for the event type and the following ten characters for the event modifier. (e.g. “100m” for 100 metres, and a modifier if needed for things like disability class in the Paralympic Games or age group etc.);
• The next four characters (4) are for the competition phase (e.g. preliminaries, semi-final, final, repechage, etc.) or part of competition (e.g. pool, subdivision, etc.);
• The last eight (8) characters identify the unit and sub-unit (e.g. a match, heat, group, etc.).
The following general rules apply for the code:
• Fixed length, 34 characters,
• Full alphanumeric to increase human readability e.g. FNL for Final phase,
• Uppercase is used in all codes,
• The dash character “-“ is used as a filler, it is used when a part of the code is not applicable,
• Allow characters are A ... Z, 0...9 and the special characters of dot and dash. Dash is only used as a filler,
• Apply right padding with the filler character in any part of the RSC when the respective code is less characters than the maximum length of this part e.g. FNL (Final phase) is shown as “FNL-“ in the RSC.
ODF R-SOG-2020_CCDEFN v1.2 APP
Version |
Date |
Comments |
R4 v1.0 SFR |
16 Sept 2013 |
First Version |
R4 v1.1 SFA |
19 Sept 2013 |
Updated after internal review |
R4 v1.2 APP |
13 Nov 2014 |
Approved with changes. |
R4 v1.3 APP |
19 Dec 2014 |
Approved with changes. |
R4 v1.4 APP |
5 Feb 2016 |
Minor error correction |
R-WOG-2018 v1.5 APP |
22 June 2016 |
CR9994 & new RSC size |
R-SOG-2020 v1.0 APP |
4 May 2018 |
New Revision for Tokyo |
R-SOG-2020 v1.1 APP |
1 Aug 2018 |
Minor Update |
R-SOG-2020 v1.2 APP |
16 Aug 2018 |
Minor update |
Version |
Status |
Changes |
R4 v1.0 |
SFR |
N/A |
R4 v1.1 |
SFA |
Corrections to reflect the current common codes (Sochi) |
R4 v1.2 |
APP |
In Schedule Status. Change the code to Char(15) Added Cluster Code and reference in Venue code set. |
R4 v1.3 |
APP |
Function table removed and data added to Results Function Table Updated with CR4228 |
R4 v1.4 |
APP |
3.25, order corrected. |
R-WOG-2018 v1.5 |
APP |
Updated for the change in RSC size CR9994, increase the size of the CompetitionCode (3.4) Removed web site tables Add H1 Report Titles Add News Item and News Sport definitions Other minor corrections |
R-SOG-2020 v1.0 |
APP |
New Revision of Tokyo, no content changes |
R-SOG-2020 v1.1 |
APP |
Minor corrections without changing meaning |
R-SOG-2020 v1.2 |
APP |
Correction in event table to add the long description (left out in error) |
R-SOG-2020 v1.3 |
APP |
Add short description in the NOC table (CR17409) |
|
|
|