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
- Owners
first name cmi_contacts.first_name
- Owners
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