⇤ ← Revision 1 as of 2012-02-24 11:00:44
16816
Comment:
|
16919
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
{{file:///C:/DOCUME%7E1/valpal.AD/LOCALS%7E1/Temp/msohtmlclip1/01/clip_image001.gif||width="2",height="14"}} FILEFORMAT FORDATADELIVERYTOTHEINTERBULL CENTRE FORTHEINTERNATIONAL EVALUATION BULLPEDIGREEANDNATIONALDAIRY-PRODUCTIONPROOF FILE (record length= 318) __StartingByte__ __FieldDescription__ __Format__ __Example__ 1 Recordtype1 character3 010 4 Breed2of evaluation16 character3 HOL Bullinternationalidentification3 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 | == FILE FORMAT FOR DATA DELIVERY TO THE INTERBULL CENTRE FOR THE INTERNATIONAL EVALUATION BULL PEDIGREE AND NATIONAL DAIRY - PRODUCTION PROOF FILE == (record length= 318) |
Line 3: | Line 4: |
BULLPEDIGREEANDNATIONALDAIRY-PRODUCTIONPROOF FILE (cont´d) __StartingByte__ __FieldDescription__ __Format__ __Example__ ||<tablestyle="margin-left:8.4pt;border-collapse:collapse;"rowstyle="height:16.85pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:16.85pt;">226||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:16.85pt;">Numberofdaughters(proteindataset)||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:16.85pt;">integer6||<^ width="50px" style="width:37.75pt;padding:0pt 0pt 0pt 0pt; height:16.85pt;" |5> || ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">232||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Numberofherds(proteindataset)||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">238||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Numberofeffectivedaughters(proteindataset)||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:11.8pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:11.8pt;">244||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:11.8pt;">Repeatability/Reliability(%-proteindataset)||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:11.8pt;">integer2|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">246||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Typeofproof11||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer2|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">248||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Incorporationofforeignproof12||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">character1||<^ width="50px" style="width:37.75pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Y/N|| ||<rowstyle="height:13.6pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;">249||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;">Officialpublicationofproof13||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;">character1||<^ width="50px" style="width:37.75pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;">Y/P/N|| ||<rowstyle="height:13.6pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;">250||<^ width="345px" style="width:258.4pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;">BirthdateoffirstAIdaughtersinthecountry||<^ width="94px" style="width:70.7pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;"> ||<^ width="50px" style="width:37.75pt;padding:0pt 0pt 0pt 0pt; height:13.6pt;"> || sendingthisinformation(YYYYMM) integer6 199010 ||<tablestyle="margin-left:8.4pt;border-collapse:collapse;"rowstyle="height:12.75pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.75pt;">256||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.75pt;">Statusofbull14||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.75pt;">integer2|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">258||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Milkyieldnationalproof15(x100)||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer8|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">266||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Fatyieldnationalproof15(x100)||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">272||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Proteinyieldnationalproof15(x100)||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">278||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">MilkyieldDYD15(x100)||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer8|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">286||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">FatyieldDYD15(x100)||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">292||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">ProteinyieldDYD15(x100)||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">298||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Effectivedaughtercontributions,milk17||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">304||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Effectivedaughtercontributions,fat17||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:12.7pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">310||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">Effectivedaughtercontributions,protein17||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:12.7pt;">integer6|| ||<rowstyle="height:17.75pt;"^ width="67px" style="width:50.4pt;padding:0pt 0pt 0pt 0pt; height:17.75pt;">316||<^ width="327px" style="width:245.5pt;padding:0pt 0pt 0pt 0pt; height:17.75pt;">Countrysendingthisinformation4||<^ width="104px" style="width:77.9pt;padding:0pt 0pt 0pt 0pt; height:17.75pt;">character3|| |
||<tablewidth="200px">__[[/../StartingByte|StartingByte]]__ ||__[[/../../FieldDescription|FieldDescription]]__||__Format__||__Example__|| ||1 ||Recordtype¹ ||character3||010|| ||4 ||Breed2 of evaluation16||character3||HOL|| |||||||| Bull international identification3 || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || || |
Line 31: | Line 38: |
{{file:///C:/DOCUME%7E1/valpal.AD/LOCALS%7E1/Temp/msohtmlclip1/01/clip_image002.gif||width="2",height="194"}} {{file:///C:/DOCUME%7E1/valpal.AD/LOCALS%7E1/Temp/msohtmlclip1/01/clip_image003.gif||width="2",height="103"}} 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). | |
Line 34: | Line 40: |
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). |
FILE FORMAT FOR DATA DELIVERY TO THE INTERBULL CENTRE FOR THE INTERNATIONAL EVALUATION BULL PEDIGREE AND NATIONAL DAIRY - PRODUCTION PROOF FILE
(record length= 318)
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
226 |
Numberofdaughters(proteindataset) |
integer6 |
|
232 |
Numberofherds(proteindataset) |
integer6 |
|
238 |
Numberofeffectivedaughters(proteindataset) |
integer6 |
|
244 |
Repeatability/Reliability(%-proteindataset) |
integer2 |
|
246 |
Typeofproof11 |
integer2 |
|
248 |
Incorporationofforeignproof12 |
character1 |
Y/N |
249 |
Officialpublicationofproof13 |
character1 |
Y/P/N |
250 |
BirthdateoffirstAIdaughtersinthecountry |
|
|
- sendingthisinformation(YYYYMM) integer6 199010
256 |
Statusofbull14 |
integer2 |
258 |
Milkyieldnationalproof15(x100) |
integer8 |
266 |
Fatyieldnationalproof15(x100) |
integer6 |
272 |
Proteinyieldnationalproof15(x100) |
integer6 |
278 |
MilkyieldDYD15(x100) |
integer8 |
286 |
FatyieldDYD15(x100) |
integer6 |
292 |
ProteinyieldDYD15(x100) |
integer6 |
298 |
Effectivedaughtercontributions,milk17 |
integer6 |
304 |
Effectivedaughtercontributions,fat17 |
integer6 |
310 |
Effectivedaughtercontributions,protein17 |
integer6 |
316 |
Countrysendingthisinformation4 |
character3 |
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).