Exporting Patient Records

To export patient data for use in an external application, on the Patient Select screen click the Export Records button. The Export Patient Data dialog box presents you with a number of export options:

	Scope Choose to export patient data for the currently selected patient, or for all patients in the units you have permission to access.
	File type You can export the data in one of the following file types: Excel 2003 Spreadsheet (.xml): the data is formatted to be read by Microsoft Excel 2003 or later, or prior versions with the Microsoft Office Compatibility Pack for Word, Excel and PowerPoint File Formats installed. Comma (,) Delimited (.csv): text file, with a comma (,) used to separate patient data fields in the exported file Pipe (\|) Delimited (.csv): text file, with a pipe (\|) used to separate patient data fields in the exported file Underscore (_) Delimited (.csv): text file, with an underscore (_) used to separate patient data fields in the exported file Asterisk () Delimited (.csv): text file, with an asterisk () used to separate patient data fields in the exported file
	Measurements Choose between exporting Assessment Summary and/or Image summary measurement. See Measurement and Note Options.
	Notes Choose whether to export patient, Visit, and Wound Level notes. See Measurement and Note Options.

Measurement and Notes Options

You need to select at least one of the measurement or notes options in order to export data. If you select more than one option, the different options will appear as different sheets in the Excel file; or, if you selected a delimited file, the different options will be contained in a zip file containing one .csv file for each export option.

Assessment Summary

The Assessment Summary option exports a wound assessment level summary of all assessments captured with SilhouetteStar. For each wound assessment the export contains:

Patient details, such as name, address, Patient ID, date of birth, and gender
The wound label, anatomical site, assessment number, assessment date and time, and state (open or healed)
The wound's area, area reduction, island area, perimeter, depth (max and mean), volume, and tissue types
Wound notes, if enabled via the Include Wound Notes in Summary Export organization setting
The axes (length and width) of each fragment and each ruler measurement

Note that the Assessment Summary present the wound measurements at the assessment level. For example, when two or more images are required to assess the area of a large wound, a single area measurement figure is displayed.

Image Summary

The Image Summary option exports an image level summary of all assessments captured with SilhouetteStar. For each image the export contains:

Patient details, such as name, address, Patient ID, date of birth, and gender
The wound label, anatomical site, assessment number and assessment date and time
The image number, capture date and time, the number of fragments, the number of islands, and state (open or healed)
The wound's area, area reduction, island area, perimeter, depth (max and mean), volume, and tissue types
The axes (length and width) of each fragment and each ruler measurement

So in contrast to the Assessment Summary which presents measurements at the assessment level, the Image Summary presents measurements at the image level.

Customizing the Displayed Measurements

The types of measurements displayed is configurable via the SilhouetteCentral Organization Settings. Any number of measurement types can be chosen (or hidden) from the following list: time, area, area reduction, island area, perimeter, axes (length and width), rulers, maximum depth, mean depth, volume, and tissue types.

For the measurement type to be included in the exported data file, it must be displayed somewhere within the Silhouette user interface.

For details on how the individual image and assessment level measurements are calculated, refer to the How Silhouette Works document.

Patient Notes

The Patient Notes option exports information extracted from the patient notes fields. In addition to the patient identity fields (name, address, Patient ID, date of birth, and gender), there are four columns:

Group
Item
Value
Changed

Each entry in the patient notes will appear as a row in the exported report, with the note's section label in the Group column, the label for the note in the Item column, the note's selected option or measurement in the Value column, and the date of the last update in the Changed column.

Visit Notes

The Visit Notes option exports information extracted from the visit notes fields. In addition to the patient identity fields (name, address, Patient ID, date of birth, and gender), there are five columns:

Visit
Group
Item
Value
Changed

Each entry in the visit notes will appear as a row in the exported report. The date of each visit is listed in the Visit column, the note's section label in the Group column, the label for the note in the Item column, the note's selected option or measurement in the Value column, and the date of the last update in the Changed column.

Wound Notes

The Wound Notes option exports information extracted from the wound notes fields. In addition to the patient identity fields, there are seven columns:

Wound
Assessment
Visit
Group
Item
Value
Changed

Each entry in the wound notes will appear as a row in the exported report. Each wound is identified in the Wound column, and alongside in the Assessment column is the date and time for each assessment. The note's section label appears in the Group column, the label for the note in the Item column, the note's selected option or measurement in the Value column, and the date of the last update in the Changed column. Note that the Wound Notes can also appear in the Assessment Summary if enabled via the Include Wound Notes in Summary Export organization setting.