Diff for "public/File200" - Interbull Centre Wiki

Differences between revisions 3 and 5 (spanning 2 versions)

File Format 200 for Dairy Pedigree


Starting position	Field	Format	Example
1	Record type	Character 3	200
	International ID of ANIMAL
5	Breed of animal	character 3	HOL
8	Country of first registration of animal¹	character 3	CAN
11	Sex	character 1	M
12	ID number of animal²	character 12	000000A12345

	International ID of Sire of ANIMAL
25	Breed of sire of animal	character 3	HOL
28	Country of first registration of sire of animal¹	character 3	CAN
31	Sex	character 1	M
32	ID number of sire of animal²	character 12	556912367589

	International ID of Dam of ANIMAL
45	Breed of dam of animal	character 3	HOL
48	Country of first registration of dam of animal¹	character 3	CAN
51	Sex	character 1	F
52	ID number of dam of animal²	character 12	123569874521

65	Birth date of animal⁴ (YYYYMMDD)	integer 8	19870215
74	Status of animal³	Integer 2	10
77	Birth date of first AI daughters (YYYYMMDD)	Integer 8	19890314
86	Name of animal	character 30	Cantarello

	National ID of ANIMAL
117	Breed of animal	character 3	HOL
120	Country	character 3	CAN
123	Sex	character 1	M
124	ID number of animal²	character 12	000000A12345

137	Country sending information	character 3	CAN
Character encoding: UTF-8

1. Identification in the country of first registration, as known in the country sending this information.

2. All ID numbers: Registration numbers, right justified, leading blanks as zeros.

3. 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".

4. Check the animal's birth date

Has to be reported in the format YYYYMMDD
If you know only the year of birth then enter it as YYYY0000
If you know year and month of birth then enter them as YYYYMM00
Missing birth dates are coded as 00000000 (or blanks or a single 0)

-  ⇤ ← Revision 3 as of 2015-03-06 12:36:59 → 
  Size: 7526
  Editor: Valentina
  Comment:
+   ← Revision 5 as of 2018-03-27 08:53:00 → ⇥
  Size: 8267
  Editor: Hjerpe
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 4:
-||<width="96px" style="vertical-align:top">1 ||<width="277px" style="vertical-align:top">Record type^1^ ||<width="115px" style="vertical-align:top">Character 3 ||<width="127px" style="vertical-align:top">200 ||
+||<width="96px" style="vertical-align:top">1 ||<width="277px" style="vertical-align:top">Record type ||<width="115px" style="vertical-align:top">Character 3 ||<width="127px" style="vertical-align:top">200 ||
 Line 6:
-||<width="96px" style="vertical-align:top">5 ||<width="277px" style="vertical-align:top">Breed of animal ^2^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
||<width="96px" style="vertical-align:top">8 ||<width="277px" style="vertical-align:top">Country of first registration of animal^3^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
+||<width="96px" style="vertical-align:top">5 ||<width="277px" style="vertical-align:top">Breed of animal ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
||<width="96px" style="vertical-align:top">8 ||<width="277px" style="vertical-align:top">Country of first registration of animal^1^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
 Line 9:
-||<width="96px" style="vertical-align:top">12 ||<width="277px" style="vertical-align:top">ID number of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">000000A12345 ||
+||<width="96px" style="vertical-align:top">12 ||<width="277px" style="vertical-align:top">ID number of animal^2^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">000000A12345 ||
 Line 13:
-||<width="96px" style="vertical-align:top">28 ||<width="277px" style="vertical-align:top">Country of first registration of sire of animal^3^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
+||<width="96px" style="vertical-align:top">28 ||<width="277px" style="vertical-align:top">Country of first registration of sire of animal^1^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
 Line 15:
-||<width="96px" style="vertical-align:top">32 ||<width="277px" style="vertical-align:top">ID number of sire of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">556912367589 ||
+||<width="96px" style="vertical-align:top">32 ||<width="277px" style="vertical-align:top">ID number of sire of animal^2^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">556912367589 ||
 Line 18:
