Create Health Surveillance File for Import
Covered by this topic
This document explains how to import your health surveillance data into WebChart .
What you will need:
- Spreadsheet software (Microsoft Excel or Google Sheets)
- Health Surveillance CSV File Example
WebChart end user with administrative rights
Create Health Surveillance 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.Note Required and Best Practice columns for the Health Surveillance CSV file.
| Field Name | Description | Requirement | Column Header Name |
| Employee ID | Employee Identifier | Required | patient_panel_status.pat_id |
| External ID | Required | patient_panel_status.ext_id | |
| Panel ID | Required | patient_panel_status.panel_id | |
| Surveillance Schedule Status | Possible values: current history deleted | Required | patient_panel_status.rec_status |
| Test Outcome Status | Possible values: pending complete fit fitrestrict: Fit with restrictions notfit overdue failcomply: Failure to comply | Required | patient_panel_status.status |
| Effective Date | When the status went into effect | Best Practice | patient_panel_status.effective_dt |
| Next Due | Next due date for panel | Best Practice | patient_panel_status.next_due |
| Panel Membership Start Date | If a date is provided, this chart will be added as a member to the panel effective the specified start date. If the chart is not an active member of the panel (EG, the record is historical), then no Panel Membership Start Date should be specified. | Best Practice | patient_panel_status.pm_start_dt |
Tip
For a more comprehensive list of supported fields, please refer to the Patient Panel Status 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 Health Surveillance CSV File Example for guidance.
- Save the file as CSV format.
Upload Health Surveillance CSV File
- Login as a user with administrator rights.
- Navigate to the Control Panel from the side menu.
- Select the Data Import tab.
- Select Patient Panel Status CSV API from the drop-down menu and click Go.
- Select the Health Surveillance CSV File and click Upload.
Tip
For extra information on what happens during the import, click the Verbose* checkbox.*
Resources
- Patient Panel Status CSV API Specification
- Health Surveillance CSV File Example
- Health Surveillance Validation Instructions
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