Skip to main content Skip to navigation

Example Sold Cow Report for DHI-Plus® Rx-Plus

Download pdf version

 

Create a new Custom Report titled ‘Sold Cow Report’.

  • From the ‘Dictionary’ click and drag the following fields into the report:
    •  In the empty space under the ‘RXRECD’ column, right click and select ‘Field Width’. Enter ’90’ in the window that pops up, then click ‘OK’.
  • SCRselectionConfigure ‘Select Logic’ like that shown in the image to the right.
    • STATUS of 8 indicates that the cow or heifer was sold for beef.
    • The ‘?’ in LFTHDTE, will create a prompt to enter the date the cows were sold.  Typically it will be ‘TODAY’, however if there was a delay in running the report instead enter ‘TODAY – x’ where ‘x’ is however many days is required to obtain a report for the date the cows were sold.
  • To access the archived cows, configure ‘Multiple Paths’ by:
    • Clicking in the area under ‘List of Paths to Include’.
    • Go to ‘Browse’, click on the dairy’s current folder and click ‘OK’.
    • Repeat the above two steps, but instead of selecting the main folder, select the ARCH folder that appears when the folder is selected and then hit ‘OK’.
    • Click in the empty ‘Herd’ space within the first line, then go to the below space, ‘List of Herds to Include from Path’, and select the herd to use by clicking on it.
      • Hit ‘Include Herds’.
    • Repeat the above step for the second line in the ‘List of Paths to Include’.
    • Click ‘Save’.
    • Note: Once you have created this path, it will remain with this report until you change it.  You will have to recreate the path for each herd that you want to run this report for.

 

Run and print the Sold Cow Report. An example is shown below.

DHIPLUSSCR

 

The report displays when the cow or heifer is okay to beef (RXMEATOK).  The date the cow or heifer was sold (LFTHDTE) should be either equal to or past the RXMEATOK date.

In addition, there is a listing of all the Rx-Plus entries for the cows or heifer removed.  See RXRECORD KEY below to understand the information within the RXRECORD.

Let’s say that cow 156.1208 was sold on 7/31/12 instead of 8/2/12.  According to her RXRECORD she was started on 4 days of Banamine and Polyflex on 7/22/12, with a meat withdrawal of 6 days.  BUT WAIT, exclaims the dairy producer!  She stopped receiving treatment on 7/24/2012.  SO WHAT!!!  The dairy’s records indicate she was sold before her beef withdrawal date and showing a daily treatment sheet without her number on it to prove she didn’t get treated is not very compelling.  Possible solution to this problem:

Change the protocol in Rx-Plus to a one day treatment and record daily treatments.  This can fill up their cow display and creates more data entry work.  Nonetheless, some dairies using handhelds and that desire accountability for treatment like this approach.

Some might think that so much effort, just to prove to the FDA that you are properly managing your dairy to avoid residues, is unnecessary.  We agree! The effort in recording treatments accurately and consistently is expended to ensure the consistent, effective implementation of best management practices on the dairy.  That process just happens to also provide the evidence of proper drug use FDA looks for on the outside chance they come to your farm when investigating a cow with a residue.

 


RXRECORD KEY:

condition: protocol.drug{dose,route^,frequency,*first treatment day start.frequency, milk withhold, meat withhold}(/days on protocol)pen, milk

drug – if different than the protocol name otherwise ”

^with limb or quarter if applicable