Problem: Acquisitions records contain a number of human readable IDs that are expected to be unique within a given library. Some of these identifiers may also need to be unique across consortia. FOLIO needs to identify what identifiers in the Instance, Holding and Item should be unique within a member vs what should be unique across members. In order to develop this feature, we need to identify which unique IDs must be unique across the entire consortium.
See UXPROD-4137 - Getting issue details... STATUS
| Rec Type | ID | Editable? | Global/Local | Why unique? | Explicit or augmented? | System-generated or manual? | Responsible Team | Notes |
|---|---|---|---|---|---|---|---|---|
| Item | Barcode | Y | G | Resource sharing | Augmented | M | Nearly impossible to eliminate barcode duplication across a large consortium, but need to differentiate ownership. | |
| Item | Item | N | Even if not unique, do we need some sort of indicator of which tenant the Item HRID belongs to? | |||||
| Instance | Instance HRID | N | Even if not unique, do we need some sort of indicator of which tenant the Instance HRID belongs to? | |||||
| Holdings | Holdings HRID | N | Even if not unique, do we need some sort of indicator of which tenant the Holdings HRID belongs to? | |||||
| Organization | Code | L | Thunderjet | |||||
| Organization | Name | L | Thunderjet | |||||
| Orders | PO Number | Thunderjet | ||||||
| Orders | PO Line | Thunderjet | I can't identify any scenarios where Tenant A would need to see a unique POL for Tenant B | |||||
| Invoices | Invoice # | L | Thunderjet | |||||
| Acquisition Unit | Name | G | Shared order across multiple tenants | Augmented | M | Thunderjet | Possible use case: central tenant acquires on behalf of other tenants. | |
| Fiscal Year | Name | L | Thunderjet | |||||
| Fiscal Year | Code | L | Thunderjet | Presumptive. Need confirmation from consortia. | ||||
| Ledger | Code | L | Thunderjet | |||||
| Group | Code | L | Thunderjet | |||||
| Fund | Code | L | Thunderjet | |||||
| Voucher | Number | L | Thunderjet | |||||
| User | Username | Y | G | Users can have multiple affiliations; need to avoid conflict. | Explicit | M | Use case: Central office has a John Doe with limited permissions across multiple tenants. One of those tenants has a staff member Jane Doe. Folio cannot support 2 "jdoe" logins within the same instance. | |
| User | Barcode | Y | G | |||||
| Service point |
Processes Potentially Affected
General
- Staff/user management
- If another record type's number is stored in a given app or record, how does that affect the storing app/record if the owning app/record changes the number or number structure, e.g.
- Inventory Instance doesn't know which SRS MARC ID it's related to, but SRS MARC record knows which Instance UUID it's related to
- Inventory Instance links to the SRS MARC and allows for quickMARC lookup/edit/update SRS MARC/update Instance, based on that relationship
- Inventory Instance/Holdings/Items do not know which POL(s) they are related to, but each POL knows every Instance/Holdings/Item related to it
- Inventory displays POL info in the Instance/Holdings/Item
- Inventory Instance doesn't know which SRS MARC ID it's related to, but SRS MARC record knows which Instance UUID it's related to
Circulation
- CI/CO
- Requests
- Loans
- Fines/Fees
- Users
Acquisitions
- Collaborative collection development (view-only)
- Joint orders (possibly - may be out of scope. Potentially impacts single-tenant, multi-acquisition unit sites more.)
Cataloging/Inventory
- Close association between Instance HRID and SRS
Data Import
Most important matchpoints for Data Import:
- SRS MARC Bib: 001, 010, 035, 9xx fields, 999 ff
- SRS MARC Authority: 001, 010
- Inventory Instance: HRID, UUID, OCLC number, LCCN, Other local ID, POL, VRN
- Inventory Holdings: HRID, UUID, Perm loc, URI, POL, VRN
- Inventory Item: HRID, UUID, Barcode, POL, VRN
Proposed Workflow
Questions
| Question | Status | Conclusions | Comments |
|---|---|---|---|
| Are any record types or unique identifiers missing in the above list, which will need to be visible or partially visible to some or all consortia members? | OPEN | ||
| Are there any circumstances under which other order-specific information should be shared with the consortium? | OPEN | ||
| Do IDs need to be natively unique or can they be augmented into uniqueness? | |||
| Why do we need uniqueness on a per record basis? | |||
| When is it OK to duplicate an ID? |