I have a executable that is distributed to several organizations. Periodically the data from these organizations are combined. To aviod conflicts in the surrogate primary keys from each organization I want each system to prefix an organization code to the keys when they are created.

How do I provide the organization code to the executable?

I could create a one-record organization table with its code but I'm thinking that there is an easier (cleaner) way.

TIA