2025 Refine Statewide Claims exemption from rules

Do we want to refine the following rules for 2025? We made a workaround to accommodate the Statewide data because the State Does not have a Program.ProgramSegment to map to.

RULES IT APPLIES TO:

Claim.ClaimID matches at least one ContactClaim.ClaimID when Claim.ClaimID does not end with one of ('Audit', 'Placeholder') and Measure.MeasImpactType does not start with 'Cust-NMEC-Pop' and Program.ProgramCategory does not equal 'Energy Savings Assistance' and Program.ProgramSegment is populated and Program.ProgramSegment does not equal 'Codes and Standards'.

Claim.SiteID is required when Claim.ClaimID does not end with one of ('Audit', 'Placeholder') and Measure.MeasImpactType does not start with 'Cust-NMEC-Pop' and Program.ProgramCategory does not equal 'Energy Savings Assistance' and Program.ProgramSegment is populated and Program.ProgramSegment does not equal 'Codes and Standards'.

Claim.MeasDetailID is not 'a restricted permutation' when Claim.ClaimType equals 'Deemed' and Program.ProgramSegment is populated and Program.ProgramSegment does not equal 'Equity'.