# Presentation: 730815

## INTRODUCTION

**1999 - AIPL first calculated national genetic evaluations for calving ease (CE) (dystocia).**
**The addition of maternal effects improves evaluations by addressing antagonism between direct and maternal genetic effects on dystocia. **
**Only 58% of the records submitted to AIPL include maternal grandsire (MGS) identification (ID).**
**Integrating the CE database with the production database was expected to improve data editing.**

_**MATERIALS **__**and**__** METHODS**_
**Master file**** of dystocia data obtained by AIPL in 1999 is ****updated biannually**** with DHIA and AI cooperators’ data.**
**CE database**** includes two primary tables:**
**CE**** records.**
**Pedigree**** information supplemental to the production database.**
**Dystocia records are compared to the ****production database****.**
**In the case of ambiguous or unknown dam ID a negative key is assigned to the dam.**
**Allows retention of data.**
**Preserves MGS ID.**
**Duplicate records were identified.  **
**Records with the same positive dam key and calving ********6mo.**
**Records with the same negative dam key and non-zero dam ID, in the same herd, and calving ********6mo.**
**Records with no dam ID, in the same herd, with the same calving date.**

**Editing of CE data is improved by accessing information from existing databases.**
**Rate of MGS ID increased via existing pedigree data.**
**Database supports complex queries and on-line access. **

**RESULTS and DISCUSSION**

| CE Database  |  |  |  |
| --- | --- | --- | --- |
| Source Data |  |  |  |
| Input |  | 11,063,139 |  |
| Updates |  | 373,318 |  |
| Duplicates |  | 132,160 |  |
| Rejects |  |  | 79,371 |
| Accepted | 10,478,290 |  |  |

| Accepted Records |  |  |  |
| --- | --- | --- | --- |
| Non-Holstein |  |  | 62,390 |
| Born <1980 |  | 89,058 |  |
| Multiple birth |  | 52,996 |  |
| Bull >15yr old |  | 78,749 |  |
| Extracted data | 10,195,097 |  |  |

| Distribution of CE scores |  |  |  |
| --- | --- | --- | --- |
|  | Source Data |  | Extracted Data |
| CE Score | Percent |  | Percent |
| 1 – No Problem | 76.0 |  | 76.3 |
| 2 – Slight Problem | 10.1 |  | 10.5 |
| 3 – Needed Assistance |  | 9.0 | 8.8 |
| 4 – Considerable Force |  | 2.9 | 2.9 |
| 5 – Extreme Difficulty | 1.5 |  | 1.5 |

**Percent Distribution of CE Scores by Parity for Extracted Data**

**Rate of MGS ID increased from ****58%**** to ****73%****.**
**Nearly ****70%**** of the accepted dams were matched with the production database and ****99%**** of these records included MGS ID.**
**Of dams with a negative key, only ****13%**** included MGS ID.**
**Variation in the distribution of CE Score within herd was considerable.**

**The extraction process produce no appreciable change in the distribution of CE scores.**
**Percentage of male calves was 51.5 in both the accepted source data and the database extract.**
**The distribution of records across parity was similar in the accepted source data and the database extract. **
**First calvings were significantly more difficult, but little difference was seen between later parities.**

**CONCLUSIONS**

|  | Parity |  |  |
| --- | --- | --- | --- |
|  | 1st | 2nd | ≥3rd   |
| Accepted data | 26.1 | 29.3 | 44.6 |
| Extracted data | 25.6 | 29.4 | 45.2 |