Differences between revisions 1 and 4 (spanning 3 versions)
Revision 1 as of 2012-02-25 19:49:34
Size: 10929
Editor: Valentina
Comment:
Revision 4 as of 2012-02-25 20:07:17
Size: 15444
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 ==
== NATIONAL WORKABILITY PROOF FILE ==
File format (record length=136)
||<tableclass="MsoNormalTable"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes"width="102px" style="border:none;border-bottom:solid windowtext 1.0pt;mso-border-bottom-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:bottom">Starting Position ||<width="331px" style="border:none;border-bottom:solid windowtext 1.0pt;mso-border-bottom-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:bottom">Field Description ||<width="95px" style="border:none;border-bottom:solid windowtext 1.0pt;mso-border-bottom-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:bottom">Format ||<width="113px" style="border:none;border-bottom:solid windowtext 1.0pt;mso-border-bottom-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:bottom">Example ||
||<rowstyle="mso-yfti-irow:1"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Record type^1^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">016 ||
||<rowstyle="mso-yfti-irow:2"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">4 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Breed^2^ of evaluation^12^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||||||||<rowstyle="mso-yfti-irow:3;page-break-inside:avoid"width="640px" style="padding:0pt 5.4pt 0pt 5.4pt;text-align:center;vertical-align:top">Bull international identification^3^ ||
||<rowstyle="mso-yfti-irow:4"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">7 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Breed^2^ of bull ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:5"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">10 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Country of first registration of bull^ 4^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:6"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">13 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Sex ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">M ||
||<rowstyle="mso-yfti-irow:7"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">14 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">ID number of bull ^5^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 12 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">000000A12345 ||
||<rowstyle="mso-yfti-irow:8"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">26 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Name of bull ^6^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 30 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:9"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">56 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Birth date of bull (YYYYMMDD) ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 8 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">19850117 ||
||||||||<rowstyle="mso-yfti-irow:10;page-break-inside:avoid"width="640px" style="padding:0pt 5.4pt 0pt 5.4pt;text-align:center;vertical-align:top">National evaluation information ||
||<rowstyle="mso-yfti-irow:11"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">64 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Date of national evaluation (YYYYMMDD) ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 8 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">19960415 ||
||<rowstyle="mso-yfti-irow:12"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">72 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Status of bull^10^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 2 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||||||||<rowstyle="mso-yfti-irow:14;page-break-inside:avoid"width="640px" style="padding:0pt 5.4pt 0pt 5.4pt;text-align:center;vertical-align:top">Trait1=Milkability ||
||<rowstyle="mso-yfti-irow:15"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">74 ||Genetic merit (national proof) definition^7^ ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 2 ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">B+/ B-/T+/ T- ||
||<width="102px" style="padding:0pt 5.4pt;vertical-align:top; ">76 ||<width="331px" style="padding:0pt 5.4pt;vertical-align:top; ">Type of proof^ 8^ ||<width="95px" style="padding:0pt 5.4pt;vertical-align:top; ">integer 2 ||<width="113px" style="padding:0pt 5.4pt;vertical-align:top; "> ||
||<rowstyle="mso-yfti-irow:16"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">78 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Official publication of proof^ 9^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Y/P/N ||
||<rowstyle="mso-yfti-irow:17"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">79 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of daughters ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:18"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">85 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of herds ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 5 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:19"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">90 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Effective Daughter Contribution^13^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:20"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">96 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Repeatability/Reliability (%) ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 2 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:21"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">98 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">National proof^11^ (x1000) ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||||||||<rowstyle="mso-yfti-irow:22;page-break-inside:avoid"width="640px" style="padding:0pt 5.4pt 0pt 5.4pt;text-align:center;vertical-align:top">trait2= Temperament ||
||<rowstyle="mso-yfti-irow:23"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">104 ||Genetic merit (national proof) definition^7^ ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 2 ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<width="102px" style="padding:0pt 5.4pt;vertical-align:top; ">106 ||<width="331px" style="padding:0pt 5.4pt;vertical-align:top; ">Type of proof^ 8^ ||<width="95px" style="padding:0pt 5.4pt;vertical-align:top; ">integer 2 ||<width="113px" style="padding:0pt 5.4pt;vertical-align:top; "> ||
||<rowstyle="mso-yfti-irow:24"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">108 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Official publication of proof^ 9^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Y/N ||
||<rowstyle="mso-yfti-irow:25"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">109 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of daughters ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:26"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">115 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of herds ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 5 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:27"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">120 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Effective Daughter Contribution^13^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:28"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">126 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Repeatability/Reliability (%) ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 2 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:29"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">128 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">National proof^11^ (x1000) ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer 6 ||<width="113px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:30;mso-yfti-lastrow:yes"width="102px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">134 ||<width="331px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Country sending this information^4^ ||<width="95px" style="padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
Line 5: Line 40:
||<tableclass="MsoNormalTable"rowstyle="mso-yfti-irow:0; mso-yfti-firstrow:yes"style="border:none; border-bottom:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt; vertical-align:bottom; width: 102px">Starting Position ||<style="border:none; border-bottom:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt; vertical-align:bottom; width: 331px">Field Description ||<style="border:none; border-bottom:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt; vertical-align:bottom; width: 95px">Format ||<style="border:none; border-bottom:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt; padding:0pt 5.4pt 0pt 5.4pt; vertical-align:bottom; width: 113px">Example ||
||<rowstyle="mso-yfti-irow:1"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">1 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Record type^1^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 3 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">016 ||
||<rowstyle="mso-yfti-irow:2"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">4 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Breed^2^ of evaluation^12^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 3 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||||||||<rowstyle="mso-yfti-irow:3; page-break-inside:avoid"style="padding:0pt 5.4pt 0pt 5.4pt; text-align:center; vertical-align:top; width: 640px">Bull international identification^3^ ||
||<rowstyle="mso-yfti-irow:4"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">7 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Breed^2^ of bull ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 3 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:5"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">10 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Country of first registration of bull^ 4^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 3 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:6"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">13 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Sex ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 1 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">M ||
||<rowstyle="mso-yfti-irow:7"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">14 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">ID number of bull ^5^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 12 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">000000A12345 ||
||<rowstyle="mso-yfti-irow:8"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">26 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Name of bull ^6^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 30 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:9"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">56 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Birth date of bull (YYYYMMDD) ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 8 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">19850117 ||
||||||||<rowstyle="mso-yfti-irow:10; page-break-inside:avoid"style="padding:0pt 5.4pt 0pt 5.4pt; text-align:center; vertical-align:top; width: 640px">National evaluation information ||
||<rowstyle="mso-yfti-irow:11"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">64 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Date of national evaluation (YYYYMMDD) ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 8 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">19960415 ||
||<rowstyle="mso-yfti-irow:12"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">72 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Type of proof^ 8^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 2 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:13"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">74 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Status of bull^10^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 2 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||||||||<rowstyle="mso-yfti-irow:14; page-break-inside:avoid"style="padding:0pt 5.4pt 0pt 5.4pt; text-align:center; vertical-align:top; width: 640px">Milk Somatic Cell ||
||<rowstyle="mso-yfti-irow:15"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">76 ||Genetic merit (national proof) definition^7^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">character 2 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">B+/ B-/T+/ T- ||
||<rowstyle="mso-yfti-irow:16"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">78 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Official publication of proof^ 9^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 1 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">Y/P/N ||
||<rowstyle="mso-yfti-irow:17"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">79 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Number of daughters ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 6 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:18"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">85 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Number of herds ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 5 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:19"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">90 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Effective Daughter Contribution^13^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 6 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:20"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">96 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Repeatability/Reliability (%) ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 2 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:21"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">98 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">National proof^11^ (x1000) ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 6 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||||||||<rowstyle="mso-yfti-irow:22; page-break-inside:avoid"style="padding:0pt 5.4pt 0pt 5.4pt; text-align:center; vertical-align:top; width: 640px">Clinical Mastitis ||
||<rowstyle="mso-yfti-irow:23"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">104 ||Genetic merit (national proof) definition^7^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">character 2 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px"> ||
||<rowstyle="mso-yfti-irow:24"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">106 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Official publication of proof^ 9^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 1 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px">Y/N ||
||<rowstyle="mso-yfti-irow:25"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">107 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Number of daughters ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 6 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:26"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">113 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Number of herds ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 5 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:27"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">118 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Effective Daughter Contribution^13^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 6 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:28"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">124 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Repeatability/Reliability (%) ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 2 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:29"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">126 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">National proof^11^ (x1000) ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">integer 6 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 113px"> ||
||<rowstyle="mso-yfti-irow:30; mso-yfti-lastrow:yes"style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 102px">132 ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 331px">Country sending this information^4^ ||<style="padding:0pt 5.4pt 0pt 5.4pt; vertical-align:top; width: 95px">character 3 ||
 1. 010=Bull National Production Proof File; 015=Bull National Conformation Proof File; 115=Bull National Brown Swiss Conformation Proof File; ''' '''016=Bull National Milk Somatic Cell and Clinical Mastitis Proof File;017=Bull National Direct Longevity and Combined Longevity Proof File; 018=Bull National Calving Ease and Stillbirth Proof File; 019=Bull National Female Fertility Proof File;'''020= Bull National Workability Proof File;''' 040=File for Genetic Trend Validation (production); 045=File for Genetic Trend Validation (conformation); 046=File for Genetic Trend Validation (milk somatic cell and clinical mastitis); 047=File for Genetic Trend Validation (direct longevity and combined longevity); 048=File for Genetic Trend Validation (calving ease and stillbirth). 049=File for Genetic Trend Validation (female fertility). 050= File for Genetic Trend Validation (Workability).