-||<width="96px" style="vertical-align:top">45 ||<width="277px" style="vertical-align:top">Breed of dam of animal ^2^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
||<width="96px" style="vertical-align:top">48 ||<width="277px" style="vertical-align:top">Country of first registration of dam of animal^3^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
+||<width="96px" style="vertical-align:top">45 ||<width="277px" style="vertical-align:top">Breed of dam of animal ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
||<width="96px" style="vertical-align:top">48 ||<width="277px" style="vertical-align:top">Country of first registration of dam of animal^1^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
 Line 21:
-||<width="96px" style="vertical-align:top">52 ||<width="277px" style="vertical-align:top">ID number of dam of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">123569874521 ||
+||<width="96px" style="vertical-align:top">52 ||<width="277px" style="vertical-align:top">ID number of dam of animal^2^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">123569874521 ||
 Line 23:
-||<width="96px" style="vertical-align:top">65 ||<width="277px" style="vertical-align:top">Birth date of animal (YYYYMMDD) ||<width="115px" style="vertical-align:top">integer 8 ||<width="127px" style="vertical-align:top">19870215 ||
||<width="96px" style="vertical-align:top">74 ||<width="277px" style="vertical-align:top">Status of animal^5^ ||<width="115px" style="vertical-align:top">Integer 2 ||<width="127px" style="vertical-align:top">10 ||
+||<width="96px" style="vertical-align:top">65 ||<width="277px" style="vertical-align:top">Birth date of animal^4^  (YYYYMMDD) ||<width="115px" style="vertical-align:top">integer 8 ||<width="127px" style="vertical-align:top">19870215 ||
||<width="96px" style="vertical-align:top">74 ||<width="277px" style="vertical-align:top">Status of animal^3^ ||<width="115px" style="vertical-align:top">Integer 2 ||<width="127px" style="vertical-align:top">10 ||
 Line 26:
-||<width="96px" style="vertical-align:top">86 ||<width="277px" style="vertical-align:top">Name of animal^6^ ||<width="115px" style="vertical-align:top">character 30 ||<width="127px" style="vertical-align:top">Cantarello ||
+||<width="96px" style="vertical-align:top">86 ||<width="277px" style="vertical-align:top">Name of animal ||<width="115px" style="vertical-align:top">character 30 ||<width="127px" style="vertical-align:top">Cantarello ||
 Line 29:
-||<width="96px" style="vertical-align:top">117 ||<width="277px" style="vertical-align:top">Breed of animal^2^ ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
+||<width="96px" style="vertical-align:top">117 ||<width="277px" style="vertical-align:top">Breed of animal ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
 Line 32:
-||<width="96px" style="vertical-align:top">124 ||<width="277px" style="vertical-align:top">ID number of animal^4^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">000000A12345 ||
+||<width="96px" style="vertical-align:top">124 ||<width="277px" style="vertical-align:top">ID number of animal^2^ ||<width="115px" style="vertical-align:top">character 12 ||<width="127px" style="vertical-align:top">000000A12345 ||
 Line 34:
-||<width="96px" style="vertical-align:top;                                                                                ">137 ||<width="277px" style="vertical-align:top;                                                                                ">Country sending information ||<width="115px" style="vertical-align:top;                                                                                ">character 3 ||<width="127px" style="vertical-align:top;                                                                                ">CAN ||
+||<width="96px" style="vertical-align:top;                                                                                    ">137 ||<width="277px" style="vertical-align:top;                                                                                    ">Country sending information ||<width="115px" style="vertical-align:top;                                                                                    ">character 3 ||<width="127px" style="vertical-align:top;                                                                                    ">CAN ||
 Line 38:
+. Identification in the country of first registration, as known in the country sending this information.

2. All ID numbers: Registration numbers, right justified, leading blanks as zeros.

3. 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".

4. Check the animal's birth date
 * Has to be reported in the format YYYYMMDD
 * If you know only the year of birth then enter it as YYYY0000
 * If you know year and month of birth then enter them as YYYYMM00
 * Missing birth dates are coded as 00000000 (or blanks or a single 0)