Format 7 - PUBLIC¶
- Table of contents
- Format 7 - PUBLIC
Category¶
Miscellaneous - Formats used to exchange data between CDCB and partners
Meaning¶
Format 7's include type trait appraisal records.
Exchange protocol¶
CDCB receives Format7 records from breeder associations (except HAUSA) on a tri-annual basis.
Old (outdated) format¶
Typerr file¶
At each submission, breed associations receive a typerr.[fmt7]
file reporting all rejected appraisal records.
Below, an explanation of the type of error and how they are reported in the typerr file.
Type of error | Error reported in typerr file |
Herd code is invalid (0000000 or completely missing) | Bad Herd code |
ID not found in ID/Pedigree tables | No Ped |
DOB not provided, or invalid (e.g. not numeric, negative value) | Bad Birth |
Non numeric byte from position 18 to 90 | Bad Char at (byte) |
Invalid appraisal date | Bad app date |
Appraisal date in the future (from day of processing) | High app date |
Invalid calving date | Bad Fresh date |
Fresh date higher than appraisal date | Fresh > appraisal |
Lactation number (bytes 54-55)is blank | Lac No Blank |
Appraisal date prior to 1980 | App date < 1980 |
Age > 240mo or < 15mo | Age=[age_in_Months] > 240 or < 15 |
Action code (byte 103) higher than 2 | Action > 2 |
Action code (byte 103) <0 | Bad Action code |
Appraisal <1 or > highest value (80/50 depending on breed/trait) | Bad Score |
Data existing and not replaced | No Replace |
No record in database and action code=2 | No rec to delete (or Not Found) |
No record in database and action code=1 | No rec to update (or Not Found) |
Identical record in database and action code=0 (duplicate) | Dup |
Different record in database and action code=0 (missmatch) | Replace not requested |
Current format¶
Byte Position(s) |
Num Bytes |
Field Format (1) |
Data Type (86) |
Ref Note(s) |
Field Description |
1 | 1 | X | CH | 13 | Species code of the animal |
Animal Identification Information | |||||
2-3 | 2 | AA | CH | 4 | Breed code of animal (alpha code only, no zeros) |
4-6 | 3 | AAA | CH | 119 | Country code of ID origin |
7-18 | 12 | AA...AA | CH | Identification number of animal (registration or eartag) | |
19-26 | 8 | XX...XX | CH | Date of appraisal (YYYYMMDD) | |
27-34 | 8 | XX...XX | CH | Birth date of animal (YYYYMMDD) | |
Appraisal Herd Code Information | |||||
35-36 | 2 | XX | CH | 5 | State code |
37-38 | 2 | XX | CH | County code | |
39-42 | 4 | XXXX | CH | Herd number | |
43-45 | 3 | XXX | CH | Appraiser code | |
46-53 | 8 | XX...XX | CH | Date of last calving (YYYYMMDD) | |
54-55 | 2 | XX | CH | Lactation number | |
56* | 1 | X | CH | 132 | Stage of lactation |
57-58 | 2 | XX | CH | Stature score | |
59-60 | 2 | XX | CH | Strength score | |
61-62 | 2 | XX | CH | Dairy form score | |
63-64 | 2 | XX | CH | Foot angle score | |
65-66 | 2 | XX | CH | Rear legs (side view) score | |
67-68 | 2 | XX | CH | Body depth score | |
69-70 | 2 | XX | CH | Rump angle score | |
71-72 | 2 | XX | CH | Thurl width score | |
73-74 | 2 | XX | CH | Fore udder attachment score | |
75-76 | 2 | XX | CH | Rear udder height score | |
77-78 | 2 | XX | CH | Rear udder width score | |
79-80 | 2 | XX | CH | Udder depth score | |
81-82 | 2 | XX | CH | Suspensory ligament score | |
83-84 | 2 | XX | CH | Front teat placement score | |
85-86 | 2 | XX | CH | Teat length score | |
87-88 | 2 | XX | CH | Final score (used for PTA) | |
89-90 | 2 | XX | CH | Alternative final score | |
91-92 | 2 | AA | CH | Miscellaneous code 1 or code "XT" indicating 2 additional traits may follow (00 indicates not reported) |
|
93-94 | 2 | AA | CH | Rear legs (rear view) or Miscellaneous code 2 | |
95-96 | 2 | AA | CH | Milking speed or Miscellaneous code 3 | |
97-102 | 6 | AA..AA | CH | Miscellaneous codes 4-6 | |
103* | 1 | X | CH | 133 | Action code |