Pedigree codes:

multiple-birth code, followed by
registry status definition, followed by
animal information mask code


Animal ID Change mask codes:

    How to interpret mask codes

80=Change in cow ID
40=Change in sire ID
20=Change in dam ID
10=Change in cow birthdate
08=Unspecified change in identification SOURCE_CODE char(1) not null,


Animal information mask codes:

    How to interpret mask codes

80=Donor dam
40=Verified unknown sire
20=Verified unknown dam
10=Estimated birth
08=Birth day is 0
04=IHF
02=Animal born <= 426 days from dam
01=Animal born <= 426 days from sire


Date

Test date (YYYYMMDD)


DHI

DHI Affiliate


Cows

Number of cows or does in milk


Freq

Milking Frequency


Weig

Number of milkings weighed


Spl

Number of milkings sampled


MRD

Milk recorded days. If greater than 1, then test-day yield is an average including this number of days.


Source of this evaluation

M = MACE (from InterBull)


Source of ID and pedigree

These 3 codes indicate whether information came from the authoritative pedigree source (country of first registration of the bull) for the bull, sire, and dam, respectively.

Y = information was supplied by the country of first registration
N = inforamation was supplied by a source other than the country of first registration
X = information returned is a cross reference provided by a source other than the country of first registration

Examples:
YYY indicates that the bull's country ID is the source for the ID, and the sire and dam ID; or that a submitted ID has been replaced by a cross reference from an authoratative source
NNN indicates that the country providing the data is not the country of first registration; and no cross reference to an authoratative ID is available
YYN indicates the the country of first registration has not provided a dam ID, but this information was provide by another source
YXY indicates that the bull's country ID is the source for the ID, and the dam ID, but the sire ID has been replaced by a cross reference from a source other than the country of first registration

Supv

Supervisor code
1 - Supervisor conducted test
2 - Owner conducted test
3 - Both supervisor and owner conducted test
5 - Supervisor conducted test using electronic recording
6 - Owner conducted test using electronic recording
7 - Both supervisor and owner conducted test using electronic recording
8 - Verification test not using electronic recording
9 - Verification test using electronic recording


%Shp

% Milk Shipped


G ID

% Good ID


Testdate

Last test date (yyyymmdd)


Updated

Date of file update (yyyymmdd)


Milk

Rolling herd average milk production (lbs)


Fat

Rolling herd average fat production (lbs)


Prot

Rolling herd average protein production (lbs)


SCS

Rolling herd average SCS


Age

Rolling herd average age at calving (months)


In File

Number of cows in AIPL database with testday information for this date


Birth

Birthdate (YYYYMMDD)


Name

Registered name of animal


Short Name

Short name of animal


Lac/Dau

Average number of lactations per daughter


Herd

Herd code
Format: first 2 digits are state, next 2 digits are county, and final 4 digits are herd


Herd

Current herd code of herd with most daughters
Herd code format: first 2 digits are state, next 2 digits are county, and final 4 digits are herd


Herds

Number of herds used in the evaluation


Daug

Number of daughters in that herd


Rel

Reliability


PTA

Predicted Transmitting Ability


Daus

Number of daughters used in the evaluation


Mean

Average 305 ME yield across lactations


Dau/Hd

Average number of daughters per herd


States

Number of states used in the evaluation


Appraisals

Number of appraisals used in the evaluation


Dau Score

Average score of daughters


Ctrl #

Control number


Kidding

Kidding date (yr/mo/da)


DIM

Days in milk


MFP$

MFP dollar for the animal


Percentile

Percentile based on MFP$


Lact

Number of lactations used in the evaluation


Progeny ID

Animal identification of progeny: breed (2 bytes), country (3 bytes), registration or eartag number (12 bytes)


Fresh

Fresh date (yyyy/mm/dd)


Lac

Lactation number


Prog Inb

Expected inbreeding of future progeny - One half the average relationship of this animal to a sample of 600 cows born 3 years ago. This value is an indication of the amount that progeny of this animal will contribute to inbreeding in the population if mated at random.


App Date

Appraisal date


Age

Age at classification (months)


App

Appraiser number


S

Stage of lactation


ST

Stature


SG

Strength


DF

Dairy form


FA

Foot angle


RL

Rear legs (side view)


BD

Body depth


RA

Rump angle


TW

Thurl width


FU

Fore udder attachment


RH

Rear udder height


RW

Rear udder width


UD

Udder depth score


UC

Suspensory ligament


FT

Front teat placement


TL

Teat length


FS

Final score


Fa

Alternate final score (Jersey and Guernsey only)


Lactation Mask Code

    How to interpret mask codes

Mask may be any combination of these values:

80 = record coded incomplete
40 = record is coded with previous days dry
20 = protein lactation information not useable
10 = crossbred animal
08 = lactation not useable
04 = somatic cell available
02 = no management group mates
01 = internal use by AIPL


