Restrictions CSV API

The following page defines data and fields that may be imported into MIE systems (WebChart, Enterprise Health) for restrictions using the Case Management CSV API .
The following CSV APIs import information used to build a case:

• Encounters/Incidents
• Restrictions Case Management CSV API
• Accommodations Case Management CSV API
• Conditions Case Management CSV API
• Nature of Injury Case Management CSV API

Audience

The abstract that follows should be presented to decision-makers or stakeholders interested in a general explanation of the Clinical Encounter CSV API. Technical details are provided in the remaining sections.

Abstract

The Case Management CSV API is used to import information related to an employee’s (patient’s) condition, accommodation, and lost time from an existing system.
It is valuable to recognize the following terminology as it pertains to MIE systems:

• An accommodation is modification that allows an employee to continue working, or lost time (worker’s comp plan) available for an employee who cannot work after an incident.
• A case is a full report of a workplace injury, or incident, for an employee (patient). The case is created in an initial visit (encounter), and is then linked to subsequent visits. A case links all follow up visits (encounters), restrictions, accommodations, conditions, and nature of injury information. All of the documents pertaining to the case are grouped together within the patient’s chart for reporting purposes. There are several case types, which designate different required fields as well as state specific incident questions and forms. The terms case and incident may be used interchangeably in an MIE system.
• A condition in an MIE system records a patient’s health/medical problem, recorded using the appropriate medical coding (ICD9/10, SNOMED, etc.).
• An encounter documents a visit with a employee, and is also known as a patient visit. All aspects of the visit are covered in the encounter, such as the history of present illness, case/incident information, past medical history, medications, allergies, review of systems, vitals, tests and procedures, physical exam, assessment, restrictions/accommodations, plan and follow up information.
• The term incident refers to the workplace injury that opens a case for an employee. The database table in an MIE system where information on the injury is recorded is the incidents table. When an incident date is entered in the incidents table, a case is created. The terms case and incident may be used interchangeably in an MIE system, because an incident creates a case.
• Lost time is the period of time that an employee (patient) is away from work due to an injury.
• Nature of injury codes and body part codes are combined in a case to create the incident nature of injury body part ID (nibp_id) in an MIE system.
• In occupational health, a restriction (clinical restriction) refers to an activity that an employee (patient) is not permitted to do after an injury (incident). 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.

Workflow Considerations

The following subsections outline situations in which cases are useful, and when they are not.

Importing Restriction Information Separately

Case management in EH was built to collect data for OSHA 300 logs. Clients that are not required to keep OSHA 300 logs may not need to use the Case Management CSV API. Depending on the way the client uses the MIE system, the imported information may be included in an encounter, restriction, accommodation, condition, or nature of injury information for a patient.
It is possible to import restriction data separately. See a developer for more details.

Importing Restriction Information as Part of a Case

Not all encounters are part of a case, but a case is always created when an incident is created in the system. The Case Management CSV API requires an incident date (incidents.inc_datetime).
A major advantage of using the Case Management CSV API is that once data is imported, all information related to case is in the system, not just visits (encounters).

Specifications

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.
Case Management CSV API specifications are available here .
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.

Field Requirements

The following sections outline requirements for importing restriction data related to case management. The Case Management CSV API utilizes data from multiple locations to track the progress of a workplace injury or illness by building a case for the patient.

Required

Since each page in the full Case Management CSV API spec also imports information separately, there is some overlap in what is required.
The following fields are required to import conditions data:

• External ID (incident_nibp.ext_id): This external ID matches the ID from the source system to a nature of injury body part (nibp).
• Patient Clinical Restriction External ID (patient_clinical_restriction.ext_id): External identifier, typically populated by third party interfaces, used to link up a chart to encounter, and to populate an OSHA 300 log. Either the Injury Description (incident_nibp.nature_injury) - a text description of the injury OR the Body Part Description (incident_nibp.body_part) - a text description of the injured body part is required. These two fields are considered conditionally required, as only one or the other is needed.
  Enforcing User ID Type (patient_clinical_restriction.enforcing_provider) is conditionally required if the field Enforcing User ID (patient_clinical_restriction.enforcing_user_id) is used to identify the user that enforced or created the restriction for the patient.
  The required IDs listed here serve to correctly identify the patient and link together all information pertinent to a case.

Examples

• Patient Clinical Restriction Downloadable CSV

Validation

Related Pages

• Data Import Master List
• Case Management CSV API
• Clinical Encounter CSV API
• Accommodations CSV API
• Conditions CSV API
• Nature of Injury CSV API