ERM-Inventory Count Cluster Prototype
The JIRA ticket for this report cluster is UXPROD-2407 ERM-Inventory Count Cluster including all respective Rep-Jira Tickets.
This report cluster contains a series of reports that are designed to count electronic resources that are not managed within the aggreements app.
Report description detail:
Overview:
DBS - Deutsche Bibliotheksstatisk: https://www.bibliotheksstatistik.de/
U.S. Association of Research Libraries (ARL) survey documentation: http://www.arlstatistics.org/about/Mailings
U.S. Association of College & Research Libraries (ACRL) survey documentation: https://acrl.countingopinions.com/
U.S. National Center for Education Statistics (NCES) Integrated Postsecondary Education Data System (IPEDS) survey documentation: https://nces.ed.gov/ipeds/report-your-data/resource-center-academic-libraries
Reports
( REP-41 (counts): Annual E-Resource Counts for ARL, ACRL and NCES and local reporting ) → please take a look at UXPROD-2529 Association of College and Research Libraries Report
REP-58 (1): Digital stocks, altogether (without electronic journals and electronic newspapers) (DBS 110)
REP-58 (2): Digital stocks, altogether (without electronic journals and electronic newspapers) (DBS 111)
REP-59 (1): Digital stocks, among these: commercially sold E-Books (digital textual materials which allow for searches on them) (DBS 113.1)
REP-61: Digital stocks, of those: digital audio-visual materials (e.g. CDs, DVDs, diskettes, web publications and recordings) (DBS114)
REP-62 (counts): "Digital stocks, of those: stocks in data bases (contents which are to be retrieved under a common user interface) serials that are not continuous,
not published on a regular basis; aggregator databases; for example, databases with topically based selections of journals" (DBS 118)REP-65: Journals and newspapers in electronic form, which either i) are licensed for use by the library in the reporting year or ii) have been digitized by the library in the reporting year. The digitization may have been carried out externally, but on behalf ... (DBS 131)
REP-66: Journals and newspapers in electronic form, of which the library has a license to use them in the reporting year, among those: those which have produced costs to the library in the reporting year (DBS 132)
REP-67: Journals and newspapers in electronic form, of which the library has a license to use them in the reporting year, among those: those which have produced costs to the library in the reporting year and of which the library will have a license also in the following year ("running journals") (DBS 133)
REP-68:** Journals and newspaper in electronic form: costs for those (licenses) in the reporting year
REP-69:** Other costs for journals and newspapers in electronic form, e.g. one-time purchase of backfiles
REP-70: Journals and newspapers in electronic form: newly licensed ones in the reporting year (DBS 138)
( REP-228: Number of serial titles currently received (people make a distinction between e-journals and e-serials?) ) → UXPROD-2398 RM-Subscription Count Cluster
Report Criteria
...
Start report with:
Instance data to be able to slice and dice by format.
Filters:
Instance type name | Instance format name | Instance Discovery suppress| instance status | Mode of Issuance | Cataloged Date | Statistical Code (Instances & Holdings) | Location | Holdings Type | Holdings Discovery Suppress| Call Number
Data fields:
Instances
ID
Discovery Suppress
Status Update Date
Instance Status
Instance Type
Instance Format
Nature Of Content Terms
Statistical Codes
Mode Of Issuance
Date of Publication
Cataloged Date
Previously Held
Holdings
ID
Instance ID
Permanent Location
Holdings Type
Discovery Suppress
Statistical Codes
Call Number
Call Number Type
Locations
Institution
Library
Campus
Items
ID
Chronology
Date created
Description Of Pieces
Holdings Record ID
Number Of Pieces
Status Name
Status Date
Statistical Codes
Material Type
FOLIO Attribute (Module/Path:Object) | FOLIO Data Element Description | Parameters/Query | Questions |
|---|---|---|---|
|
|
|
|
Table name: mod-inventory-storage/instance-storage/instances |
|
|
|
Instance ID (mod-inventory-storage/instance-storage/instances:id) | UUID for an Instance record | Allows for title counts. Provides a join between mod-inventory-storage and mod-inventory-storage/holdings-storage. instances:id == mod-inventory-storage/holdings-storage/holdings:instanceId It is possible that an Instance record do not have holdings/items associated with it, like memberships. An Instance record is like a BIB record. |
|
Instance HRID (mod-inventory-storage/instance-storage/instances:hrid) | (human readable ID) |
|
|
Instance Suppression Status (mod-inventory-storage/instance-storage/instances:discoverySuppress) | Indicates that the instance record is "suppressed" and should not be displayed in a discovery system | This element provides a means of excluding suppressed instance records from the total title count. Will not want to count titles suppressed from discovery. Will also be used to find withdrawn titles. |
|
Instance Status ID (mod-inventory-storage-/instance_statuses:id) | UUID for a particular instance status | Provide a join between mod-inventory-storage/instance-storage/instance/status_id and mod inventory-storage/instance_status:id May want to count only those things cataloged and made ready for use. This may also be a way to exclude unpurchased PDA/DDA titles. |
|
Instance Status Updated Date (mod-inventory-storage/instance-storage/instances:statusUpdatedDate) | Provides the status update date | Needs to be extracted from the JSON object. Keep this. Might be needed to determine when status set. repeatable? |
|
Instance Type ID (mod-inventory-storage/instance-storage/instances:instanceTypeId) | UUID for a particular instance type | Provides a join point between mod-inventory-storage/instance-storage and mod-inventory-storage/instance-types. May allow to filter by type/format if needed. Connects with:mod-inventory-storage/instance-types:id. |
|
Instance Format ID (mod-inventory-storage/instance-storage/instances:instanceFormatIds) | UUID associated with a particular instance format | Provides a join point between mod-inventory-storage/instance-storage and mod-inventory-storage/instance-format. May allow to filter by type/format if needed. Connects with:mod-inventory-storage/instance-formats:id |
|
Instance Nature of Content Terms ID (mod-inventory storage/instances:natureOfContentTermID) | UUID of the Nature Of Content Term | “Nature of content” will be used by German institutions in FOLIO. We don't know of any US libraries using it; but they could. Needs to be extracted from the JSON object. |
|
Instances Statistical Code ID (mod-inventory-storage/instances: statistical_code_id) | UUID of a statistical code | Connects with mod-inventory-storage/instances: statistical_code_id. May allow to filter by type/format if needed. *Repeatable field* Will be pulled from Json. |
|
Instances Modes of Issuance ID (mod-inventory-storage/instance-storage/instance:mode_of_issuance_id | UUID of a mode of issuance. | Connects with mod-inventory-storage/modes_of_issuance:id Some examples of values: single unit; multipart monograph; serial; integrating resource... Coming from RDA. |
|
Date of Publication (mod-inventory-storage/instance-storage/instances:publication{dateOfPublication} | Date (year YYYY) of publication, distribution, etc. | *Repeatable field* Is this right? May be needed to get the publication dates. Date of publication may also be used to help define a format? |
|
Instances Cataloged date (mod-inventory-storage/instance-storage/instances:cataloged_date) | Provide the cataloged date | May need to say, e.g., was cataloged before 7/1/2020 for FY20 stats. Is this also used for the other statuses we'd be interested in? |
|
Instance Previously Held (mod-inventory-storage/instance-storage/instance:previously_held) | Indicates if the instance was previously held | Records the fact that the resource was previously held by the library for things like Hathi access, etc. Will return a True of False. Yes, we want that. May not be implemented yet though; it is in the administrative data of the instance record. |
|
|
| OA - WIth ERM? Set up a meeting with Peter McCracken and Laura. Where is the location of OA? Not currently in Inventory. Laura says no standard way to do OA naturally. Ask Peter McCracken to a meeting with us three. How are we doing in Voyager? Should be set so that can be used in discovery: some users only want OA materials. Not sure where it should go in FOLIO. Is is not an ISness issue (like I am a newspaper)? Would use a code like instance status? Statistical? In an instance or a holdings note? |
|
Add instance notes - look up. repeatable. |
| they are paired with types |
|
Add: language of publication; country of publication; country about; general classification. |
|
|
|
Table name: mod-inventory-storage/instance_statuses |
|
|
|
Instance Status ID (mod-inventory-storage/instance_statuses:id | UUID of an Instance Status | Provides a join between mod-inventory-storage /instance_statuses:id and mod-inventory-storage/instance-storage/instances:statusId |
|
Instance Status Name (mod-inventory-storage/instance_statuses:name) | Label for the instance status (e.g., possibly in this case "Cataloged", "Batch Loaded", OR "pda unpurchased".) | A library may want to select only those titles cataloged and made ready for use as of the date of the count. Each institution should have its own list of statuses. At CU, we can likely use "cataloged" and "batch loaded." Laura is contemplating added a status of "pda unpurchased" so institutions can exclude unpurchased patron driven acquisition / demand driven acquisition (PDA/DDA). Statuses not selected will be excluded. Not repeatable. |
|
Table name: mod-inventory-storage/instance-types |
|
|
|
Instance Types ID (mod-inventory-storage/instance-types:id) | UUID of an Instance Type | Provides a join between mod-inventory-storage /instance-types:id and mod-inventory-storage/instance-storage/instances:instanceTypeId |
|
Instance Type Name (mod-inventory-storage/instance-types:name) | Label for the instance type (e.g. for REP-61 "performed music", "sounds", "spoken word", "three-dimensional moving image", OR "two-dimensional moving image") | Used to filter (if necessary). This table connects with: mod-inventory-storage/instance-storage:id. In MARC 21 terms this is "content type" (Bib 336):“form of communication through which a work is expressed”. https://www.loc.gov/marc/bibliographic/bd336.html
|
|
Table name: mod-inventory-storage/instance-formats |
|
|
|
Instance Formats ID (mod-inventory-storage/instance-formats:id) | UUID of an Instance Format | Provides a join between mod-inventory-storage /instance-format:id and mod-inventory-storage/instance-storage/instances:instanceFormatIds |
|
Instance Format Name (mod-inventory-storage/instance-formats:name) | Label for the Instance Format (e.g. for REP-61 "audio – audio disc", "computer – computer disc", "computer – online resource", OR "video – videodisc") | Used to filter (if necessary). This table connects with (mod-inventory-storage/instance-storage/instance_formats:id). In MARC 21 terms this is a combination of "media type" (Bib 337) and "carrier type" (Bib 338). |
|
Table Name: mod-inventory-storage/nature_of_content_terms |
|
|
|
Nature of Content terms ID: (mod-inventory-storage/nature_of_content_terms:id) | UUID of the Nature Of Content Terms | Provides a join between mod-inventory-storage/instances:natureOfContentTermID and mod-inventory-storage/nature_of_content_terms:id |
|
Nature of Content Terms Name: (mod-inventory-storage/nature_of_content:name) | Name of the Nature of Content | “Nature of content” will be used by German institutions in FOLIO. We don't know of any US libraries using it; but they could. Needs to be extracted from the JSON object. Connects with mod-inventory-storage/instances:natureOfContentTermID |
|
Table name: mod-inventory-storage/statistical_codes |
|
|
|
Statistical Codes ID (mod-inventory-storage/statistical-codes:id) | UUID of a Statistical Code | Provides a join between mod-inventory-storage /statistical-codes:id and mod-inventory-storage/instance-storage/instances:statisticalCodeIds |
|
Statistical Codes Name (mod-inventory-storage/statistical-codes: name) | Name of the Statistical Code | Allows to code for particular things institutions need, e.g., particular formats; particular projects; withdrawn?; don't export to OCLC; etc. |
|
Table name: mod-inventory-storage/statistical_codes_types |
|
|
|
Statistical Codes Types ID (mod-inventory-storage/statistical_codes_types:id) | UUID of a statistical Code Type | Provide a join between mod-inventory-storage/instances: statistical_code_type_id and mod-inventory-storage/statistical_codes_types:id |
|
Statistical Codes Types Name (mod-inventory-storage/statistical_codes_types:name) | Name of the Statistical Code Type (Ex: ARL, DISC,RECM,SERM) | Some institutions will be using this for various types of counts (e.g., ARL and serials maintenance (including way to tell if a serial is currently received or not). It will be locally defined. Connects with mod-inventory-storage/statistical_codes:statistical_code_type_id |
|
Table name: mod-inventory-storage/modes_of_issuance |
|
|
|
Modes of Issuance ID (mod-inventory-storage/modes_of_issuance:id) | ID of the mode of issuance | Provides a join between mod-inventory-storage/instance-storage/instances:mode_of_issuance_id and mod-inventory-storage/mode_of_issuance:id |
|
Modes of Issuance Name (mod-inventory-storage/modes_of_issuance/issuance:name) | Provides the name of the mode of issuance (Ex.: Integrating resource, multipart monograph, serial, single unit, unspecified) | Connects with mod-inventory-storage/instances/mode_of_issuance_id |
|
Library may need to select by or exclude certain holdings locations. This requires adding link to holdings and locations record measures. | |||
Table name: mod-inventory-storage/holdings-storage/holdings |
|
|
|
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. A Holdings must have an Instance ID associated with it. holdings:instanceId == mod-inventory-storage/instance-storage/instances:id |
|
Holding ID (mod-inventory-storage/holdings-storage/holdingsRecord: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 |
|
Holdings HRID (mod-inventory-storage/holdings-storage/holdingsRecords:hrid) | (human readable ID) |
|
|
Permanent location (mod-inventory-storage/holdings-storage/holdingsRecord:permanentLocationId) |
| Assuming we don't care about temporary location? |
|
Holdings Types (mod-inventory-storage/holdings-storage/Holdings:holdings_type_id) | UUID for a particular instance type | Provide a join between mod-inventory-storage/holdings-storage and mod inventory-storage/holdings_type_id |
|
Holdings 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. Will also be used to find withdrawn items. |
|
Holdings Statistical Codes ID (mod-inventory-storage/holdings-storage/holdings: statistical_code_ids) | UUID of a statistical Code | Provide a join between mod-inventory-storage/holdings storage/holdings: statistical_code_ids and mod-inventory-storage/statistical-codes:id |
|
Call Number (mod-inventory-storage/holdings-storage/holdings: callNumber) |
Provides the Call Number of an item. | Call number is an identifier assigned to an item, usually printed on a label attached to the item. May be needed for queries on specific subjects, classifications. |
|
Call Number Type ID (mod-inventory-storage/holdings-storage/holdings:callNumberTypeID) | UUID of a call number type | Provide a joint between mode-inventory-storage/holdings storage/holdings: callNumberTypeID and mod-inventory-storage/call-number-type/callNumberTypes:id |
|
Holdings Mode of issuance? Not in API as of 03/17/2020 |
| On instance record is how published, on holdings how received. |
|
Table name: mod-inventory-storage/Holdings_Types |
|
|
|
Holdings Types ID (mod-inventory-storage/holdings-types:id) | UUID of an Holdings Type | Provides join between mod-inventory-storage/holdings-storage:holdings_type_id and mod-inventory-storage/holdings-types:id. |
|
Holding Types Name (mod-inventory-storage/holdings-types:name) | |||