Mask codes are interpreted by reading each digit segment individually.

The number or letter in the first digit of the code refers to a possible combination of codes 10 through 80. The number or letter in the second digit of the code refers to a possible combination of codes 01 through 08. When there is a combination of codes, the code numbers are added together (i.e. codes 04 and 02 would be written as 06). When the code combination added together is greater than 9, alphabetic letters are used (i.e. a = 10, b = 11, ..., f = 15).

Possible combinations of codes:

1 = code 1
2 = code 2
3 = code 2 and 1
4 = code 4
5 = code 4 and 1
6 = code 4 and 2
7 = code 4 and 2 and 1
8 = code 8
9 = code 8 and 1
a = code 8 and 2
b = code 8 and 2 and 1
c = code 8 and 4
d = code 8 and 4 and 1
e = code 8 and 4 and 2
f = code 8 and 4 and 2 and 1

Examples:

40 = code 40
82 = codes 80, 02
47 = codes 40, 04, 02, 01
6b = codes 40, 20, 08, 02, 01
a1 = codes 80, 20, 01
d4 = codes 80, 40, 10, 04
5c = codes 40, 10, 08, 04
ba = codes 80, 20, 10, 08, 02
ff = codes 80, 40, 20, 10, 08, 04, 02, 01


Reasons for not usable:

Reasons for no records or no information:

Reasons for missing evaluation:


Opn

Days open


Inbrd

Animal inbreeding coefficient (percent)


Dau Inbrd

Average inbreeding of daughters


Fut Prog Inbrd

Expected inbreeding of future progeny - One half the average relationship of this animal to a sample of 600 cows born 3 years ago. This value is an indication of the amount that progeny of this animal will contribute to inbreeding in the population if mated at random.


Primary Stud Code

Primary stud code of bull
See NAAB for list


% US

Percentage of daughters which are US cows


% OS

Percentage of records from Owner Sampler herds


Net Merit

Net Merit $ (NM$) for the bull


Rel

Reliability for Net Merit $


Net Merit Percentile

Net Merit percentile based on NM$


Mgt Gp

Average number of cows in managment group; averaged over lactations for cows and over daughters for bulls


DauDev

Daughter Yield Deviation


PA

Parent Average


RelPA

Reliability of Parent Average


Fat PTA %

Predicted Transmitting Ability percent for fat


Protein PTA %

Predicted Transmitting Ability percent for protein


Age Wt

Average age weight of daughters for Productive Life evaluations


Current Status

Current status of bull


Controlling Stud

Stud code of current controller
See NAAB for list


Sampling Status

Sampling status of bull


Original Stud

Stud code of original owner of the bull
See NAAB for list


Yr Mo

Date bull entered AI (YY/MM)


Interbull

Interbull description


Daughter

Animal identification.


Calving

Current calving date (mo/da/yr).


Codes

Status of record submitted to USDA
* = Change in pedigree information after second test following entry into herd
N = All records not usable, including first lactation records in progress with less than 40 days in milk
R = Record from last lactation is a record in progress
A = First lactation record is from predominately unsupervised testing.


Trt

Component trait information: fat or protein.


Milk

Average mature equivalent milk (lb. 305 DIM, 2 Times a day milking).


Comp

Average mature equivalent fat or protein (lb. 305 DIM, 2 Times a day milking).


MgtGp

Average number of cows in managment group; averaged over lactations for cows and over daughters for bulls.


YDm

Yield deviation for milk. These values are weighted averages across the lactations of a cow for difference between her milk or component yield and estimates of effects of her management group, herd-by-sire interaction, and permanent environment.


YDc

Yield deviation for components. These values are weighted averages across the lactations of a cow for difference between her milk or component yield and estimates of effects of her management group, herd-by-sire interaction, and permanent environment.


Wt

Weight of daughter's contribution to sire's evaluation:
1.0 Daughter's dam evaluated
0.7 Daughter's dam unknown or not evaluated
0.0 Record unusable


ContBm

Contribution of individual daughter to sire's evaluation for milk. This value is calculated as twice the PTA of daughter minus PTA of mate (dam of daughter).


ContBc

Contribution of individual daughter to sire's evaluation for components. This value is calculated as twice the PTA of daughter minus PTA of mate (dam of daughter).


PTAm

Predicted transmitting ability for milk


PTAc

Predicted transmitting ability for components


Dsp -- Disposition Code

R = Reject
C = Change
N = Notify


Goodness of Fit

The Goodness of Fit (GoF) statistic is based on the log of a likelihood ratio test and is divided by 2×(herd size) to make it size neutral. This adjusted GoF value ranges from about –2.2 to 0.2. About 1% of the herd years (GoF < –1) are flagged with a *** and these are excluded from the evaluation. Those flagged with a * have (GoF <–0.2) and are excluded if adjacent to an excluded herd year