Ok good. I understand the reference field from my exception table back to the cmdb_ci parent.

I'm ok with multiple entries for now into the ci_exception table. Ideally, I would want one for each type of offense.

Rec 1: Serial Number ABC has a bad model.

Rec 2: Serial Number ABC has a bad location.

This way one person may be tasked to resolved all "bad model" and another all "bad locations".

Each subsequent import would just overwrite the same Serial Number and type to show the last time it was encountered but no need for 10 of the same records.

I'm going to get to work now. I will let you know how it goes.