search

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

Monitoring Plan Management Configurations Last-Updated Endpoint - Add Missing Unit Control Indicator Code Field #6293

Open djw4erg opened 5 months ago

djw4erg commented 5 months ago

Overview

Add the Unit Control Indicator Code as fuelIndicatorCode to the payload for the Monitoring Plan Management API's "/configurations/last-updated" endpoint.

The UNIT_CONTROL table in both CAMDECMPS and CAMDECMPSWKS contain the INDICATOR_CD column which holds the Fuel Indicator Code ("E": Emergency, "I": Ignition, "P": Primary, and "S": Secondary).

Both ECMPS 1.0and 2.0 do not allow the editing or import of the Unit Control's Fuel Indicator Code. With the exception of 19 Unit Control rows entered by scripts for moved units, all Unit Control rows with Fuel Indicator Codes were created before the 2009 Q1 reporting month (April 2009).

Although new Unit Control Fuel Indicator Codes will not exist without the erroneous intervention of scripts, the existing values are needed for CAMPD CONTROL_YEAR_DIM loading.

Notes:

  1. Currently, Indicator Code is only needed the Monitoring Plan Management Configurations Last-Updated.
  2. Although Indicator Code is not included in exports, reimporting Unit Control data does not affect existing Indicator Codes.

Related Tickets

Ticket #6368 was created to investigate and correct the fact that Unit Control, Unit Capacity, and Unit Fuel data is not currently included in the Monitoring Plan Management Configurations Last-Updated endpoint's payload. The inclusion should have occurred as part of #5574.

Acceptance Criteria

  1. The UNIT_CONTROL's INDICATOR_CD data is included in the Monitoring Plan Management Configurations Last-Updated endpoint's payload as "fuelIndicatorCode".
djw4erg commented 3 months ago

Blocked

By #6368: Monitoring Plan Management Configurations Last-Updated Endpoint - Missing Unit Capacity, Control and Fuel Data

lgiannini1 commented 2 months ago

Verified in testing of #6368 throught Postman. Unit Control Indicator Code is present in unit control records as "fuelIndicatorCode.

ibarra-michelle commented 1 month ago

Verified in test:

https://api.epa.gov/easey/test/monitor-plan-mgmt/configurations/last-updated?date=2023-08-01

image