US-EPA-CAMD / easey-ui

Project Management repo for EPA Clean Air Markets Division (CAMD) Business Suite of applications
MIT License
0 stars 0 forks source link

Test Exemption and Extension (TEE) Checks: Add Import Check to Prevent Introducing Duplicate TEE Through Imports #6308

Open djw4erg opened 2 months ago

djw4erg commented 2 months ago

Background

ECMPS 1.0 and now ECMPS 2.0 will allow the introduction of duplicate TEE through the TEE import process. ECMPS 1.0 prevents adding duplicates through the edit screens and ECMPS 2.0 will prevent adding duplicates when #6126 - Add EXTEXEM-8 TEE Check is implemented. This ticket will prevent the introduction of duplicates through the import process.

Requirements

  1. Prevent importing TEE JSON that either contains duplicate TEE or contain TEE that with duplicates in CAMDECMPSWS or CAMDECMPS.
  2. Duplicates will have the same values for the following:
    • Location Identifier (or Id)
    • Extension_Or_Exemption Code
    • Reporting Period (Year and Quarter)
    • Monitoring System Identifier (or Id)
    • Component Identifier (or Id)
    • Fuel Code

Ultimately, the purpose of this ticket is to prevent the submission of duplicate TEE, but it attempts to do this by preventing the import of duplicates.

annalbrecht commented 1 month ago

Needs acceptance criteria.