|
Size: 35016
Comment: Better clarification on footnotes numbering
|
← Revision 22 as of 2026-10-01 10:11:22 ⇥
Size: 35280
Comment: Updating file format removing absolete codes for ToP, Status bull and Publication, adding refernce to claw health and metabolic disease traits
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 34: | Line 34: |
| . ^3^Valid population codes: ARG AUS BEL CAN CHE CZE ^a^DEA DEU ^b^DFS ESP EST FIN FRA ^c^FRM GBR HUN IRL ISR ITA JPN LTU LVA NLD NZL POL PRT SVN SVK SWE USA URY ZAF . where: ^a^ Austria+Germany; ^b^Denmark + Finland + Sweden; ^c^ France Montbeliarde; |
. ^3^Valid population codes: ARG AUS BEL CAN ^a^CAM CHE CZE ^b^DEA DEU ^c^DFS ESP EST FIN FRA ^d^FRM GBR HUN IRL ISR ITA JPN LTU LVA NLD NOR NZL POL PRT SVN SVK SWE USA URY ZAF . where: ^a^ Canadian !MilkShorthorn ^b^Austria+Germany; ^c^Denmark + Finland + Sweden; ^d^ France Montbeliarde; |
| Line 42: | Line 42: |
| . <<span(style="color: #FF00FF;")>>Calving<<span>> ==> dce = direct calving ease;mce = maternal calving ease;dsb= direct stillbirth;msb = maternal stillbirth | . <<span(style="color: #FF00FF;")>>Calving<<span>> ==> dce = direct calving ease;mce = maternal calving ease;dsb= direct stillbirth;msb = maternal stillbirth; ges = direct gestation length |
| Line 46: | Line 46: |
| . <<span(style="color: #FF00FF;")>> Claw Health <<span>> ==> dde = digital dermatitis . <<span(style="color: #FF00FF;")>> Metabolic disease <<span>> ==> sck = sub-clinical ketosis . |
|
| Line 49: | Line 52: |
| . '''11''' (based on first crop sampling daughters); | . '''11''' (based on first crop sampling daughters or based on usage while having a genomic proof); |
| Line 52: | Line 55: |
| . '''21'''(based on imported semen of proven bull, second crop daughters only); . '''22''' (based on mostly, more than 50%, imported daughters or daughters born from imported embryos.) . '''23''' (GEBV with foreign PA) . '''24''' (GEBV with foreign proof) |
. '''21'''(based on imported semen of proven bull, second crop daughters only, or based on imported daughters/embryos); . '''23''' (GEBV with foreign PA) ''- specific to GMACE files (file700)'' |
| Line 57: | Line 58: |
| . ^6^Accepted abbreviations: | '''24''' (GEBV with foreign proof) ''- specific to GMACE files (file700)'' . ^6^Accepted abbreviations:''(Please Note that from September 2026 onwards code P will no longer be valid)'' |
| Line 59: | Line 63: |
| . '''P''' (if bull is part of a simultaneous progeny-testing program, but the proof does not yet meet national standards for official publication); | |
| Line 62: | Line 65: |
| . ^7^Valid codes for status of bulls: . '''00'''(unknown); . '''10'''(bull randomly sampled through an official AI scheme); . '''15''' (young bull, genomically tested, not yet selected for AI); . '''20'''(other bull. Records with “20” in this file will be excluded from the international evaluation, unless type of proof is “21”). |
. ^7^Valid codes for status of bulls:''(Please Note that from September 2026 onwards code 20 will no longer be valid)'' . '''00''' (other or unknown); . '''10''' (national and international AI bulls); . '''15''' (young bull, genomically tested, not yet selected for AI) ''- specific to GMACE files (file700)'' . |
| Line 72: | Line 77: |
| . ^10^ <<span(style="color: #FF00FF;")>>''Production, conformation, udder health, fertility, workability, and SNP training traits:''<<span>> Weighting factor used for these traits is “the effective daughter contribution (EDC)”, which is described In the Interbull document Code of practice, Appendix IV, “Weighting factor for international genetic evaluation”, updated April 27, 2004. EDC values should be rounded to the nearest integer value.<<BR>> | . ^10^ <<span(style="color: #FF00FF;")>>Production, conformation, udder health, fertility, workability, SNP training traits, claw health, metabolic disease:<<span>> Weighting factor used for these traits is “the effective daughter contribution (EDC)”, which is described In the Interbull document Code of practice, Appendix IV, “Weighting factor for international genetic evaluation”, updated April 27, 2004. EDC values should be rounded to the nearest integer value.<<BR>> |
| Line 79: | Line 84: |
. . |
APPENDIX I - Format File300-EBV and File700-GEBV
Col |
Name |
Start |
Format |
Description (footnote) |
Example |
1 |
rec type |
1 |
a3 |
Record type (1) |
300 |
2 |
brd_eval |
5 |
a3 |
Breed of evaluation (2) |
HOL |
3 |
pop |
9 |
a3 |
Population code (3) |
USA |
4 |
trt |
13 |
a3 |
Trait of evaluation (4) |
mil |
5 |
brd_anim |
17 |
a3 |
Breed of animal |
HOL |
6 |
cou_orig |
20 |
a3 |
Country of first registration |
USA |
7 |
sex |
23 |
a1 |
Sex of animal |
M |
8 |
id_no |
24 |
a12 |
Animal identification number |
003000336289 |
9 |
typ_prf |
37 |
i2 |
Type of proof (5) |
11 |
10 |
off_pub |
40 |
a1 |
Official publicationof proof (6) |
Y |
11 |
status |
42 |
i2 |
Animal status (7) |
10 |
12 |
ndau |
44 |
i8 |
Number of daughters (8) |
115 |
13 |
nhrd |
52 |
i8 |
Number of herds (9) |
75 |
14 |
edc |
60 |
i8 |
Number of effective daughter contributions (10) |
133 |
15 |
rel |
69 |
f7.4 |
Repeatability/Reliability (11) |
82 |
16 |
ebv |
76 |
f10. |
National predicted genetic merit (12) |
2.780 |
IMPORTANT NOTE !!!!! In the old fileformat 01x-020 and 115, the national proofs were multiplied by a factor: (prod=100; conf=100;udder=1000;long=1000;calv=1000;fert=1000; fert=1000;work=1000). This multiplication will no longer be needed.
1Valid record types:
- 300 for EBV
- 700 for GEBV
2Breed codes accepted:
BSW=Brown Swiss type; GUE=Guernsey type; HOL=Holstein-Friesian (Black & White) type; JER=Jersey type; RDC=Red Dairy Cattle type ; SIM=Simmental type.
3Valid population codes: ARG AUS BEL CAN aCAM CHE CZE bDEA DEU cDFS ESP EST FIN FRA dFRM GBR HUN IRL ISR ITA JPN LTU LVA NLD NOR NZL POL PRT SVN SVK SWE USA URY ZAF
where: a Canadian MilkShorthorn bAustria+Germany; cDenmark + Finland + Sweden; d France Montbeliarde;
4Accepted traits abbreviations:
Production ==> mil = milk;fat =fat; pro = protein;
Conformation ==> sta = stature;cwi = chest width;bde = body depth;ang = angularity;ran = rump angle;rwi = rump width; rls = rear-leg set;rlr = rear-leg rear view;fan = foot angle;hde = heel depth/hoof height; fua = fore udder attachment; ruh = rear udder height; ruw = rear udder width; usu = udder support;ude = udder depth;ftp = front teat placement;ftl = (front) teat length;rtp = rear teat placement;ous = overall udder score; ofl = overall feet&legs score; ocs = overall conformation score; bcs = body condition score; loc = locomotion;
Udder ==>scs = somatic cell; mas = mastitis
Longevity ==> dlo = direct longevity;
Calving ==> dce = direct calving ease;mce = maternal calving ease;dsb= direct stillbirth;msb = maternal stillbirth; ges = direct gestation length
Female fertility ==>hco = heifer conception;crc = cow recycling;cc1 = lactating cow's ability to conceive (1);cc2 = lactating cow's ability to conceive (2);int= internval traits
Workability ==> msp = milking speed;tem = temperament
SNP Training ==> cma = clinical mastitis
Claw Health ==> dde = digital dermatitis
Metabolic disease ==> sck = sub-clinical ketosis
5Accepted codes:
00 (unknown);
11 (based on first crop sampling daughters or based on usage while having a genomic proof);
12 (based on first and second crop daughters);
13 (based on parent average and genomic information only);
21(based on imported semen of proven bull, second crop daughters only, or based on imported daughters/embryos);
23 (GEBV with foreign PA) - specific to GMACE files (file700)
24 (GEBV with foreign proof) - specific to GMACE files (file700)
6Accepted abbreviations:(Please Note that from September 2026 onwards code P will no longer be valid)
Y (if bull proof meets national standards for official publication in the country sending information.);
N (otherwise).
7Valid codes for status of bulls:(Please Note that from September 2026 onwards code 20 will no longer be valid)
00 (other or unknown);
10 (national and international AI bulls);
15 (young bull, genomically tested, not yet selected for AI) - specific to GMACE files (file700)
8Field for number of daughters should be positive. For missing value put 0.
9Field for number of herds should be positive. For missing value put 0.
10 Production, conformation, udder health, fertility, workability, SNP training traits, claw health, metabolic disease: Weighting factor used for these traits is “the effective daughter contribution (EDC)”, which is described In the Interbull document Code of practice, Appendix IV, “Weighting factor for international genetic evaluation”, updated April 27, 2004. EDC values should be rounded to the nearest integer value.
Calving: The weighting factors used for calving traits it the total number of calvings for the direct effects and number of daughters with calving for maternal effect
Longevity: The weighting factor used for longevity traits depends on the national genetic evaluation model. For linear models the weighting factor is the same as described above for conformation, fertility, production, udder health and workability traits. For survival models number of culled daughters is used as the weighting factor.
11Reliability values are nationally calculated reliability values expressed in percents with 4 decimials. For missing value put 0.
12National predicted genetic merit values published domestically. For threshold models the submitted values are from the underlying scale. For missing values put 9999999999. Please note! In the old fileformat 01x-020 and 115, the national proofs were multiplied by a factor: (prod=100; conf=100;udder=1000;long=1000;calv=1000;fert=1000; fert=1000;work=1000). This multiplication will no longer be needed.