Olympic Data Feed
Rio 2016
Common Codes Definition
ODF/INT185-R4 v1.4 APP
5 February 2016
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.9.... Discipline Classification (Paralympic only)
3.11... Event Class (Paralympic only)
3.14... External URLs (Organisation Web)
3.25... National Olympic/Paralympic Committee (NOC / NPC)
3.26... Organisation (= NOC/NPC + Sport Federation)
3.36... Venue (Competition
& non-Competition)
3.40... 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.
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 |
|
CGS |
|
Core Games Management System |
|
IDS |
|
Info Diffusion System |
|
OC |
|
Organising Committee |
|
ODF |
|
Olympic Data Feed |
|
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 for Olympics and Paralympics. 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 the Olympic Games.
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.
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 |
|
Data Element |
Format |
Key |
Language |
|
Background Report Type Code |
Char(3) |
Unique |
N/A |
|
Background Report Type Description |
Char(40) |
|
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 |
The key code in all ODF messages.
|
Data Element |
Format |
Key |
Language |
|
Competition Code |
Char(7) |
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, including IOC country codes and descriptions. 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 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 |
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 (2) |
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. |
List of genders associated to a discipline.
|
Format |
Key |
Language |
|
|
Discipline Code |
Char (2) |
Discipline + Gender unique |
N/A |
|
Discipline Gender Code |
Char (1) |
||
|
Discipline Gender Description |
Char (40) |
|
All supported languages |
List of all possible classes applicable in the Paralympics Games:
|
Data Element |
Format |
Key |
Language |
Comments |
|
Discipline Code |
Char (2) |
Discipline+Class unique |
N/A. |
|
|
Class Code |
Char (8) |
N/A. |
|
|
|
Class Name |
Char(8) |
|
N/A |
|
|
Class Description |
Char (30) |
|
English |
|
List of events of each discipline-gender, including description in all supported languages.
|
Data Element |
Format |
Key |
Language |
Comments |
|
Discipline Code |
Char (2) |
Discipline+Gender +Event must be unique. |
N/A. |
See Discipline |
|
Gender Code |
Char (1) |
N/A. |
||
|
Event Code |
Char (3) |
N/A |
|
|
|
Sport Order |
Number |
|
N/A |
Indicates the event order within a discipline according to the sport rules. |
|
Event Description |
Char (40) |
|
All supported languages |
|
|
Team Events |
Format(1) |
|
N/A |
Y if team event |
Allowed classes in each event (Paralympic only).
|
Data Element |
Format |
Key |
Language |
|
Event Class Code |
Char (14) |
|
N/A. |
|
Discipline Code |
Char (2) |
|
N/A |
|
Gender Code |
Char (1) |
|
N/A |
|
Event Code |
Char (3) |
|
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 (2) |
Discipline+ Gender + Event + Phase + Event Unit must be unique |
N/A |
|
|
Gender Code |
Char (1) |
N/A |
||
|
Event Code |
Char (3) |
N/A |
||
|
Phase Code |
Char (1) |
N/A |
||
|
Event Unit Code |
Char (2) |
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 bronze only. 0 otherwise. |
|
Event Unit Type flag |
Char (5) |
|
|
|
|
CIS Schedule |
Char (1) |
|
|
Shown in CIS -> Y Not shown in CIS -> N |
|
INFO Schedule |
Char (1) |
|
|
Shown in INFO (Comp. Schedules) -> Y Not shown in INFO (Comp. Schedules) -> N |
|
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 |
|
Data Element |
Format |
Key |
Language |
Comments |
|
Organisation Code |
Char (12) |
Unique |
N/A |
|
|
Web Site Type |
Char(3) |
|
N/A |
|
|
Website URL |
Char (250) |
|
All supported languages |
Full URL (inc. http) |
|
Website Description |
Char(60) |
|
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 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 Code |
Char (30) |
) |
N/A |
|
|
Function Discipline |
Char (2) |
N/A |
||
|
Function Category |
Char (1) |
|
|
|
|
Function Sort Order |
Number |
|
N/A |
Order numerically with discipline |
|
Function 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 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 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 GMS with language list for users to select language skills and another in IDS for the supported languages in the IDS systems. The IDS 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 Short 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 |
|
|
NOC Short Description |
Char (20) |
|
All supported languages |
|
|
NOC Long Description |
Char (60) |
|
All supported languages |
|
|
NOC Participation flag |
Char (2) |
|
N/A |
P if participating in these Games, NP if not and H if Historical NOC. |
|
Order |
Number |
|
N/A |
Sort Order for ties in medals |
Other descriptions will be filled with English descriptions for Sport Federation as language does not apply.
This generally includes all sports federations and all NOCs/NPCs
This will not include all organisations for Accreditation or Messageboards 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 |
|
Short Description |
Char (20) |
|
All supported languages |
Only if NOC |
|
Long Description |
Char (60) |
|
All supported languages |
NOC Long and Sport Federation description |
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 possible phases within an event, including description in all supported languages:
|
Data Element |
Format |
Key |
Language |
Comments |
|
Discipline Code |
Char (2) |
Discipline + Gender + Event + Phase must be unique |
N/A |
|
|
Gender Code |
Char (1) |
N/A |
||
|
Event Code |
Char (3) |
N/A |
||
|
Phase Code |
Char (1) |
N/A. |
|
|
|
Phase Type Code |
Char (1) |
|
N/A |
|
|
Phase Short Description |
Char (40) |
|
All supported languages |
|
|
Phase Long Description |
Char (80) |
|
All supported languages |
|
|
Phase Print Description |
Char (80) |
|
All supported languages |
|
List of positions related to athletes in a sport.
|
Format |
Key |
Language |
Comments |
|
|
Discipline Code |
Char (2) |
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 (12) |
Unique |
N/A |
|
|
Related Event Code |
Char(6) |
|
N/A |
(discipline + gender + event) |
|
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 (2) |
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 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 |
|
|
Cluster Code |
Char (3) |
|
|
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 |
Web Site Types for links in systems:
|
Data Element |
Format |
Key |
Language |
|
Web Site Type Code |
Char (3) |
Unique |
N/A. |
|
Web Site Type Description |
Char (30) |
|
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 nine character code (made up of 5 sub-codes) which uniquely identifies a report on the result feed.
The format is DDGEEEPU made up in the following way:
· Discipline (DD)
· Discipline Gender (G)
· Event (EEE)
· Phase (P)
· Event Unit (U)
If some fields are not relevant, they are set to the default of zero (0, 00, 000 as applicable).
RSCs are used mainly in schedules and results in Games systems.
ODF/INT185-R4 v1.4 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 |
|
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 |