Skip to content

Latest commit

 

History

History
213 lines (190 loc) · 8.44 KB

create-vital-signs-file-for-import.md

File metadata and controls

213 lines (190 loc) · 8.44 KB
id title date version lastAuthor mimeType links source wikigdrive
1SsFJhFp4cUoRKLIULnvccNLyYB7TpnevOHj4EJMwSJU
Create Vital Signs File for Import
2020-03-17T02:50:33.797Z
43
text/x-markdown
0008bcbb1563384efe0a28ada6f97e9432e65f10

This document explains how to import historical vital signs for employees into {{% system-name %}} .

What you will need:

  • Spreadsheet software (Microsoft Excel or Google Sheets)
  • Vital Signs CSV File Example
  • {{% system-name %}} 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 {{% system-name %}} , 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
 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:
    • in = Inches
    • cm = Centimeters
 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:
    • lbs = Pounds
    • kg = Kilograms
 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.
{{% /warning %}}		 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
 Best Practice @obs.BP Site.obs_result
Position The position of the patient when the BP was collected. Valid choices are:
    • Sitting
    • Standing
    • Supine
 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:
    • Regular
    • Irregular
 Best Practice @obs.Pulse Regularity.obs_result
Pulse Site Location where pulse was taken. Valid choices are:
    • Radial
    • Apical
    • Brachial
    • Carotid
    • Femoral
    • Pedal
 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 (%).
{{% /note %}}		 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
 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. {{% /tip %}}

  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.* {{% /tip %}}

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.