National DHIA

Home
About Us
Members
MUN Data
QCS
References
Animal ID
APHIS Proposal
Herd and Cow Profile Formats
Herd Profiles and Description
Link to File Transfer Area
DHIA Approved Meters, Weigh Jars, and Scales
National DHIA Arbitration Policy
NCDHIP Testing Plans (pdf)
Profile Software/Electronic Format Distribution Policy
Progeny Test Program Benefits
Standard Transfer Formats
Resources
News
Premises and Animal ID
Links
Awards
Scholarship Program (pdf)
Scholarship Program (doc)
DBC Articles
Contacts

stf-ref STANDARD TRANSFER FORMAT REFERENCES

GENERAL COMMENTS

All records for a herd should be sent in a single file.

Format fields follow USDA-AIPL standards, except blank filler is used in all fields if information is not available. An "X" in the Field Format indicates that the field is right justified numeric data with left zero fill. An "A" in the Field Format indicates left justified alphanumeric data.

Trailing blanks can be eliminated and records should be terminated with a carriage return and linefeed.

REQUIRED DATA

The following statements identify items that must be included in the Standard Transfer File to maintain minimum continuity of records transferred from one processing center to another:

FILE FORMAT A -- HERD RECORD is required.

FILE FORMAT B -- COW AND HEIFER RECORD is required for each active animal in the herd and it is desirable to include a record for each animal that has left the herd in the last 14 months.

FILE FORMAT C -- LACTATION RECORD is required for each lactation of cows that had a "B" record.

FILE FORMAT D -- TEST DAY DATA RECORD is required for each test day of the cow's current lactation. It is desirable to include a record for test days of previous lactations.

FILE FORMAT E -- HERD TOTALS RECORD is required for each test period during the past 13 months. It is desirable to include additional test period data.

FILE FORMAT G -- GENERAL MESSAGE RECORD is an optional record available to send a message regarding this herd.

FILE FORMAT H -- HEALTH RECORD is an optional record to be used to transfer health information on individual animals.

Fields in records that are identified with a "R" are required to be included with each transfer. The only exception is milk component fields that the herd has not chosen to test. It is desirable to report as much data as possible to make a more complete transfer of the producer's records.

SELECTED USDA-AIPL REFERENCE NOTES

Reference 4. -- Alphabetic breed codes (by species; breed codes are for cattle in formats with no species code):

Dairy cattle		Dairy goats
AY	Ayrshire	AI	Alpine
BS	Brown Swiss	EN	Saanen
DL	Dutch Belted	EX	Experimental
GU	Guernsey	LN	La Mancha
GV	Gelbvieh	ND	Nigerian Dwarf
HO	Holstein	NU	Nubian
JE	Jersey	OH	Oberhasli
LD	American Lineback	PY	Pygmy
MS	Milking Shorthorn	TO	Toggenburg
NM	Normande	XX	Mixed
NR	Norwegian Red	blank	Unknown
RD	Red Dane
RP	Red Poll
SM	Simmental
WW	Red and White
XX	Mixed
blank	Unknown

Reference 5. -- Prefix and location codes used in animal identification:

Prefix codes
blank	Identification Program (VIP) recorded animal (NOTE: Position to right of blanks must be letter.)
00	U.S. registered animal with number <10 million
01	U.S. registered animal with number in 10-million range
02	U.S. registered animal with number in 20-million range
03	U.S. registered animal with number in 30-million range
04	Canadian or Channel Islands registered animal
05	Canadian grade animal
06	United Kingdom including Channel Islands
07	Unassigned
08	Not to be used (used in past for mixed breeds and Red and Whites)
09-10	Unassigned
11-16	See location codes
17	Not to be used (used in past for dairy goats)
18	American goat breed registered by ADGA
19	British goat breed registered by ADGA
20	All goat breeds registered by American Goat Society
21-23	See location codes
24-27	Unassigned
28	See location codes
29	Unassigned
30	USDA internal VIP prefix code; used by USDA only (see blank for dairy records processing centers)
31-35	See location codes
36	Cow in identity enrollment (IE) program, but offspring not eligible for inclusion in regular herdbook; granddaughters or later generations' offspring may be eligible for entry
37	Cow in IE program, and offspring eligible for inclusion in regular herdbook if specified requirements are met
38-40	Unassigned
41-43	See location codes
44	Unassigned
45-48	See location codes
49	Unassigned
50-52	See location codes
53	Unassigned
54-59	See location codes
60	Unassigned
61	See location codes
62	Unassigned
63-66	See location codes
67-70	Unassigned
71-75	See location codes
76-80	Unassigned
81-88	See location codes
89-90	Unassigned
91-96	See location codes
97	Reserved for 93V duplicate eartags
98	Reserved for breed-association non-testing herds
99	Unassigned

