move copy location mapping functionality into base.sql