Home : SDWIS/State Fixed-Format Lab EDI File Structure
Q14279 - INFO: SDWIS/State Fixed-Format Lab EDI File Structure

EPA has developed 31 different structure sets for creating fixed-format, fixed-length ASCII files that contain a variety of water system data.  Hach WIMS supports two of these file structures: B_SAMPLE_SAMPLE_SUMMARY and B_RESULT_SUMMARY_RESULT. 

Hach WIMS can produce these files from a Spread Report using Locate, eDMR Link, Connecticut EDI

Hach WIMS can also import these data files from an external lab using certain interfaces.

The two files combined allow us to report results in the following categories. 

  • Total Coliform
  • Chemical and Lead & Copper
  • Radionuclide
  • Water Quality

The file structures are identical for each category; however the "rules" for filling out the fields differ for each category. 

For more detailed information on the file structures see sections 18 and 19 of Appendix A in the SDWIS/STATE System Administrator Guide for Release 8.0.

B_SAMPLE_SAMPLE_SUMMARY file structure (18.x Structure set)

This file contains sample summary information such as Sample Number, Sampling Location, Collection Date etc... 

 

B_RESULT_SUMMARY_RESULT file structure (19.x Structure set)

This file contains result information Result, Analyte Code, Units, etc...

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 11/18/2014 10:18 AM.
Last Modified on 11/19/2014 9:01 AM.
Last Modified by Scott Dorner.
Article has been viewed 3846 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article