FEM: Data Exports

Table of Contents

• Navigation
  • Overview: Individual Data Downloads
  • Modules: Bulk Data Downloads
• Getting Started - Data Downloads
• How to access Hidden Columns
• Data Download File Types
• FAQs
• Data Dictionary Downloads

Data exports are downloaded from the Worldly platform on the Dashboard and the Modules pages.

• The Dashboard provides a main overview of the module
• Modules provides a table of all of your modules

Navigation

Access an individual data download by navigating to the Dashboard page, or access bulk downloads by navigating to the Modules page.

Overview: Individual Data Downloads

1. In the top navigation bar, select Assessments, followed by Higg FEM.
   
2. On the Dashboard page, select the specific FEM year from the dropdown menu.
   
3. Select Data Downloads in the left-hand side bar.

Modules: Bulk Data Downloads

1. In the top navigation bar, select Assessments, followed by Higg FEM.
   
    
2. Select the Modules tab, followed by the desired FEM Modules from the All Modules table.
   
    
3. Select Download from the table.

Getting Started - Data Downloads

All modules are available for individual download. You can bulk download by clicking the check mark next to multiple FEM assessments from different facilities and different cadence years. 

To understand and analyze your data downloads, we recommend the following:

1. Begin with the Meta file, which provides a high level summary of shared assessments such as details about the facilities and dates of completion. This file does not include FEM answers.
2. Review the Performance file to see scores and quantitative information with simplified and readable column names.
3. Next, do a deep dive with the Quantitative Impacts file to understand facility resource usage and impact metrics such as water, energy, and greenhouse gas emissions.
4. Lastly, look up information in Raw Responses, which provides data on all questions about the facility from specific sections such as the Air Emissions, Energy, or Waste sections.

How to access Hidden Columns

If you don't see a column in the All Modules table, follow these directions to access hidden columns:

1. On the Modules tab, click on the upper right corner of the All Modules table.
   
    
2. In the drop down menu, use the toggle to hide/show each column.
   
    
3. Click Reset Columns to return to the standard view of the table. (i.e. 12 columns are hidden)
   
4. Select Save Columns to save a specific column configuration. 
   

Data Download File Details

Table

Use this export to view all columns from the Modules table. This export will include only the records selected from the Modules page.

Bulk CSV V2

The Bulk CSV V2 download option is available for analyzing previous module year data. 

Use this export to view fields from previous V2 exports with 2023 data. This export does not contain the new columns introduced with the new FEM methodology. The new data can be found in the section raw response exports.

While there is no bulk csv available for FEM2023 containing all FEM data in one assessment due to the new FEM4.0 assessment exceeding the size of one excel file, it is possible to download all FEM data points in multiple excel downloads.

Performance CSV

The Performance CSV is the most cleaned, readable, and user-friendly assessment export that holds most relevant quantitative impact and general facility information. It provides information on scores and quantitative information with simplified and readable column names. This file is unique for two reasons:

1. It can recognize whether an assessment has been verified (status = VRF)
2. It will fill in verifier values for data points that were corrected by the verifier

This CSV file is distinct from others, because other reports present both verifier and facility data points regardless of assessment status. In other words, any data points deemed incorrect by a verifier will be replaced within the Performance CSV with the corrected answer. 

This difference can lead to user confusion, as one REFID can have multiple “responses” in the exports. Using the Performance CSV will ensure that you are using the correct value every time.

Lastly, download the FEM Performance CSV Data Dictionary at the bottom of this page, which will help you navigate the Performance CSV. In this dictionary, you can look up characteristics such as description and question-type of all calculated fields in the FEM Performance CSV file, identifiable by readable column names.

Meta 

Use this export to understand key assessment data such as current status, status change events, location, and verifier details (with a completed verification).

Quantitative Impacts

Use this export to understand facility resource usage and impact metrics such as water, energy, and greenhouse gas emissions.

Download the Normal Data Dictionary, which will help you navigate the Quantitative Impacts CSV and the Raw Response CSVs. In this dictionary, you can look up characteristics such as description, inclusion in verification, question-type and applicability, of all FEM2023 questions (identifiable by their REFID).

Scores and Levels

Use this export to understand facility ratings and progress with overall scores, section level scores, and per question scores.

FEM has three levels:

• Level 1 – Awareness and understanding of sources and basic management systems
• Level 2 – Setting baselines, targets, and tracking improvements
• Level 3 – Leading aspirational practices

Two specific fields have been defined below for clarity. These fields are split by section of the FEM (ex. Chemicals, Waste, etc.)

• LevelsOpen – This field tells you which levels that were open or available for a facility to answer within the FEM.

• LevelsAchieved – This field tells you which levels were achieved, meaning the facility scored the a sufficient amount of points in that level.

Additional details:

• FEM defaults to level 1 open.
• If a facility achieves level 1 in a section, we open levels 2 and 3 and require facilities to answer those questions.
• If a facility does not achieve level 1 in a section, they can opt to open or keep levels 2 and 3 closed.

Areas of Focus and Improvement

Use this export to understand the questions that were answered negatively and flagged as areas where the facility can improve their environmental sustainability strategy.

FAQs

Data Dictionary Downloads