Panel Status Import
The following page defines data and fields that may be imported into MIE systems (WebChart, Enterprise Health) to create patient panel status records using the Panel Status CSV API.
The abstract that follows should be presented to decision-makers or stakeholders interested in a general explanation of the Panel Status CSV API. Technical details are provided in the remaining sections.
The Panel Status CSV API imports discrete employee panel status records.
It is valuable to recognize the following terminology as it pertains to MIE systems:
- A chart is a patient’s electronic medical information organized in tabular form. A chart is simply a way to collect different information on one topic, just like a physical patient chart would contain a variety of information on an individual patient.
- A panel is a group of one-time or recurring testing items to performed for a person.
- A panel membership is the assignment of a person to a panel. It can be assigned based on the kind of work that a person does, the materials they handle, the environment in which they work, or other factors.
- A panel status indicates an person’s current or historical fitness for doing the work that requires their membership in a particular panel. Also indicates when testing will be due next.
CSV refers to the type of file and format of data needed to import information into an EH system. API refers to how the data interacts with the EH system. See the Import Overview page for a more detailed explanation of terminology.
The following sections provide insight for technical personnel working with the provided import specifications. Although the specifications provided include details on each field utilized in the import, the sections below include further discussion on best practices for imported data to provide the best functionality in Enterprise Health.
Note: The specification may be downloaded as Excel, CSV, or duplicated as an online spreadsheet under the File menu.
Additionally, user instructions are available for importing data in EH.
Column Definitions and Specific Coded Values
Definitions for the columns utilized in the specification, as well as commonly used specific coded values appear on the Data Import Standards page.
The following fields (indicated in the Data Name column) are noted as required (R) or are recommended as best practice (BP) in the Panel Status CSV API specification. Additional details and considerations are provided here.
The following fields are required:
- Chart ID (patient_panel_status.pat_id) and Chart ID Type patient_panel_status.pat_id_type) are used to to correctly identify a chart.
- External ID identifies a record in the original data source (i.e., this is often the primary or unique key on the table of the legacy database that is being migrated to the MIE system).
- Panel ID identifies which panel the status applies to
- Rec Status should be marked as current for the most recent status for each unique chart+panel combination. All others should be marked as history.
- Status indicates a person’s progress through the testing process. “In-Flight” individuals, meaning those who were scheduled for testing by a different employee health system, but have not yet completed it, could be marked as pending or overdue. Other people that do not yet have scheduled testing could be marked as complete or one of the other statuses.
- Next Due is conditionally required, based on the panel. An annual or otherwise recurring panel should have a next due date marked so that the system knows when to initiate future testing. A one-time panel, such as an acute exposure group, could leave this field blank except for those people who are considered “In-Flight”.
Although this information is not required, it is considered a best practice to use them:
- Effective Date (patient_panel_status.effective_dt) is the date that a final status went into effect.
These fields are optional:
- Review Date (patient_panel_status.review_dt) is the date when a status determination was made.
- Create Date (patient_panel_status.create_dt) is the date when a status record was created.
- Creating Provider ID (patient_panel_status.create_user_id) along with Creating Provider ID Type (patient_panel_status.create_user_id_type) identify the provider who added the status to the system.
- Panel Membership Start Date (patient_panel_status.pm_start_dt) is the date when the patient started membership in the panel.
Unless otherwise specified, validation between the previous system and the new EH system requires the client to provide a number of test patients. This data can be compared in the previous system and EH using the validation test script.