Diff for "public/Format601" - Interbull Centre Wiki

Differences between revisions 4 and 6 (spanning 2 versions)

Table 1: 601 file format (total length = 107)

Field description	Label	Format	Start		Length		Status^a	Note	Example
Record type	RTYPE	Char		1		3	M		601
International ID of ANIMAL
Breed of the animal	ABREED	Char		5		3	M	I	LIM
Country of birth	AIDC	Char		8		3	M	II	FRA
Sex	ASEX	Char	11			1	M	III	F
ID code of the animal	AID	Char	12		12		M	IV	008795005065
International ID of Animal’s SIRE
Breed of the sire	SBREED	Char	25			3	O	I	LIM
Country of birth	SIIDC	Char	28			3	O	II	FRA
Sex	SSEX	Char	31			1	O	III	M
ID code of the sire	SIID	Char	32		12		O	IV	000095015085
International ID of Animal’s DAM
Breed of the dam	DBREED	Char	45			3	O	I	LIM
Country of birth	DIIDC	Char	48			3	O	II	FRA
Sex	DSEX	Char	51			1	O	III	F
ID code of the dam	DIID	Char	52		12		O	IV	001111001111
Additional information
Date of birth of animal	BDATE	Int	65			8	O	V		20010130
Name of animal	NAME	Char	74		30		O		Faust
Country sending information	RCOU	Char	105			3	M	II	FRA

^aStatus: M = Mandatory, O = Optional

Note
I	See Reference section for Breed codes
II	See Reference Section for Country codes – ISO 3166 Alpha-3
III	Sex : M for Male, F for Female only
IV	Identification Number in Interbull Format : Right justified, Leading blanks filled with Zero (“0”)
V	YYYYMMDD format

-  ⇤ ← Revision 4 as of 2012-10-15 14:52:17 → 
  Size: 52539
  Editor: Valentina
  Comment:
+   ← Revision 6 as of 2013-12-12 15:39:17 → ⇥
  Size: 52505
  Editor: Valentina
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 9:
-||<rowstyle="mso-yfti-irow:6"width="198px" height="14.4pt" style="border:solid black 1.0pt;border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">ID code of the animal ||<width="65px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">AID ||<width="59px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">Char ||||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||||<width="56px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||<width="57px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">M ||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">IV ||||<width="94px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">''8795005065'' ||
+||<rowstyle="mso-yfti-irow:6"width="198px" height="14.4pt" style="border:solid black 1.0pt;border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">ID code of the animal ||<width="65px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">AID ||<width="59px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">Char ||||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||||<width="56px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||<width="57px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">M ||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">IV ||||<width="94px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">''008795005065'' ||
 Line 14:
-||<rowstyle="mso-yfti-irow:11"width="198px" height="14.4pt" style="border:solid black 1.0pt;border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">ID code of the sire ||<width="65px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">SIID ||<width="59px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">Char ||||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">32 ||||<width="56px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||<width="57px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">O ||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">IV ||||<width="94px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">''95015085'' ||
+||<rowstyle="mso-yfti-irow:11"width="198px" height="14.4pt" style="border:solid black 1.0pt;border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">ID code of the sire ||<width="65px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">SIID ||<width="59px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">Char ||||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">32 ||||<width="56px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||<width="57px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">O ||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">IV ||||<width="94px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">''000095015085'' ||
 Line 19:
-||<rowstyle="mso-yfti-irow:16"width="198px" height="14.4pt" style="border:solid black 1.0pt;border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">ID code of the dam ||<width="65px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">DIID ||<width="59px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">Char ||||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">52 ||||<width="56px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||<width="57px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">O ||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">IV ||||<width="94px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">''1111001111'' ||
+||<rowstyle="mso-yfti-irow:16"width="198px" height="14.4pt" style="border:solid black 1.0pt;border-top:none;mso-border-top-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">ID code of the dam ||<width="65px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">DIID ||<width="59px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">Char ||||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">52 ||||<width="56px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">12 ||<width="57px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">O ||<width="43px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;vertical-align:top">IV ||||<width="94px" height="14.4pt" style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-top-alt:solid black .5pt;mso-border-left-alt:solid black .5pt;mso-border-alt:solid black .5pt;padding:0cm 0cm 0cm 0cm;text-align:center;vertical-align:top">''001111001111'' ||
 Line 26:
+^a^'''Status:''' M = Mandatory, O = Optional
||<tablewidth="585px" tableheight="96px" tablestyle="border-collapse:collapse; " tableclass="MsoNormalTable"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-height-rule:exactly"7%  height="11.55pt" style="border:none;border-bottom:solid black 1.5pt;padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">'''Note''' ||<92%  height="11.55pt" style="border:none;border-bottom:solid black 1.5pt;padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">''' ''' ||
||<rowstyle="mso-yfti-irow:1;mso-height-rule:exactly"7%  height="13.3pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">'''I''' ||<92%  height="13.3pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">See Reference section for Breed codes ||
||<rowstyle="mso-yfti-irow:2;mso-height-rule:exactly"7%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">'''II''' ||<92%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">See Reference   Section for Country codes –   ISO 3166 Alpha-3 ||
||<rowstyle="mso-yfti-irow:3;mso-height-rule:exactly"7%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">'''III''' ||<92%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">Sex : M for Male, F for Female only ||
||<rowstyle="mso-yfti-irow:4;mso-height-rule:exactly"7%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">'''IV''' ||<92%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">Identification Number in Interbull   Format : Right justified, Leading blanks filled with Zero (“0”) ||
||<rowstyle="mso-yfti-irow:5;mso-yfti-lastrow:yes;mso-height-rule:exactly"7%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">'''V''' ||<92%  height="11.55pt" style="padding:0cm 5.4pt 0cm 5.4pt;mso-height-rule:exactly;vertical-align:top">YYYYMMDD format ||
-Line 27:
+Line 34:
-^a^'''Status:''' M = Mandatory, O = Optional
-Line 29:
+Line 35:
-||<tablewidth="585px" tableheight="96px" tablestyle="border-collapse: collapse;" tableclass="MsoNormalTable"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:11.55pt;mso-height-rule:   exactly"^7%  style="width:7.84%;border:none;border-bottom:solid black 1.5pt;   padding:0cm 5.4pt 0cm 5.4pt;height:11.55pt;mso-height-rule:exactly">'''Note''' ||<^92%  style="width:92.16%;border:none;border-bottom:   solid black 1.5pt;padding:0cm 5.4pt 0cm 5.4pt;height:11.55pt;mso-height-rule:   exactly">''' ''' ||
||<rowstyle="mso-yfti-irow:1;height:13.3pt;mso-height-rule:exactly"^7%  style="width:7.84%;padding:0cm 5.4pt 0cm 5.4pt;   height:13.3pt;mso-height-rule:exactly">'''I''' ||<^92%  style="width:92.16%;padding:0cm 5.4pt 0cm 5.4pt;   height:13.3pt;mso-height-rule:exactly">See Reference section for Breed codes ||
||<rowstyle="mso-yfti-irow:2;height:11.55pt;mso-height-rule:exactly"^7%  style="width:7.84%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">'''II''' ||<^92%  style="width:92.16%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">See Reference   Section for Country codes –   ISO 3166 Alpha-3 ||
||<rowstyle="mso-yfti-irow:3;height:11.55pt;mso-height-rule:exactly"^7%  style="width:7.84%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">'''III''' ||<^92%  style="width:92.16%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">Sex : M ó Male, F ó Female only ||
||<rowstyle="mso-yfti-irow:4;height:11.55pt;mso-height-rule:exactly"^7%  style="width:7.84%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">'''IV''' ||<^92%  style="width:92.16%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">Identification Number in Interbull   Format : Right justified, Leading blanks filled with Zero (“0”) ||
||<rowstyle="mso-yfti-irow:5;mso-yfti-lastrow:yes;height:11.55pt;mso-height-rule:   exactly"^7%  style="width:7.84%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">'''V''' ||<^92%  style="width:92.16%;padding:0cm 5.4pt 0cm 5.4pt;   height:11.55pt;mso-height-rule:exactly">YYYYMMDD format ||