ECMPS Support

As a result of some necessary loading on the EPA Host System of used identifier data, about 187 facilities will be forced to synchronize their data. Please check this Excel spreadsheet to determine if any of your facilities are affected. More information is provided in the rest of this post.

As part of the ongoing transition from the legacy system to ECMPS, the remaining emissions legacy data loading continues to take place. The data which remain to be loaded from the legacy system are emissions data from sources which transitioned to ECMPS in 2009.

During the preparation for the 2009 Q2 Release, additional legacy emissions data were loaded. Part of the data loading of legacy emissions should include the loading of what is known as used identifier data. Used identifier data insures that links between emissions and QA data and monitoring plan data are not lost.

For example, the Formula Identifier reported in the Derived Hourly Value record should correspond with a Formula Identifier (e.g., 101) found in the monitoring plan. If changes to the monitoring plan require a new Formula Identifier (e.g., 102), the new Formula Identifier will be reported in subsequent Derived Hourly Value records. The used identifier record for Formula Identifier 101 prevents it from being deleted from the monitoring plan although it is no longer an active in the monitoring plan and has, in fact, been replaced by Formula Identifier 102.

The reason that Formula Identifier 101 cannot be deleted is because there are data in previously emissions data which reference Formula Identifier 101. (For the technical people out there, this prevents a referential integrity problem in the EPA Host System database.)

Used identifiers are established for component IDs, system IDs, formula IDs, stack IDs, and pipe IDs.

Unfortunately, the data loading which took place in June did not include the loading of the used identifier data for the newly loaded legacy emissions data. This needs to be corrected immediately in order to prevent identifier data from being deleted in the Client Tool.

From a practical point of view, what this means is that once the used identifier data are loaded on the EPA Host System, the affected facilities will by default by out of sync. When prompted to sync these facilities, sources should go ahead and sync the data. In the case in which the source has made changes to the monitoring plan which needs be synced, the source should export a copy of their monitoring plan data and save a copy of the monitoring plan printout report.

The affected sources are listed in this Excel spreadsheet. The used identifier data will be loaded on the EPA Host System on Wednesday morning, June 24th. If your facility is listed, the next time you log in to the EPA Host System after the used identifier data are loaded, you will be prompted to sync your data.