Pre-Populate of LIMS

Animal Site Information—ISU VDL LIMS Pre-Populate Option

Premises identification numbers are the foundation of area regional disease control, FAD preparedness, and producer participation in the continuity of business programs (Secure Pork) being developed for the US Pork Industry. In the event of a foreign animal or reportable disease outbreak or for use in producer-driven herd health management initiatives, the premises ID would allow data to be linked within and between laboratories, databases, and area regional disease management tools. Additionally, the ISU VDL knows that our clients’ time is limited and valuable. In today’s data-driven world, our clients have a considerable amount of information to fill out, record, and enter on a daily basis, much of which is often repetitive.

The ISU VDL is committed to collecting accurate, meaningful data that is beneficial to our clients. In order to do this while encouraging the use of premises IDs and decreasing the time it takes to submit samples to the lab, the ISU VDL has created various methods to allow clients to fill out key parts of the submission form, which then auto-populate some of the other site-base fields when the case is entered at the diagnostic lab.

Client provides to the ISU VDL:

  • A spreadsheet (see template) of animal location (site) specific data to be uploaded and stored in ISU VDL LIMS database
  • When sending a diagnostic submission to the lab using the new ISU VDL submission forms, the client will provide one of the following (this information will be used to auto-populate the site address information)
    • Site name—in the form of the site number (if applicable) followed by the name
    • Premises ID barcode label

Benefit to clients:

  • Provides multiple different methods/options to include premise IDs on submission forms
    • Premise ID barcode label on form → auto-populates site name and address
      • For more information on ordering premises ID barcode labels, click here
    • Site Number/Name on form → auto-populates site address and premise ID
    • Web-submission ⇒ auto-populates site information and premise ID
  • Increases ease, speed, and accuracy when filling out submission forms
  • Decreases error by VDL case entry staff, increasing accuracy of information recorded into LIMS and sent out in reports to client
  • Decreases time to enter cases at the lab, decreasing turnaround time of reports/bills
  • Providing animal location information with every submission:
    • improves functionality for area regional disease management applications
    • allows clients and producers to effectively sort/categorize data

How to participate:

  • Click and download the spreadsheet template
  • Populate the fields with your site data
  • Email spreadsheet to isuvdl@iastate.edu with “Site Info LIMS Pre-Population” in the subject line

Questions:

For questions regarding the site information pre-population option, please contact Dr. Katie Woodard at kwoodard@iastate.edu or Jordan Bjustrom-Kraft at jnb@iastate.edu / 515-294-6128.

Download Template