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 NameDescriptionRequirementData File Header
Employee IDEmployee Identifier. This field will be used for looking up the chart in WebChart , to insert or update.Requiredpatients.id
Test DatetimeDatetime vital signs were recorded. Must be in YYYY-MM-DD HH:MM:SS format.Best Practice@obs.*.observed_datetime
TemperatureDegree 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 UnitsDefault units are determined by the Preferred Unit System user setting, or they can be overridden. Choices are:
    • F = Fahrenheit
    • C = Celsius
Optional@obs.BODY TEMPERATURE.obs_units
HeightMeasurement from head to foot of a standing person. Provide a numeric value (e.g., 72).Best Practice@obs.BODY HEIGHT.obs_result
Height UnitsDefault units are determined by the Preferred Unite System user setting, or they can be overridden. Choices are:
    • in = Inches
    • cm = Centimeters
Optional@obs.BODY HEIGHT.obs_units
WeightThe heaviness of a person. Provide a numeric value (e.g., 150).Best Practice@obs.BODY WEIGHT.obs_result
Weight UnitsDefault units are determined by the Preferred Unite System user setting, or they can be overridden. Choices are:
    • lbs = Pounds
    • kg = Kilograms
Optional@obs.BODY HEIGHT.obs_units
BMIProvide 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 BPSupply a numeric value for Systolic Blood Pressure.Best Practice@obs.Systolic BP.obs_result
Diastolic BPSupply a numeric value for Diastolic Blood Pressure.Best Practice@obs.Diastolic BP.obs_result
BP SiteBody part from which blood pressure was taken. Valid choices are:
    • Left Arm
    • Right Arm
    • Left Leg
    • Right Leg
Best Practice@obs.BP Site.obs_result
PositionThe position of the patient when the BP was collected. Valid choices are:
    • Sitting
    • Standing
    • Supine
Best Practice@obs.Position.obs_result
Heart RateProvide a numeric value for Heart Rate as beats per minute (bpm).Best Practice@obs.HEART RATE.obs_result
Pulse RegularityPulse regularity choices:
    • Regular
    • Irregular
Best Practice@obs.Pulse Regularity.obs_result
Pulse SiteLocation where pulse was taken. Valid choices are:
    • Radial
    • Apical
    • Brachial
    • Carotid
    • Femoral
    • Pedal
Best Practice@obs.Pulse Site.obs_result
O2 SaturationProvide 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 RateProvide a numeric value for Respiration Rate as breaths per minute.Best Practice@obs.RESPIRATION RATE.obs_result
ExertionSpecific 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
Best Practice@obs.Exertion.obs_result
Pain SeverityProvide 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 Updated:

Last Build: Thu, 05 Dec 2024 18:17:23 UTC
WikiGDrive Version: 2aacb51f060d0354a678419290943a99bd16aad1