This entity represents the relationship between clients and their associated patients. The attached contains the required format for the IClientPatientRelationship.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 |
ClientD | Y | nvarchar(MAX) | Client Key from IClient |
PatientID | Y | nvarchar(MAX) | Patient Key from IPatient |
ClientPmsID |
| nvarchar(MAX) | Client PmsID from IClient |
PatientPmsID | Y | nvarchar(MAX) | Patient PmsID from IPatient |
Type |
| nvarchar(MAX) | Default is Owner |
Percentage | Y | integer | Default is 100, multiple clients with the same Patient ID will total 100 |
IsPrimary |
| boolean | Default is 1, multiple clients only 1 can have IsPrimary=1 |
[Key] |
| nvarchar(4000) | Unique record ID |
PmsID |
| nvarchar(MAX) | Unique record ID |