130 likes | 228 Views
Reproduction data in USDA database. History. Format 5 reproductive events. Database design. Record key Cow, calving, herd Record fields Status and production data Up to 50 test-day segments Up to 50 reproductive events. Integration of lactation source data.
E N D
Database design • Record key • Cow, calving, herd • Record fields • Status and production data • Up to 50 test-day segments • Up to 50 reproductive events
Integration of lactation source data • Breeding events from current lactation records stored • Different event type used (B) • Pregnancy confirmation and estimated date derived from subsequent test date • Service sire derived from progeny
Current reproduction data • Lactation or heifer ID/breeding records • 2,336,621 cows calving in 2003 • 304,183 heifers born in 2002 • 67% include pregnancy confirmation • Most confirmations are affirmative • 76% confirmed pregnant • 24% confirmed not pregnant
Current reproduction data • Reproductive record (format 5) • Reporting from 2 DRPCs • 57% of all cows • Reporting herds with 10+ calvings • 71% reported data in format 5 • 24% reported breeding dates only (format 4) • 81% reported either pregnancy confirmation (format 4) or diagnosis (format 5)
Current reproduction data • Cows • 86% include at least 1 breeding • Mean number of breedings: 2.1 • Heifers • 82% include at least 1 breeding • Mean number of breedings: 1.5
Format 5 data • 89% of breedings include service sire • Almost no estrus synchronization • Very few embryo transfers • As either donor or recipient
Uses • Daughter pregnancy rate evaluation • Pregnancy status used to improve estimates of days open for lactations without subsequent calving • Pedigree validation • Planned evaluation of male fertility • Research resource
Service sire vs. calf sire • 111,546 Holsteins • Born June–December 2004 • Registry status 75–100% • Not embryo transfer • Sire and dam reported • Comparison • Match: 48.7% • Service sire unknown: 49.3% • Sires different: 2.0%
Resolution of differences • Allow breeds to query AIPL database prior to issuance of registration: • Dam's calving date • Dam's service sire • Calf pedigree • Benefits: • Use of data recorded closest to event • Conflicts resolved prior to registration • Conflicts between breed and DHI reduced
Summary • Extensive set of reproduction information collected • High proportion of recent cows have some data • Used to improve DPR • May add to accuracy of sire identification • Data for planned male fertility evaluation