Patients (Veterinary Systems only)

Field	Type	Length	Unique	Required	Format	Description
identifier	varchar	80	yes	yes		Patient ID
client_id	varchar	255	no	yes	table: clients, field: identifier	Client ID of patient owner
is_active	boolean		no	yes	true/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'.
name	varchar	50	no	yes		First name
species	varchar	50	no	no		Animal species
gender	varchar	10	no	no		Animal gender
neutered	boolean		no	no	true/false	Is animal neutered
date_of_birth	timestamp		no	no	YYYY-MM-DD	Animal Date of birth

Example CSV-File: patients.csv

ProfitDiagnostix Public knowledge base