Line 37: Line 42:
 1. HOL=Holstein-Friesian (Black-and-White) type; BSW=Brown Swiss type; GUE=Guernsey type; JER=Jersey type; SIM=Simmental type; MSH=Milking Shorthorn type; PIN=Pinzgauer type; AYS=Ayrshire type; RED=Non-Ayrshire Red and Red-and-White types.
  . For additional breed codes please refer to the list available in the Interbull website
Line 38: Line 45:
 1. Identification in the country of first registration, as known in the country sending this information.
Line 39: Line 47:
 1. Country codes; Interbull codes in English: ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; CAN=Canada; HRV=Croatia; CZE=Czech Republic; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; GBR=United Kingdom; 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=New Zealand; NOR=Norway; POL=Poland; PRT=Portugal; ROU=Romania; SVK=Slovak Republic; SVN=Slovenia; KOR=South Korea; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; TUN=Tunisia; USA=United States of America; ZWE=Zimbabwe
  . For additional country codes please use the ISO 3166 standard.
Line 40: Line 50:
 1. All ID numbers: Registration numbers, right justified, leading blanks as zeros.
Line 41: Line 52:
 1. Name: Left justified, blanks not as zeros.
Line 42: Line 54:
 1. High breeding value (B+) / transmitting ability (T+, half BV), means high values are desirable (i.e. fewer somatic cells reps. better resistance to mastitis); low breeding value (B-) / transmitting ability (T-, half BV), means low values are desirable.
