Case Management CSV API
The following page defines data and fields that may be imported into MIE systems (WebChart, Enterprise Health) using the Case Management CSV API. A case encompasses a variety of data that is ultimately meant to generate an OSHA 300 log for occupational injuries and illness.
The following CSV APIs import information used to build a case:
- Restrictions Case Management CSV API
- Accommodations Case Management CSV API
- Conditions Case Management CSV API
- Nature of Injury Case Management CSV API
The Case Management CSV API includes encounter information, but a separate CSV API–Clinical Encounter CSV API is used when encounters are not imported as a part of a case.
Although data may be imported separately, the specifications outlined on this page include all of the CSV APIs listed above to create cases and generate an OSHA 300 log.
The abstract that follows should be presented to decision-makers or stakeholders interested in a general explanation of the Case Management CSV API. Technical details are provided in the remaining sections.
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.
The following screenshots show a simple CSV file, and the resulting case documents in an EH system. Example data is available on the tab “—-” in the specification (see link in Specification section of this page).
The following subsections outline situations in which cases are useful, and when they are not.
Importing Information Separately
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.
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.
The Clinical Encounter CSV API imports case-related data, such as how and where an injury occurred, but does not include data on how a workplace accommodates an injury. An incident is not required for an encounter.
Importing 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).
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.
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 sections outline requirements for importing 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.
Because the Case Management CSV API is broken up into multiple, related CSVs (sheets in the workbook), all of the fields marked required or best practice apply to the Case Management CSV API.
Since each page in the full Case Management CSV API spec also imports information separately, there is some overlap in what is required.
- Chart Identifier (encounters.pat_id): Links a chart to a patient.
- Chart ID Type (encounters.pat_id_type): Identifies the type of chart.
- Record External ID (encounters.ext_id): Number that identified the encounter in the previous system.
Performing User ID Type (encounters.performing_user_id_type): is conditionally required if the field Performing User ID (encounters.performing_user_id) is used to identify the user that performed the encounter.
The required IDs listed here serve to correctly identify the patient and link together all information pertinent to a case.
Although this information is not required, it is considered a best practice to use at least some of these fields to populate information in the header of a document for identification and organizational purposes.
The fields that follow are used to populate the OSHA 300 log.
- Visit Type (encounters.visit_type): Identifies how the encounter was performed (phone, office, etc.).
- Date of Service (enounters.serv_date): It is best practice to record the date of service for record keeping purposes.
- Encounter Closed (encounters.closed): Encounters that are flagged as closed cannot be opened as an encounter once imported into in EH.
- Case Date Time (incidents.inc_datetime):
- Case Type (incidents.case_type):
- Location Description (incidents.loc_description): The location description is a text description of where an incident occurred, and should be utilized with incidents.
- Work Related (incidents.osha_work_related): Flags injury as OSHA work-related.
- OSHA Reported Date (incidents.osha_completed_dt): Timestamp when incident was reported to OSHA.
- Injury/Illness Type (incidents.osha_itype): Maps to EH incident field “Injury/illness type”. Injury or illness type (OSHA list).
- Privacy Case (incidents.privacy_case): Flag if incident is sensitive. Name of employee is hidden on OSHA log.
- Workers’ compensation related (incidents.workcomp_completed_dt): Maps to EH incident field “Workers’ comp related.” Indicates that the incident is compensable by a work comp provider.
- Last date of work (incidents.date_last_worked): Datetime the employee last time worked before the incident.
- Time patient began work on day of injury/illness (incidents.employee_starttime): Maps to EH incident field “Time patient began work on day of injury/illness.” Time employee began shift on day of injury.
- Date supervisor notified (incidents.reported_super_datetime): Maps to EH incident field “Date/time supervisor notified"Datetime incident was reported to the employee’s supervisor.”
- Action employee performing before incident (incidents.comment_activity): Maps to EH incidents field “What was the employee doing just before the incident occurred?” Documents action employee was performing before incident happened. Corresponds to OSHA form.
- Incident Explanation (incidents.comment_explanation): Maps to EH incident field “What happened?” Explanation of how injury occurred. Corresponds to OSHA form.
- Incident Cause (incidents.comment_cause): Maps to EH incident field “What object or substance directly harmed the employee?” Object or substance that harmed the employee. Corresponds to OSHA form.
- Incident Status (incidents.status): Populates the “case/incident” in EH as opened or closed.
- California dwc 1 Form (incident_extended_fields.ca_dwc_1_form): Part of the California work comp form.
The EER diagram below identifies the database tables involved in creating cases in EH.
- Google spreadsheet
- This sheet has 5 tabs, one for each file type
Downloadable CSV versions are available:
- Encounters and Incidents Downloadable CSV
- Patient Conditions Downloadable CSV
- Patient Clinical Restriction Downloadable CSV
- Accommodations Downloadable CSV
- Incident Body Parts Downloadable CSV