Differences between revisions 5 and 6
⇤ ← Revision 5 as of 2018-03-27 08:53:00 →
Size: 8267
Editor: Hjerpe
Comment:
← Revision 6 as of 2025-09-12 13:43:27 → ⇥
Size: 8305
Editor: Valentina
Comment: Mark footnotes numbering better within the format table
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
||<width="96px" style="vertical-align:top">Starting position''' ''' ||<width="277px" style="vertical-align:top">Field''' ''' ||<width="115px" style="vertical-align:top">Format''' ''' ||<width="127px" style="vertical-align:top">Example''' ''' || ||<width="96px" style="vertical-align:top">Starting position''' ''' ||<width="277px" style="vertical-align:top">Field (foot note) ||<width="115px" style="vertical-align:top">Format''' ''' ||<width="127px" style="vertical-align:top">Example''' ''' ||
Line 7: Line 7:
||<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 || ||<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: Line 9:
||<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 || ||<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: Line 13:
||<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 || ||<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: Line 15:
||<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 || ||<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 19: Line 19:
||<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 || ||<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: Line 21:
||<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 || ||<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: Line 23:
||<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 ||		 ||<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 32: Line 32:
||<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 || ||<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: 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 47: Line 47:

File Format 200 for Dairy Pedigree

Starting position

Field (foot note)

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 (1)

character 3

CAN

11

Sex

character 1

M

12

ID number of animal (2)

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 (1)

character 3

CAN

31

Sex

character 1

M

32

ID number of sire of animal (2)

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 (1)

character 3

CAN

51

Sex

character 1

F

52

ID number of dam of animal (2)

character 12

123569874521

65

Birth date of animal (4) (YYYYMMDD)

integer 8

19870215

74

Status of animal (3)

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 (2)

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)

public/File200 (last edited 2025-09-12 13:45:34 by Valentina)