Remove MONITOR_QUALIFICATION_CPMS Table (Initial)

[djw4erg]

Overview

The indication is that reporting CPMS will be removed from the MATS 2.0 implementation. CAPD confirmed this removal at the ECMPS Support Meeting on June 6, 2024.

CPMS systems required a specific monitor qualification that have already been implemented by adding an additional monitor qualification code and a new child table to store the CPMS qualification information

Removing the MONITOR QUALIFICATION_CPMS table would take the following steps:

1. This Ticket: Remove the display and editing of Monitor Qualification CPMS data from the Workspace and Official pages. This will include changes to the [easey-ecmps-ui] repository, and as needed, changes to the [easey-monitor-plan-api] repository.

2. 6262: Remove Monitor Qualification CPMS from the Monitor Plan API. This will include the [easey-monitor-plan-api] repository.

3. 6262: Remove the MONITOR_QUALIFICATION_CPMS table from the database. This will involve the [easey-db-scripts] repository.

Affected Files by Repository

This list might not be complete.

Remove from [US-EPA-CAMD/easey-ecmps-ui]

• src/additional-functions/data-table-section-and-store-names.js
• src/components/datatablesContainer/DataTableCPMSQualifications/DataTableCPMSQualifications.js
• src/components/datatablesContainer/DataTableCPMSQualifications/DataTableCPMSQualifications.test.js
• src/components/datatablesContainer/DataTableCPMSQualifications/mocks.js
• src/components/datatablesContainer/DataTableQualifications/DataTableQualifications.js
• src/store/reducers/initialState.js
• src/utils/api/monitoringPlansApi.js
• src/utils/selectors/monitoringPlanCPMSQualifications.js

Remove from [US-EPA-CAMD/easey-monitor-plan-api]

• src/app.module.ts
• src/cpms-qualification/cpms-qualification.controller.ts
• src/cpms-qualification/cpms-qualification.controller.spec.ts
• src/cpms-qualification/cpms-qualification.module.ts
• src/cpms-qualification/cpms-qualification.repository.ts
• src/cpms-qualification/cpms-qualification.repository.spec.ts
• src/cpms-qualification/cpms-qualification.service.ts
• src/cpms-qualification/cpms-qualification.service.spec.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.controller.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.controller.spec.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.module.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.repository.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.repository.spec.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.service.ts
• src/cpms-qualification-workspace/cpms-qualification-workspace.service.spec.ts
• src/dtos/cpms-qualification.dto.ts
• src/dtos/monitor-qualification.dto.ts
• src/entities/cpms-qualification.entity.ts
• src/entities/monitor-qualification.entity.ts
• src/entities/workspace/cpms-qualification.entity.ts
• src/entities/workspace/monitor-qualification.entity.ts
• src/maps/cpms-qualification.map.ts
• src/maps/monitor-plan.map.spec.ts
• src/maps/monitor-qualification.map.ts
• src/maps/monitor-qualification.map.spec.ts
• src/monitor-plan/monitor-plan.module.ts
• src/monitor-plan/monitor-plan.service.ts
• src/monitor-plan-workspace/monitor-plan.module.ts
• src/monitor-plan-workspace/monitor-plan.service.ts
• src/monitor-plan-workspace/monitor-plan.service.spec.ts
• src/monitor-qualification/monitor-qualification.module.ts
• src/monitor-qualification-workspace/monitor-qualification.module.ts
• src/monitor-qualification-workspace/monitor-qualification.service.ts
• src/monitor-qualification-workspace/monitor-qualification.service.spec.ts
• src/routes.ts
• src/utilities/remove-non-reported-values.ts

Remove from [US-EPA-CAMD/easey-common]

• src/constants/property-metadata.constants.ts

Remove from database and related [EASEY-DB-SCRIPTS] scripts

• /camdecmpswks/procedures/load_monitor_plan_workspace.sql
• /camdecmpswks/procedures/copy_monitor_plan_to_workspace.sql
• /camdecmps/procedures/copy_monitor_plan_from_workspace_to_global.sql
• /camdecmpswks/constraints-indexes/4-monitor_qualification_cpms.sql
• /camdecmpswks/tables/monitor_qualification_cpms.sql
• /camdecmps/constraints-indexes/group5/4-monitor_qualification_cpms.sql
• /camdecmps/tables/monitor_qualification_cpms.sql

[annalbrecht]

From May 16th ECMPS Support Meeting Notes

The RTR was finalized on April 25, 2024, becomes effective July 8, 2024, and eliminates LEE, CPMS, and Stack testing as options. There are only 4 units that utilize CPMS. Until hearing otherwise, don’t program ECMPS for CPMS.

Sources have until July 6, 2027 to transition from CPMS to CEMS. In the meantime, sources can use the MATS Bulk file submission module to submit their CPMS data. There is a PM/CPMS MATS Supplemental Method code that sources can also use in the monitoring plan.

Charlie sent an email to Jason, Jeremy, and Michelle asking if CPMS should be removed from ECMPS 2.0 and the reporting instructions. Michelle is coordinating the removal of CPMS.

[lgiannini1]

Verified on dev using ORIS 6137, 1 that CPMS Qualification child records are no longer viewable/ editable in workspace and official views when selecting the CPMS Qualification Type Code.

Unable to test viewing in official due to the following error received on submissions (Example submission set IDs - 92566973-b40b-49ca-aa32-dd76553ebc7b, 24570c2c-6b9b-49b3-b250-92a6c9bda788, bcdfb89e-42c7-4273-9a31-d812c6be304c, 415e00f5-2aa1-4302-9372-23997afa75a6).

{"response":{"message":"there is no unique or exclusion constraint matching the ON CONFLICT specification","statusCode":500},"status":500,"message":"there is no unique or exclusion constraint matching the ON CONFLICT specification","name":"EaseyException","metadata":{}}

[ibarra-michelle]

Verified in test for ORIS 6137 Location 1, no child table information is displayed or editable in the workspace and global view.