This entity represents all patients configured in the practice including species, breed, and demographic information. The attached contains the required format for the IPatient.CSV with a sample record.
The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.
Fields
Field Name | Required | Type | Description |
SiteID |
| nvarchar(MAX) | Id of site if more than one site location is being converted |
Name | Y | nvarchar(MAX) |
|
IsDeleted |
| bit |
|
DateOfBirth |
| datetime2(7) |
|
DateOfDeath |
| datetime2(7) |
|
SpeciesID |
| nvarchar(MAX) |
|
SpeciesCode | Y | nvarchar(MAX) | unique code used to identify the species. |
SpeciesDescription | Y | nvarchar(MAX) | Species description – may be the same as the SpeciesCode |
Allergy |
| nvarchar(MAX) |
|
Breed1Code | Y | nvarchar(MAX) | unique code used to identify the Breed. Breed.BreedCode example LabRet |
Breed1Description | Y | nvarchar(MAX) | Breed description –example: Labrador Retriever |
Breed2Code |
| nvarchar(MAX) |
|
Breed2Description |
| nvarchar(MAX) |
|
IsMixedBreed |
| bit |
|
ColorCode | Y | nvarchar(MAX) | unique code used to identify the color. Example: BlkWht |
ColorDescription | Y | nvarchar(MAX) | Color description – example: Black and White |
Markings |
| nvarchar(MAX) |
|
GenderID |
| nvarchar(MAX) |
|
GenderCode |
| nvarchar(MAX) |
|
GenderDescription |
| nvarchar(MAX) |
|
Weight |
| float |
|
WeightUnit |
| nvarchar(MAX) |
|
ProviderID |
| nvarchar(MAX) |
|
ProviderName |
| nvarchar(MAX) |
|
IsSpayedOrNeutered |
| bit |
|
IsDeceased |
| bit |
|
Inactive |
| bit |
|
SuspendReminders |
| bit |
|
EnteredDate |
| datetime2(7) |
|
FirstVisitDate |
| datetime2(7) |
|
LastVisitDate |
| datetime2(7) |
|
[Key] | Y | nvarchar(4000) | unique id for the record. This needs to be the same between trial and final |
PmsID | Y | nvarchar(MAX) | The can be the same as the key. |