Line 43: Line 56:
 1. Type of proof: '''00''' unknown; '''11''' based on first crop sampling daughters; '''12''' based on first and second crop daughters; '''21''' based on imported semen of proven bull (second crop daughters only).
Line 44: Line 58:
 1. Y if bull proof meets national standards for official publication in the country sending this information; P if bull is part of a simultaneous progeny-testing programme, but the proof does not yet meet national standards for official publication; N otherwise.
Line 45: Line 60:
 1. Status of bull: '''00''' unknown; '''10''' bull randomly sampled through an official AI scheme; '''20''' other bull. Records with "20" in this field will be excluded from the international evaluation, unless type of proof is "21".
Line 46: Line 62:
 1. National proof expressed in their official (publishable) form; multiplied by 1000 to include 3 decimal points; for missing national proof fill in 9s (eg. 999999).
Line 47: Line 64:
 1. Breed of evaluation will determine the international evaluation of the breed that will include this record; usually it is the same as the breed of bull.
Line 48: Line 66:
 1. Effective daughters should for linear models be calculated using the same formula as for production traits.''' '''
Line 49: Line 68:
General:

All numeric fields should be right justified

All alpha fields should be in upper case.

If numbers of daughters, herds, and effective daughters and repeatability/reliability are the same for protein as for milk/fat, information must be repeated (do not leave it blank).

Describe public/file018 here.

FILE FORMAT FOR DATA DELIVERY TO THE INTERBULL CENTRE FOR THE INTERNATIONAL EVALUATION

NATIONAL WORKABILITY PROOF FILE

File format (record length=136)

Starting Position

Field Description

Format

Example

1

Record type1

character 3

016

4

Breed2 of evaluation12

character 3

Bull international identification3

7

Breed2 of bull

character 3

10

Country of first registration of bull 4

character 3

13

Sex

character 1

M

14

ID number of bull 5

character 12

000000A12345

26

Name of bull 6

character 30

56

