| Sep 30, 2011
This message summarizes some recent corrections/changes implemented by Cal/EPA's Technology Services Unit staff (TSU) that may impact any EDT implementers who have or are mapping their fields to the CERS Data Registry (CDR) or starting to construct their facility submittal XML packages. Please refer any questions about the issues in this listserv message to Chris Allen at firstname.lastname@example.org.
VARIOUS OMISSIONS IN CERS DATA REGISTRY
TSU has identified and corrected a number of omissions in the CERS Data Registry. These were:
--A number of HazWaste fields were not identified as CERS Minimally-Required (based on CERS Regulator User Group direction in spring 2011). The following fields have been updated to be shown as CERS Minimally-required: 500, 501, 502, 503, 521, 522, 523, 525, 526, 606, 607, 608, 609, 611, 612, 614, 630, 701, 702, 724, 725, 727, 728
--The Recyclable Materials Report Material UPCF field #522 ("Quantity During Two Year Reporting Period") was incorrectly entered in CDR as varchar(10). It has been corrected to match the definition in regulations as a numeric field.
--The following fields were added in CDR as "placeholders" to reflect long lists of Y/N fields on Tiered Permitting Unit Waste and Treatment Process Combination UPCFs. While no particular one of these Y/N fields are required, businesses must select at least one field (value=Y) on the form. These and other "placeholder" fields were added to CDR to help remind EDT Implementers about this issue.
627 CESQT Unit Waste and Treatment Process Combinations
628 CESW Unit Waste and Treatment Process Combinations
629 CA Unit Waste and Treatment Process Combinations
630 PBR Unit Waste and Treatment Combinations
631 CEL Unit Waste and Treatment Process Combinations Page
"CHEMICALREGULATORKEY" SYSTEM FIELD #20.0053 NO LONGER OPTIONAL
In the RC1/RC2 version of the CERS EDT Schemas, all of the Facility Submittal local regulator keys identifying subparts of various submittal elements were optional (e.g., BizActivitiesRegulatorKey, OwnerOperatorRegulatorKey, USTTankRegulatorKey). However, the Chemical Inventory Submittal Element, which has potentially far more sub-parts than any other submittal element (potentially thousands), poses special challenges for meaningful EDT exception error reporting. TSU has determined the best solution is to REQUIRE a unique local regulator identifier for each chemical inventory record
(ChemicalRegulatorKey, CERS System Field #20.0053). TSU will be encouraging EDT implementers to always provide the various optional local regulator keys identified in the CERS Systems fields to allow regulators to better identify what portion of their XML submission has an error, but ChemicalRegulatorKey will specifically be required. The field definition is shown below.
ChemicalRegulatorKey AN(36): A locally-generated unique identifier used to identify a specific chemical record in a Chemical Inventory submittal element. This particular local regulator key is REQUIRED to support meaningful diagnostic/error reporting. Although any unique alphanumeric string is allowable, a Universally Unique Identifier (UUID) is encouraged.
CERS2 EDT information is accessible at https://cers.calepa.ca.gov/EDT/
Unsubscribe from this listserv at http://www.calepa.ca.gov/listservs/Unsubscribe.asp?LID=110