Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2015-03-06 12:25:28 →
Size: 7516
Editor: Valentina
Comment:
← Revision 2 as of 2015-03-06 12:36:15 → ⇥
Size: 7514
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^1^ ||<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 ^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">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^4^ ||<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^3^ ||<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^4^ ||<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 ^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">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^4^ ||<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^5^ ||<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^6^ ||<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^2^ ||<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^4^ ||<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 ||

File Format 200 for Dairy Pedigree

Starting position

Field

Format

Example

1

Record type1

Character 3

200

International ID of ANIMAL

5

Breed of animal 2

character 3

HOL

8

Country of first registration of animal3

character 3

CAN

11

Sex

character 1

M

12

ID number of animal4

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 animal3

character 3

CAN

31

Sex

character 1

M

32

ID number of sire of animal4

character 12

556912367589

International ID of Dam of ANIMAL

45

Breed of dam of animal 2

character 3

HOL

48

Country of first registration of dam of animal3

character 3

CAN

51

Sex

character 1

F

52

ID number of dam of animal4

character 12

123569874521

65

Birth date of animal (YYYYMMDD)

integer 8

19870215

74

Status of animal5

Integer 2

10

77

Birth date of first AI daughters (YYYYMMDD)

Integer 8

19890314

86

Name of animal6

character 30

Cantarello

National ID of ANIMAL

117

Breed of animal2

character 3

HOL

120

Country

character 3

CAN

123

Sex

character 1

M

124

ID number of animal4

character 12

000000A12345

137

Country sending information

character 3

CAN

Character encoding: UTF-8

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