Diff for "public/file015" - Interbull Centre Wiki

Differences between revisions 8 and 9

FILE FORMAT FOR DATA DELIVERY TO THE INTERBULL CENTRE FOR THE INTERNATIONAL EVALUATION DAIRY- CONFORMATION PROOF FILE

File 015 (record length=585)

Starting Byte		Field Description	Format	Example
1		Record type¹	character 3	015
4		Breed² of evaluation¹²	character 3	HOL
	Bull international identification³
7		Breed² of bull	character 3
10		Country of first registration of bull⁴	character 3
13		Sex	character 1	M
14		ID number of bull ⁵	character 12	000000A12345
26		Name of bull ⁶	character 30
56		Birth date of bull (YYYYMMDD)	integer 8	19850101
	National evaluation information
64		Date of national evaluation (YYYYMMDD)	integer 8	19960415
72		Genetic merit (national proof) definition⁷	character 2	BV/TA
74		Type of proof⁸	integer 2
76		Official publication of proof⁹	character 1	Y/P/N
77		Status of bull¹⁰	integer 2
	Stature¹³
79		Number of daughters	integer 6
85		Number of herds	integer 5
90		Effective Daughter Contribution¹⁴	integer 6
96		Repeatability/Reliability (%)	integer 2
98		National proof¹¹ (x100)	integer 5
	Chest width¹³
103		Number of daughters	integer 6
109		Number of herds	integer 5
114		Effective Daughter Contribution¹⁴	integer 6
120		Repeatability/Reliability (%)	integer 2
122		National proof¹¹ (x100)	integer 5
	Body depth¹³
127		Number of daughters	integer 6
133		Number of herds	integer 5
138		Effective Daughter Contribution¹⁴	integer 6
144		Repeatability/Reliability (%)	integer 2
146		National proof¹¹ (x100)	integer 5
	Angularity¹³
151		Number of daughters	integer 6
157		Number of herds	integer 5
162		Effective Daughter Contribution¹⁴	integer 6
168		Repeatability/Reliability (%)	integer 2
170		National proof¹¹ (x100)	integer 5

	Rump angle¹³
175		Number of daughters	integer 6
181		Number of herds	integer 5
186		Effective Daughter Contribution¹⁴	integer 6
192		Repeatability/Reliability (%)	integer 2
194		National proof¹¹ (x100)	integer 5
	Rump width¹³
199		Number of daughters	integer 6
205		Number of herds	integer 5
210		Effective Daughter Contribution¹⁴	integer 6
216		Repeatability/Reliability (%)	integer 2
218		National proof¹¹ (x100)	integer 5
	Rear leg set¹³
223		Number of daughters	integer 6
229		Number of herds	integer 5
234		Effective Daughter Contribution¹⁴	integer 6
240		Repeatability/Reliability (%)	integer 2
242		National proof¹¹ (x100)	integer 5
	Rear leg rear view¹³
247		Number of daughters	integer 6
253		Number of herds	integer 5
258		Effective Daughter Contribution¹⁴	integer 6
264		Repeatability/Reliability (%)	integer 2
266		National proof¹¹ (x100)	integer 5
	Foot angle¹³
271		Number of daughters	integer 6
277		Number of herds	integer 5
282		Effective Daughter Contribution¹⁴	integer 6
288		Repeatability/Reliability (%)	integer 2
290		National proof¹¹ (x100)	integer 5
	Fore udder¹³
295		Number of daughters	integer 6
301		Number of herds	integer 5
306		Effective Daughter Contribution¹⁴	integer 6
312		Repeatability/Reliability (%)	integer 2
314		National proof¹¹ (x100)	integer 5
	Rear udder height¹³
319		Number of daughters	integer 6
325		Number of herds	integer 5
330		Effective Daughter Contribution¹⁴	integer 6
336		Repeatability/Reliability (%)	integer 2
338		National proof¹¹ (x100)	integer 5

	Udder support¹³
