HOLSTEIN ASSOCIATION, USA Top CTPI Cow File Format

# Bytes	Format	Type	Description	Update
3	ccc	CH	Country Code
2	cc	CH	Breed
12	nnnnnnnnnnnn	CH	Registration Number (leading zeros)
3	nnn	CH	Herdbook RHA Status (0-100)
2	cc	CH	RHA Indicator (NA or I)
30	c(30)	CH	Registered Name
16	c(16)	CH	Recessive Codes
8	nnnnnnnn	CH	Date of Birth (YYYYMMDD)
2	nn	CH	Final Score
4	nnnn	CH	Age at Classification (YYMM)
8	nnnnnnnn	CH	Date of Classification (YYYYMMDD)
1	c	CH	Front End / Capacity ^(1)
1	c	CH	Dairy Strength ^(1)
1	c	CH	Rump  ^(1)
1	c	CH	Feet and Legs^(2)
1	c	CH	Udder
1	n	CH	Multiple E (0-4)
1	n	CH	Gold Medal (1 or 0)
1	n	CH	Dam of Merit (1 or 0)
1	c	CH	CTPI Origin Indicator (U, M or C)
5	snnnn	CSL	CTPI
3	ccc	CH	Sire's Country Code
2	cc	CH	Sire's Breed
12	nnnnnnnnnnnn	CH	Sire's Registration Number (leading zeros)
3	nnn	CH	Sire's Herdbook RHA Status (0-100)
2	cc	CH	Sire's RHA Indicator (NA or I)
30	c(30)	CH	Sire's Registered Name
16	c(16)	CH	Sire's Recessive Codes
10	nnnccnnnnn	CH	Stud code number
1	c	CH	Sire's TPI Origin Indicator (U, M or C)
5	snnnn	CSL	Sire's TPI
2	nn	CH	Sire's Classification Score
1	c	CH	Sire's Production Proof Origin Indicator (U, M or C)
5	snnnn	CSL	Sire's PTAM
4	snnn	CSL	Sire's PTAP
4	snnn	CSL	Sire's PTAF
1	c	CH	Sire's Type Proof Origin Indicator (U, M or C)
5	sn.nn	CSL	Sire's PTAT
5	sn.nn	CSL	Sire's Udder Composite
5	sn.nn	CSL	Sire's Feet and Legs Composite
3	ccc	CH	Dam's Country Code
2	cc	CH	Dam's Breed
12	nnnnnnnnnnnn	CH	Dam's Registration Number (leading zeros)
3	nnn	CH	Dam's Herdbook RHA Status (0-100)
2	cc	CH	Dam's RHA Indicator (NA or I)
30	c(30)	CH	Dam's Registered Name
16	c(16)	CH	Dam's Recessive Codes
1	c	CH	Dam's CTPI Origin Indicator (U, M or C)
5	snnnn	CSL	Dam's CTPI
2	nn	CH	Dam's Final Score
8	nnnnnnnn	CH	Dam's Date of Classification
1	c	CH	Dam's Front End / Capacity ^(1)
1	c	CH	Dam's Dairy Strength ^(1)
1	c	CH	Dam's Rump  ^(1)
1	c	CH	Dam's Feet and Legs^(2)
1	c	CH	Dam's Udder
3	ccc	CH	Dam's Best Lactation - Testing Program
3	nnn	CH	Dam's Best Lactation - Data Collection Rating - Milk
3	nnn	CH	Dam's Best Lactation - Data Collection Rating - Components
4	nnnn	CH	Dam's Best Lactation - Age at Calving (YYMM)
1	n	CH	Dam's Best Lactation - Times milked daily (2=2X, 3=3X)
3	nnn	CH	Dam's Best Lactation - Length of Record (365 or less)
5	nnnnn	CH	Dam's Best Lactation - Milk #
4	nnnn	CH	Dam's Best Lactation - Fat #
4	nnnn	CH	Dam's Best Lactation - True Protein #
4	nnnn	CH	Dam's Best Lactation - Crude Protein #
1	c	CH	Dam's Best Lactation - verification test(V), extreme test-day(X) or injection(I) indicator
1	c	CH	Dam's Production Proof Origin (U, M or C)
5	snnnn	CSL	Dam's PTAM
4	snnn	CSL	Dam's PTAP
4	snnn	CSL	Dam's PTAF
1	c	CH	Dam's Type Proof Origin (U, M or C)
5	sn.nn	CSL	Dam's PTAT
5	sn.nn	CH	Dam's Udder Composite
5	sn.nn	CSL	Dam's Feet and Legs Composite
3	ccc	CH	Maternal GrandSire's Country Code
2	cc	CH	Maternal GrandSire's Breed
12	nnnnnnnnnnnn	CH	Maternal GrandSire's Registration Number (leading zeros)
3	nnn	CH	Maternal GrandSire's Herdbook RHA Status (0-100)
2	cc	CH	Maternal GrandSire's RHA Indicator (NA or I)
30	c(30)	CH	Maternal GrandSire's Registered Name
16	c(16)	CH	Maternal GrandSire's Recessive Codes
10	nnnccnnnnn	CH	Maternal GrandSire's Stud code number
1	c	CH	Maternal GrandSire's TPI Origin Indicator (U, M or C)
5	snnnn	CSL	Maternal GrandSire's TPI
1	c	CH	Production Proof Origin (U, M or C)
6	nnnnnn	CH	USDA Calculation Date (YYYYMM)
2	nn	CH	% Reliability
6	snnnnn	CSL	YD Milk
5	snnnn	CSL	PTAM
4	snnn	CSL	YD Fat
4	snnn	CSL	PTA Fat
4	s.nn	CSL	PTA% Fat
2	nn	CH	% Yield Reliability
4	snnn	CSL	YD Protein
4	snnn	CSL	PTA Protein
4	s.nn	CSL	PTA%Protein
4		CSL	Blank
			FIRST PRODUCTION RECORD:
3	ccc	CH	Testing Program
3	nnn	CH	Data Collection Rating - Milk
3	nnn	CH	Data Collection Rating - Components
4	nnnn	CH	Age at Calving (YYMM)
1	n	CH	Times milked daily
3	nnn	CH	Length of Record
5	nnnnn	CH	Milk #
3	n.n	CH	% Fat
4	nnnn	CH	Fat #
3	n.n	CH	% Protein
4	nnnn	CH	Protein #
3	n.n	CH	% Crude Protein
4	nnnn	CH	Crude Protein #
1	c	CH	Verification test(V), extreme test-day(X) or injection(I) indicator
			HIGHEST PRODUCTION RECORD:
3	ccc	CH	Testing Program
3	nnn	CH	Data Collection Rating - Milk
3	nnn	CH	Data Collection Rating - Components
4	nnnn	CH	Age at Calving (YYMM)
1	n	CH	Times milked daily
3	nnn	CH	Length of Record
5	nnnnn	CH	Milk #
3	n.n	CH	% Fat
4	nnnn	CH	Fat #
3	n.n	CH	% Protein
4	nnnn	CH	Protein #
3	n.n	CH	% Crude Protein
4	nnnn	CH	Crude Protein #
1	c	CH	Verification test(V), extreme test-day(X) or injection(I) indicator
1	c	CH	Type Proof Origin (U, M or C)
6	nnnnnn	CH	PTAT Calculation Date (YYYYMM)
2	nn	CH	% Reliability PTAT
5	snn.n	CSL	Deviation
4	nn.n	CH	AASC
5	sn.nn	CSL	PTA Type
5	sn.nn	CSL	Udder Composite
5	sn.nn	CSL	Feet and Legs Composite
28	c(28)	CH	Owner Name
24	c(24)	CH	Owner Street
20	c(20)	CH	Owner City
2	cc	CH	Owner State
10	nnnnn-nnnn	CH	Owner Zip
16	n(16)	CH	Owner Phone
5	snnnn	CSL	Subject Cow's NM$
4	sn.n	CSL	Subject Cow's PL
4	n.nn	CH	Subject Cow's SCS
5	sn.nn	CH	Subject Cow's STA Dairy Form
5	snn.n	CH	Subject Cow's Daughter Pregnancy Rate	Modified
5	snn.n	CSL	Subject Cow's Heifer Conception Rate	NEW
5	snn.n	CSL	Subject Cow's Cow Conception Rate	NEW
5	snn.n	CSL	Subject Cow's Fertility Index	NEW
2	nn	CH	Subject Cow's % Reliability Fertility Index	NEW
4	snnn	CSL	Subject Cow's Feed Efficiency	NEW
2	nn	CSL	Subject Cow's % Reliability Feed Efficiency	NEW
4	nn.n	CH	Subject Cow's Daughter Calving Ease
5	snnnn	CSL	Sire's NM$
4	sn.n	CSL	Sire's PL
4	n.nn	CH	Sire's SCS
5	sn.nn	CH	Sire's STA Dairy Form
5	snn.n	CH	Sire's Daughter Pregnancy Rate	Modified
5	snn.n	CSL	Sire’s Heifer Conception Rate	NEW
5	snn.n	CSL	Sire’s Cow Conception Rate	NEW
5	snn.n	CSL	Sire’s Fertility Index	NEW
2	nn	CH	Sire’s % Reliability Fertility Index	NEW
4	snnn	CSL	Sire’s Feed Efficiency	NEW
2	nn	CSL	Sire’s % Reliability Feed Efficiency	NEW
4	nn.n	CH	Sire's Daughter Calving Ease
5	snnnn	CSL	Dam's NM$
4	sn.n	CSL	Dam's PL
4	n.nn	CH	Dam's SCS
5	sn.nn	CH	Dam's STA Dairy Form
5	snn.n	CH	Dam's Daughter Pregnancy Rate	Modified
5	snn.n	CSL	Dam’s Heifer Conception Rate	NEW
5	snn.n	CSL	Dam’s Cow Conception Rate	NEW
5	snn.n	CSL	Dam’s Fertility Index	NEW
2	nn	CH	Dam’s % Reliability Fertility Index	NEW
4	snnn	CSL	Dam’s Feed Efficiency	NEW
2	nn	CSL	Dam’s % Reliability Feed Efficiency	NEW
4	nn.n	CH	Dam's Daughter Calving Ease