Birth date of bull (YYYYMMDD)

integer 8

19850117

National evaluation information

64

Date of national evaluation (YYYYMMDD)

integer 8

19960415

72

Status of bull10

integer 2

Trait1=Milkability

74

Genetic merit (national proof) definition7

character 2

B+/ B-/T+/ T-

76

Type of proof 8

integer 2

78

Official publication of proof 9

character 1

Y/P/N

79

Number of daughters

integer 6

85

Number of herds

integer 5

90

Effective Daughter Contribution13

integer 6

96

Repeatability/Reliability (%)

integer 2

98

National proof11 (x1000)

integer 6

trait2= Temperament

104

Genetic merit (national proof) definition7

character 2

106

Type of proof 8

integer 2

108

Official publication of proof 9

character 1

Y/N

109

Number of daughters

integer 6

115

Number of herds

integer 5

120

Effective Daughter Contribution13

integer 6

126

Repeatability/Reliability (%)

integer 2

128

National proof11 (x1000)

integer 6

134

Country sending this information4

character 3

  1. 010=Bull National Production Proof File; 015=Bull National Conformation Proof File; 115=Bull National Brown Swiss Conformation Proof File; 016=Bull National Milk Somatic Cell and Clinical Mastitis Proof File;017=Bull National Direct Longevity and Combined Longevity Proof File; 018=Bull National Calving Ease and Stillbirth Proof File; 019=Bull National Female Fertility Proof File;020= Bull National Workability Proof File; 040=File for Genetic Trend Validation (production); 045=File for Genetic Trend Validation (conformation); 046=File for Genetic Trend Validation (milk somatic cell and clinical mastitis); 047=File for Genetic Trend Validation (direct longevity and combined longevity); 048=File for Genetic Trend Validation (calving ease and stillbirth). 049=File for Genetic Trend Validation (female fertility). 050= File for Genetic Trend Validation (Workability).

  2. HOL=Holstein-Friesian (Black-and-White) type; BSW=Brown Swiss type; GUE=Guernsey type; JER=Jersey type; SIM=Simmental type; MSH=Milking Shorthorn type; PIN=Pinzgauer type; AYS=Ayrshire type; RED=Non-Ayrshire Red and Red-and-White types.
    • For additional breed codes please refer to the list available in the Interbull website
  3. Identification in the country of first registration, as known in the country sending this information.
  4. Country codes; Interbull codes in English: ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; CAN=Canada; HRV=Croatia; CZE=Czech Republic; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; GBR=United Kingdom; 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=New Zealand; NOR=Norway; POL=Poland; PRT=Portugal; ROU=Romania; SVK=Slovak Republic; SVN=Slovenia; KOR=South Korea; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; TUN=Tunisia; USA=United States of America; ZWE=Zimbabwe
    • For additional country codes please use the ISO 3166 standard.
  5. All ID numbers: Registration numbers, right justified, leading blanks as zeros.
  6. Name: Left justified, blanks not as zeros.
  7. High breeding value (B+) / transmitting ability (T+, half BV), means high values are desirable (i.e. fewer somatic cells reps. better resistance to mastitis); low breeding value (B-) / transmitting ability (T-, half BV), means low values are desirable.
  8. Type of proof: 00 unknown; 11 based on first crop sampling daughters; 12 based on first and second crop daughters; 21 based on imported semen of proven bull (second crop daughters only).

  9. Y if bull proof meets national standards for official publication in the country sending this information; P if bull is part of a simultaneous progeny-testing programme, but the proof does not yet meet national standards for official publication; N otherwise.
  10. Status of bull: 00 unknown; 10 bull randomly sampled through an official AI scheme; 20 other bull. Records with "20" in this field will be excluded from the international evaluation, unless type of proof is "21".

  11. National proof expressed in their official (publishable) form; multiplied by 1000 to include 3 decimal points; for missing national proof fill in 9s (eg. 999999).
  12. Breed of evaluation will determine the international evaluation of the breed that will include this record; usually it is the same as the breed of bull.
  13. Effective daughters should for linear models be calculated using the same formula as for production traits.

General:

All numeric fields should be right justified

All alpha fields should be in upper case.

If numbers of daughters, herds, and effective daughters and repeatability/reliability are the same for protein as for milk/fat, information must be repeated (do not leave it blank).

Describe public/file018 here.

Describe public/file020 here.

public/file020 (last edited 2012-03-05 14:35:32 by Valentina)