Location code
Code	Location	Available County Numbers	Code	Location	Available County Numbers
11	Maine	00-99	59	Jamaica	00-09
12	New Hampshire	00-99	59	West Indies	10-39
13	Vermont	00-99	59	Dominican Republic	40-49
14	Massachusetts	00-99	59	Virgin Islands	59
15	Rhode Island	00-99	59	Korea	60
16	Connecticut	00-99	61	Kentucky	00-99
21	New York	00-99	63	Tennessee	00-99
22	New Jersey	00-99	64	Alabama	00-99
23	Pennsylvania	00-99	65	Mississippi	00-99
28	Chile	00-99	66	Mexico	00-99
31	Ohio	00-99	71	Arkansas	00-99
32	Indiana	00-99	72	Louisiana	00-99
33	Illinois	00-99	73	Oklahoma	00-99
34	Michigan	00-99	74	Texas	00-99
35	Wisconsin	00-99	75	Colombia	00-99
41	Minnesota	00-99	81	Montana	00-99
42	Iowa	00-99	82	Idaho	00-99
43	Missouri	00-99	83	Wyoming	00-99
45	North Dakota	00-99	84	Colorado	00-99
46	South Dakota	00-99	85	New Mexico	00-99
47	Nebraska	00-99	86	Arizona	00-99
48	Kansas	00-99	87	Utah	00-99
50	Delaware	00-99	88	Nevada	00-99
51	Maryland	00-99	91	Washington	00-99
52	Virginia	00-99	92	Oregon	00-99
54	West Virginia	00-99	93	California	00-99
55	North Carolina	00-99	94	Puerto Rico	00-99
56	South Carolina	00-99	95	Hawaii	00-99
57	Georgia	00-99	96	Alaska	00-99
58	Florida	00-99

Reference 10. -- Termination codes:

0	=	Went dry or had 305 days in milk (normal).
1	=	No longer used
2	=	Sold for dairy purposes or testing of herd discontinued; allows animals to have subsequent records in different herds. Other "sold" or "died" codes indicate no new records are expected for animal.
3	=	Sold for slaughter or any reason not identified specifically.
4	=	Sold because of reproductive problems.
5	=	Sold because of disease, injury, or unspecified reasons.
6	=	Died.
7	=	Sold because of mastitis or other udder problems.
8	=	Aborted at = 152 days from last breeding or at = 200 days in milk if no breeding date.
9	=	Does not provide reason for termination; indicates that record not be included in calculating genetic evaluations because 1) lactation initiated by abortion, or 2) no test day between freshening and terminations dates.

Reference 13. -- Species codes:

0	=	Dairy cattle
1	=	Dairy goat (must be used with goat breed codes)
2	=	Dairy sheep (no breeds assigned at present)
3-9	=	Do not use

Reference 16. -- Dairy records processing center (DRPC) and Dairy management systems (DMS) codes:

DRPC Codes
01	=	Agritech Analytics (CA)
02	=	Unassigned
03	=	Unassigned
04	=	Unassigned
05	=	Unassigned
06	=	Unassigned
07	=	Dairy Records Management Systems (Raleigh, NC, and Ames, IA)
08	=	Unassigned
09	=	Pennsylvania DHIA (PA)
10	=	DHI-Provo (UT)
11	=	Unassigned
12	=	AgSource Cooperative Services (WI)
13	=	USDA special input data
14	=	Mexico
15	=	Texas DHIA (TX)

DMS Codes
51	=	North Carolina Dart System

Reference 19. -- Days milked 3X should reflect proportion of lactation credits computed from 3X test days; e.g., if test days are at 20, 50, and 80 days and 3X milking occurs in first two, then days 3X = 65.

