Refactor ref data

This request includes the following changes:
- use GetGeneratedKeys annotation to return the pk id for an newly added lookup entry.
- use SqlBatch to batch suppress/unsuppress lookup entries.