{{attachment:ibc_logo.jpg}}

== FILE FORMAT FOR INTERNATIONAL PARENT AVERAGE MACE/GMACE ==
||<tablestyle="border-collapse:collapse;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="439px" style="border:1pt solid windowtext;padding:0pt 5.4pt;vertical-align:top;font-weight:bold;      ">Field   Description ||<width="191px" 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;vertical-align:top;font-weight:bold;      ">Format ||
||<rowstyle="mso-yfti-irow:1"width="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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="439px" 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="191px" 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:12"width="439px" 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="191px" 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:13"width="439px" 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="191px" 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:14"width="439px" 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="191px" 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:15"width="439px" 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="191px" 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:16"width="439px" 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="191px" 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:17"width="439px" 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="191px" 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:18"width="439px" 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="191px" 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:19;mso-yfti-lastrow:yes"width="439px" 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">Parent average for TRAIT i (x1000)   (9) ||<width="191px" 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 ||


'''KEY TO: INTERBULL GENETIC EVALUATION FILE FORMAT'''

 1. 060 = Interbull Production File; 065 = Interbull Conformation File; 066 = Interbull Udder health file; 067 = Interbull Longevity File; 068 = Interbull Calving File; 069 = Interbull Female Fertility File; 070 = Interbull Workability File; 071= Interbull SNP Training for Clinical Mastitis File

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

 1. 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).

 1. 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.

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

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

 1. 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)

 1. Repeat as necessary depending on number of countries;

 1. Parent averages in base and unit of each country; proofs are multiplied by 1000 to include 3 decimals; missing values are represented by 999999.