[vc_row][vc_column offset=”vc_col-lg-9 vc_col-md-9″ el_class=”order-2″][breadcrumb-shortcode][vc_column_text]<\/p>\n
Welcome to the new Electronic Data Interchange manual. The New Jersey Department of Environmental Protection\u2019s (NJDEP) Contaminated Site Remediation & Redevelopment (CSRR) has updated the CSRR Electronic Data Interchange (EDI) manual to coincide with the new Electronic Data Deliverables(EDD) format. The new EDI manual has been released in concert with a new version of CSRR\u2019s Electronic Data Submittal Application (EDSA7) which is an application that checks the accuracy of CSRR EDD. The new EDSA is now known as EDSA7. The new EDI manual includes all the updated table and field definitions required for accurate CSRR EDDs. The new EDI manual also includes a submission process which coincides with the Licensed Site Remediation Professional (LSRP) Program being implemented by CSRR.<\/p>\n
Requirements for the CSRR\u2019s electronic data deliverables are included in the Administrative Requirements for the Remediation of Contaminated Sites (ARRCS Rule), (N.J.A.C. 7:26C-1.6) and the Technical Requirements for Site Remediation (Tech Rule), (N.J.A.C. 7:26E\u20131.6). The regulations require that sample location information and result information from the analysis of the samples, be provided to CSRR in an electronic format. In this way, your data can be entered into our data management system, and be made accessible for internal and external data sharing. Exemptions are listed in Who needs to submit data<\/a>?<\/strong><\/p>\n The ARRC Rule simply states, in sub-chapter 1.6, that the submittal of \u201claboratory data deliverables\u201d are required in an electronic format. The Tech Rule, also in sub-chapter 1.6, goes into more detail and lists some of the required fields, timeframes, additions and exceptions. In the pages that follow, the EDI manual will thoroughly explain what is required and how to submit it to CSRR. The sample data being submitted by you will help the CSRR investigator\/review staff process you information accurately and efficiently.<\/p>\n It\u2019s important to remember that complete, accurate data deliverables begin with the LSRP. Without quality deliverables the sampling data cannot produce accurate reports. Without accurate reports, using the data successfully becomes extremely difficult. CSRR data uses, such as LSRP Data Miner reports and the Remedial Priority System, requires quality data.<\/p>\n NOTE \u2013An EDD may be prepared by a Licensed Site Remediation Professional (LSRP) or a qualified data preparer on behalf of the responsible party, but the obligation of submitting an accurate EDD lies with the person responsible for conducting the remediation.<\/p>\n Full laboratory deliverables for \u201cpotable water, vapor intrusion (sub-slab, indoor, and ambient), polychlorinated dibenzo-p-dioxins\/polychlorinated dibenzofurans (PCDDs\/PCDFs), and hexavalent chromium soil sample results\u201d are also required by CSRR. The Technical Requirements for Site Remediation (Tech Rule), (N.J.A.C. 7:26E\u20132.1 and 2.2)<\/a> [pdf]<\/span> and Appendix A of the Tech Rule<\/a> [pdf]<\/span>, details how to submit full laboratory deliverables for specific methods and\/or analytes and media. More details on the method-specific requirements for vapor intrusion data deliverables (i.e. the TO-15 Conversion Table) are available via NJDEP Method LLTO-15<\/a> [pdf]<\/span>. The NJDEP Method LLTO-15 Appendix<\/a> [pdf]<\/span> also includes significant information. Detailed guidance on remediating vapor intrusion contamination is available via the Vapor Intrusion Technical Guidance<\/a>.<\/p>\n Please note that these full laboratory deliverables are frequently submitted to the Department prior to the submission of the key documents due to the time frames defined in the Tech Rule.<\/p>\n Full laboratory deliverable criteria are not explained<\/strong> in the EDI Manual. Only electronic data deliverable criteria are explained here. However, it is important to note that the NJDEP Method LLTO-15, the NJDEP Method LLTO-15 Appendix and the Vapor Intrusion Technical Guidance have not been updated<\/strong> yet and do contain data that have been deleted or edited in the EDI Manual. Please follow the EDI Manual when submitting electronic data deliverables to the CSRR. The NJDEP Method LLTO-15, the NJDEP Method LLTO-15 Appendix and the Vapor Intrusion Technical Guidance are being updated and will be released later this year. Upon release, these documents will be in concert with the 2012 CSRR EDI Manual.<\/p>\n<\/div>\n<\/li>\n A complete data deliverable requires three tables which must be submitted to CSRR in three separate files. These files are:<\/p>\n There is a one-to-many relationship between the three files. For example, if you are reporting a dataset where five (5) samples were collected, and each sample was analyzed for twenty (20) different analytes, the tables submitted must be constructed as follows:<\/p>\n Each row of data corresponds to one record in a text file.<\/p>\n<\/div>\n<\/li>\n The analysis of sample data must be completed by a certified lab.\u00a0 However, if your lab is not satisfying all of the EDI criteria or you have old non compliant data or hard copy data or you\u2019re preparing sample data for submittal to a lab\u2026etc, CSRR has supplied the required format below. There are three options that can be used to create your electronic data deliverable. It is extremely important to follow the required format for all your EDDs.\u00a0 If the format shown below is not the final format that is submitted to the CSRR, the submittal will fail.\u00a0An EDD may be prepared by a Licensed Site Remediation Professional (LSRP) or a qualified data preparer on behalf of the responsible party, but the obligation of submitting an accurate EDD lies with the person responsible for conducting the remediation.<\/p>\n An LSRP or data preparer having access to a computer but limited means of computer support, may find it easier to use the CSRR Template Format to meet the data deliverable requirements. The CSRR Template Format is a basic, stand-alone spreadsheet which outputs to a text, tab-delimited format. All of the required fields are identified in the spreadsheet by column headers. This option is most suitable where the number of samples and the number of analytes for each sample are relatively small, since every result of every sample will have a separate record (separate row in the spreadsheet). The CSRR Template and instructions on how to use this option are available in Appendix 1<\/a>.<\/p>\n An LSRP or data preparer having access to and familiarity with spreadsheet software can create files with a spreadsheet product. Each table must be a separate spreadsheet and saved as a “tab delimited text \u201d (i.e., ASCII, tab-delimited) format. The table definitions and field definitions are described in section 4.0 of this manual. It is absolutely essential that the formats shown below are strictly followed for field names, widths, order, formatting, etc., or the submission will fail.<\/p>\n An LSRP or data preparer having access to and familiarity with database software can create files with a database product and save each table in a “tab delimited text\u201d (i.e., ASCII, tab-delimited) format. The table definitions and field definitions are described in section 4.0 of this manual. It is absolutely essential that the formats shown below are strictly followed for field names, widths, order, formatting, etc., or the submission will fail.<\/p>\n<\/div>\n<\/li>\n The table definitions and field definitions for each table are shown below. The column titles \u201cRequired 11\/14\/2012 and before\u201d and \u201cRequired 11\/15\/2012 and after\u201d in the tables below refer to the field \u201cSampdate\u201d. See <\/a>HazSite Changes \u2013 Compliance Date Change Clarification for details. It is absolutely essential that these table formats are strictly followed.<\/p>\n The Dataset can be defined as the electronic equivalent of the cover page for the sampling and analytical results that are submitted to the CSRR. The DATASET file provides basic information about the sampling event, including site description, investigation phase, consultant, submittal date, and other information. There should be only one record in each Dataset file. The Dataset may represent one or more sampling episodes at a site. For example, the sampling and analytical results of four rounds of quarterly monitoring (at the same site) can be submitted as a single dataset. Valid values are required for several of the DATASET table fields.<\/p>\nFull Laboratory Deliverables<\/h6>\n
Conclusion<\/h6>\n
<\/a>2.0 Data Tables<\/h5>\n
\n
\n
<\/a>3.0 Data Formats<\/h5>\n
3.1 The CSRR Template Format<\/h6>\n
3.2 The Spreadsheet Format<\/h6>\n
3.3 The Database Format<\/h6>\n
<\/a>4.0 Table Definitions & Field Definitions<\/h5>\n
4.1 The Dataset File (DTST)<\/h6>\n
4.1a DTST Table Definitions<\/a><\/h6>\n