Reference 20. -- Processing date is the date on which monthly test data for a herd was last processed unless records were corrected or altered after that date. If records were corrected or altered after that date, the date on which the records were corrected or altered should be the processing date. Processing date is not the date that the tape was cut.

Reference 24. -- Multiple-birth codes:

1	=	Single
2	=	Multiple birth
3	=	Birth resulted from embryo transfer
4	=	Split embryo

Reference 28. -- Codes and tags for testing plans approved by NCDHIP Policy Board:

Official records (all Official DHI Rules apply)

Code	Tag	Plan
00	DHI	DHI
01	DHI-AP-T	DHI AM-PM with monitoring device
02	DHI-APCS	DHI AM-PM with alternate AM-PM Component Sampling

20	DHIR	DHIR
21	DHIR-AP-T	DHIR AM-PM with monitoring device
22	DHIR-APCS	DHIR AM-PM with alternate AM-PM Component Sampling
23	DHIR-AP	DHIR AM-PM

31	DHI-AP	DHI AM-PM
33	DHI-MO	DHI Milk Only
34	DHI-MO-AP	DHI AM-PM Milk Only

40	DHI-OS	Owner-Sampler
41	DHI-OS-AP	Owner-Sampler AM-PM
42	DHI-OS-APCS	Owner-Sampler with alternate AM-PM Component Sampling
43	DHI-OS-MO	Owner-Sampler Milk Only
44	DHI-OS-MO-AP	Owner-Sampler AM-PM Milk Only
45	DHI-OS-AC	Owner-Sampler with Average (breed or plant) Components used
46	DHI-OS-AP-AC	Owner-Sampler AM-PM with Average (breed or plant) Components used
47	DHI-OS-TC	Owner-Sampler with Trimonthly tests
47	DHI-OS-MO-TMW	Owner-Sampler Milk Only with Trimonthly Milk Weights

60	DHI-COMM	Commercial
61	DHI-COMM-AP	Commercial AM-PM
62	DHI-COMM-APCS	Commercial with alternate AM-PM Component Sampling
63	DHI-COMM-MO	Commercial Milk Only
64	DHI-COMM-MO-AP	Commercial AM-PM Milk Only

70	DHI-SS	Supervised Sampling
71	DHI-SS-AP	Supervised Sampling AM-PM
72	DHI-SS-APCS	Supervised Sampling with alternate AM-PM Component Sampling
73	DHI-SS-MO	Supervised Sampling Milk Only
74	DHI-SS-MO-AP	Supervised Sampling AM-PM Milk Only

80	DHI-BASIC	Basic management information plan

98	DHI-OTHER	Other dairy record keeping plans

Reference 39. -- Percentile for bulls based on Net Merit $ (NM$) of active AI bulls of previous run. Bulls with Net Merit above that of highest active AI bull have percentile of ++; those with Net Merit below that of lowest active AI bull have percentile of --. Blank for bulls not evaluated. Percentile for cows based on distribution of NM$ for registered cows evaluated that pass first stage of screening for breed (eligible cows).

Reference 75. -- Linear score = log base 2 (.01 somatic cell count) + 3.

Where SCS is cells per microliter. Report linear scores of < 0.1 as 0.1. Use blanks to indicate a missing value.

Reference 85. -- Codes for changes in cow's identification (ID) information after the second test following a cow's entry into the herd:

0	=	No change in cow ID number or birth date
1	=	Cow ID number changed
2	=	Cow birth date changed
3	=	Both cow ID number and birth date changed
4	=	No change in sire or dam ID number
5	=	Sire ID number changed
6	=	Dam ID number changed
7	=	Both sire and dam ID numbers changed
8	=	Verified but unspecified change(s) in cow birth date, sire ID, and/or dam ID
9	=	Any identification change made electronically for administrative purposes

Reference 90. -- Owner sampler (OS) data code (format 105 definition):

blank	=	No lactation information
0	=	Neither cow or dam had a first lactation of predominately OS type-of-test (TOT).
1	=	Cow had a first lactation of predominately OS TOT
2	=	Dam had a first lactation of predominately OS TOT
3	=	Both cow and dam had a first lactation of predominately OS TOT

Reference 103. -- Milk-recorded days (number of days on which one or more milk weights were recorded); in labor-efficient records if the test is a five day average, report 5 as the milk recorded days for such test.

