Differences between revisions 1 and 3 (spanning 2 versions)
Revision 1 as of 2012-02-29 17:38:43
Size: 17847
Editor: Valentina
Comment:
Revision 3 as of 2012-03-05 14:39:33
Size: 19060
Editor: Valentina
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
{{attachment:ibc_logo.jpg}}

== FILE FORMAT FOR INTERNATIONAL PREDICTED GENETIC MERIT ==
||<tablestyle="border-collapse:collapse;mso-table-layout-alt:fixed;border:none;mso-border-alt:solid windowtext .5pt;mso-yfti-tbllook:1184;mso-padding-alt:0pt 5.4pt 0pt 5.4pt" tableclass="MsoTableGrid"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes"width="487px" style="border:solid windowtext 1.0pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">'''Field Description''' ||<width="151px" style="border-width:1pt 1pt 1pt medium;border-style:solid solid solid none;border-color:windowtext windowtext windowtext -moz-use-text-color;-moz-border-top-colors:none;-moz-border-right-colors:none;-moz-border-bottom-colors:none;-moz-border-left-colors:none;-moz-border-image:none;padding:0pt 5.4pt;font-weight:bold; ;vertical-align:top">Format ||
||<rowstyle="mso-yfti-irow:1"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Record type (1) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:2"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Breed of evaluation (2) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:3"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Bull international identification (3) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:4"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Breed of bull ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:5"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Country of registration of bull (4) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:6"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Sex ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||
||<rowstyle="mso-yfti-irow:7"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">ID number of bull (5) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 12 ||
||<rowstyle="mso-yfti-irow:8"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:9"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:10"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Date of international evaluation (YYYYMM) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||
||<rowstyle="mso-yfti-irow:11"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:12"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Official publication of proof (6) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||
||<rowstyle="mso-yfti-irow:13"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:14"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of repeated segments for this file ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:15"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">number of countries ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 3 ||
||<rowstyle="mso-yfti-irow:16"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">number of traits (7) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 3 ||
||<rowstyle="mso-yfti-irow:17"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:18"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">International proof in each country (8) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:19"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:20"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Country code ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:21"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:22"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Genetic merit (international proof) definition(9) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 2 ||
||<rowstyle="mso-yfti-irow:23"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of herds ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 8 ||
||<rowstyle="mso-yfti-irow:24"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of daughters ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 8 ||
||<rowstyle="mso-yfti-irow:25"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Effective Daughter Contribution ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 8 ||
||<rowstyle="mso-yfti-irow:26"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:27"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Repeatability/Reliability (%) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 2 ||
||<rowstyle="mso-yfti-irow:28;mso-yfti-lastrow:yes"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">International proof (x1000) (10) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 10 ||
Line 3: Line 35:
== FILE FORMAT FOR INTERNATIONAL PREDICTED GENETIC MERIT == === KEY TO: INTERBULL GENETIC EVALUATION FILE FORMAT ===
1. 030 = Interbull Production File; 035 = Interbull Conformation File; 036 = Interbull Udder health file; 037 = Interbull Longevity File; 038 = Interbull Calving File; 039 = Interbull Female Fertility File; 140 = Interbull Workability File.
Line 5: Line 38:
||<tablestyle="border-collapse:collapse;mso-table-layout-alt:fixed;border:none; mso-border-alt:solid windowtext .5pt;mso-yfti-tbllook:1184;mso-padding-alt: 0pt 5.4pt 0pt 5.4pt" tableclass="MsoTableGrid"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">'''Field Description''' ||<^ width="151px" style="width: 113.4pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0pt 5.4pt; font-weight: bold;">Format ||
||<rowstyle="mso-yfti-irow:1"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">Record type (1) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:2"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">Breed of evaluation (2) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:3"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">Bull international identification (3) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:4"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Breed of bull ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:5"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Country of registration of bull (4) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:6"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Sex ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 1 ||
||<rowstyle="mso-yfti-irow:7"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> ID number of bull (5) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 12 ||
||<rowstyle="mso-yfti-irow:8"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:9"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">EMPTY SPACE ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:10"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">Date of international evaluation (YYYYMM) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 6 ||
||<rowstyle="mso-yfti-irow:11"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">EMPTY SPACE ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:12"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">Official publication of proof (6) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 1 ||
||<rowstyle="mso-yfti-irow:13"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:14"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">Number of repeated segments for this file ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:15"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> number of countries ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 3 ||
||<rowstyle="mso-yfti-irow:16"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> number of traits (7) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 3 ||
||<rowstyle="mso-yfti-irow:17"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:18"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt">International proof in each country (8) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:19"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> EMPTY SPACE ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:20"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Country code ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:21"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> EMPTY SPACE ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:22"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Genetic merit (international proof) definition(9) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 2 ||
||<rowstyle="mso-yfti-irow:23"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Number of herds ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 8 ||
||<rowstyle="mso-yfti-irow:24"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Number of daughters ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 8 ||
||<rowstyle="mso-yfti-irow:25"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Effective Daughter Contribution ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 8 ||
||<rowstyle="mso-yfti-irow:26"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> EMPTY SPACE ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:27"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> Repeatability/Reliability (%) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 2 ||
||<rowstyle="mso-yfti-irow:28;mso-yfti-lastrow:yes"^ width="487px" style="width:365.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt"> International proof (x1000) (10) ||<^ width="151px" style="width:113.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer 10 ||
2. BSW = Brown Swiss, GUE = Guernsey, HOL = Holsteins, JER = Jersey, RDC = Red Dairy Cattle, SIM = Simmental
Line 35: Line 40:
3. International identification in the country of first registration as known at the Interbull Centre; this is the first ID in new cross-reference list Xrefmult.*** found on the Interbull ftp site (where *** refer to breed).
Line 36: Line 42:
4. Country codes of Interbull members (in alphabetical order):
Line 37: Line 44:
 . ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; BUL=Bulgaria;CAN=Canada; HRV=Croatia; CZE=Czech Republic; [DFS:Denmark,Finland,Sweden]; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; [DEU=Germany,Austria]; DEU=Germany; GRC=Greece; HUN=Hungary; IRL=Ireland; ISR=Israel; ITA=Italy; JPN=Japan; KOR=Korea; LVA=Lathvia; LTU=Lithuania;LUX=Luxembourg; MEX=Mexico; NLD=Netherlands; NZL=New Zealand; NOR=Norway; POL=Poland; PRT=Portugal; SVK=Slovak Republic; SVN=Slovenia; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; GBR=United Kingdom; USA=United States of America.
