Covered by this topic
This document explains how to import historical vital signs for employees into
What you will need:
- Spreadsheet software (Microsoft Excel or Google Sheets)
- Vital Signs CSV File Example
- end user with administrative rights
- 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).|
This is not automatically calculated during an import.
|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).|
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|
- 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.
- 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.
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.