Differences between revisions 1 and 4 (spanning 3 versions)
⇤ ← Revision 1 as of 2015-03-06 12:25:28 →
Size: 7516
Editor: Valentina
Comment:
← Revision 4 as of 2016-08-02 15:07:27 → ⇥
Size: 7972
Editor: Valentina
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 (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".

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 animal (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".

public/File200 (last edited 2018-03-27 08:53:00 by Hjerpe)