Noting that this would require refactoring the database schema to establish the notion of an acquisitions holdings subfield mapping independent of the provider record. Something like:
acq.holdings_subfield_map
id
owner
name (for the map)
acq.holdings_subfield_map_entries
id
field_name
subfield
holdings_subfield_map FK
Then acq.provider would gain a holdings_subfield_map column.
During upgrade, it would be possible to migrate the existing mappings to a de-duplicated set linked back to the correct providers.
Maybe toss in a library setting to specify a default mapping for new provider records.
Noting that this would require refactoring the database schema to establish the notion of an acquisitions holdings subfield mapping independent of the provider record. Something like:
acq.holdings_ subfield_ map
id
owner
name (for the map)
acq.holdings_ subfield_ map_entries subfield_ map FK
id
field_name
subfield
holdings_
Then acq.provider would gain a holdings_ subfield_ map column.
During upgrade, it would be possible to migrate the existing mappings to a de-duplicated set linked back to the correct providers.
Maybe toss in a library setting to specify a default mapping for new provider records.