Field Layout for Demographic csv files
- Circuit
number – cmi_herds.cir_no
- District
number – cmi_herds.cir_dst_cd
- Fieldstaff name – cmi_contacts.surname
and first_name
- Province
– cmi_herds.prv_cd
- Herd –
cmi_herds.id
- Owner’s
first name – cmi_contacts.first_name
- Owner’s
last name – cmi_contacts.surname
- Publishable
Ind
– ais_herd_service_plans.publish_ind
- Service
Plan – cmi_herd_service_plans.service_plan_abbr
- Latest
test date – cmi_herd_test_periods.test_date
- Number
of animal – cmi_herd_test_periods.cows_in_herd_num
- Number
of 1st lactation with unique id – cmi_herd_test_periods.cows_reg_no_first_lact_num
- Number
of 1st lactation more than 90 days from first_test
– cmi_herd_test_periods.active_cows_1st_lact_ftd_num
- Number
of 1st lactation with verified id –
cmi_herd_test_periods.active_cows_1st_lact_ftd_pv_num
- Number
of animals with unique id – cmi_herd_test_periods.cows_reg_no_num
- Number
of animals in milk – cmi_herd_test_totals.num_cow_milk_lact
- Number
of animals with milk – cmi_herd_test_totals.num_cow_prod_milk
- Number
of animals dry – cmi_herd_test_totals.num_dry_cows
- Number
of heifers – counted from cmi_herd_animals where
heifer_ind = 1
- Number
of old heifers (3 yrs +) – counted from cmi_herd_animals
where sex = F and heifer_ind = 1 and age is 3 years or more
- Number
of breedings – counted from cmi_breedings for
non-heifers serviced within one year
- Number
of heats – counted from cmi_heat_dates for
non-heifers in heat within one year
- Number
of pregnancies – counted from cmi_pregnancies
for non-heifers and preg-checked within one year
- Number
of health events – counted from cmi_healths for
non-heifers and observed within one year
- Milking
brand code– cmi_barns.mbr_cd
- Milking
brand description – Text description for cmi_barns.mbr_cd
- Milking
system type code – cmi_barns.mkt_cd
- Milking
system type description – Text description for cmi_barns.mkt_cd
- Feed
system code – cmi_barns.feed_sys_type
- Feed
system description – Text description for cmi_barns.feed_sys_type
- Barn
layout code – cmi_barns.layot
- Barn
layout description – Text description for cmi_barns.layot
- Number
of milking units – cmi_barns.milk_machine_num
- Number
of owned meters – cmi_barns.owned_meter_num
- Number
of rented meters – cmi_barns.rental_meter_num
- Unit
of measure – cmi_barns.unit_measure
- Number
of animals in lactation 1 – counted from latest cmi_animal_tests
for lact_no = 1 and animal is not sold
- Number
of milking speed records – counted from cmi_animals
for animals with lact_no = 1 on the latest test
- Number
of temperament records – counted from cmi_animals
for animals with lact_no = 1 on the latest test
- Number
of calving ease records – counted from cmi_calving_easy
for the lact_no current on the latest test
- Number
of calving ease with sire – counted from cmi_calving_easy
for the lact_no current on the latest test with sire_reg_id not null
- Last
date meters verified – cmi_meter_verifications.verfctn_date
- On
DAISY option – cmi_herd_contact_options
- Electronic
File Type – from cmi_herds.elec_file_type
- Rolling
Percent 1st lact verified – fields 13
and 14 summed over a 380 day window from the last test expessed
as a percentage
- County
– Text description for cmi_herds.cny_cd
- Herd
average Current BCA for Milk – cmi_herd_test_averages.curr_bca
- Herd
average Current BCA for Fat – cmi_herd_test_averages.curr_bca
- Herd
average Current BCA for Pro – cmi_herd_test_averages.curr_bca
- Number
of ERA – counted from cmi_era_animals –
accumulated fiscal year-to-date value (from Oct 01)
- Number
of heifer breedings – counted from cmi_breedings
for animals currently flagged as heifers and serviced within one year
- Number
of heifer pregnancies – counted from cmi_pregnancies
for animals currently flagged as heifers and preg-checked
within one year
- Number
of uniquely identified heifers
– counted from cmi_herd_animals where sex = F and heifer_ind
= 1 and reg_id is not null
- Number
of id verified heifers – counted from cmi_herd_animals
where sex = F and heifer_ind = 1 and pedigree
status is “verified”
- Number
of males – counted from cmi_herd_animals
where sex = M
- Health
Events Recorded code – from cmi_herd_test_periods.health_events_recrd
- Health
Events Recorded – text description for cmi_herd_test_periods.health_events_recrd
- Number
of Health Events for retained placenta – counted from cmi_healths
for non-heifers and observed within one year
- Number
of Health Events for metritis – counted from cmi_healths for non-heifers and observed within one
year (includes acute, chronic and endometritis)
- Number
of Health Events for ovarian cysts – counted from cmi_healths
for non-heifers and observed within one year
- Number
of Health Events for mastitis – counted from cmi_healths
for non-heifers and observed within one year
- Number
of Health Events for lameness – counted from cmi_healths
for non-heifers and observed within one year (includes foot rot,
arthritis, sole bruise, sprain, laminitis, white-line, periarthritis,
bulb ulcer and sole ulcer)
- Number
of Health Events for ketosis – counted from cmi_healths
for non-heifers and observed within one year
- Number
of Health Events for milk fever – counted from cmi_healths
for non-heifers and observed within one year
- Number
of Health Events for displaced abomasum –
counted from cmi_healths for non-heifers and
observed within one year
- Turnaround
– Test to Herd header upload
- Turnaround
– Test to Lab header upload
- Turnaround
– Test to Match end date
- Turnaround
– Test to Mail