Hazardous Site (HZST) Format

Format Name: HZST

File Name: HZST.zip

Source: Available for the EarthSoft Primary Point of Contact (POC) on the EarthSoft Community Center downloads dashboard from the All Items > Formats > v7 > 22.1+ folder.

Export(s): HZST EDD

Note: Exports will not work as expected if the data were imported using a different format, as each format has different mappings, checks, etc.

Description: The Hazardous Site (HZST) Format is used to submit data to the New Jersey Department of Environmental Protection (NJDEP) Site Remediation Program (SRP). For further details on the submittal process and specific submission guidelines read here: http://www.nj.gov/dep/srp/hazsite/.

Installation Instructions: Download the HZST format from the EarthSoft Community Center and unblock the *.zip file. See the Interfaces page on how to use the HazSite button in EQuIS Professional to export data.

Limitations/Assumptions: As of November 15, 2012, the HZST Format has been updated to comply with the new requirements outlined by the New Jersey Department of Environmental Protection. For further details, read here: http://www.nj.gov/dep/srp/hazsite/news/20121102_compliance_date.htm.

NJDEP Hazsite Table Definitions and Field Definitions: http://www.nj.gov/dep/srp/hazsite/docs/edi/srpedi04.htm.

Setup for Remapping / Reference Values: Columns in the HZST format use different tables for their reference value lookups. The EQuIS EDD (Electronic Data Deliverable) Description file includes which tables are used for the reference value source. Create the EQuIS EDD Description file in EDP or the Enterprise EDP EDD Upload widget.

To comply with the NJDEP SRP submission guidelines, you may need to use the EQuIS Remap tool to manage synonyms on both import and export of data using the format. The HZST Format .zip will contain a guidance file, NJDEP_HZST_REMAP_GUIDE.xlsx, on creating remaps for this format. See Remap for additional information on how to setup and create the remap records needed.

Note: All Internal Values provided in the NJDEP_HZST_REMAP_GUIDE file are provided as examples only. Internal values should be reviewed to ensure the values in the database match those used in your remaps.

Troubleshooting

When using the HZST format to load data through EQuIS Professional EDP, additional remaps will need to be implemented in RT_REMAP and RT_REMAP_DETAIL to avoid the following error message during the Create step:

Cannot set column 'matrix_code'. The value violates the MaxLength limit of this column.

Cause: HZSAMPLE.MATRIX data type = Text(15); however the database mapping DT_SAMPLE.MATRIX_CODE = VARCHAR (10)

Resolution: Populate RT_REMAP and RT_REMAP_DETAIL to remap the imported data to meet the database requirements. Please note RT_REMAP.REMAP_CODE and RT_REMAP_DETAIL.REMAP_CODE must be populated with "HZST" in order for the remap to automatically occur during the create process.

Example:

Populate RT_REMAP:

RT_REMAP.REMAP_CODE = HZST

RT_REMAP.STATUS_FLAG = A

Populate RT_REMAP_DETAIL:

RT_REMAP_DETAIL.REMAP_CODE = HZST

RT_REMAP_DETAIL.STATUS_FLAG = A

RT_REMAP_DETAIL.EXTERNAL_FIELD = HZSAMPLE.MATRIX

RT_REMAP_DETAIL.EXTERNAL_VALUE = GROUND WATER

RT_REMAP_DETAIL.INTERNAL_VALUE = WG **