Common Mistakes Made When Creating Files for Electronic Submission of
Groundwater and Leachate Monitoring Data
The submission of groundwater and leachate monitoring data electronically
has been very successful with 100% of all data submitted in an electronic format.
As the system has evolved a few common mistakes keep turning up, some of which
prevent the proper loading of the data. In order to further streamline the
process and to help avoid creating errors that require a second submission or
compliance issues, below is a list of the common errors encountered to assist
you in preparing complete, error free files.
- Complete and correct facility ID Number. Records still come in with
incomplete or incorrect facility ID numbers. When this occurs the data
cannot be loaded and in some cases identification of the facility is not
possible. The data from many facilities are combined into upload files
making it difficult to back track to try and determine the proper facility
to contact regarding the error.
- Proper spacing of both the 01 (header) and 02 (detail) records. It is
imperative that the record spacing requirements are followed. When the
spacing requirements are not met characters are shifted, often into locations
resulting in an error. In those cases where an error is not detected, the
improper spacing may result in an erroneous result in the value field.
In addition, improper characters have appeared resulting in errors and
rejection of the record in some cases.
- Missing Time of Collection and Monitoring Point Sampled By data.
These fields need to contain data to avoid an error.
- Improper characters in the Background, Unable to Collect, Inorganic
and Organic Field Filtering fields. When reporting a sample as a
background sample or when the sample was field filtered for either the
inorganic or organic parameters the proper character is an “X”. Any
other character will result in an error. The Unable to Collect field,
when appropriate, has a list of codes, depending on the circumstances,
which are to be used. Any other character will result in an error.
- Results (02 record) submitted without a Header Record (01 record).
All detail records must have a corresponding header record. The header
record must have the same facility ID number, monitoring point
designation and date of collection. Many detail records (02 records)
have been received without a corresponding header record. When this
occurs the results (detail records) are rejected when the system is
unable to match the result to the corresponding header record. In some
cases the date of collection in the header differs from the date of
collection in the detail record. Also detail records have been received
where some of the detail records have one date of collection and others
have a differing date of collection.
- Use of the Lab Field and Missing Header Records. When a sample is
split and sent to two or more labs the lab field is used to differentiate
one lab from the other(s). No problems have been found with the use of the
lab field other than a missing header record error. When reporting results
for the second, and subsequent labs, a header record is required for the
second or subsequent lab. Without a header record indicating Lab 2, for
example, the detail records reported with a “2” in the lab field will be
rejected. Refer to the item above for further discussion of the header
record requirements.
|