Line 38: Line 46:
5. ID numbers: Registration numbers, right justified, leading blanks as zeros.
Line 39: Line 48:
6. Y = Bull meets standard for official publication in at least one country.
Line 40: Line 50:
7. Number of traits:
Line 41: Line 52:
 . Production i = 3 (1=mi, 2=fa, 3=pr ) Udder health i = 2 (1=sc, 2=ma ) Longevity i = 1 (1=dl ) Calving i = 4 (1=dc, 2=mc, 3=ds, 4=ms ) Fertility i = 5 (1=ch, 2=cy, 3=c1, 4=c2, 5=it) Workability i = 2 (1=md, 2=te ) Conformation BSW i= 22 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=fan 9=hde 10=fua 11=ruh 12=ruw 13=usu 14=ude 15=ftp 16=ftl 17=rtp 18=ocs 19=ous 20=ofl 21=loc 22=bcs) RDC HOL JER GUE i= 21 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=rlr 9=fan 10=fua 11=ruh 12=usu 13=ude 14=ftp 15=ftl 16=rtp 17=ocs 18=ous 19=ofl 20=loc 21=bcs)
Line 42: Line 54:
8. Repeat as necessary depending on number of countries;
Line 43: Line 56:
9. B+ = Breeding Value, high values desirable; B- = Breeding Value, low values desirable; T+ = Transmitting Ability, high values desirable; T- = Transmitting Ability, low values desirable.
Line 44: Line 58:
Describe public/itb files here. 10. International proof expressed as either estimated B+, B-, T+ or T-, in base and unit of each country; proofs are multiplied by 1000 to include 3 decimals; missing values are represented by 999999.

