• public
• file010

FILE FORMAT FOR DATA DELIVERY TO THE INTERBULL CENTRE FOR THE INTERNATIONAL EVALUATION BULL PEDIGREE AND NATIONAL DAIRY - PRODUCTION PROOF FILE

(record length= 318)

7 Breed2ofbull character3 10 Countryoffirstregistrationofbull4 character3 13 Sex character1 M 14 IDnumberofbull5 character12 000000A12345 26 Nameofbull6 character30 Bullidentificationinthecountrysendingthisinformation7 56 Country4 character3 59 Sex character1 M 60 IDnumberofbull5 character12 72 Nameofbull6 character30 102 Birthdataofbull(YYYYMMDD) integer8 19850101 Sireofbullinternationalidentification3 110 Breed2ofsireofbull character3 113 Countryoffirstregistrationofsireofbull4 character3 116 Sex character1 M 117 IDnumberofsireofbull5 character12 Damofbullinternationalidentification3 129 Breed2ofdamofbull character3 132 Countryoffirstregistrationofdamofbull4 character3 135 Sex character1 F 136 IDnumberofdamofbull5 character12 Maternal-grand-sire(MGS)ofbullinternationalidentification3 148 Breed2ofMGSofbull character3 151 CountryoffirstregistrationofMGSofbull4 character3 154 Sex character1 M 155 IDnumberofMGSofbull5 character12 Maternal-grand-dam(MGD)ofbullinternationalidentification3 167 Breed2ofMGDofbulls character3 170 CountryoffirstregistrationofMGDofbull4 character3 173 Sex character1 F 174 IDnumberofMGDofbull5 character12 186 Dateofnationalevaluation(YYYYMMDD) integer8 19940715 194 Referencebasedefinition8 character7 H00CC95 201 Unitof measurement9 character3 KGS 204 Geneticmerit(nationalproof)definition10 character2 BV/TA 206 Numberofdaughters(milk/fatdataset) integer6 212 Numberofherds(milk/fatdataset) integer6 218 Numberofeffectivedaughters(milk/fatdataset) integer6 224 Repeatability/Reliability(%-milk/fatdataset) integer2

• BULLPEDIGREEANDNATIONALDAIRY-PRODUCTIONPROOF FILE (cont´d) StartingByte FieldDescription Format Example

• sendingthisinformation(YYYYMM) integer6 199010

1. 010=BullNationalProductionProofFile; 015=BullNationalConformationProofFile; 115=BullNationalBrownSwissConformationProofFile; 016=BullNationalMilkSomaticCellandClinicalMastitisProofFile; 040=FileforGeneticTrendValidation(production); 045=FileforGeneticTrendValidation(conformation); 046=FileforGeneticTrendValidation(milksomaticcellandclinicalmastitis). 2. HOL=Holstein-Friesian(Black-and-White)type;BSW=BrownSwisstype;GUE=Guernseytype; JER=Jerseytype;SIM=Simmentaltype;MSH=MilkingShorthorntype;PIN=Pinzgauertype; AYS=Ayrshiretype;RED=Non-AyrshireRedandRed-and-Whitetypes. 3. Identificationinthecountryoffirstregistration,asknowninthecountrysendingthisinformation. 4. Countrycodes;InterbullcodesinEnglish: ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; CAN=Canada; HRV=Croatia; CZE=CzechRepublic; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; GBR=UnitedKingdom; DEU=Germany; GRC=Greece; HUN=Hungary; IND=India; IRL=Ireland; ISR=Israel; ITA=Italy; JPN=Japan; LVA=Latvia; LTU=Lithuania; LUX=Luxembourg; MEX=Mexico; NLD=Netherlands; NZL=NewZealand; NOR=Norway; POL=Poland; PRT=Portugal; ROU=Romania; SVK=SlovakRepublic;SVN=Slovenia; KOR=SouthKorea; ZAF=SouthAfricanRepublic; ESP=Spain; SWE=Sweden; CHE=Switzerland; TUN=Tunisia; USA=UnitedStatesofAmerica; ZWE=Zimbabwe ForadditionalcountrycodespleaseusetheISO3166standard. 5. AllIDnumbers:Registrationnumbers,rightjustified,leadingblanksaszeros. 6. Name:Leftjustified,blanksnotaszeros. 7. Neededtocreateacross-referencelistofbullswithmultipleregistrations;couldbeidenticaltothe internationalidentification. 8. Reference(genetic)basedefinitioninthecountrysendingthisinformation: breedinitial(1char),yearestablished(YY),bull(B)orcow(C)(1char); birth(B),calving(C)orevaluation(E)(1char); yearofevent(usemiddleyearifbasedon multipleyears(YY); forbreedinitialseebreedcodeinfootnote2(useXifbasedon multiplebreeds); e.g.H00BB95meansabasedefined2000basedonHolsteinbullsbornin1995; A95CC90meansabasedefined1995basedonAyrshirecowscalvingin1990. 9. Unitofexpressionofnationalproofanddaughteryielddeviationinthecountrysendingthis information; KGS=kilogram,LTR=litre;LBS=pound; RBV=RelativeBreedingValue;BCA=BreedClassAverage. 10. BV=BreedingValue: TA=TransmittingAbility(halfBV).

(cont´d) 11. Typeofproof: 00 unknown;11 basedonfirstcropsamplingdaughters;12 basedonfirstandsecondcropdaughters;21 basedonimportedsemenofprovenbull(secondcropdaughtersonly). 12. Yifinformationfromanothercountryisincorporatedindaughteryielddeviationornational proofifdaughteryielddeviationisnotavailable;Notherwise.Recordswith"Y"inthisfieldwillbeexcludedfromtheinternationalevaluation. 13 Yifbullproofmeetsnationalstandardsforofficialpublicationinthecountrysendingthis information;Pifbullispartofasimultaneousprogeny-testingprogramme,buttheproofdoesnotyetmeet nationalstandardsforofficialpublication;Notherwise. 14. Statusofbull 00 unknown10 bullrandomlysampledthroughanofficialAIscheme20 otherbull.Recordswith"20"inthisfieldwillbeexcludedfromtheinternationalevaluation,unlesstypeof proofis"21". 15. DYD=DaughterYieldDeviation;NationalproofexpressedaseitherestimatedBVorTA(footnote10);inbaseandunitsequivalenttothecountrysendingthisinformation(footnotes8and9);multipliedby 100toinclude2decimalpoints;formissingnationalprooforDYDfillin9s:e.g. missingmilkyieldnationalproof99999999 missingfatyieldDYD999999. 16. Breedofevaluationwilldeterminetheinternationalevaluationofthebreedthatwillincludethis record;usuallyitisthesameasthebreedofbull. 17. EffectivedaughtercontributionscalculatedaccordingtotheInterbulldocument"Newweighting factorsfortheinternationalgeneticevaluation",7July,2000,roundedtonearestinteger. General: AllnumericfieldsshouldberightjustifiedAllalphafieldsshouldbeinuppercase.Ifnumbersofdaughters,herds,andeffectivedaughtersandrepeatability/reliabilityarethesame forproteinasformilk/fat,informationmustberepeated(donotleaveitblank).