I have the following possible conditions. There can only be one Patient.EligRule and only one InsCarr.RuleType. The goal is determine whether to do a validation. Is there a clear way to handle the different scenarios?

Some examples:

EligRule is 2 then validate.
EligRule is 1 and RuleType is 'N' then do not validate.
EligRule is 3 then do not validate.

Etc...

Should this be a couple of CASE statements? The first determines the patient, then depending on that, run through the Carrier conditions?

* Patient Table
Patient.EligRule = 1 && Use Carrier Rule
Patient.EligRule = 2 && Always Validate
Patient.EligRule = 3 && Do Not Validate

* Carrier Table
InsCarr.RuleType = 'V' && Always Validate
InsCarr.RuleType = 'N' && Never Validate
InsCarr.RuleType = 'A' && Use Anniversary
InsCarr.RuleType = 'M' && Through End of Month