Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldTypeLengthUniqueRequiredFormatDescription
identifiervarchar80yesyes
Patient ID
ownerclient_idvarchar255noyestable: clients-csv: company_identifier, field: identifierClient ID of patient owner
is_activeboolean
noyestrue/false

Is patient active. Source data may have various ways of classifying these patients. The most common examples for our system for inactive patients:
Deceased patients should be tagged as 'false' as they are classed as inactive in our system. 
Patients that the business no longer wants to service should also be classed as 'false'.
Patients that have been soft deleted in the source system should be classed as 'false'.

namevarchar50noyes
First name
speciesvarchar50nono
Animal species
gendervarchar10nono
Animal sexgender
neuteredboolean
nonotrue/falseIs animal neutered
date_of_birthtimestamp
nonoYYYY-MM-DDAnimal Date of birth


Example CSV-File: patients.csv