343		Number of daughters	integer 6
349		Number of herds	integer 5
354		Effective Daughter Contribution¹⁴	integer 6
360		Repeatability/Reliability (%)	integer 2
362		National proof¹¹ (x100)	integer 5
	Udder depth¹³
367		Number of daughters	integer 6
373		Number of herds	integer 5
378		Effective Daughter Contribution¹⁴	integer 6
384		Repeatability/Reliability (%)	integer 2
386		National proof¹¹ (x100)	integer 5
	Front teat placement¹³
391		Number of daughters	integer 6
397		Number of herds	integer 5
402		Effective Daughter Contribution¹⁴	integer 6
408		Repeatability/Reliability (%)	integer 2
410		National proof¹¹ (x100)	integer 5
	Teat length¹³
415		Number of daughters	integer 6
421		Number of herds	integer 5
426		Effective Daughter Contribution¹⁴	integer 6
432		Repeatability/Reliability (%)	integer 2
434		National proof¹¹ (x100)	integer 5
	Rear teat placement¹³
439		Number of daughters	integer 6
445		Number of herds	integer 5
450		Effective Daughter Contribution¹⁴	integer 6
456		Repeatability/Reliability (%)	integer 2
458		National proof¹¹ (x100)	integer 5
	Overall conformation score¹³
463		Number of daughters	integer 6
469		Number of herds	integer 5
474		Effective Daughter Contribution¹⁴	integer 6
480		Repeatability/Reliability (%)	integer 2
482		National proof¹¹ (x100)	integer 5
	Overall udder score¹³
487		Number of daughters	integer 6
493		Number of herds	integer 5
498		Effective Daughter Contribution¹⁴	integer 6
504		Repeatability/Reliability (%)	integer 2
506		National proof¹¹ (x100)	integer 5
	Overall feet & leg score¹³
511		Number of daughters	integer 6
517		Number of herds	integer 5
522		Effective Daughter Contribution¹⁴	integer 6
528		Repeatability/Reliability (%)	integer 2
530		National proof¹¹ (x100)	integer 5

	Locomotion
535		Number of daughters	integer 6
541		Number of herds	integer 5
546		Effective Daughter Contribution¹⁴	integer 6
552		Repeatability/Reliability (%)	integer 2
554		National proof¹¹ (x100)	integer 5
	Body condition score
559		Number of daughters	integer 6
565		Number of herds	integer 5
570		Effective Daughter Contribution¹⁴	integer 6
576		Repeatability/Reliability (%)	integer 2
578		National proof¹¹ (x100)	integer 5
583	Country sending this information⁴		character 3

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).
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
Identification in the country of first registration, as known in the country sending this information.
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.
All ID numbers: Registration numbers, right justified, leading blanks as zeros.
Name: Left justified, blanks not as zeros.
High breeding value (B+) / transmitting ability (T+, half BV), means high values are desirable; low breeding value (B-) / transmitting ability (T-, half BV), means low breeding values are desirable.
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 only);
22 based on mostly (more than 50%) imported daughters or daughters born from imported embryos.
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.
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".

National proof expressed in their official (publishable) form; multiplied by 100 to include 2 decimal points; for missing national proof fill in 9s (eg. 99999).
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.
Conformation trait definition: Conformation traits may be named differently in different countries and definitions may not be exactly the same. Recommended definitions are included in Table 1 in the document “Interbull evaluations for conformation traits for the Holstein breed”. Individual countries are encouraged to provide data on traits matching closest to these definitions.
Effective Daughter Contribution should be calculated using the same formulae as for production traits. Note: reliability due to own performance should be computed per trait and information from other traits in a multiple trait national genetic evaluation should be ignored.

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

-  ⇤ ← Revision 8 as of 2012-02-25 15:58:58 → 
  Size: 66038
  Editor: Valentina
  Comment:
+   ← Revision 9 as of 2012-02-25 16:00:19 → ⇥
  Size: 65881
  Editor: Valentina
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 157:
- '''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).
+ '''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).