Remove Analytical Principle Column (Component) and Backing Lookup Table

[djw4erg]

Overview

The indication is that reporting CPMS will be removed from the MATS 2.0 implementation. Please confirm that this is true before implementing this ticket.

The COMPONENT ANALYTICAL_PRINCIPLE_CD column supports CPMS components and has already been implemented by adding the column and supporting lookup table.

Removing the COMPONENT ANALYTICAL_PRINCIPLE column would take the following steps:

1. 6260: Remove the display and editing of the Analytical Principle from the Workspace and Official pages containing Component data. This will include changes to the [easey-ecmps-ui] repository, and as needed, changes to the [easey-monitor-plan-api] repository.

2. This Ticket: Remove Analytical Principle from the Monitor Plan API. This will include the [easey-monitor-plan-api] repository.
3. This Ticket: Remove the COMPONENT ANALYTICAL_PRINCIPLE_CD column 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/retrieve-dropdown-api.js
• src/components/datatablesContainer/DataTableSystems/DataTableSystems.js
• src/components/datatablesContainer/DataTableSystemsComponents/DataTableSystemsComponents.js
• src/utils/api/dataManagementApi.js

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

• src/component-workspace/component.service.ts
• src/dtos/component.dto.ts
• src/dtos/system-component.dto.ts
• src/entities/analytical-principal-code.entity.ts
• src/entities/component.entity.ts
• src/entities/workspace/component.entity.ts
• src/maps/component.map.ts
• src/maps/component.map.spec.ts
• src/maps/system-component.map.ts
• src/system-component-workspace/system-component.service.ts

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

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

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

• beta/ecmps/reporting-instructions/monitor-plan.schema.json
• dev/ecmps/reporting-instructions/monitor-plan.schema.json
• perf/ecmps/reporting-instructions/monitor-plan.schema.json
• test/ecmps/reporting-instructions/monitor-plan.schema.json

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

• src/test/java/tests/UITests/ECMPS/exportImport/files/upload2.json

Remove from [US-EPA-CAMD/easey-db-scripts]

• camdecmps/constraints-indexes/group1/3-component.sql
• camdecmps/tables/component.sql
• camdecmpsmd/constraints-indexes/1-analytical_principle_code.sql
• camdecmpsmd/tables/analytical_principle_code.sql
• camdecmpswks/constraints-indexes/3-component.sql
• deployments/ecmps/release-v2.0/add-customizations.sql
• deployments/ecmps/release-v2.0/drop-customizations.sql
• deployments/ecmps/release-v2.0/load-additional-mdm-data.sql
• deployments/ecmps/release-v2.0/load-master-data-definitions.sql

[lgiannini1]

On dev, the ANALYTICAL_PRINCIPLE_CD column still exists in the official and workspace COMPONENT table, but there's no data in this column.

[annalbrecht]

@usmanahmederg please complete these changes on the DEV database. Then move this back to Ready for QA.

[lgiannini1]

Verified on dev. ANALYTICAL_PRINCIPAL_CD column is removed from the COMPONENT table in official and workspace.

[ibarra-michelle]

Verified on test for that the ANALYTICAL_PRINCIPAL_CD column is removed from the COMPONENT table in official (camdecmps) and workspace (camdecmpswks) .