Create Vital Signs File for Import
Covered by this topic
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
- 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:
| Optional | @obs.BODY TEMPERATURE.obs_units |
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:
| Optional | @obs.BODY HEIGHT.obs_units |
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:
| Optional | @obs.BODY HEIGHT.obs_units |
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:
| Best Practice | @obs.BP Site.obs_result |
Position | The position of the patient when the BP was collected. Valid choices are:
| Best Practice | @obs.Position.obs_result |
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:
| Best Practice | @obs.Pulse Regularity.obs_result |
Pulse Site | Location where pulse was taken. Valid choices are:
| Best Practice | @obs.Pulse Site.obs_result |
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:
| Best Practice | @obs.Exertion.obs_result |
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.
- 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.
- Save the file as CSV format.
Upload Vital Signs CSV File
- Login as a user with administrator rights.
- Navigate to the Control Panel from the side menu.
- Select the Data Import tab.
- Select Chart Data CSV API from the drop-down menu and click Go.
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