Requirements: CDC Changes for ECMPS 2.0

[JanellC]

We need to make some changes to the CAMDBSP CDC job that runs every hour from 8am to 11pm for ECMPS 2.0 release.

Add the following highlighted tables (the other 4 should already be there)…

• Add CAMDECMPSAUX.PROGRAM_PARAMETER

• Add CAMDAUX.INVENTORY_STATUS_LOG (this should be in the LOG schema on oracle)

• Update CAMD.UNIT sync to ignore the NON_LOAD_BASED_IND column

  • This column will be set/editable in ECMPS 2.0

• Confirm that the REGION_ANALYST table is NOT part of CDC process

  • This table will no longer exist in the NCC Oracle database and will live in the ECMPS 2.0 Postgres database and be managed via ECMPS 2.0 admin functionality

• Remove the PLANT_PERSON table from the CDC process

  • The data in this table is needed by any ECMPS 2.0 process
  • Remove camd/tables/plant-person.sql and camd/constraints-indexes/2-plant-person.sql from Git repo and drop tables from Postgres db
  • Modify misc/select-counts-all.sql and misc/counts-by-module.sql to remove references to plant_person table

• Once all data is synced please execute the camdecmpswks.update_mp_eval_status_and_reporting_freq procedure on cloud.gov postgres

• Job should email only if one or more of the count diffs are not 0 or if the job fails for some reason

• Job run interval needs to change from hourly to every 5 mins from 8am to 12midnight

[JanellC]

@jwhitehead77 will veirfy and test this ticket