Quarterly Summary View is missing NOx Mass (tons)

[esaber76]

Emissions: NOx Mass (tons) column is missing from the Quarterly Summary View and download.

[annalbrecht]

First, we need to find out what ECMPS 2.0 is doing-- whether it is trying to load data by program or not. Then we need to fix the bug based on that information.

[annalbrecht]

Requirement for all pollutant parameters: If there is data for a column, it should be shown on the screen.

Also check if other pollutant parameters are affected by this issue.

[ergjustin]

NOx Mass (tons) row not listed in the camdaux.datacolumn select * from camdaux.datacolumn where datatable_id = '1367'

[ergjustin]

For testing: I added a new row to the camdaux.datacolumn table (datatable_id = 1367, name = 'nox_mass', alias = 'noxMass', display_name = 'Nox Mass (tons)'). But when I tested it, I received an error message indicating that the camdecmpswks.emission_view_sumval is missing the nox_mass column.

select * from camdecmpswks.emission_view_sumval where mon_plan_id = 'MDC-676AF5A7769747B08E87B4E3D55189C5'

[ergjustin]

Additional information from Dwayne So checking the data source was also needed. Clearly NOx Mass is not part of the view that provides the data, so the EMISSION_VIEW_SUMVAL view will need to be changed. It looks like that will require changes to the following:

1. EMISSION_VIEW_SUMVAL
2. GET_SUMMARY_VALUES ( string, numeric )
3. GET_SUMMARY_VALUES_PIVOTED ( string, string, numeric )
4. GET_SUMMARY_VALUES ( string, string, numeric )

The changes are needed in both CAMDECMPSWKS and CAMDECMPS.

[mxtomoto1]

NOx Mass (tons) column found on both dev emissions interface and on the CSV that is downloaded from the interface.

[ibarra-michelle]

Verified in the test environment. For ORIS 298 and Location LM1, I see the NOx Mass (tons) data in the UI and download.