Correcting DatesAfter mentioning some important preliminary items in the
first and
second posts of this series, the
third part in this series began to deal with specific monitoring plan evaluation errors and how to correct them. In this fourth post, the focus will continue to be on monitoring plan data, specifically correcting date errors.
As soon as you install the Client Tool, you will be able to run evaluations on your monitoring plan data. The evaluation reports you generate will inevitably have errors that need to be corrected. There are several reasons for this. The reason for the errors which this post will focus on is dates.
In ECMPS, your monitoring plan is a complete history of your monitoring plan. The evaluation looks at all of your monitoring plan data from January 1, 2003 to the present as a complete picture. For dates, that means that the begin dates and end dates matter.
In MDC, your monitoring plan is evaluated from the viewpoint of a quarter. And for reporting purposes, you report the monitoring plan data which supports your quarterly emissions data. However, once you begin to look at a complete monitoring plan history, there is the possibility that dates will not match up as they should.
In other cases, dates were not required when reporting with the EDR, but they are now required in ECMPS. In the case of new date requirements, some assumptions have been made in order to load your monitoring plan data into the new database.
In general, date errors occur because the dates do not cover the entire evaluation period or the dates for two records overlap.
1. Fixing dates for data which do not cover the evaluation periodThe first case of not covering the evaluation period will generate errors that are similar to
You reported 123, but you did not report FLOW span records to span the entire evaluation period for the component.Here is what the data might look like on the Add/Edit screen in the Client Tool.

(Click on the picture to view an enlarged copy.)
Notice, how the end date and end hour for the first record is 4/11/2007 hour 22 and the begin date for the second record is 5/25/2007 hour 8. With these dates, there is a gap in the flow span reporting which runs from 4/11/2007 hour 23 until 5/25/2007 hour 7. The evaluation error is corrected by data that covers that time period. Depending on the actual flow span data, there are three ways to correct this:
- Add a flow span record which covers this time period.
- Modify the end date and hour of the first record.
- Modify the begin date and hour of the second record.
The method chosen should be used to reflect the actual flow span data.
2. Fixing dates for data which overlap during the evaluation periodThe second typical data error involves having overlapping dates. This evaluation error is simply the opposite of the first one. Instead, of having a gap in reported data for the evaluation period, there are two or more records reported for the same time period. The error message might read something like:
You have reported FLOW 1/1/1995, but you have reported another span record with the same ComponentTypeCode (and SpanScaleCode) that was active at the same time.Here is what the data might look like on the Add/Edit screen in the Client Tool.

(Click on the picture to view an enlarged copy.)
Note, how the end date and hour for the first record and the begin date and hour for the second record are the same--10/25/2005 hour 10. This is considered overlapping dates because the begin date and hour of the second record must be the very next hour after the end date and hour of the first record. There are two options for correcting this evaluation error:
- Modify the end date and hour of the first record.
- Modify the begin date and hour of the second record.
The method selected to correct the evaluation error should reflect the actual data for the flow span.
Labels: Preparing for ECMPS