Dairy Board Herd Testing Database Formats




NEW ZEALAND GAZETTE

No. 92

Combination Systems

– Bentley

Models – 2500 Combi

– 2300 Combi

– 150 Combi

Any sample collection and sample analysis equipment approved by the International Dairy Federation (IDF) and/or the International Committee for Animal Recording (ICAR) is also approved for use within New Zealand.

The endorsement of equipment that meets IDF and/or ICAR standards does not preclude different standards for New Zealand.

APPENDIX II

RECORD FORMATS

The following is the list of record formats approved by the database manager (ref 1.2) as at 1 June 1998.

Note: Where the contents of a text field do not fill the field, spaces are leading.

All numeric fields are left zero filled.

Null value for all text fields is spaces, null value for all numeric fields is zero.

FARM LOCATION:

Type Text Length 10

Map reference of farm entrance from New Zealand map series and contains map sheet number and East and North grid references to a tenth of a division.

HERD NUMBER:

Type Numeric Length 2

The number of a herd within a location. At any one location there may be 0 1 or more herds.

Each herd is a distinct business unit. An animal may belong to only one herd at any one time.

PARTICIPANT CODE:

Type Text Length 4

The code assigned to each person or business unit owning or having contractual rights to a herd under test.

“NEW COW” INDICATOR

Type Text Length 1

An indicator showing whether the details in this record should be added to those already recorded for an animal on the Database, or a set of records should be created on the Database to accommodate a previously unrecorded animal.

Blank This animal is already recorded on the Database.

1 This animal has no information currently recorded on the Database.

ANIMAL IDENTIFICATION:

BIRTH IDENTIFICATION:

Owner

Type Text Length 4

Participant code of owner of herd which the animal is born.

Year

Type Numeric Length 4

Year of identification of animal.

Birth Identification Number

Type Numeric Length 4

Number which uniquely identifies the animal in that year in that herd.

AB Code:

Type Numeric Length 6

Code allocated by LIC to uniquely identify all bulls used in AB. Also used for grade bulls born prior to 1985.

LIVESTOCK IMPROVEMENT ASSOCIATION (LIA) IDENTIFICATION (USED ONLY FOR ANIMALS BORN PRIOR TO 1985):

LIA Region

Type Text Length 4

L1 – Northland

L2 – Auckland

L3 – Bay of Plenty/East Coast

L4 – Taranaki

L5 – Wellington/Hawkes Bay

L6 – South Island

LIA Herdcode

Type Numeric Length 6

Herdcode allocated by LIA to the member recording the birth of the animal.

LIA Identification Year

Type Numeric Length 4

Year of identification of animal.

LIA Identification Tag/Tattoo

Type Text Length 6

Tattoo or ear tag which uniquely identifies the animal in that herd in that year.

PEDIGREE HERDBOOK IDENTIFICATION:

These records are provided and controlled by the Breeds Societies who are participating members in the database.

Herdbook Number:

Type Text Length 6

Number recorded in a herdbook of a New Zealand Pedigree Breed Society.

Breed Society:

Type Text Length 6

Code identifying the herdbook to which the herdbook number refers.

AY – Ayrshire

FR – Friesian

PJ – Polled Jersey

MS – Milking Shorthorn

BS – Brown Swiss

JR – Jersey

GU – Guernsey

SEX:

Type Text Length 1

Code indicating sex of animal

– M Bull, male

– F Heifer, cow, female

– S Steer, male-castrate

– P Spay, female-castrate

– V Vasectomised bull

– T Freemartin

– U Unknown

DATE OF BIRTH:

Type Numeric Length 6

Date on which the animal was born. Format YYMMDD

DATE OF BIRTH ESTIMATED INDICATOR:

Type Numeric Length 1

Code showing status of date of birth

– 0 No date recorded

– 1 Actual

– 2 Estimated by farmer

– 3 Estimated on age and calving date of this animal



Next Page →



Online Sources for this page:

VUW Te Waharoa PDF NZ Gazette 2000, No 92


Gazette.govt.nz PDF NZ Gazette 2000, No 92





✨ LLM interpretation of page content

🌾 Dairy Board Herd Testing Database Formats (continued from previous page)

🌾 Primary Industries & Resources
1 June 1998
Dairy Board, Herd Testing, Database Formats, Record Structures, Farm Location, Herd Number, Participant Code, Animal Identification, LIA Identification, Pedigree Herdbook, Sex, Date of Birth