Differences between revisions 1 and 5 (spanning 4 versions)
Revision 1 as of 2015-03-06 12:25:28
Size: 7516
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 1: Line 1:
== File Format 200 for Dairy Pedigree ==
||||||||<tablestyle="text-align:left"style="text-align:center; vertical-align:top; width: 616px"> ||
||<style="vertical-align:top; width: 96px">Starting position''' ''' ||<style="vertical-align:top; width: 277px">Field''' ''' ||<style="vertical-align:top; width: 115px">Format''' ''' ||<style="vertical-align:top; width: 127px">Example''' ''' ||
||<style="vertical-align:top; width: 96px">1 ||<style="vertical-align:top; width: 277px">Record type^1^ ||<style="vertical-align:top; width: 115px">Character 3 ||<style="vertical-align:top; width: 127px">200 ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px">International ID of ANIMAL''' ''' ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px">5 ||<style="vertical-align:top; width: 277px">Breed of animal ^2^ ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">HOL ||
||<style="vertical-align:top; width: 96px">8 ||<style="vertical-align:top; width: 277px">Country of first registration of animal^3^ ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">CAN ||
||<style="vertical-align:top; width: 96px">11 ||<style="vertical-align:top; width: 277px">Sex ||<style="vertical-align:top; width: 115px">character 1 ||<style="vertical-align:top; width: 127px">M ||
||<style="vertical-align:top; width: 96px">12 ||<style="vertical-align:top; width: 277px">ID number of animal^4^ ||<style="vertical-align:top; width: 115px">character 12 ||<style="vertical-align:top; width: 127px">000000A12345 ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px"> ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px">International ID of Sire of ANIMAL''' ''' ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px">25 ||<style="vertical-align:top; width: 277px">Breed of sire of animal ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">HOL ||
||<style="vertical-align:top; width: 96px">28 ||<style="vertical-align:top; width: 277px">Country of first registration of sire of animal^3^ ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">CAN ||
||<style="vertical-align:top; width: 96px">31 ||<style="vertical-align:top; width: 277px">Sex ||<style="vertical-align:top; width: 115px">character 1 ||<style="vertical-align:top; width: 127px">M ||
||<style="vertical-align:top; width: 96px">32 ||<style="vertical-align:top; width: 277px">ID number of sire of animal^4^ ||<style="vertical-align:top; width: 115px">character 12 ||<style="vertical-align:top; width: 127px">556912367589 ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px"> ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px">International ID of Dam of ANIMAL''' ''' ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px">45 ||<style="vertical-align:top; width: 277px">Breed of dam of animal ^2^ ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">HOL ||
||<style="vertical-align:top; width: 96px">48 ||<style="vertical-align:top; width: 277px">Country of first registration of dam of animal^3^ ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">CAN ||
||<style="vertical-align:top; width: 96px">51 ||<style="vertical-align:top; width: 277px">Sex ||<style="vertical-align:top; width: 115px">character 1 ||<style="vertical-align:top; width: 127px">F ||
||<style="vertical-align:top; width: 96px">52 ||<style="vertical-align:top; width: 277px">ID number of dam of animal^4^ ||<style="vertical-align:top; width: 115px">character 12 ||<style="vertical-align:top; width: 127px">123569874521 ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px"> ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px">65 ||<style="vertical-align:top; width: 277px">Birth date of animal (YYYYMMDD) ||<style="vertical-align:top; width: 115px">integer 8 ||<style="vertical-align:top; width: 127px">19870215 ||
||<style="vertical-align:top; width: 96px">74 ||<style="vertical-align:top; width: 277px">Status of animal^5^ ||<style="vertical-align:top; width: 115px">Integer 2 ||<style="vertical-align:top; width: 127px">10 ||
||<style="vertical-align:top; width: 96px">77 ||<style="vertical-align:top; width: 277px">Birth date of first AI daughters (YYYYMMDD) ||<style="vertical-align:top; width: 115px">Integer 8 ||<style="vertical-align:top; width: 127px">19890314 ||
||<style="vertical-align:top; width: 96px">86 ||<style="vertical-align:top; width: 277px">Name of animal^6^ ||<style="vertical-align:top; width: 115px">character 30 ||<style="vertical-align:top; width: 127px">Cantarello ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px"> ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px">National ID of ANIMAL''' ''' ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; width: 96px">117 ||<style="vertical-align:top; width: 277px">Breed of animal^2^ ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">HOL ||
||<style="vertical-align:top; width: 96px">120 ||<style="vertical-align:top; width: 277px">Country ||<style="vertical-align:top; width: 115px">character 3 ||<style="vertical-align:top; width: 127px">CAN ||
||<style="vertical-align:top; width: 96px">123 ||<style="vertical-align:top; width: 277px">Sex ||<style="vertical-align:top; width: 115px">character 1 ||<style="vertical-align:top; width: 127px">M ||
||<style="vertical-align:top; width: 96px">124 ||<style="vertical-align:top; width: 277px">ID number of animal^4^ ||<style="vertical-align:top; width: 115px">character 12 ||<style="vertical-align:top; width: 127px">000000A12345 ||
||<style="vertical-align:top; width: 96px"> ||<style="vertical-align:top; width: 277px"> ||<style="vertical-align:top; width: 115px"> ||<style="vertical-align:top; width: 127px"> ||
||<style="vertical-align:top; ; width: 96px">137 ||<style="vertical-align:top; ; width: 277px">Country sending information ||<style="vertical-align:top; ; width: 115px">character 3 ||<style="vertical-align:top; ; width: 127px">CAN ||
||||||||<style="vertical-align:top; text-align:center; width: 96px">Character encoding: UTF-8 ||
'''File Format 200 for Dairy Pedigree'''
||||||||<tablestyle="text-align:left"width="616px" style="text-align:center;vertical-align:top"> ||
||<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">1 ||<width="277px" style="vertical-align:top">Record type ||<width="115px" style="vertical-align:top">Character 3 ||<width="127px" style="vertical-align:top">200 ||
||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">International ID of ANIMAL''' ''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<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 ||
||<width="96px" style="vertical-align:top">11 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top">M ||
||<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"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">International ID of Sire of ANIMAL''' ''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<width="96px" style="vertical-align:top">25 ||<width="277px" style="vertical-align:top">Breed of sire of animal ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">HOL ||
||<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">31 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top">M ||
||<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"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">International ID of Dam of ANIMAL''' ''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<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 ||
||<width="96px" style="vertical-align:top">51 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top">F ||
||<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"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<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">77 ||<width="277px" style="vertical-align:top">Birth date of first AI daughters (YYYYMMDD) ||<width="115px" style="vertical-align:top">Integer 8 ||<width="127px" style="vertical-align:top">19890314 ||
||<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 ||
||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<width="96px" style="vertical-align:top"> ||<width="277px" style="vertical-align:top">National ID of ANIMAL''' ''' ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<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 ||
||<width="96px" style="vertical-align:top">120 ||<width="277px" style="vertical-align:top">Country ||<width="115px" style="vertical-align:top">character 3 ||<width="127px" style="vertical-align:top">CAN ||
||<width="96px" style="vertical-align:top">123 ||<width="277px" style="vertical-align:top">Sex ||<width="115px" style="vertical-align:top">character 1 ||<width="127px" style="vertical-align:top">M ||
||<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"> ||<width="277px" style="vertical-align:top"> ||<width="115px" style="vertical-align:top"> ||<width="127px" style="vertical-align:top"> ||
||<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;text-align:center">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)

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 animal1

character 3

CAN

11

Sex

character 1

M

12

ID number of animal2

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 animal1

character 3

CAN

31

Sex

character 1

M

32

ID number of sire of animal2

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 animal1

character 3

CAN

51

Sex

character 1

F

52

ID number of dam of animal2

character 12

123569874521

65

Birth date of animal4 (YYYYMMDD)

integer 8

19870215

74

Status of animal3

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 animal2

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 2018-03-27 08:53:00 by Hjerpe)