SNOMED Transmission File

Field Definitions

 

Description
Data Type Comment XML Tag
Accession
numeric
Institutional specific numeric for unique visit or accession

accession_num

VMDB Institutional Code Number
char
VMDB assigned Institution Number
inst_id
Transaction Type
char
A for add, D for Delete, C for Correction, O for add and overwrite of patient signalment not visit data
trans_type
Medical Record
char
A institutional unique string not over 25 characters
pat_no
Species
numeric
SNOMED concept id (required if breed not included)
species
Breed
numeric
SNOMED concept id
breed
Date of Birth
Date/Time
Time Optional (When unknown leave blank)
date _of_birth
Gender
char

Institutional specific codes will be converted to standard VMDB codes.

  • C = male castrated
  • F = female intact
  • H = hermaphrodite
  • M = male intact
  • S = female spayed
  • U = unknown/not stated
  • X = multiple animals (litters/herds)
  • T = male, neuter status unknown
  • O = female, neuter status unknown
gender
Animal ID
char
Microchip, tattoo Maximum of 50 characters
animid
Chip Type
char
AVID, HomeAgain, etc
chip_type
Postal Code
char
US zip code or Canadian Postal Code
postal_code
Country*
char
ISO 3166-1 Country Codes, Only for non-US postal codes
country_code
Weight
numeric
weight_value
Unit of Measure
char
weight_unit
Admit Date
Date/Time
yyyymmdd:hhmm (required)
admit_dt
Discharge Date
Date/Time
yyyymmdd:hhmm (required)
discharge_dt
Discharge Clinician
char
Institutional specific code
clinician
Discharge status**
char
0=alive, 5=died, 6=euthanatized, 7=discharged and referred
discharge _disposition
SNOMED Concept
numeric
SNOMED Concept id
snomed
Recheck***
char
0=Initial Diagnosis, 1=Recheck
recheck
Suspect
numeric
0=Confirmed diagnosis, 1=Suspect or Probable
suspect
       

 

 


Additional Notes:

Necropsies should be coded and submitted using a SNOMED concept id

Line breaks and tabs, while not essential, make the document human readable.

We do not record color. There is no harm including it; it will be ignored for now.

There is no need to submit age. It is computed on the fly.

Some dates are formatted differently than others, however, consistent input will yield consistent results.

The order, suspect and recheck attributes of the concept_id element are optional. If left blank, suspect and recheck are set to "0".
If order is left blank, the order in which the concepts ids appear in the document is then used.

It is essential that, for a given snomed_group, either ALL or NONE of the concept_id elements have order attributes. The results are
undefined if some orders are defined and others are not.

 

For an example of the SNOMED transmission file click here