Differences between revisions 2 and 3
Revision 2 as of 2012-02-24 11:24:46
Size: 16919
Editor: Valentina
Comment:
Revision 3 as of 2012-02-24 12:00:43
Size: 31
Editor: Valentina
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
== FILE FORMAT FOR DATA DELIVERY TO THE INTERBULL CENTRE FOR THE INTERNATIONAL EVALUATION BULL PEDIGREE AND NATIONAL DAIRY - PRODUCTION PROOF FILE ==
(record length= 318)

||<tablewidth="200px">__[[/../StartingByte|StartingByte]]__ ||__[[/../../FieldDescription|FieldDescription]]__||__Format__||__Example__||
||1 ||Recordtype¹ ||character3||010||
||4 ||Breed2 of evaluation16||character3||HOL||
|||||||| Bull international identification3 ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||
|| || || || ||






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__

||<tablestyle="margin-left:8.4pt;border-collapse:collapse;"rowstyle=""width="67px" height="16.85pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">226 ||<width="345px" height="16.85pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Numberofdaughters(proteindataset) ||<width="94px" height="16.85pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||<width="50px" height="16.85pt" style="padding:0pt 0pt 0pt 0pt; ;text-align:center;vertical-align:top" |5> ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">232 ||<width="345px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Numberofherds(proteindataset) ||<width="94px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">238 ||<width="345px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Numberofeffectivedaughters(proteindataset) ||<width="94px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="11.8pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">244 ||<width="345px" height="11.8pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Repeatability/Reliability(%-proteindataset) ||<width="94px" height="11.8pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer2 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">246 ||<width="345px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Typeofproof11 ||<width="94px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer2 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">248 ||<width="345px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Incorporationofforeignproof12 ||<width="94px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">character1 ||<width="50px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Y/N ||
||<rowstyle=""width="67px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">249 ||<width="345px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Officialpublicationofproof13 ||<width="94px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">character1 ||<width="50px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Y/P/N ||
||<rowstyle=""width="67px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">250 ||<width="345px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">BirthdateoffirstAIdaughtersinthecountry ||<width="94px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top"> ||<width="50px" height="13.6pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top"> ||


 . sendingthisinformation(YYYYMM) integer6 199010

||<tablestyle="margin-left:8.4pt;border-collapse:collapse;"rowstyle=""width="67px" height="12.75pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">256 ||<width="327px" height="12.75pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Statusofbull14 ||<width="104px" height="12.75pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer2 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">258 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Milkyieldnationalproof15(x100) ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer8 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">266 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Fatyieldnationalproof15(x100) ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">272 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Proteinyieldnationalproof15(x100) ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">278 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">MilkyieldDYD15(x100) ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer8 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">286 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">FatyieldDYD15(x100) ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">292 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">ProteinyieldDYD15(x100) ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">298 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Effectivedaughtercontributions,milk17 ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">304 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Effectivedaughtercontributions,fat17 ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">310 ||<width="327px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Effectivedaughtercontributions,protein17 ||<width="104px" height="12.7pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">integer6 ||
||<rowstyle=""width="67px" height="17.75pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">316 ||<width="327px" height="17.75pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">Countrysendingthisinformation4 ||<width="104px" height="17.75pt" style="padding:0pt 0pt 0pt 0pt; ;vertical-align:top">character3 ||


{{file:///C:/DOCUME~1/valpal.AD/LOCALS~1/Temp/msohtmlclip1/01/clip_image002.gif||height="194",width="2"}} {{file:///C:/DOCUME~1/valpal.AD/LOCALS~1/Temp/msohtmlclip1/01/clip_image003.gif||height="103",width="2"}} 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,blanks__not__aszeros. 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).
Describe public/file010 here.

Describe public/file010 here.

public/file010 (last edited 2012-03-05 14:31:44 by Valentina)