Page Comparison

Field	Type	Length	Unique	requiredRequired	Format	Description
customer_identifier	varchar	80	yes	yes		Patient ID
ownerclient_id	varchar	255	no	yes	table: clients-csv: company_identifier, field: identifier	Client ID of patient owner
is_active	boolean		no	yes	true/false	Is patient active person_given_ . 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
animal_species	varchar	50	no	no		Animal species
person_gender	varchar	10	no	no		Animal sexgender
animal_neutered	boolean		no	no	true/false	Is animal neutered
persondate_of_birth_date	timestamp		no	no	YYYY-MM-DD	Animal Date of birth

Example CSV-File: patients.csv

Versions Compared