Create Vital Signs File for Import

This document explains how to import historical vital signs for employees into WebChart .

What you will need:

  • Spreadsheet software (Microsoft Excel or Google Sheets)
  • Vital Signs CSV File Example

WebChart end user with administrative rights

Create Vital Signs CSV File

  1. The following table provides optional or required Field Names and Descriptions, as indicated by the Requirement column. Items marked as Best Practice or Optional are not required and may be left blank or omitted entirely. Employee ID must be the first column in the CSV file. The order of the remaining fields does not matter.
**Field Name** **Description** **Requirement** Data File Header
Employee ID Employee Identifier. This field will be used for looking up the chart in WebChart , to insert or update. **Required** patients.id
Test Datetime Datetime vital signs were recorded. Must be in YYYY-MM-DD HH:MM:SS format. Best Practice @obs.*.observed_datetime
Temperature Degree of hotness or coldness of the body. Provide a numeric value (e.g., 98.6 or 101). Best Practice @obs.BODY TEMPERATURE.obs_result
Temperature Units Default units are determined by the Preferred Unit System user setting, or they can be overridden. Choices are:
* **F** = Fahrenheit
* **C** = Celsius
</td>
<td>Optional</td>
<td>@obs.BODY TEMPERATURE.obs_units</td>
Height Measurement from head to foot of a standing person. Provide a numeric value (e.g., 72). Best Practice @obs.BODY HEIGHT.obs_result
Height Units Default units are determined by the Preferred Unite System user setting, or they can be overridden. Choices are:
* **in** = Inches
* **cm** = Centimeters
</td>
<td>Optional</td>
<td>@obs.BODY HEIGHT.obs_units</td>
Weight The heaviness of a person. Provide a numeric value (e.g., 150). Best Practice @obs.BODY WEIGHT.obs_result
Weight Units Default units are determined by the Preferred Unite System user setting, or they can be overridden. Choices are:
* **lbs** = Pounds
* **kg** = Kilograms
</td>
<td>Optional</td>
<td>@obs.BODY HEIGHT.obs_units</td>
BMI Provide a numeric value for Body Mass Index (e.g., 22.45).
Warning
This is not automatically calculated during an import.
Best Practice @obs.BMI.obs_result
Systolic BP Supply a numeric value for Systolic Blood Pressure. Best Practice @obs.Systolic BP.obs_result
Diastolic BP Supply a numeric value for Diastolic Blood Pressure. Best Practice @obs.Diastolic BP.obs_result
BP Site Body part from which blood pressure was taken. Valid choices are:
* Left Arm
* Right Arm
* Left Leg
* Right Leg
</td>
<td>Best Practice</td>
<td>@obs.BP Site.obs_result</td>
Position The position of the patient when the BP was collected. Valid choices are:
* Sitting
* Standing
* Supine
</td>
<td>Best Practice</td>
<td>@obs.Position.obs_result</td>
Heart Rate Provide a numeric value for Heart Rate as beats per minute (bpm). Best Practice @obs.HEART RATE.obs_result
Pulse Regularity Pulse regularity choices:
* Regular
* Irregular
</td>
<td>Best Practice</td>
<td>@obs.Pulse Regularity.obs_result</td>
Pulse Site Location where pulse was taken. Valid choices are:
* Radial
* Apical
* Brachial
* Carotid
* Femoral
* Pedal
</td>
<td>Best Practice</td>
<td>@obs.Pulse Site.obs_result</td>
O2 Saturation Provide a numeric value for Oxygen Saturation percentage (e.g., 96 or 98.5).
Note
Do not provide the percentage sign (%).
Best Practice @obs.O2 Saturation.obs_result
Respiration Rate Provide a numeric value for Respiration Rate as breaths per minute. Best Practice @obs.RESPIRATION RATE.obs_result
Exertion Specific exertion, as it relates to the respiration rate. Valid choices are:
* Resting
* Immediately after exertion
* 1 minute after exertion
* 2 minute after exertion
* 3 minute after exertion
* Sleeping
</td>
<td>Best Practice</td>
<td>@obs.Exertion.obs_result</td>
Pain Severity Provide a whole number from 0-10. 0 is no pain, and 10 is extreme pain. Best Practice @obs.Pain Severity.obs_result
Tip
For a more comprehensive list of supported fields, please refer to the Vital Signs CSV API Specification.
  1. Using the table, above, determine the data to be imported. Starting with the Employee ID field, enter all required and desired data, verifying required data is present. Note that each row represents an employee record. Below is a screenshot of the Vital Signs CSV File Example for guidance.

  1. Save the file as CSV format.

Upload Vital Signs CSV File

  1. Login as a user with administrator rights.
  2. Navigate to the Control Panel from the side menu.

  1. Select the Data Import tab.

  1. Select Chart Data CSV API from the drop-down menu and click Go.

  1. Select the Vital Signs CSV File and click Upload.
Tip
For extra information on what happens during the import, click the Verbose checkbox.

Resources

Troubleshooting

Ensure that all of the fields marked as Required have valid content. The file uploaded must be saved as a CSV formatted file. In case of any errors, contact Technical Support.

WebChart Documentation
Last Build: Wed, 08 Sep 2021 00:25:59 EDT Legacy Documentation