Circulation Detail Report Prototype
Report to Prototype
- Circulation Detail Report
Report Purpose
- provides count of loan transactions for a given date range sorted by library location and patron group
Report Data Elements
Folio Attribute (Module, Path, Attribute) | Folio Data Element Description | Parameters/Query |
---|---|---|
(mod-users:) groups/id | A UUID identifying this (patron) group | sort and count results by (patron group) id |
(mod-users:) groups /group | The unique name of this (patron) group | |
(mod-users:) users/id | A globally unique (UUID) identifier for the user | |
(mod-users:) users/patronGroup | A UUID corresponding to the group the user belongs to; this is a reference to (mod-users:) groups/id; this is a foreign key to the id attribute under groups | |
(mod-circulation-storage:/loan-storage/loans)id | Unique ID (generated UUID) of the loan; represents the loan transaction; storage module; we get data from the storage module | count loan transactions |
(mod-circulation-storage: /loan-storage/loans) userId | foreign key; ID of the patron the item was lent to. Required for open loans, not required for closed loans (for anonymization). | |
(mod-circulation-storage: /loan-storage/loans) loanDate | Date time when the loan began | filter loan transaction ids by date range |
(mod-circulation: /circulation/loans)id | Unique ID (generated UUID) of the loan; business logic module; called "loanid" in the reporting database, will be marked as a foreign key | |
(mod-circulation: /circulation/loans)location | The effective location of the item; nested under "items" |
See LDP-11
Modeling Folio attributes:
mod-users: /groups
- id
- group
mod-users: /users
- id
- patronGroup
mod-circulation-storage: /loan-storage/loans
- id
- userId
- loanDate
mod-circulation: /circulation/loans
- id
- item.location