Data overview: Laboratory data

Submission data

  • Date submitted
  • Reason (dagnostic, surveillance, veterinary public health, etc)
  • Laboratory submission ID (Epi Number)
  • Laboratory
  • Case ID
  • Location
  • Submitter details
    • Submitter type
    • Submitter name
    • Submitter address
    • Submitter phone

Data Tables

Reference Tables

Owner data data

  • Owner type
  • Owner name
  • Owner address
  • Owner phone
  • Owner userid

Data Tables

Animals

  • Animal ID
  • Species/breed
  • Sex
  • Age
  • Age units

Data tables

Reference tables

Vaccination history

  • Animal ID
  • Disease
  • Vaccine
  • Vaccination date

Data tables

Reference tables

Specimens

  • Specimen type (part of the animal etc)
  • Specimen form (preservative, handling etc)

Data tables

Reference tables

Tests

  • Specimen tested
  • Test name
  • Target (pathogen etc)
  • Method
  • Date tested
  • Accredited

Data tables

Reference tables

  • TestTypes
    • List of tests
  • Targets
    • Test targets (the thing that they are looking for)
  • Methods
  • LabTests
    • List of tests used by each laboratory, with references, accreditation etc.

Results

  • Quantitative finding
  • Qualitative finding
  • Uncertainty (less than, more than, too many to be counted, approximately)
  • Result

Data Tables

Reference Tables