This entity represents file attachments associated with history records, patients, or clients. The attached contains the required format for the IAttachment.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 |
RelationshipID | Y | Nvarchar(max) | This represents the History record that the attachment is associated with. OR the patient id of the patient the image is of. |
RelationshipType | Y | nvarchar(4000) | Type of attachment "HistorylinesAttachments" or "Patient" or "Client" |
FileType | Y | Nvarchar(max) | This is the extension type of the file. '." + extensiontype |
Type | Y | Nvarchar(max) | ClientImage or "HistlineAttachments" or "PatientPhoto" |
Date | Y | Datetime(2) | Date time the service was provided |
Description | Y | Nvarchar(max) | Description of service/image |
Filebytes |
| varbinary(max) |
|
ObjectFilename | Y | Nvarchar(max) | This is the combined path and filename of the image referrenced in this record. Path +'/' + 'filename' |
Key |
| Nvarchar(max) | unique id for the record. This needs to be the same between trial and final |
PmsID |
| Nvarchar(max) | The can be the same as the key. |