Hazsite NewsElectronic Data Deliverable File Format Support Changes |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
These fields have become necessary due to elimination of case managers and implementation of the LSRP program. Since there are no longer case managers to run hard media submissions of EDSA7 data, SRP is implementing a system, whereby the Electronic Data Deliverable (EDD) can be e-mailed to srpedd@dep.nj.gov and automatically run by the automated EDSA7 program. Contact information becomes critical because there is no single individual assigned to a given case, therefore, if problems arise with the submitted dataset, it is necessary to have the name, phone and e-mail of the data preparer or a person with full knowledge of how the data was prepared. Summary of changes to HZSAMPLEHZSAMPLE has undergone extensive revisions. The order of the fields, however, has been retained so that any older EDDs or existing templates can be cut and pasted into the new format without loss of information due to changes in field locations. Highlights of these changes are as follows:
A brief summary of changes to fields is as follows: SAMPNUM has been increased due to complaints from a large number of end-users that the data collection system was inadequate to hold large identifiers often used in field collection. Often such identifiers were placed into the FIELDID field, resulting in problems because this field is intended to be a unique identifier of the location for a sample point in the field (See FIELDID below for further details). SAMPNUM should now accommodate highly descriptive text strings that field and laboratory personnel use to designate samples making up the EDD. SAMPTIME has been changed to accommodate a Date/Time string. Latitude and Longitude fields (LAT_DEGREE, LAT_MINUTE, LAT_SECOND; LON_DEGREE, LON_MINUTE, LON_SECOND) have been changed to accommodate Decimal Degrees and Decimal Minutes because it has come to SRP’s attention that many data preparers have been attempting to submit data in these formats by distributing the result into the existing fields. This results in data points that are often far from the intended location (See the example of NJDEP’s Trenton building in the main webpage). The Latitude and Longitude fields have traditionally collected Decimal Second data and will continue to default to that format. If, however, the data being sent to SRP uses one of the acceptable alternate formats, the submitter must input Decimal Degrees or Decimal Minutes in the COORDMETH field. SAMPNOTE has been changed to a 254-character field. If notes exceed the 254-charactes, contact SRP for instructions as to how to submit an equivalent document in XML format QAQC has been expanded to 15 characters. Many end-users are already familiar with this change, due to the requirements of TO-15 Ambient Air Reporting (see section 11.3.5 for more details). This expansion of the field is intended to hold the Sample Delivery Group (SDG) number for Field/Laboratory EDD identification purposes. COORDMETH is a new field that is used to track the coordinate method, by which the location of data points are being presented to SRP. Because of data discrepancies related to the submission of Lat/Long data, two methods are currently acceptable for input to this field: COORDNOTE is a new field that allows the user to convey useful information related to how data points were collected. For sampling data, three methods are currently recognized: They are Survey, GPS and Dig. Image. The interpretation is as follows: GWDEPTHPRI is a measure of the depth to ground water before purging a well. It is reported as the absolute value of feet below the ground surface (NOTE: GROUNDELEV – the measure of ground surface – is measured in feet above mean sea level). GWDEPTHPOS is a measure of the depth to ground water after purging a well. It is reported as the absolute value of feet below the ground surface (NOTE: GROUNDELEV – the measure of ground surface – is measured in feet above mean sea level). SCREENTOP is a measure of the depth to the top of a well screen (or packer interval or passive diffusion bag) as the absolute value of feet below the ground surface (NOTE: GROUNDELEV – the measure of ground surface – is measured in feet above mean sea level). SCREENBOT is a measure of the depth to the bottom of a well screen (or packer interval or passive diffusion bag) as the absolute value of feet below the ground surface (NOTE: GROUNDELEV – the measure of ground surface – is measured in feet above mean sea level). WELLPERMIT is the Well Permit Number. This is now required for Monitoring Wells. The current Well Permit Number consists of 10 alphanumeric characters, with the following rules:
In the old system a hyphen was used in the place of the padding zeros. If we compare numbers from the old system to the new system, they might look like:
SRP_DIR is used by SRP for cataloging datasets that come into the system. It is the Catalog Number for EDSA7 datasets. It was decided that any dataset returned for whatever reason would have the SRP_DIR tracked in HZSAMPLE, so that when corrections are made to the dataset, SRP can make a definitive correlation between those dataset(s) and the corrected EDD data. From time to time, SRP personnel extract multiple datasets from the HazSite data to correct multiple datasets at one time. This system allows SRP to track the source of several datasets simultaneously so that one EDD can correct multiple problem datasets, if necessary. SAMPLABID is a new field that allows the laboratory to track information between HZSAMPLE and HZRESULT using the HZRESULT.LABID as a secondary key. When the laboratory creates a diluted sample from one or more serial dilutions, if no additional (properly numbered) row in HZSAMPLE is created, all results for the main sample and the diluted sample are tied to the main sample in HZSAMPLE. This violates the requirements of the primary key between the two tables and results in “duplicates” that are flagged as errors. Where this, or similar conditions exist, EDSA7 will now check the SAMPLABID as a check on the primary key – if present, it will be included to sort between the original sample and the serial dilution sample(s). Summary of changes to HZRESULTHZRESULT has undergone extensive revisions. The order of the fields, however, has been retained so that any older EDDs or existing templates can be cut and pasted into the new format without loss of information due to changes in field locations. Highlights of these changes are as follows:
SRPID has been changed to accommodate identifiers that may be longer than the 16-character date fields. The New Jersey Environmental Management System (NJEMS) has made use of larger SRPIDs possible and EDSA7 has followed the NJEMS lead in order to facilitate integration of HazSite data to NJEMS data. SAMPNUM has been increased due to complaints from a large number of end-users that the data collection system was inadequate to hold large identifiers often used in field collection. Often such identifiers were placed into the FIELDID field, resulting in problems because this field is intended to be a unique identifier of the location for a sample point in the field (See FIELDID below for further details). SAMPNUM should now accommodate highly descriptive text strings that field and laboratory personnel use to designate samples making up the EDD. LABID was increased in size from 12 characters to 20 characters due to complaints by various laboratories that the size of the field was insufficient. TDANALYZ was formerly DANALYZ. This field was changed from a date field to a text field that contains the string associated with the typical Microsoft Excel Date/Time field. The format allows for Year/Month/Day/Hours/Minutes/Seconds NJDLABCERT is the Laboratory Certification number. Formerly, it was 5 characters, however now it has been re-set to 7 characters to account for certain labs whose ID numbers exceed the 5-character length. RESULTTYPE has remained the same, in that it is still one character in length, however SRP has added to the valid values recognized for this field. In addition to the traditional A(nalyte), P(arameter) and T(IC), S(urrogate), I(nternal Standard) and L(aboratory generated quality control sample) have been added to the list. In particular, in the past, surrogates that were included as Analytes could have created serious false positive results when looking at the data. This had the potential to represent the site as contaminated when, in reality, it is clean. MDL is now required for all analytes. This field must be entered for all rows in HZRESULT that are considered ANALYTES (HZRESULT.RESULTTYPE field = 'A'). Parameters require a MDL where applicable(HZRESULT.RESULTTYPE field = 'P'). QUANTTYPE is now required for all rows in HZRESULT that are considered ANALYTES (HZRESULT.RESULTTYPE field =A). The value entered for QUANTTYPE (a majority of the time) will be the reporting limit. QUANTLEVEL A numerical value must be entered in QUANTLEVEL for all QUANTTYPEs. ANLYS_MTHD has been changed from 15 to 35 characters in length, in response to numerous complaints about the lack of space for methods to be properly detailed. QAQC was expanded in 2003 as part of the initiative for tracking Sample Delivery Groups as part of the Indoor Air requirements. UNCOR_CONC & UNCOR_UNIT are both required fields for Indoor Air sampling. These fields provide part of the data required by the TO-15 Method (see webpage section 11) for additional details. These fields have been required for some time for the Indoor Air sampling EDDs and should be relatively familiar to experienced EDD preparers. RETEN_TIME is currently flagged as a warning only, however SRP intends to move toward its inclusion as a required field when reporting Tentatively Identified Compounds (TICs). Prior to the creation of this field, the TIC could be identified by T in the RESULTTYPE field plus the retention time concatenated to the ANALTPARAM name portion of what has been tentatively identified (Example: ANALTPARAM = PENTANE, 2,3,3-TRIMETHYL- 7.48; CAS = 560-21-4). The 7.48 means the TIC was observed as a peak coming off the Gas Chromatography (GC) column at 7.48 minutes (7 minutes, 28.8 seconds). The TIC is matched to a library of known compounds by Mass Spectroscopy and the compound assigned the name and CAS number of the closest matching compound. The current interpretation of this example would be as follows: DILUT_FAC is included for those instances where there has been a dilution of the original sample. This usually occurs for samples that have contaminants in concentrations above the expected range for the GC column. The original sample is suitably diluted so that the expected levels of contamination are within the limits of the column. The sample that is re-run in this manner may be diluted by a factor of 2 or perhaps 10 or more. This field is intended to capture the magnitude of the dilution relative to the undiluted sample. If an additional record is not included for each dilution in HZSAMPLE, at least one error will result for each missing HZSAMPLE record. PREP_MTHD is included to track the method employed for those samples requiring special preparation (not implied in the method citation) prior to analysis. It is not required for standard analyses. CLNUP_MTHD is included to track various methods that may be employed to decrease interference of a non-target compound on a target compound’s analytical results. Certain compounds may break down in such a way that they change the amplitude of a peak for a target analyte in the GC analysis, resulting in a “false positive” (peak is too large) or a “false negative” (peak is too low). The cleanup method is designed (for these cases) to affect the non-target compound without changing the target compound.
|
To report an environmental
incident impacting NJ, call the Toll-Free 24-Hour Hotline |
||
Contact DEP | Privacy Notice | Legal Statement & Disclaimers | Accessibility Statement |
||
Site Remediation Program: SRP
Home | About SRP |
Search | Help Copyright © State of New Jersey, 1996- |