ibc_logo.jpg

FILE FORMAT FOR INTERNATIONAL PREDICTED GENETIC MERIT

Field Description

Format

Record type (1)

character 3

Breed of evaluation (2)

character 3

Bull international identification (3)

Breed of bull

character 3

Country of registration of bull (4)

character 3

Sex

character 1

ID number of bull (5)

character 12

EMPTY SPACE

1

Date of international evaluation (YYYYMM)

integer 6

EMPTY SPACE

1

Official publication of proof (6)

character 1

Number of repeated segments for this file

number of countries

integer 3

number of traits (7)

integer 3

International proof in each country (8)

EMPTY SPACE

1

Country code

character 3

EMPTY SPACE

1

Genetic merit (international proof) definition(9)

character 2

Number of herds

integer 8

Number of daughters

integer 8

Effective Daughter Contribution

integer 8

EMPTY SPACE

1

Repeatability/Reliability (%)

integer 2

International proof (x1000) (10)

integer 10

KEY TO: INTERBULL GENETIC EVALUATION FILE FORMAT

1. 030 = Interbull Production File; 035 = Interbull Conformation File; 036 = Interbull Udder health file; 037 = Interbull Longevity File; 038 = Interbull Calving File; 039 = Interbull Female Fertility File; 140 = Interbull Workability File.

2. BSW = Brown Swiss, GUE = Guernsey, HOL = Holsteins, JER = Jersey, RDC = Red Dairy Cattle, SIM = Simmental

3. International identification in the country of first registration as known at the Interbull Centre; this is the first ID in new cross-reference list Xrefmult.*** found on the Interbull ftp site (where *** refer to breed).

4. Country codes of Interbull members (in alphabetical order):

  • ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; BUL=Bulgaria;CAN=Canada; HRV=Croatia; CZE=Czech Republic; [DFS:Denmark,Finland,Sweden]; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; [DEU=Germany,Austria]; DEU=Germany; GRC=Greece; HUN=Hungary; IRL=Ireland; ISR=Israel; ITA=Italy; JPN=Japan; KOR=Korea; LVA=Lathvia; LTU=Lithuania;LUX=Luxembourg; MEX=Mexico; NLD=Netherlands; NZL=New Zealand; NOR=Norway; POL=Poland; PRT=Portugal; SVK=Slovak Republic; SVN=Slovenia; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; GBR=United Kingdom; USA=United States of America.

5. ID numbers: Registration numbers, right justified, leading blanks as zeros.

6. Y = Bull meets standard for official publication in at least one country.

7. Number of traits:

  • Production i = 3 (1=mi, 2=fa, 3=pr ) Udder health i = 2 (1=sc, 2=ma ) Longevity i = 1 (1=dl ) Calving i = 4 (1=dc, 2=mc, 3=ds, 4=ms ) Fertility i = 5 (1=ch, 2=cy, 3=c1, 4=c2, 5=it) Workability i = 2 (1=md, 2=te ) Conformation BSW i= 22 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=fan 9=hde 10=fua 11=ruh 12=ruw 13=usu 14=ude 15=ftp 16=ftl 17=rtp 18=ocs 19=ous 20=ofl 21=loc 22=bcs) RDC HOL JER GUE i= 21 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=rlr 9=fan 10=fua 11=ruh 12=usu 13=ude 14=ftp 15=ftl 16=rtp 17=ocs 18=ous 19=ofl 20=loc 21=bcs)

8. Repeat as necessary depending on number of countries;

9. B+ = Breeding Value, high values desirable; B- = Breeding Value, low values desirable; T+ = Transmitting Ability, high values desirable; T- = Transmitting Ability, low values desirable.

10. International proof expressed as either estimated B+, B-, T+ or T-, in base and unit of each country; proofs are multiplied by 1000 to include 3 decimals; missing values are represented by 999999.

public/itb files (last edited 2022-08-24 09:33:02 by Valentina)