Add Non Load Based Indicator field to UI

[esaber76]

Overview

For ECMPS 1.0, the Non-Load-Based Indicator (NON_LOAD_BASED_IND) is stored in the CAMD.UNIT table on the host and the ECMPS.UNIT table on the client. Non-Load-Based Indicator is editable in ECMPS 1.0 and should be editable in ECMPS 2.0.

Currently ECMPS 2.0 stores the Non-Load-Based Indicator in the CAMD.UNIT table. However, editable (submittable) data must exist in the CAMDECMPSWKS schema when it is edited and before it is submitted. To enable the editing and submitting of the Non-Load-Based Indicator, a new UNIT table will be created in the CAMDECMPSWKS schema that will contain the columns listed below. The Non-Load-Based Indicator in that table will be submitted to the CAMD.UNIT table when an MP is submitted, and will be updated from the CAMD.UNIT table when an MP is reverted (or otherwise copied) from official.

Acceptance Tests

• A Non Load Based Indicator field is present in the Unit Attributes grid and can be edited in the workspace.
  • The Non-Load-Based Indicator field is a dropdown field that can only be either 0 or 1.
  • Reverting the Monitoring Plan to Official Record removes the edits made to the Non Load Based Indicator field
  • Submitting a monitoring plan with edits to the Non Load Based Indicator updates the monitoring plan in Official view

Change List

• [ ] Add a UNIT table to the CAMDECMPSWKS schema using the structure below.
• [ ] Add a "Unit Attributes" grid to the "Unit Information" section of the "Monitoring Plans" screen.
  1. The grid should contain both an Actions and a Non Load Based Indicator column.
  2. The Action column should contain a link to open a Unit Attribute screen in either view or view/edit mode.
  3. The Unit Attribute screen should show and in view/edit mode allow the editing of the Non Load Based Indicator.
• [ ] Include the update of the NON_LOAD_BASED_IND in the CAMDECMPSWKS.UNIT table when a monitoring plan is reverted or loaded into the workspace.
• [ ] Include the update of the NON_LOAD_BASED_IND in the CAMDECMPS.UNIT table when a monitoring plan is submitted.
• [ ] Ensure that the CAMDECMPS.UNIT.NON_LOAD_BASED_IND defaults to 0 (zero) when created.

Additional Considerations

6233 was created to display Unit Attributes including Non Load Based Indicator, CO, CCO, etc, as well as Unit Program and Reporting Frequency data. This matches the ECMPS 1.0 Unit Characteristics Tab's sub tabs:

• Unit Attributes:
  • Non Load Based Indicator
  • Source Category Code
  • Commence Operation Date (CO)
  • Commercial Operation Date (CCO)
  • Unit Type Code
  • Operation Status Code
  • Operation Status Begin Date
• Unit Capacity: Already implemented.
• Unit Control: Already Implemented
• Unit Fuel: Already Implemented
• Unit Program
• Reporting Frequency

Based on this ticket, #6233 should include the items under bullet Unit Attributes above in the grid and pop-up for this ticket as read-only items. Pull the additional (non-editable) values from the CAMD.UNIT table. Do not add them to the CAMDECMPSAUX table.

CAMDECMPSWKS.UNIT Table

Column Name	Data Type	Required	Constraining Values
UNIT_ID	numeric(38)	Yes
NON_LOAD_BASED_IND	numeric(1)	Yes	0 or 1
USER_ID	varchar(160)	Yes
ADD_DATE	timestamp	Yes
UPDATE_DATE	timestamp	No

Original Description

See also #6233

This is a placeholder for the needed changes to add the ability for users to update the Non Load Based Indicator. This field does not currently exist and can only be seen in a MP Printout Report.

The database column (NON_LOAD_BASED_IND) is currently in CAMD.UNIT and needs to be moved to CAMDECMPS... (separate ticket(s) for db changes?).

Field in ECMPS 1.0:

[annalbrecht]

@lgiannini1 please add acceptance tests.

[annalbrecht]

Developers- please work on in association with #6233.

[yonatan-dp]

@djw4erg, I have the following questions on the above:

1. In the overview section, it states: "To enable the editing and submitting of the Non-Load-Based Indicator, the Non-Load-Based Indicator (NON_LOAD_BASED_IND) will move to the MONITOR_LOCATION tables in the CAMDECMPS and CAMDECMPSWKS schemas." By this, I understand that NON_LOAD_BASED_IND column should be dropped from the CAMD.UNIT table.

@yonatan-dp, I have updated the description. Originally we were planning to move the NON_LOAD_BASE_IND to the MONITOR_LOCATION table, but decided that creating a modified version of the UNIT table in CAMDECMPSWKS was a better solution.

In the change list above

2. Under "Change List", the first bullet states: " Add a UNIT table to the CAMDECMPSWKS schema using the structure below." Why do we need to add a UNIT table in CAMDECMPSWKS since the only editable field (NON_LOAD_BASED_IND) is moving to MONITOR_LOCATION in both schemas? The rest are read only and won't be involved in revert/submission operations.
3. Under "Additional Considerations", it states: "Pull the additional (non-editable) values from the CAMD.UNIT table. Do not add them to the CAMDECMPSAUX table." a) This states non-editable data comes from CAMD.UNIT (per #2 above). b) By CAMDECMPSAUX, do you mean CAMDECMPSWKS?
4. Under "Change List", in the fourth bullet, do you mean CAMD.UNIT instead of CAMDECMPS.UNIT? The Unit table is in the CAMD schema currently (see the overview above too).
5. Bullet 3 also conflicts with the overview. Is NON_LOAD_BASED_IND moving to MONITOR_LOCATION or we are adding the Unit table to CAMDECMPSWKS. If we are using CAMDECMPSWKS and CAMDECMPS, what do we do with the CAMD.Unit (remove it, or leave it)?
6. Please note that ticket 6233 also refers to only Unit table from CAMD schema.

[lgiannini1]

Verified the following on dev:

• An editable Non Load Based Indicator field was added to the Unit Attributes grid in the Unit Information section of the Monitoring Plan
• Editing the Non Load Based Indicator in the UI updates the column in CAMDECMPSWKS.UNIT table
• Reverting to official after editing the Non Load Based Indicator removes the change.

Issues:

• Updating the Non Load Based Indicator does not update the Evaluation and Submission Status for the Monitoring Plan. For ORIS 8906, 20, changing the Non Load Based Indicator from "No" to "Yes" and saving still shows an Evaluation Status of "Passed" and a Submission Status of "Updated on Host".
• Monitoring plan submissions are failing to upload to the host with the following error details. The following submission set IDs all received this error:
  • 6692b714-572b-4c10-84e8-614253faf47e
  • e5581e17-f851-424a-9a4b-45f9f3140bbc
  • 6cb19fc2-abf1-47e1-9b92-c30c2e20efcf

{"response":{"message":"relation \"camdecmps.unit\" does not exist","statusCode":500},"status":500,"message":"relation \"camdecmps.unit\" does not exist","name":"EaseyException","metadata":{}}