Reference 104. -- Average times cow is milked on milk-recorded days (total number of times cow is milked on all milk-recorded days divided by milk-recorded days).

Reference 105. -- Percentage of milkings at which milk was weighed on milk-recorded days (total number of milkings at which milk is weighed on all milk-recorded days divided by total number of times cow is milked on all milk-recorded days).

Reference 106. -- Percentage of milkings at which samples were taken and applied to the lactation record for component analysis on component-recorded days (total number of milkings at which sample was taken on all component-recorded days divided by total number of times cow was milked on all component-recorded days).

Reference 107. -- Testing-method code:

0	=	Not used
1	=	Traditional testing
2	=	Labor-efficient record (LER)
3	=	Experimental plan

Reference 108. -- Supervision code:

0	=	Not used
1	=	Supervisor conducted test
2	=	Owner conducted test
3	=	Both supervisor and owner conducted test
4	=	Not used
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

Reference 111. -- Sex codes:

M	=	Male
F	=	Female

Reference 115. -- Last test-day status codes:

0	=	Field not used
1	=	Both milk weight and components recorded
2	=	Milk components estimated or not recorded
3	=	Both milk weight and components estimated or not recorded
4	=	Cow sick on test day
5	=	Delete this test day

Reference 116. -- Last test-day percentage of milk shipped; calculated as:

