Size: 11261
Comment:
|
Size: 11543
Comment:
|
Deletions are marked like this. | Additions are marked like this. |
Line 93: | Line 93: |
Line 100: | Line 99: |
== 3.4 The performance file (602) == '''All animals with a performance must have a line as animal in the 601 pedigree file.''' The performance file must be constructed in agreement with the 601 file and be consistent with the international identification of the animal.<<BR>> It is expected that countries participating with data support the ICAR guidelines for beef recording.<<BR>> As indicated in the ICAR recommendations, any group of animals kept for the same purpose and at the same location shall be regarded as a whole herd. For a performance record to be considered an official record, '''the whole herd as defined above must be recorded.''' Each herd is identified with 15 digits identification, coded as characters: |
|
Line 101: | Line 102: |
== 3.4 The performance file (602) == '''All animals with a performance must have a line as animal in the 601 pedigree file.''' The performance file must be constructed in agreement with the 601 file and be consistent with the international identification of the animal.<<BR>> It is expected that countries participating with data support the ICAR guidelines for beef recording.<<BR>> As indicated in the ICAR recommendations, any group of animals kept for the same purpose and at the same location shall be regarded as a whole herd. For a performance record to be considered an official record, '''the whole herd as defined above must be recorded.''' Each herd is identified with 15 digits identification, coded as characters: |
|
Line 109: | Line 104: |
Line 110: | Line 106: |
<<Include(public/Format602)>> == 3.5 Parameter file (603) == The parameter file (603) contains the name of two variables and the names of the environmental effects for each trait included in the performance file (602). This file must be provided together with the 602 file. |
Guidelines to Join Interbeef
Version 2.2 InterBeef 20 August 2012
== contact: Interbull Centre - Dept. Animal Breeding and Genetic SLU,
Box 7023 S-75007 Uppsala, Sweden
Phone: 0046-18-672848
Fax: 0046-18-672848
E-mail : interbeef@hgen.slu.se
URL : http://www.icar.org/pages/working_groups/wg_interbeef.htm
1. INTRODUCTION
Countries willing to join InterBeef must be members of Interbull and support the ICAR guidelines for data collection (http://www.icar.org/). This document is a description of the necessary actions and relevant files required by a new country willing to join InterBeef.
2. The Animal International Identification
2.1 Format
A unique international identification for each animal is used in the international genetic evaluation system and will be referred to as the Animal International IDentification (AIID). The AIID is constructed using the Interbull rules (referred as Interbull format in the document) and its structure is:
Breed + Country + Sex + Identification number
The field ‘Breed‘ of the AIID refers to the breed of identification of the animal in its country of first registration (in most cases, the country of origin): 3 characters as defined in the Interbull Breed Codes, available at www.interbull.org (see Reference section).
The field ‘Country’ of the AIID refers to the country of first registration of the animal (in most cases, the country of origin): 3 characters or 3 digits number as defined in ISO 3166 Codes, available at http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html (see Reference section).
The field ‘Sex’ of the AIID refers to the sex of the animal (M = male ; F = female)
The field ‘Identification number’ of the AIID refers to the identification number of the animal in the country of first registration: 12 characters right justified with left blanks filled in with zero (“0”).
Ex: CHAFRAM006327826864 refers to
- A Charolais CHA
- First registered in France FRA
- A male M
- With the following identification in France 006327826864
Ex: BAQIRL125693456875 refers to
- A Blonde d’Aquitaine BAQ
- First registered in Ireland IRL
- A female F
- With the following identification in Ireland 125693456875
2.2 Constructing the international identification number
A country should first construct the international identifications for the animals born on its soil. The general rule for this construction would be that a given identification number is unique within a country and a breed.
When an animal (live animal or issued from AI straw or embryo) is sold abroad, the importing country should avoid re-registration; in case of re-registration the original ID and the national ID should be kept.
The animal ‘IE231112150014’ is, for example, a pure breed Irish limousine female named ‘SHRIFFTOWN RIPPER’. Ireland has constructed its AIID as followed: LIMIRLF231112150014.
The animal ‘FR0384106449’ is a pure breed French Charolais bull named ‘VLADIMIR’. That animal is also used in Ireland under the name ‘VLADIMER’ and the number ‘0384106449’ and has also been re-codified ‘108376849’ and ‘VLR’. France constructs its AIID as followed: CHAFRAM000384106449.
In the international identification number, hyphens, slashes, commas, dots, blank spaces or any other symbols are allowed.
The animal ‘UK9373 70-2/-7’, for example, is a UK Salers female animal and its international identification number would be ‘SALGBRF9373 70-2/-7’
2.3 The New Web Interface at Interbull
Interbull has developed a new database, IDEA (Interbull Data Exchange Area) that allows register users to all the pedigree handling functionalities. IDEA is available at https://idea.interbull.org/
IDEA is exclusive for database users. To become a database user you need to belong to a national evaluation centre participating to the Interbeef evaluation. If you want to join the Interbeef evaluation and therefore have access to IDEA, your national genetic centre needs to be associated to a username and a contact email address. To get your national genetic centre listed among the ones participating to the Interbeef evaluation, you have to:
Send an email to interbeef@hgen.slu.se providing information on your national genetic centre: Full name and address of the organization and full name and email address of the designated contact person. Clearly state the breed(s) and trait(s) you wish to participate with. If your organization provides data as a joint evaluation including other countries, you clearly have to state for which other countries and breed(s) your organization provides pedigree and performance information.
Upon reception of your request, Interbull will send you by email a link to an IDEA-test environment together with a username and password so that you will be able to get acquainted with the IDEA functionalities and the user manual which is located under “Help”.
The national pedigree file must be first checked with the CheckPedigree.py script provided by Interbull Centre. The checking programs are available under “Software”. The zip files produced by the Python scripts represent the only valid infiles for the database; no other files will be accepted by the system.
When your pedigree enters the database it undergoes a series of checks called “verification process” aiming at identifying the correct authoritative organization of each and every animals listed in your pedigree. In general the system has been built in such a way that it accepts information only if these comes from the authoritative organization. Therefore, whenever you submit pedigree data, the system first checks that the combination “country-breed” in the animal ID matches with the combination your organization “owns”. If so the records are considered correct and stored in the database, if this is not the case then the records will be listed in the appropriate authoritative organization account waiting for verification, i.e. waiting for the authoritative organization to provide the correct pedigree information. In case the authoritative organization is a country or organization that does not yet participate to the Interbeef evaluation, then the animals will appear as verified by Interbull until eventually that country/organization would join the service.
Example:
Ireland submits the following pedigree records to the database:
601 CHAIRLM458962315289 CHAIRLM789456123652 CHAIRLF369852147852 1985 OMAR IRL
601 CHAFRAM865412398745 CHAFRAM231658479851 CHAFRAF845693274125 1988 OSCAR IRL
In the first case the animal is an Irish Charolais sent by Ireland. Ireland is therefore the authoritative organization for that animal so the record gets stored in the database. In the second case the animal appears to be a French Charolais sent by Ireland. Ireland is no longer the authoritative organization for this bull therefore the system will send the record to the French account and will wait for France to provide its correct pedigree information.
3. The required files
There are 4 groups of files to be created by a country willing to join the international beef genetic evaluation:
- The 601 file representing the national pedigree file
- The 602 file representing the national performance file (limited until now to adjusted weaning weights, adjusted carcass weight and calving ease)
- The 603 file representing the parameter file.
- The Beef Form, see Reference section.
A country willing to join InterBeef needs to include at least one breed and one trait in the process of the international genetic evaluation. The objective of the present document is to help a new member country in the construction of these files.
NB: Since the verification of the International ID is done via database, national cross-reference files are no longer needed. For more information about IID verification, please refer to the IDEA user manual.
3.1 The Different InterBeef steps
The construction of these files follows several steps:
The first step for a country that wishes to join the international evaluation system is to upload the pedigree file into the IDEA database (https://idea.interbull.org/).
- Once the pedigree file (601) is uploaded into the database, the country will have to correct its own database according to the feedback obtained from the database regarding verified pedigree information from authoritative organizations. (see corrected foreign information in the IDEA user manual)
Once this step has been fulfilled then countries will proceed sending performance file (file 602) and parameter file (file 603) to the Interbull ftp server.
3.2 General principles for file preparation:
- Numeric information must be right justified.
- Characters must be left justified.
- All characters should be in upper case.
3.3 The national pedigree file (601 file)
The 601 file is a national pedigree file and must contain pedigree information of all animals included in the performance file in an animal-sire-dam format. Sires, dams and ancestors must also have an entry in this file as an animal; unknown ancestors should be coded ‘UUUUUUUUUUUUUUUUUUU’.
To ensure sufficient pedigree information it is recommended that pedigree information of animals born within a period equivalent to a minimum of three generation intervals should be included. The 601 file is a file issued per country or organization providing pedigree information according to the format shown in Table 1. The 601 files can contain one breed or multiple breeds.
Table 1: 601 file format (total length = 107)
Field description |
Label |
Format |
Start |
|
Length |
|
Statusa |
Note |
Example |
|
Record type |
RTYPE |
Char |
|
1 |
|
3 |
M |
|
601 |
|
International ID of ANIMAL |
||||||||||
Breed of the animal |
ABREED |
Char |
|
5 |
|
3 |
M |
I |
LIM |
|
Country of birth |
AIDC |
Char |
|
8 |
|
3 |
M |
II |
FRA |
|
Sex |
ASEX |
Char |
11 |
|
1 |
M |
III |
F |
|
|
ID code of the animal |
AID |
Char |
12 |
12 |
M |
IV |
008795005065 |
|||
International ID of Animal’s SIRE |
||||||||||
Breed of the sire |
SBREED |
Char |
25 |
|
3 |
O |
I |
LIM |
|
|
Country of birth |
SIIDC |
Char |
28 |
|
3 |
O |
II |
FRA |
|
|
Sex |
SSEX |
Char |
31 |
|
1 |
O |
III |
M |
|
|
ID code of the sire |
SIID |
Char |
32 |
12 |
O |
IV |
000095015085 |
|||
International ID of Animal’s DAM |
||||||||||
Breed of the dam |
DBREED |
Char |
45 |
|
3 |
O |
I |
LIM |
|
|
Country of birth |
DIIDC |
Char |
48 |
|
3 |
O |
II |
FRA |
|
|
Sex |
DSEX |
Char |
51 |
|
1 |
O |
III |
F |
|
|
ID code of the dam |
DIID |
Char |
52 |
12 |
O |
IV |
001111001111 |
|||
Additional information |
||||||||||
Date of birth of animal |
BDATE |
Int |
65 |
|
8 |
O |
V |
|
20010130 |
|
Name of animal |
NAME |
Char |
74 |
30 |
O |
|
Faust |
|
||
Country sending information |
RCOU |
Char |
105 |
|
3 |
M |
II |
FRA |
|
aStatus: M = Mandatory, O = Optional
Note |
|
I |
The field ‘Breed‘ of the AIID refers to the breed of identification of the animal in its country of first registration (in most cases, the country of origin): 3 characters as defined in the Interbull Breed Codes, |
II |
The field ‘Country’ of the AIID refers to the country of first registration of the animal (in most cases, the country of origin): 3 characters or 3 digits number as defined in ISO 3166 Codes, available at https://www.iso.org/obp/ui/#search |
III |
Sex : M for Male, F for Female only |
IV |
The field ‘Identification number’ of the AIID refers to the identification number of the animal in the country of first registration: 12 characters right justified with left blanks filled in with zero (“0”). |
V |
YYYYMMDD format |
3.4 The performance file (602)
All animals with a performance must have a line as animal in the 601 pedigree file. The performance file must be constructed in agreement with the 601 file and be consistent with the international identification of the animal.
It is expected that countries participating with data support the ICAR guidelines for beef recording.
As indicated in the ICAR recommendations, any group of animals kept for the same purpose and at the same location shall be regarded as a whole herd. For a performance record to be considered an official record, the whole herd as defined above must be recorded. Each herd is identified with 15 digits identification, coded as characters:
- The first three digits correspond to the country, using the ISO 3166 Alpha-3 system, see Reference section.
- The next 12 digits correspond to the identification of the herd within the country. The original herd identification number should be used. The characters (letters or numbers) are right justified, the left blanks being filled with zeros.
All performance traits are associated with their environmental effects and complementary information (one observation line per measurement) as described in Table 2.
Table 2: 602 file format (all fields are mandatory)
Performance file
Field description |
Label |
Format |
Starting byte |
Fielda |
Note |
Example |
Record type |
RTYPE |
Char |
1 |
3 |
|
602 |
Trait |
FCODE |
Char |
5 |
3 |
I |
AWW |
Breed of evaluation |
EBREED |
Char |
9 |
3 |
II |
LIM |
Country sending information |
RCOU |
Char |
13 |
3 |
III |
FRA |
International ID of ANIMAL |
||||||
Breed of the animal |
ABREED |
Char |
17 |
3 |
II |
LIM |
Country of birth |
AIDC |
Char |
20 |
3 |
III |
FRA |
Sex |
ASEX |
Char |
23 |
1 |
IV |
F |
ID code of the animal |
AID |
Char |
24 |
12 |
V |
008795005065 |
|
||||||
Twinning |
TWI |
Int |
37 |
1 |
VI |
1 |
Embryo transfer |
ET |
Int |
39 |
1 |
VII |
0 |
Herd |
HERID |
Char |
41 |
15 |
VIII |
FRA000123456789 |
Dependent variable |
Y |
Int |
57 |
10 |
IX |
245 |
Number of environmental effects included in the national model |
NENV |
Int |
68 |
3 |
XI |
4 |
Environmental effect (n)b |
ENV(n) |
Char |
72 |
20 |
XII |
2 |
b Repeat this field n times (n = 1,…,NENV), adding one (1) empty space between fields; contemporary group should come as the first effect
Notes |
|
I |
|
II |
See Reference section for Breed codes |
III |
See Reference section for Country codes – ISO 3166 Alpha-3 |
IV |
Sex : M for Male, F for Female only; U for unknown |
V |
Identification Number in Interbull Format : Alpha-numeric codes only, Right justified, Left blanks being filled with '0' |
VI |
1 = single birth ; 2 = twin birth |
VII |
0 = no ET ; 1 = ET |
VIII |
Herd identification number corresponding to the herd included in the contemporary group. Format: 3 character country code + 12 digits |
IX |
Value observed for the trait in question. Ex. 245 Kg (no decimals) |
XI |
Defines the remaining number of fields in the record. Additional fields = NENV |
XII |
Value of the respective environmental effect for the current record. Ex. season = 2 (out of 4 classes); birth weight = 36 (kg); sex of calf = F |
3.5 Parameter file (603)
The parameter file (603) contains the name of two variables and the names of the environmental effects for each trait included in the performance file (602). This file must be provided together with the 602 file.