Create a Data Model or Models to Store a Mapping of FOLIO Tenant Libraries and Shelving Locations to INN-Reach Compatible Location Codes

Purpose/Overview:

INN-Reach uses a flat location structure that does not distinguish between branches ("libraries" in FOLIO) and shelving locations ("locations" in FOLIO). Therefore, the FOLIO system administrator or other user with appropriate permissions must provide a mapping between these records in FOLIO and an INN-Reach compatible code/description combination. The INN-Reach location code/description options should be loaded/managed as reference data by a user with appropriate permissions and referenced by ID (or code) in the mapping model (MODINREACH-17)

Requirements/Scope:

1. Mapping should be per local server/central server combination
2. Mapping must support having either a Library or shelving location ("Settings > Tenant > Location Setup") correspond to an INN-Reach location code/description
   • The same code/description can apply to multiple FOLIO location-like objects (libraries or locations)
3. If not specified, the shelving locations should inherit the mapping for their parent library
   • The inheritance applies until a mapping is explicitly specified for a shelving location
4. The situation in which the mapping will be used is to convert a FOLIO location into an INN-Reach code for transmission to the server as part of record contribution. The model should be structured accordingly
5. There should be some mechanism for indicating that a library and/or location is intended for INN-Reach circulation-only use and ignored for purposes of mapping validation
   • To begin with, this indication will not be managed, and we should avoid creating libraries and locations for these purposes
   • Later development will account for this functionality when the circulation agency-to-location mappings are implemented

Approach:

Acceptance criteria:

• AC: A mapping configuration record/records can be created, retrieved, updated, and deleted from the database