We have 2 tables which are joined by customer id (key field). This is a valid 11-proof number. We have a requirement to mask customer id in both tables ensuring consistency and 11-proof check.
Is there any function which generates 11-proof numbers and also helps us manage the relational integrity. If not, can we create a seed by generating valid 11-proof numbers and create a mapping between original customer id and generated 11-proof id such that the data is masked consistently based on this seed.