Having trouble viewing this email? View it as a Web page.

Background

The Hot Spots Analysis and Reporting Program (HARP) Emission Inventory Module (EIM) is a data reporting tool that outputs the California Emissions Inventory Data Analysis and Reporting System (CEIDARS) 2.5 transaction files.

CARB has released both a software update and a file update. For 2025 point source reporting, both the software update and file update are required.

Installation instructions are provided at the bottom of this bulletin.

File Updates

CEIDARS utility table

Utility tables are lookup tables for specific CEIDARS data columns (e.g. the POLLUTANT utility table is used to populate the emission table's POL column).

The following utility tables have been updated:

• CATEGORY

• CNTLDEV

• COABDIS

• DEFSRCTYP

• EIC

• POLLUTANT

• SCC

• SIC

For utility table descriptions, see CEIDARS data dictionary.

The most notable utility table update is DEFSRCTYP. The codes in this utility table are used to populate the stack source type column (SRCTYP) in the stack table.

CARB has transitioned from using the United States Environmental Protection Agency (EPA)'s NEI codes to the EPA's AERMOD codes. Please reference this crosswalk for transitioning SRCTYP codes:

Users of HARP EIM can apply this crosswalk to their point source inventory within HARP EIM. Instructions on how to do so are provided in the next section.

CEIDARS database

In the backend, HARP EIM utilizes a Microsoft Access database file in order to define tables and data column constraints. This database file aligns with the database structure of CEIDARS.

The following updates were made to HARP EIM's database file:

• STACK table
  • The SRCTYP column's character length has been extended from 7 characters to 9 characters in order to accommodate the updated codes in DEFSRCTYP.
• QUERIES table
  • The list of pre-defined SQL queries available in HARP EIM has been updated.
  • The most notable addition is the stack source type crosswalk. Running this query will batch update any stack record that is using an NEI code and map it to an AERMOD code.
  • The pre-defined SQL queries can be found in Tools > Database Utilities > SQL Viewer

HARP EIM interface displaying the SQL Browser, where users can run pre-defined queries on their project

Note: the only way to obtain the updated database file is by installing HARP EIM v2.3.0, which is why the software update is required for 2025 point source reporting.

Software update

Transaction file validation tool

HARP EIM's transaction file validation tool performs the data QA/QC checks outlined in CARB's point source reporting guidelines The tool provides a log of flagged data records and describes what the issue is for each record. 

The transaction file validation tool has been updated to align with the QA/QC that CARB will be performing on 2025 point source inventory submissions. CARB highly recommends Air Districts utilize the validation tool prior to submitting their 2025 point source inventory to CARB. 

HARP EIM interface displaying the summary page for a transaction file that has been run through the transaction file validation tool

Batch excel importing

The batch excel importer now supports importing .xlsx files. The previous version of HARP EIM (v.2.2.0) only supports importing .xls files. 

Individual table excel importing

Excel importing to individual tables has been re-introduced. This functionality was removed in the previous version (v.2.2.0).

Note: individual table excel importing only supports .xls files, consistent with how this feature functioned in earlier versions of HARP EIM (e.g. v2.1.6).

SCC lookup

When selecting an SCC code, the lookup table no longer displays the SCCUN column. This column provides a default process unit to a given SCC code. 

The reason for removing SCCUN is CARB requires process rate units be reported using the DEFPRUN utility table.

Change in the default installation folder

When installing HARP EIM, the default file path for the application has been changed from C:\HARP2\ to C:\HARP-EIM\

Below you'll see a side-by-side comparison between the previous version (v2.2.0) and the latest version (v2.3.0). 

HARP EIM default installation path side-by-side comparison between v2.2.0 and v.2.3.0

The rationale for this update is to help users differentiate among the various HARP applications that CARB maintains (e.g. HARP ADMRT, HARP EIM).

Note that users do not need to install HARP EIM in the default file path; users are welcome to install HARP EIM anywhere in their file system.

File system reorganized

HARP EIM's file system has been reorganized.

Below you'll see a side-by-side comparison between the previous version (v2.2.0) and the latest version (v2.3.0). 

Note that users do not need to interact directly with HARP EIM’s file system in order to use the application.

Bug fixes

The following fixes were made:

• Facility emission data entry page
  • Filtering pollutants by device and process ID has been patched.
• Tab order

  • The tab order was updated to align with the user interface of the following forms: Facility ID, Facility Address & Location, Contact & Employee Info, Release Data, Process Data, Emission Data, Priority Calculation.

  • This update will benefit users who use a screen reader when navigating HARP EIM forms.

• Facility explorer page
  • In the facility explorer page, if a facility had a null facility name, HARP EIM would crash if the user double-clicked on that facility. This has been patched.
• Utility table text filtering 

  • The following tables' text lookup was not working correctly: DEFMETH, DEFHPDY, DEFDPWK. This has been patched.

Installing update

As previously mentioned, the only way to obtain the database file update is install the latest version of HARP EIM (v.2.3.0). Therefore, for 2025 point source reporting, the software update is required.

Users only need to install the software update—the required file updates (utility table and database updates) are bundled in the software update.

Step 1

If you have any active projects that use an older version of HARP EIM, CARB recommends making copies of .mdb files as well as exporting data as a .tra file. 

Once a user has installed the latest version of HARP EIM, the user can import the .tra file. 

Step 2

If you have a previous version of HARP EIM installed in your device, CARB recommends uninstalling the older version before installing the latest version. Although you can have multiple versions of HARP EIM running on your device, this may lead to user error down the line.

Step 3

Install the latest version of HARP EIM by clicking the link below.

HARP EIM v2.3.0

Contact

For any questions regarding this bulletin or HARP EIM v.2.3.0, please contact eibweb@arb.ca.gov

Clearing California Skies for Over 50 Years

CARB is the lead agency for California’s fight against climate change, and oversees all air pollution control efforts in the state to attain and maintain health-based air quality standards.

More Information