21 APRIL NEW ZEALAND GAZETTE

1405

APPENDIX II

RECORD FORMATS

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 is has no information currently recorded on the Database.

ANIMAL IDENTIFICATION:

BIRTH IDENTIFICATION:
Owner
Type Text Length 4
Participant code of owner of herd into 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 L.I.C. 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:

Herdbook Number:
Type Text Length 6
Number recorded in a herdbook of a New Zealand Pedigree Breed Society.

Breed Society:
Type Text Length 4
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

SIRE OFFICIAL INDICATOR:
Type Text Length 1
Code showing extent to which it has been possible to confirm the sire of the animal. Values 7, 8 and 9 indicate official acceptance of the sire.
The sire validation section of the Database system checks recorded matings against the calving date and dam recorded.