Report Description Detail
To extract records for all items that have a permanent location or temporary location that matches the location(s) selected from the location list. This can include barcode information or not. This report can be run ad hoc or on a regular basis.
The model is based on REP-189.
Start report with:
Instance Discovery Suppress
Item Discovery Suppress
Inventory Item ID
Item Location
Item Call number
Item Call number type
Item Call number Prefix
Item Call number Suffix
Barcode
Title
Author
Year
Enumeration
Chronology
OCLC
ISSN
ISBN
Last Circulation date
Checkouts
Filters:
Instance Discovery Suppression | Item Discovery Suppress | Item Location
Data fields:
Instance ID Values | Instance Title | Primary Contributor | Date instance created | Instance created by user | date instance updated | Instance updated by user | Item Effective Call number | Item status | Patron ID
| Folio Attribute (Module/Path:Object) | Folio Data Element Description | Parameters/Query |
|---|---|---|
| Table name: mod-inventory-storage/instance-storage/instances | ||
| Instance ID (mod-inventory-storage/instance-storage/instances:id) | UUID for an Instance record | Do not display in report. |
| Instance HRID (mod-inventory-storage/instance-storage/instances:hrid) | HRID for an instance record | Display as Instance ID in report. Order by. |
| Discovery Suppress (mod-inventory-storage/instance-storage/instances:discoverySuppress) | Records the fact that the record should not be displayed in a discovery system | This data element can be used to filter the report for Instance Discovery Suppress where True or False. Filter where value = False. (Need to confirm that False = suppressed.) (We want only those instances that are not suppressed from discovery) Display True = N. |
| Title (mod-inventory-storage/instance-storage/instances:title) | The primary title (or label) associated with the resource | Would like the title in the output report. |
| Contributor Name (mod-inventory-storage/instance-storage/instances:contributors{name}) | Personal, corporate, or meeting name that contributed to a work | *Repeatable field* Only pull the contributor that is marked as the primary contributor. |
| Identifier Value (mod-inventory-storage/instance-storage/instances:contributors{primary}) | Boolean for if contributor is main contributor | *Repeatable field* instances:contributors{primary} == True Would only like to have the primary contributor listed in output report. |
| Identifier Value (mod-inventory-storage/instance-storage/instances:identifiers{identiferTypeId}) | UUID for a lookup table to make the connection with a name and the type of contributor they are | *Repeatable field* Provides a join between mod-inventory-storage/instance-storage and mod-inventory-storage/identifier-type. This allows us to determine what the identifier is. instances:identifiers{identiferTypeId} == mod-inventory-storage/identifier-type/identiferTypes:id |
| Identifier Value (mod-inventory-storage/instance-storage/instances:identifiers{value}) | An identification of an item (e.g. ISBN, ISSN) | *Repeatable field* Would like to break out identifiers into a column by type in output report. |
| Table name: mod-inventory-storage/instance-statuses/ | ||
| Instance Status ID (mod-inventory-storage/instance-statuses/id) | UUID to match to instance status applied to instance | Do not display in report |
| Instance status name (mod-inventory-storage/instance-statuses/name) | Label for instance status | Filter: Null or Uncataloged Display in report |
| Table name: mod-inventory-storage/identifier-types | ||
| Identifier Type ID (mod-inventory-storage/identifier-type/identiferTypes:id) | UUID of an identifier type | Provides a join between mod-inventory-storage/identifier-type and (mod-inventory-storage/instance-storage/instances:identifiers{identiferTypeId}. identiferTypes:id == mod-inventory-storage/instance-storage/instances:identifiers{identiferTypeId} |
| Identifier Type Name (mod-inventory-storage/identifier-type/identiferTypes:name) | Name of the type of an identifier (e.g. ISBN, ISSN) | |
| Table name: mod-inventory-storage/holdings-storage/holding | ||
| Holding ID (mod-inventory-storage/holdings-storage/holdings:id) | UUID for a Holdings record | Provides a join between mod-inventory-storage/holding-storage to mod-inventory/item-storage. This allows us to gain access to instance level details. holdings:id == mod-inventory-storage/item-storage/items:holdingsRecordId |
| Discovery Suppress (mod-inventory-storage/holdings-storage/holdings:discoverySuppress) | Records the fact that the record should not be displayed in a discovery system | This data element can be used to filter the report for Holding Discovery Suppress where True or False. |
| Holding's Instance ID (mod-inventory-storage/holdings-storage/holdings:instanceId) | UUID to link a Holdings record to an Instance | Provides a join between mod-inventory-storage/holding-storage to mod-inventory/instance-storage. This allows us to pull the bibliographic data in the instance record. holdings:instanceId == mod-inventory-storage/instance-storage/instances:id |
| Table name: mod-inventory-storage/locations | ||
| Location ID (mod-inventory-storage/location/locations:id) | UUID for the Location record | |
| Name (mod-inventory-storage/location/locations:name) | Name of the Location | |