Thanks Michael,

I feel like such an infant. It's not a good feeling being a newbie.

I appreciate your time.

I will take this example and see how it goes.

I'm good with putting the script in the transform map on the field that needs looked up and/or validated.

After I get this working, I think I'll try to tweak it to ensure the exception doesn't 'insert' more than once for the same serial number + offense combination.

Not a big deal, but if the model is bad for serial number ABC, I don't need an entry each time the import runs. An update to the   already created serial_number+type will do. But that's minor. Hopefully the users will have corrected the bad data by the next time it tries to import.

I think I understand when you say "// Add a reference field to the cmdb_ci table and set it to the"..... You mean in my ci_exception table, I should make the serial number be a reference field back to the cmdb_ci table so when inside the ci_exception table you can have a link back to the CI to make the corrections.

Thanks again Michael.