animal

The animal table holds a row for each animal on the system. Various denormalised fields at the end are used to track the current movement, whether the animal is on shelter, etc. These are useful for writing reports.

Name	Type	Description
ID	INTEGER	A unique, incrementing number that identifies this record
AnimalTypeID	INTEGER	Link to the animaltype table
AnimalName	VARCHAR	The animal's name
NonShelterAnimal	INTEGER	1 if the animal is a non-shelter animal (kept out of figures)
CrueltyCase	INTEGER	1 if the animal is a cruelty case (all 0/1 fields link to lksyesno table)
BondedAnimalID	INTEGER	Animal ID of bonded animal 1 (or 0)
BondedAnimal2ID	INTEGER	Animal ID of bonded animal 2 (or 0)
BaseColourID	INTEGER	Link to the basecolour table
SpeciesID	INTEGER	Link to the species table
BreedID	INTEGER	Primary breed (link to the breed table)
Breed2ID	INTEGER	Secondary breed (same as primary if not crossbreed)
BreedName	VARCHAR	Name of breed in form breed1 / breed2 if crossbreed
CrossBreed	INTEGER	1 if animal is a crossbreed
CoatType	INTEGER	Link to lkcoattype table
Markings	VARCHAR	Distinguishing features field
ShelterCode	VARCHAR	The animal's shelter code
ShortCode	VARCHAR	The short version of the shelter code
UniqueCodeID	INTEGER	The next UUU code can be generated by doing MAX(UniqueCodeID)
YearCodeID	INTEGER	The next NNN code is MAX(YearCodeID) for matching brought in year and type
AcceptanceNumber	VARCHAR	The acceptance number/Litter ID
DateOfBirth	TIMESTAMP	The animal's date of birth
AgeGroup	VARCHAR	The animal's age group based on date of birth
DeceasedDate	TIMESTAMP	Date the animal died, if null the animal is still alive
Sex	INTEGER	Link to the lksex table
Identichipped	INTEGER	1 if the animal is microchipped
IdentichipNumber	VARCHAR	The animal's microchip number
IdentichipDate	TIMESTAMP	The date the animal was microchipped
Tattoo	INTEGER	1 if the animal has an ear tattoo
TattooNumber	VARCHAR	The animal's tattoo number
TattooDate	TIMESTAMP	The date the animal was tattooed
Neutered	INTEGER	1 if the animal has been neutered/spayed
NeuteredDate	TIMESTAMP	The date the animal was neutered/spayed
CombiTested	INTEGER	1 if the animal has been combi tested (FIV/L tested for US locale)
CombiTestDate	TIMESTAMP	The date of the combi/FIV/L test
CombiTestResult	INTEGER	The combi result or FIV result for US (link to lksposneg table)
FLVTestResult	INTEGER	The FLV result for US locale
HeartwormTested	INTEGER	1 if the animal has been heartworm tested
HeartwormTestDate	TIMESTAMP	Date of the heartworm test
HeartwormTestResult	INTEGER	The result (link to lksposneg table)
Declawed	INTEGER	1 if the animal has been declawed
HiddenAnimalDetails	VARCHAR	Hidden animal comments
AnimalComments	VARCHAR	The animal's comments
OwnersVetID	INTEGER	Link to the owner's vet (owner table, 0 for no value)
CurrentVetID	INTEGER	Link to the current vet (owner table, 0 for no value)
OriginalOwnerID	INTEGER	Link to the original owner (owner table)
BroughtInByOwnerID	INTEGER	Link to the owner who brought the animal in (owner table)
ReasonForEntry	VARCHAR	Freeform text, reason animal was brought to shelter
ReasonNO	VARCHAR	Freeform text, reason original owner didn't bring the animal in
DateBroughtIn	TIMESTAMP	The date the animal was brought into the shelter
EntryReasonID	INTEGER	Reason for entry (link to entryreason table)
HealthProblems	VARCHAR	Health problems box on Vet tab
PutToSleep	INTEGER	1 if the animal was euthanised
PTSReason	VARCHAR	Freeform text, reason the animal died
PTSReasonID	INTEGER	Euthanasia category - link to deathreason table
IsDOA	INTEGER	1 if the animal was dead on arrival to the shelter
IsTransfer	INTEGER	1 if the animal was a transfer from another animal shelter
IsGoodWithCats	INTEGER	Link to the lksyesnoun table for yes/no/unknown
IsGoodWithDogs	INTEGER	Link to the lksyesnoun table for yes/no/unknown
IsGoodWithChildren	INTEGER	Link to the lksyesnoun table for yes/no/unknown
IsHouseTrained	INTEGER	Link to the lksyesnoun table for yes/no/unknown
IsNotAvailableForAdoption	INTEGER	1 if the animal should not be included for publishing as adoptable
HasSpecialNeeds	INTEGER	1 if the animal has special needs
ShelterLocation	INTEGER	Location on shelter (link to internallocation table)
DiedOffShelter	INTEGER	1 if the animal died off shelter (won't be included on figures reports)
Size	INTEGER	animal's size (link to lksize table)
RabiesTag	VARCHAR	The rabies tag field
Archived	INTEGER	1 if the animal is off shelter now
ActiveMovementID	INTEGER	Link to the adoption table for the latest movement for this animal
ActiveMovementType	INTEGER	Link to lksmovementtype for the current movement type
ActiveMovementDate	TIMESTAMP	The current movement date
ActiveMovementReturn	TIMESTAMP	The current movement's return date
HasActiveReserve	INTEGER	1 if the animal has an open reservation
MostRecentEntryDate	TIMESTAMP	The most recent entry date - either DateBroughtIn or ActiveMovementDate
TimeOnShelter	VARCHAR	Readable time spent on shelter (eg: 1 year, 3 months)
DaysOnShelter	INTEGER	Number of days spent on shelter
DailyBoardingCost	FLOAT	The cost of one days board on shelter for this animal
AnimalAge	VARCHAR	Readable animal age (eg: 1 year, 3 months)
RecordVersion	INTEGER	For optimistic locking, each save increments this lock value
CreatedBy	VARCHAR	Name of user that created this record
CreatedDate	TIMESTAMP	Date this record was created
LastChangedBy	VARCHAR	Name of user that last changed this record
LastChangedDate	TIMESTAMP	Date this record was last changed