ASCII	Comma separates each field Character fields are enclosed in " "
November, 1997	Updated to include Registered Holstein Ancestry (RHA) Updated to include TriStar Production Records programs and data collection ratings. (PRM = Premier, DLX = Deluxe, CST = Custom) Updated stud codes to represent NNNCCNNNNN - two character breed code.
August, 1998	Replaced both Milk and Protein Reliability with Yield Reliability
September, 1998	Updated Registration Number fields to be zero filled. Updated YY to YYYY in preparation for the year 2000.
January, 2000	Inserted NM$, PL and SCS for Subject Cow, Sire and Dam Changed the TriStar labels to be *** = Premier, ** = Deluxe and * = Custom Updated the zip code to incorporate format nnnnn-nnnn
July, 2000	Increased NM$ from 4 bytes to 5 bytes Added Crude Protein to all production records
February, 2005	Added Dairy Form, Daughter Pregnancy Rate and Daughter Calving Ease for Subject Cow, Sire and Dam. Added Date of Classification for Cow and Dam.
August, 2013	Calving Ease traits reported as xx.x instead of xx.
December, 2015	Added Heifer and Cow Conception Rate, Fertility Index (FI), FI reliability, Feed Efficiency and FE reliability for Sire, Dam and Subject Cow.

1. Improved Major Breakdowns implemented on December 1, 2004. New breakdowns are Front End / Capacity; Dairy Strength; Rump; Feet & Legs; and             Udder. Prior to this date, Major Breakdowns were Frame, Dairy Character; Body Capacity; Feet & Legs; and Udder.

  2. If Feet and Legs field is blank, then cow was scored prior to May, 1993 using the four major breakdown system.
      If this is the case, interpret Front End / Capacity as General Appearance.