[(herd test-day milk yield/(milk shipped)]*100 (rounded to one decimal place)

where:

herd test-day milk yield	=	sum of test-day milk yields for all cows in herd
milk shipped	=	bulk tank milk weight adjusted to a daily basis (NCDHIP Rules, Appendix 2, state that the bulk tank weight shall be estimated by bulk tank pickup weights for three shipments immediately prior to the test date).

Reference 117. -- National DHIA service affiliates and assigned codes:

Code	Affiliate	Address
013	Vermont DHIA	3 Gilman Office Ctr. White River Junction, VT 05001
021	Northeast DHIA	730 Warren Rd. Ithaca, NY 14850
023	Pennsylvania DHIA	Orchard Rd. State College, PA 16802
031	DHIA, Inc.	Box 1560 Powell, OH 43065
032	Indiana DHIA	208 Poultry Sciences Bldg West Lafayette, IN 47907
034	Michigan DHIA	4418 Forest Rd. Box 23158 Lansing, MI 48909
035	AgSource Coop. Services	135 Enterprise Dr. Verona, WI 53593
041	Minnesota DHIA	307 Brighton Ave., South Buffalo, MN 55313
042	Dairy Lab Services	5105 Wolff Rd. Dubuque, IA 52001
043	Mid-South DHIA	1559 N. National Rd. Springfield, MO 65803
045	North Dakota DHIA	North Dakota State University Hultz Hall, Room 100, Box 5053 Fargo, ND 58105
046	South Dakota DHIA	South Dakota State University P.O. Box 2104 Brookings, SD 57007
047	Nebraska DHIA	1208 West Court Box 663 Beatrice, NE 68310
048	Kansas DHIA	628 Pottawatomie Box 3700 Manhattan, KS 66502
051	Mid-East DHIC	1040 Frederick St. Hagerstown, MD 21740
056	South Carolina DHIA	3691 Busch River Rd. Newberry, SC 29108
057	Georgia DHIA	University of Georgia Hoke Smith Annex Athens, GA 30602
058	Florida DHIA	University of Florida 106 Dairy Science Gainesville, FL 32611
063	Tennessee DHIA	114 McCord Hall P.O. Box 1071 Knoxville, TN 37901
064	Alabama DHIA	109 Animal & Dairy Sciences Bldg Auburn, AL 36849
065	Mississippi DHIA	Box 9815 Mississippi State University Mississippi State, MS 39762
071	Arkansas DHIA	1204 SW 14th St. P.O. Box 299 Bentonville, AR 72712
072	Louisiana DHIA	2288 Gourrier Dr. Baton Rouge, LA 70820
073	Oklahoma DHIA	212C Poultry Bldg Stillwater, OK 74078
074	Texas DHIA	Texas A & M University 435 Kleberg Center College Station, TX 77843
082	Colorado DHIA	1223 28th Ave. Suite 4 Greeley, CO 80631
084	Idaho DHIA	P.O. Box 1827 Twin Falls, ID 83303
085	New Mexico DHIA	5514 Lassiter Rd. Las Cruces, NM 88001
086	Arizona DHIA	3414 South 48th St., #3 Phoenix, AZ 85040
087	Rocky Mountain DHIA	P.O. Box 6426 Logan, UT 84341
091	Washington DHIA	105 South Pine St. Burlington, WA 98233
092	Oregon DHIA	P.O. Box 17399 Salem, OR 97305
093	California DHIA	100 W. Inyo Tulare, CA 93274
094	Puerto Rico DHIA	G.P.O. 360454 San Juan, PR 00936
123	Lancaster DHIA	1592 Old Line Rd. Manheim, PA 17545
135	Fox Valley DHIA	3302 West Brewster Appleton, WI 54914
148	Heart of America DHI	P.O. Box 3700 Manhattan, KS 66502
193	Tulare DHIA	100 W. Inyo Tulare, CA 93274

Reference 118. -- Quality certification (QC) status.

The primary use for this field is to indicate weighing device certification. Failure to meet other aspects of QC should also be indicated by assigning a value of 2.

0	=	Coding not implemented
1	=	Meets quality certification (QC) standards
2	=	Does not meet QC standards

Reference 119. -- Country codes:

Abbrev.	Country	Abbrev.	Country
ARG	Argentina	ITA	Italy
AUS	Australia	JPN	Japan
AUT	Austria	LUX	Luxembourg
BEL	Belgium	MEX	Mexico
CAN	Canada	NLD	Netherlands
CSK	Czech Republic	NZL	New Zealand
DNK	Denmark	NOR	Norway
FIN	Finland	PRT	Portugal
FRA	France	SLO	Slovenia
GBR	Great Britain	ZAF	South Africa
DEU	Germany	ESP	Spain
GRC	Greece	SWE	Sweden
HUN	Hungary	CHE	Switzerland
IRL	Ireland	USA	United States of America
ISR	Israel

Reference 124. -- Lactation Verification Code

0	=	No correction or verification
1	=	Corrected lactation or production data
2	=	Verified lactation or production data

Reference 127. -- This field should represent values as of last sample date.

Reference 128. -- This field should represent an average over the previous 365 days.

Reference 130. -- Registry Status Definitions:

Ayrshire Breeders Association
OA	First generation grade up animals. Only females can have registry status OA. These animals are currently identified with registration numbers in the 369 series.
PR	Second generation grade up animals. Only females can have registry status PR. These animals are currently identified with registration numbers in the 379 series.
HR	Fully registered males and females. Third generation grade up animals will also contain an "HR" registry status.
XX	Foreign registered animals.

Brown Swiss Cattle Breeders Association
RF	Initial grade up animal. Only females are eligible for this program. One parent must be a registered Brown Swiss and the second parent can be any dairy animal. Thus, these may be crossbred animals. These animals are currently identified with a 365xxxxxx series registration number. Please note, that not all animals must start with this step, as characteristic grade Brown Swiss may go directly into the ID step (next step).
ID	Will be the next step which may be either (a) an offspring of a RF dam and a registered Brown Swiss sire or may be (b) an identified and inspected grade Brown Swiss (original animal) possessing typical Brown Swiss color and characteristics. These females (b) would have either unknown Brown Swiss parents or may have one registered parent. Only females are eligible for this program step. These animals are currently identified with a 369xxxxxx series registration number.
IE	Will be the next step which will always have an ID (369xxxxxx) dam and a registered Brown Swiss sire. Again only females are eligible for this step. These animals are currently identified with a 3793xxxxx series registration number.
HR	Will be for fully registered animals. The dam may be either an IE or HR registry status animal. If the dam is an IE, only female offspring may be registered. The sire will always be HR status and Brown Swiss.

American Guernsey Association
RF	Recorded Female - Initial grade up animal. Only females are eligible for this program. She must have one purebred Guernsey parent (registered or unregistered) and the other parent must be another dairy breed. Thus, these may be crossbred animals. These animals are identified with a 360 series.
GT	Guernsey Type - This generation requires Guernsey appearance. This female must be sired by a purebred Guernsey bull out of an RF animal. The animal in this step must be a minimum 75% Guernsey. If adequate records are provided the initial animal may enter as a GT animal. These animals are identified with registration numbers in the 365 series.
PR	Provisional Register - A female out of an GT female sired by a registered bull. These animals are identified with the registration numbers in the 376 series.
GR	Genetic Recovery - A female out of a PR female and a registered bull. Bulls may be registered out of this generation. These animals are identified with registration numbers in the regular herdbook series.

Holstein Association
00-99	Indicates percent Registered Holstein Ancestry (RHA). Values from 93 to 99 will be used to indicate animals previously known as Qualified. Values from 00 thru 92 will be females previously known as Identified Holstein Female (IHF).
**	Fully registered males and females.

American Jersey Cattle Association
OA	First generation grade up animals. Only females can have registry status OA. One or both parents may be grade, unregistered or unknown. These animals are currently identified with registration numbers in the 368 series. We will not issue new numbers in the 368 series once we have implemented American ID.
PR	Second generation grade up animals. Only females can have registry status PR. The dam will be either from the 368 number series or OA registry status, and the sire will be a registered Jersey (HR). These animals are currently identified with registration numbers in the 379 series. We will not issue new numbers in the 379 series once we have implemented American ID.
GR	Third generation grade up animals. Only females can have registry status GR. The dam will be either from the 379 number series or PR registry status, and the sire will be a registered Jersey (HR). These animals are currently identified with numbers from our regular herdbook series.
J1	All Registry Status J1 animals will be females. All their sires will be registered Jersey bulls. Their dams will be identified with their non-Jersey breed code, country code and unique ID. The ID may be a registration number, American ID number, USDA eartag, or a default ID created for unknown dams. Only female progeny can be recorded from J1 dams. Their progeny must be sired by registered Jersey bulls. The progeny will be assigned Registry Status OA.
HR	Fully registered males and females. The dam will be either GR or HR registry status, and the sire will be registered Jersey (HR).

Red and White Cattle Breeders Association
WW	Registered with the Red and White Cattle Breeders Association

For all breeds
blank	Grade animal, or registry status unknown.

ADDITIONAL REFERENCE NOTES

Reference 305. -- Reproductive code:

C	=	Reproductive cull (do not plan to breed)
P	=	Diagnosed pregnant
N	=	Diagnosed open after "last breeding date"
H	=	Date in "last breeding date" is last heat date

Reference 307. -- If days in milk for this component is less than days in milk for milk yield, it should be set to blank.

Reference 309. -- Abortion-induced lactation:

1	=	Record initiated by an abortion
2	=	Record initiated by induced lactation

Reference 310. -- 305 day record code:

0	=	305 record has not been computed
1	=	305 day record has been computed
2	=	day record has been computed
3	=	305 day record cannot be calculated

Reference 311. -- Complete record code:

0	=	Complete record has not been computed
1	=	Complete record has been computed
2	=	Record not initiated with a calving date (incomplete)

Reference 312. -- Fresh code:

0	=	Normal 1st test or current test is not 1st test
1	=	Too fresh to test
2	=	No milk weight on 1st test (>6 days in milk)
3	=	1st milk weights reported as abnormal (6> days in milk)
4	=	No component sample on 1st test (>6 days in milk)
5	=	Calving date missing from fresh cow

Reference 313. -- Privacy Code:

N	=	No restrictions
Y	=	Do not publish

Reference 315. -- Replacement Animal Codes:

H	=	Animal is a replacement
M	=	Animal in the milking herd

Reference 324. -- Sample day status code:

1	=	Both milk weight and components recorded
2	=	Milk components estimated
3	=	Both milk weight and components estimated
4	=	Milk weight estimated
5	=	Milk weight carried (or held open) from previous test
6	=	Components carried (or held open) from previous test
7	=	Both milk weight and components carried (or held open) from previous test
8	=	Only milk weight recorded

Reference 333. -- String Number; 999 = Total for All Strings. If strings are not used, leave blank.

Reference 335. -- 305 Actual Milk, Fat and Protein. Only actual, not projected records should be listed.

Reference 337. -- Barn Name of Animal is a required field. If a barn name is not available on the sender's files, the sender should include computer control number.

Reference 338. -- Records Disclosure Policy Codes:

O	=	Open
L