MATS 2.0 Needed Non-CPMS Crosscheck and Lookup Changes

[djw4erg]

Needed Crosscheck Changes

Formula Parameter and Component Type and Basis to Formula Code (Cross_Chk_Catalog_Id 16):

1. Change Parameter Code to "PM" for rows where Parameter Code equals "PMRE" and Formula Code equals "11-3", "11-16", "11-34", "11-37" or "11-46".
2. Remove rows where Parameter Code equals "PMRH" and Formula Code equals "11-3", "11-16", "11-34", "11-37" or "11-46".

Method Parameter Equivalent (Cross_Chk_Catalog_Id 97):

1. Add row for Parameter Code "PMRE", Equivalent Code: "PMRH"
2. Add row for Parameter Code "PMRH", Equivalent Code: "PMRE"

• Confirm that this cross check is actually missing.

Method Parameter to Method to System Type (Cross_Chk_Catalog_Id 8):

1. Add row for Parameter Code equal to "OP", Component Type And Basis equal to "COM", and Formula Code equal to "PM"

Parameter Code to Control Code for Unit Control (Cross_Chk_Catalog_Id 114):

1. Add row for Parameter Code equal to "PM" and Control Code equal to "B"
2. Add row for Parameter Code equal to "PM" and Control Code equal to "ESP"
3. Add row for Parameter Code equal to "PM" and Control Code equal to "HESP"
4. Add row for Parameter Code equal to "PM" and Control Code equal to "WESP"

• Confirm that this cross check is actually missing.

Parameter Method to Formula (Actual Table):

1. Change Formula List to "F-28" row where Parameter Code equals to "NOX" and Method Code equals "CALC"

Parameter to Category (Cross_Chk_Catalog_Id 11):

1. Add row for Parameter Code equal to "PM" and Category Code equal to "FORMULA"

Program Parameter to Method Parameter (Cross_Chk_Catalog_Id 85):

1. Update row with Program Parameter Code equal to "PM" changing Method Parameter List to "PMRE,PMRH,PM" (Confirm that PMPMA and PMPMC should be removed.)
2. Determine whether the "MATSSUP" should be included in the Method Parameter List for pre January 1, 2024.

Needed Lookup Changes

Control Equipment Parameter Code

1. Add row for Control Equipment Parameter Code "PM" with Description of "Particulate Matter"

Equation Code

1. Remove row for Equation Code "F-29" and "K-5". (Not actually a MATS 2.0 change)

Parameter UOM

1. Add row with Param Id of "142", Parameter Code of "PMRE", UOM Code of "LBMWH", and null for all other columns.
2. Add row with Param Id of "143", Parameter Code of "PMRH", UOM Code of "LBMMBTU", and null for all other columns.

Acceptance Criteria

• MATS 2.0: New PM Equations: https://camddevelopment.atlassian.net/browse/EC-3764
• MATS 2.0: Add Unit Control Codes: https://camddevelopment.atlassian.net/browse/EC-3768
• MATS 2.0: Add PM Parameters and Methods: https://camddevelopment.atlassian.net/browse/EC-3786
• MATS 2.0 PS-11 Formulas: https://camddevelopment.atlassian.net/browse/EC-3790
• MATS 2.0 PM Formulas: https://camddevelopment.atlassian.net/browse/EC-3890
• PROGRAM updates to check for methods for all MATS parameters: https://camddevelopment.atlassian.net/browse/EC-3922
• MATS 2.0 Metadata: Method Parameter to Method to System Type Crosscheck: https://camddevelopment.atlassian.net/browse/EC-3974
• MATS 2.0 Metadata: System Type to Component Type Crosscheck: https://camddevelopment.atlassian.net/browse/EC-3975
• MATS 2.0 Metadata: Program Parameter to Method Parameter Crosscheck: https://camddevelopment.atlassian.net/browse/EC-3976
• MATS 2.0 Metadata: Method Parameter Equivalent Crosscheck: https://camddevelopment.atlassian.net/browse/EC-3977
• MATS 2.0 Metadata: Parameter to Category Crosscheck: https://camddevelopment.atlassian.net/browse/EC-3978
• MATS 2.0 Metadata: Equation Code Lookup: https://camddevelopment.atlassian.net/browse/EC-3979
• MATS 2.0 Metadata: Formula Parameter and Component Type and Basis to Formula Code Crosscheck: https://camddevelopment.atlassian.net/browse/EC-3980

Notes

Created from https://github.com/US-EPA-CAMD/easey-ui/issues/6119 research.

[mark-hayward-erg]

@djw4erg @esaber76 This needs acceptance criteria, but otherwise looks to be ready for development.

[mark-hayward-erg]

@lgiannini1 please find and link the correct JIRA tickets in the Acceptance Criteria section. When you are done, please reassign to Dwayne and update the sprint to Sprint 12.